Convert PSQL to XLSX online

Input file

Our API uses a .SQL file as input. This could be a PostgreSQL dump from the pg_dump 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 table in the given database 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 PostgreSQL .SQL file you want to convert.
The file output.zip will contain a XLSX file, one for each table in the given database 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.

Why use RebaseData?

Terms