Exporting Table Data as an XLSX File
Export data from your table as an XLSX file.
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.
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 and verify the separator formats.
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.
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.
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.
- Choose your table.
- Choose .
- In the dialog, provide a Name for your XLSX file.
- For your table, verify that the File Type field shows XLSX.
To maintain Scaling, Units, and Currencies formatting, select
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).
- To keep the hierarchical indentation for the data labels, select Indent Hierarchy.
Depending on your browser settings, your file is saved automatically or a dialog opens for you to choose where to save your file.
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.
In excel, select the column that is incorrectly formatted.
From the ribbon menu, select “Data”, select “Text to Column”, and then select “Finish”.
From the ribbon menu, select “Home”, and then apply the correct number formatting.