Sign up free

SQL to Excel Converter

Open the data inside a .sql dump as a spreadsheet, with a sheet for every table.

More tools
Excel & CSVExcel to CSVCSV to ExcelXLS to XLSXNumbers to ExcelODS to ExcelHTML Table to Excel
Data formatsExcel to JSONJSON to ExcelCSV to JSONJSON to CSVXML to JSONYAML to JSONJSON to YAMLJSON to XML

or drop files here

Accepts SQL

Encrypted upload. Files are deleted automatically after 1 hour.

About SQL to Excel

SQL to Excel is for the times you have a database dump but no database: a backup from a hosting panel, an export from phpMyAdmin, a .sql file a developer sent over. Upload it and the rows in its INSERT statements land in an Excel workbook, one sheet per table, so you can search, filter and check the data without setting anything up. To pass a table on to another system, Excel to CSV can then save each sheet as a CSV.

Column names come from the INSERT column list, or from the matching CREATE TABLE when the INSERT has none. Quoted text is unescaped, including doubled quotes and escaped line breaks, NULL becomes an empty cell, and numbers arrive as numbers. INSERT statements as written by mysqldump, phpMyAdmin, SQLite's .dump or pg_dump --inserts are read directly. pg_dump's default COPY format isn't, because it contains no INSERT statements.

How to use SQL to Excel

  1. 1
    Upload the .sql file

    Choose or drop the dump. It can hold CREATE TABLE and other statements; only the INSERTs are turned into rows.

  2. 2
    Click SQL to Excel

    Every INSERT is parsed on our server and its rows are grouped by table.

  3. 3
    Download the workbook

    Each table gets its own sheet, named after the table, with a frozen header row.

Why use Cubfile for this

  • One sheet per table

    users, orders and products from the same dump end up side by side in one workbook.

  • Real column names

    Taken from the INSERT itself or from CREATE TABLE, with column_1, column_2 as a fallback.

  • Values cleaned up

    Quotes are unescaped, NULL is left blank and numbers are stored as numbers.

  • No database needed

    Read a dump on any computer without installing MySQL, PostgreSQL or a SQL client.

FAQ

SQL to Excel: questions and answers

Which dumps does SQL to Excel understand?
Any file with standard INSERT INTO statements, including multi-row VALUES lists, as written by mysqldump, phpMyAdmin, SQLite's .dump and pg_dump with --inserts or --column-inserts. Going the other way, Excel to SQL writes such statements from a spreadsheet.
Why does it say no INSERT statements were found?
The file probably stores its rows another way, such as pg_dump's default COPY blocks. Export again with --inserts, or check that the file isn't a schema without any data.
How do I convert SQL to Excel when the dump is huge?
Free accounts can upload dumps up to 50 MB and VIP up to 1 GB. For anything bigger, export only the tables you need, for example with mysqldump mydb orders customers.
Is it free?
Yes. There are 2 tasks in total without an account and 2 a day with a free one, and VIP has unlimited tasks.
Is a database dump safe to upload?
Dumps often hold personal data, so we treat them with care: the upload is encrypted, the file is parsed in an isolated process and it's deleted automatically after an hour. Nobody here opens it.
Share SQL to Excel with a friendIt runs in any browser, and they can try it without signing up.

Related tools

XLSSQL Excel to SQLGenerate CREATE TABLE and INSERT statements from Excel or CSV.
XMLXLS XML to ExcelTurn repeating XML records into spreadsheet rows.
CSVXLS CSV to ExcelOpen CSV and TSV data in Excel with the right columns and encoding.
CSVJSON CSV to JSONConvert CSV to JSON in your browser. Nothing is uploaded.
CSVXML CSV to XMLConvert CSV or Excel rows into XML records.
XLSCSV Excel to CSVSave each sheet as CSV, line breaks in cells handled.
XLSHTML Excel to HTMLTurn a sheet into an HTML table you can paste into a page.
XLSJPG Excel to ImageSnapshot sheets and charts as images.