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.
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.
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/
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 firstname.lastname@example.org 'https://www.rebasedata.com/api/v1/convert?outputFormat=xlsx&errorResponse=zip' -o output.zip
The conversion process takes between 15 seconds and multiple minutes. It depends on the size of the database.