Download report data (Tables)

To download a report to your computer, click the "Download report data" button on the toolbar.

Click on a format to start the download. The following formats are available:

• Beyond 20/20 table format (IVT)
• Microsoft Excel format (XLS)
• Comma-delimited ASCII format (CSV)
• Semicolon-delimited ASCII format (CSV)

  Note: In some cases when opening a downloaded CSV or SSV file in MS Excel, all the data appears in a single row instead of being properly distributed across the spreadsheet. The following workaround will enable you to view the data correctly:
  In MS Excel, select Data menu> Text to columns> Delimited> Next> Comma/Semicolon> Finish.

Notes on downloading report data:.

• All selected items will be downloaded, including inactive Other dimension items. (IVT only.)
• Downloaded IVTs are automatically saved as the latest Beyond 20/20 file format, currently version 6.2. To view version 6.2 files users must have version 6.2 or later of Beyond 20/20 Browser or Builder.
• Footnotes are retained when saving a report in IVT or XLS format, but not when saving as a CSV file.
• Source information for a report (shown in the status bar of the web browser) is included in downloaded XLS files only. It appears as the first line after the report's title.
• The limit for downloading a report to Microsoft Excel format (XLS) is 16,384 rows by 256 columns. Exceeding either limit will cause the download to fail with an error message explaining which limit has been exceeded. (Note that in this case rows and columns are not the same as rows and columns of data cells. For example, titles, subtitles, and the empty spaces between them also count as rows.)