SQL to Excel
Turn database dumps into spreadsheets. Extract data from SQL INSERT statements into Excel files.
Upload a SQL file to convert to Excel
About SQL to Excel
The SQL to Excel converter helps you visualize database backups. It scans SQL files for `INSERT INTO` statements and parses the values into a structured Excel workbook. This allows non-technical users to read database dumps without needing to install a database server.
How to Use?
- Upload File: Select or drag & drop your SQL dump file.
- Convert: Click the button to start the extraction process.
- Download: Save the resulting Excel file to your computer.
Features
- Basic Parsing: Extracts data from standard INSERT statements.
- Header Detection: Reads column names from the SQL query.
- Type Handling: Converts numbers and strings appropriately.
- Privacy First: Parsing happens entirely in your browser.
FAQ
Does it support all SQL formats?
It supports standard `INSERT INTO table (col1, col2) VALUES (val1, val2);` syntax. Complex multi-value inserts or specific dialect features might be skipped.
Can I upload large dumps?
Since processing happens in the browser, very large files (hundreds of MBs) may crash the tab. It's best for smaller extracts.
What about other SQL commands?
The tool ignores CREATE, UPDATE, DELETE, and other commands, focusing only on extracting data from INSERTs.