How to Convert Oracle Dump Files to CSV & Excel
Need to convert table data from an Oracle dump file (.dmp) into CSV or Excel? Whether it's for data migration, analysis, or loading into another system, this is a task that comes up frequently.
This article walks you through converting .dmp files to CSV and Excel without an Oracle environment.
What You Need
- Windows PC (Windows 10+, x64 or ARM64)
- OraDB DUMP Viewer (free download)
- Your .dmp file
Converting to CSV
Single Table CSV Export
- Open the .dmp file in OraDB DUMP Viewer
- Select the target table in the left panel
- Choose Export → CSV
- Specify the destination and filename
The output CSV is RFC 4180 compliant, ready to open in Excel or any BI tool.
Batch Export (Multiple Tables)
For many tables, use the batch export feature:
- Select Batch Export from the menu
- Check the tables you want to convert (or select all)
- Choose "CSV" as the output format
- Specify the output folder and run
Each table is saved as a separate CSV file.
Converting to Excel (.xlsx)
- Select a table and choose Export → Excel
- Specify the destination and run
This generates an .xlsx file with header rows, ready to open directly in Excel. Batch export also supports Excel format.
Converting to SQL (INSERT Statements)
For migrating to another database, SQL export is useful:
- Select a table and choose Export → SQL
- Choose the target database:
- Oracle
- PostgreSQL
- MySQL
- SQL Server
- Specify the destination and run
Generates CREATE TABLE and INSERT statements in the selected database's syntax.
Direct Import to SQL Server
If you have a SQL Server environment, you can import directly without going through CSV:
- Select a table and choose Export → SQL Server
- Enter the connection string
- Confirm the target table name and run
Extracting LOB (BLOB/CLOB) Data
LOB data like images and documents can be extracted as individual files:
- Select a table containing LOB columns
- Use the LOB Extract feature and specify an output folder
- Each row's LOB data is saved as a separate file (images, PDFs, etc.)
Supported Data Types
| Category | Data Types |
|---|---|
| Numeric | NUMBER, BINARY_FLOAT, BINARY_DOUBLE |
| String | VARCHAR2, CHAR, CLOB |
| Date/Time | DATE, TIMESTAMP |
| Binary | BLOB |
Summary
With OraDB DUMP Viewer, you can convert .dmp file data into CSV, Excel, SQL, and more — no Oracle environment needed. Batch export handles large numbers of tables efficiently. A practical tool for data migration and analysis projects.