Convert MySQL to XLSX online

Input file

Our API uses a .SQL file as input. This could be a MySQL dump from the mysqldump tool or an output of any other tool that returns SQL. The file should contain CREATE TABLE and INSERT/UPDATE statements.

Max file size for web uploads: 50 GB

Output file

The API will return a ZIP archive of .XLSX files, one for each input file. Since Excel has a limit of about one million rows, it could be that the rows are divided into several files.

Conversion methods

Using our Java tool

Download the RebaseData client Java tool . To convert your database using RebaseData, run the following command:

                    java -jar client-0.0.5.jar convert --output-format=xlsx file.sql output-dir/
                
Using CURL

Replace file.sql with the path to the MySQL .SQL file you want to convert.
The file output.zip will contain a XLSX file, one for each input file. If something went wrong, output.zip contains the error message.

curl -F 'files[]=@file.sql' 'https://www.rebasedata.com/api/v1/convert?outputFormat=xlsx&errorResponse=zip' -o output.zip

How long does it take?

The conversion process takes between 15 seconds and multiple minutes. It depends on the size of the database.

You can also use your favourite tool

Why use RebaseData?

Terms