| Purpose | Understand export formats, data limits, and PDF behavior for reports and dashboards. |
| Intended audience | Property owners, managers, and administrators who export reporting data. |
| Use this when | Choosing an export format, reviewing a PDF with limited data, or troubleshooting an export that did not arrive. |
| Requirements | A report or dashboard available for export. |
| Expected result | Choose a suitable format and understand which data will appear in the exported file. |
| Limitations | Export formats have row or cell limits. Large PDF exports may contain only part of the report or table. |
Introduction
Reporting and Cloudbeds Insights support exporting reports and dashboards in different formats, depending on the content you want to download.
Export limits help keep files manageable and prevent large exports from interrupting other reporting activities. PDF exports have additional restrictions because they are designed for viewing and printing rather than working with large datasets.
When an export exceeds its limit, the downloaded file may contain only part of the data. Understanding these limits helps you select the right format and interpret the exported results.
Table of contents
- Report export formats and limits
- How PDF limits work for reports
- Dashboard export formats and limits
- How tables appear in dashboard PDFs
- Compare report and dashboard PDFs
- Export limits for Insights Hubs
- Troubleshoot an export that does not arrive
Report export formats and limits
Reports can be exported as XLSX, CSV, or PDF. Each format has a maximum amount of data it can include.
| Format | Export limit | What happens when the limit is exceeded |
|---|---|---|
| XLSX | 100,000 rows | The export includes the first 100,000 rows. |
| CSV | 100,000 rows | The export includes the first 100,000 rows. |
| 5,000 rows or 200,000 cells, whichever comes first | The PDF includes the first rows that fit. If totals are enabled, they are also included. |
Scheduled email exports: The same format limits apply to reports delivered by scheduled email.
How PDF limits work for reports
A report PDF is limited by both the number of rows and the total number of cells. The export stops at whichever limit is reached first.
- Row limit: Up to 5,000 rows.
- Cell limit: Up to 200,000 cells. Cells are calculated by multiplying rows by columns, including grouping columns.
Reports with more than 40 columns reach the cell limit before the 5,000-row limit.
Examples of PDF row limits
The number of columns determines how many rows can fit in a report PDF.
| Columns in the report | Maximum rows in the PDF |
|---|---|
| 10 | 5,000 |
| 40 | 5,000 |
| 41 | 4,878 |
| 80 | 2,500 |
What happens when a report exceeds the PDF limit?
If a report exceeds either limit, the PDF includes only the first rows that fit.
- Totals: If totals are enabled, they remain at the bottom of the PDF and are calculated using all rows, including those not displayed.
- Record count: The count at the top of the PDF reflects the entire report, not only the displayed rows.
- Export notice: Every page displays a notice explaining how many rows are included.
For example:
4,878 of 32,001 rows are shown; PDF exports are limited by report size. Export as XLSX or CSV for more rows.
When totals are enabled, the notice also includes:
Totals include the rows not shown.
If the report is within both limits, the PDF includes every row and does not display a limitation notice.
PDF limits for transposed reports
In a transposed report, metrics appear as rows and groups appear as columns.
Instead of removing rows, the PDF keeps the first group columns that fit within the 200,000-cell limit. When this happens, the limitation notice refers to columns rather than rows.
Need more data? Export the report as XLSX or CSV to include up to 100,000 rows. To create a smaller PDF, apply filters or remove unnecessary columns.
Dashboard export formats and limits
Dashboard exports offer different views and file formats. Choose the view that matches the information you want to download.
| Export view | Available formats | Details |
|---|---|---|
| Formatted | PDF, XLSX | Exports the formatted dashboard view. |
| Table | CSV, JSON | Exports only table cards, with one file per card. Multiple cards are downloaded together as a ZIP file. Chart cards are not included. |
| Details | PDF, XLSX, CSV, JSON | Provides additional export format options. |
Dashboard data limits
Dashboard exports have the following limits:
| Limit | Maximum |
|---|---|
| Rows per card, in every export format | 100,000 |
| Rows per table in PDF full-table pages | 5,000 |
How tables appear in dashboard PDFs
A dashboard PDF first displays the dashboard layout, including charts as images and table cards as previews.
When a table contains more data than fits within its card, the PDF includes a shortened preview on the dashboard page and prints the table on subsequent pages.
Table previews on dashboard pages
Table previews follow these rules:
- Up to 12 columns are displayed.
- Only the rows that fit inside the card are shown.
- Long text is shortened with an ellipsis (...).
When a preview is truncated, the card displays one of the following notices:
Showing 12 of 30 columns — full table on the following pages
Preview truncated — full table on the following pages
Full-table pages in dashboard PDFs
After the dashboard pages, the PDF prints the tables whose previews were truncated.
- Columns: Tables are split across as many pages as needed. Page titles identify the columns displayed, such as "columns 1–9 of 30".
- Rows: Each table includes up to 5,000 rows.
- Limit notice: If a table contains more than 5,000 rows, its title indicates that only the first rows are included.
For example:
Revenue by source — first 5000 of 12450 rows (use XLSX/CSV export for all rows)
To export more rows from a dashboard table card, use an available XLSX or CSV export option. These formats support up to 100,000 rows per card.
Compare report and dashboard PDFs
Report and dashboard PDFs have different limits and display truncated data differently. Use this comparison to understand what to expect from each export.
| Feature | Report PDF | Dashboard PDF |
|---|---|---|
| Row limit | 5,000 rows per report | 5,000 rows per table card |
| Cell limit | 200,000 cells | No separate cell limit |
| Totals when rows are truncated | Included when totals are enabled; calculated using all report rows | Not retained in the same way |
| Where truncation is indicated | A notice on every PDF page | The title on the full-table pages; preview cards also show truncation notes |
| CSV alternative | Available | Available through supported dashboard export views |
Both PDF types limit the amount of table data displayed, but the limits apply to different units: a whole report versus each dashboard table card.
Export limits for Insights Hubs
If your property still uses Insights Hubs, the following export options and restrictions apply:
- Hubs can be exported as XLSX or PDF only.
- A hub can contain up to 15 cards.
- Hub PDFs display tables using the same preview and full-table behavior as dashboard PDFs.
- To export more rows from a table card, use XLSX instead of PDF.
Troubleshoot an export that does not arrive
Very large exports may be interrupted before they finish. Cloudbeds automatically retries an interrupted export, up to three attempts.
If the export still cannot finish after three attempts, it is cancelled, and no file is sent.
What to do if an export fails
- Try exporting again with a smaller date range.
- Remove unnecessary columns to reduce the size of the export.
- If you need a large dataset, try an available XLSX or CSV format instead of PDF.
- If the export continues to fail, contact Cloudbeds Support.
Choosing the appropriate export format and reducing the amount of data when necessary can help prevent interrupted exports and ensure that your downloaded files contain the information you need.
Related articles
For additional guidance on creating, managing, and exporting reports or dashboards, browse the Cloudbeds Insights Help Center section.
Comments
Please sign in to leave a comment.