Stat-Xplore : Download Tables

Once you have created a table, you can download the data in the following formats:

Excel 2007
Excel 2003
Comma Separated Value (CSV)
CSV string value
SDMX Structure Definition
SDMX Archive

You cannot reload a downloaded table back into Stat-Xplore. If you want to save a table in a format that you can reuse in Stat-Xplore, see the section on saving and reloading tables.

To download your table data:

Create your table.
Select the format from the Download Table drop-down list:

Some of the download formats have restrictions and may not be always be available. See below for more details.
Click Go.

Depending on your browser, the file will either be saved to your default downloads folder, or you may be prompted to choose whether you want to Save or Open the file. For example:

Save or Open option button

Download Format Restrictions

Some of the download formats may not always be available. This will depend on the type of table you have created:

Excel

Excel 2003 and Excel 2007 have limitations on the size of a table they can display. To prevent data outside of the row/column limit being lost, you will not be able to download in Excel format if your table exceeds these limits.

CSV

CSV downloads are not available if the table contains axis derivations.

SDMX

SDMX downloads are not available if the table contains any of the following:

Concatenated fields.
Axis or field derivations.
Items from multiple levels of a hierarchical field.

Percentages in Downloaded Tables

When downloading tables containing percentages, the percentage symbol is only displayed in Excel format downloads. Other formats, such as CSV, will include the percentage value but will not show the percent symbol (%) after the value.

Annotations in Downloaded Tables

If the table contains annotations, they will be saved as follows:

Download Format Location of Annotations

CSV and CSV String

Downloads will include:

Annotation symbols in a separate column.
Annotation details immediately after the table data.