Why Doesn't My Review Table Display All My Rows?

If you've imported and are working with a particularly large dataset, you may see message when you scroll to the bottom of the sheet indicating "... and X more rows. Search or filter to reduce the size of your dataset."

HTML has a limit on the height of a table, limiting the number of rows we can show at once in a table in Flatfile's Platform. If this limit is reached by your file or dataset, the table can still be filtered or searched through to make sure you can access all records.

When retrieving data programmatically using sheet.allData(), there is a 10,000 row limit per API call. If your dataset contains more than 10,000 rows, you'll need to implement pagination to retrieve all records. This prevents heavy API loads but means you cannot fetch all data at once for large datasets. For guidance on implementing pagination, see our documentation on batching records during data egress.