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 potential workarounds we’re exploring:
- Splitting the export into multiple XLSX files to stay within size limits
- Setting a row limit specifically for XLSX exports, while keeping CSV available for full exports
Would be great to hear if others have found effective solutions or if there are any best practices recommended by the Retool team for managing large XLSX exports.
Appreciate the support!