Convert PSQL to Excel 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
Register to upload big files via Amazon S3.

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 CURL

Replace file.sql with the path to the PostgreSQL .SQL file you want to convert.
The file output.zip will contain a Excel 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