Retool export table data as "xlsx" limit on records

[Filippo_Galli]

Hey @utkarshwork,

Check out this thread - it explains the XLSX export limitation and shares some solid workarounds:

Retool XLSX Export Error: “Invalid array length” with Large Dataset (~50k rows)

Hello @Tess, thanks for getting back to me! Based on what the engineering team confirmed, it seems that XLSX exports are best suited for smaller datasets, typically under 500,000 total cells (rows × columns). Once that threshold is exceeded on the client side, it can lead to issues like the “Invalid array length” error I encountered. In contrast, CSV exports handle larger datasets without problems, making them a more reliable option for exporting high-volume data. Here are a couple of potenti…

The main limitation:

Retool’s .xlsx export seems to hit a cap at around 500,000 total cells (rows × columns). Beyond that, you might get errors like “Invalid array length,” or the export just fails silently.

A few workaround ideas:

If reducing the dataset isn’t ideal, here are some alternative approaches that work better with larger sizes:

1. Send data to an external API Services that convert JSON or CSV to .xlsx. Some are free, others may require a subscription.
2. Use a Retool Workflow You can build one that processes the data into .xlsx using a library like xlsx or exceljs, then return a download link.
3. Host your own conversion script Set up a small backend (Node.js, Python, etc.) to receive the data, convert it into .xlsx, and return the file URL.

Hope this helps! Let me know if you need help setting one of these up.