Download Tables - SuperWEB2

Once you have created a table, you can download the table data in any of 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 SuperWEB2. If you want to save a table in a format that you can reuse in SuperWEB2, 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:

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

Relative Standard Error in Downloaded Tables

Where Relative Standard Error (RSE) data is available, this data will be saved in the downloaded table as follows:

Download Format Location of the RSE Data

CSV and CSV String Downloads will include a separate column for RSE data.

Excel Downloads will include RSE data in a separate Excel worksheet.

SDMX

RSE will be represented as an attribute value in the SDMX Generic Data observation element. This attribute is only added when the database is weighted and has RSE values in the associated data cube.

For example:

CODE

<Obs>
    <Time>...</Time>
    <ObsValue value="..."/>
    <Attributes>
        <Value concept="RSE" value="0.437"/>
    </Attributes>
    ...
</Obs>

If RSE data is available then it will be downloaded even if it is not currently displayed in the table in Table View.

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.

Excel

Downloads will include:

Annotations symbols in the table cells on the first worksheet.
Annotation details in footnotes under the table.

SDMX SDMX downloaded at the data set level will contain database level annotation descriptions and symbols in the <Annotations> ... </Annotations> section of the XML.