Exporting Table Data as an XLSX File

Export data from your table as an XLSX file.

Context

The export process exports what you see in the table grid (all the visible rows and columns), including comment columns, calculations, and hierarchy levels in separate columns.

You can export both acquired and live data as an XLSX file. However, live data may take some time to export, because it must be downloaded before it can be exported.

You can also export from the Explorer. For more information, see Accessing the Explorer.

Note

Before exporting data, make sure that the number formats are the same for the model and your local machine. For example, if the data you want to export uses a comma as a decimal separator and a period as a thousands separator (123.456,78), you will need to verify that your machine's number format is the same.

On a PC, in the Control Panel, go to Start of the navigation pathClock, Language, and Region Next navigation step Region Next navigation step Additional SettingsEnd of the navigation path and verify the separator formats.

Restriction
The following limitations apply to the export:

  • Maximum number of cells of data: 500 thousand.

  • Formatting (such as cell color, font styles, and so on) will not be exported.

  • Only the table data region is exported. Custom cells outside the data region (for example, on a grid page) are not exported.

  • Hyperlinks are removed.

  • Hierarchies are flattened.

Tip

If you want to include custom cells (that are outside the table data region) in your export, you need to select all the cells, copy them, and then paste them into Excel.

Restriction

The export option is disabled if the model that is used is in Edit mode.

The notification dialog provides information on the export progress or completion. It also allows you to cancel the export.

Procedure

  1. Choose your table.
  2. Choose Start of the navigation path (More Actions) Next navigation step  ExportEnd of the navigation path.
  3. In the dialog, provide a Name for your XLSX file.
  4. For your table, verify that the File Type field shows XLSX.
  5. To maintain Scaling, Units, and Currencies formatting, select Include Formatting.
    Tip

    Use Include Formatting when you want the formatting to exactly match what is in the table. For example, if the table shows $12.04 Million, that is how the value will be exported, even if that is a rounded value.

    Don't use Include Formatting if the actual data values are different from those displayed in the table (for example, the actual data has more decimal places).

  6. To keep the hierarchical indentation for the data labels, select Indent Hierarchy.
  7. Select OK.

    Depending on your browser settings, your file is saved automatically or a dialog opens for you to choose where to save your file.

Results

Your XLSX file is saved.

Next Steps

If you have characters such as parentheses or the percent sign in your exported data, Microsoft Excel may treat your numeric data as text and left align the data.

To correct the formatting, do the following:

  1. In excel, select the column that is incorrectly formatted.

  2. From the ribbon menu, select “Data”, select “Text to Column”, and then select “Finish”.

  3. From the ribbon menu, select “Home”, and then apply the correct number formatting.

Related Information