Export Formats, Limits, and PDF Behavior

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

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.
PDF 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

  1. Try exporting again with a smaller date range.
  2. Remove unnecessary columns to reduce the size of the export.
  3. If you need a large dataset, try an available XLSX or CSV format instead of PDF.
  4. 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.


For additional guidance on creating, managing, and exporting reports or dashboards, browse the Cloudbeds Insights Help Center section.

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.