Child pages
  • Which are the available formats

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Text (TSV or CSV) format

  • JSON-STAT format

  • XLSX format

  • SDMX format

Text (TSV or CSV) format

TSV stands for Tab Separated Value. TSV file is a flat file, which uses the Tab character to delimit data and reports one time-series per line.

...

Here is an example of a TSV data file for a dataset with a single time series:

FREQ,CURRENCY,POST,STK_FLOW,S_ADJ,PARTNER,GEO/TIME_PERIOD

1999-01

1999-02

1999-03

1999-04

1999-05

M,MIO_EUR,010,CRE,NSA,EXT_EA16,EA16

100001

96664

114413

107945

107837

Here is an example of a data file for a dataset with multiple time series:

FREQ,CURRENCY,POST,STK_FLOW,S_ADJ,PARTNER,GEO/TIME_PERIOD

1999

1999-01

1999-02

1999-03

1999-04

1999-05

A,MIO_EUR,010,CRE,NSA,EXT_EA16,EA16

1353651

:

:

:

:

:

M,MIO_EUR,010,CRE,NSA,EXT_EA16,EA16

:

100001

96664

114413

107945

107837

  • First column - header line is written in upper case letters.

  • First column - first line: sequence of codes separated by a comma followed by a code separated by a back slash (\).

...

Here is an example with multiple time series:

FREQ,CURRENCY,POST,STK_FLOW,S_ADJ,PARTNER,GEO/TIME_PERIOD

1999

1999-01

A,MIO_EUR,010,CRE,NSA,EXT_EA16,EA16

1353651

:

M,MIO_EUR,010,CRE,NSA,EXT_EA16,EA16

:

100001

Is to be understood as

FREQ,CURRENCY,POST,STK_FLOW,S_ADJ,PARTNER,GEO/TIME_PERIOD

1999

1999-01

A,MIO_EUR,010,CRE,NSA,EXT_EA16,EA16

1353651

Not applicable

M,MIO_EUR,010,CRE,NSA,EXT_EA16,EA16

Not applicable

100001

JSON-STAT format

JSON-stat is a simple lightweight JSON dissemination format best suited for data visualisation, mobile apps or open data initiatives.

For more information about JSON-stat please visit json-stat.org.

XLSX (Spreadsheet) format

The XLSX is a format based on XML, that can be used by spreadsheet applications. The data are stored in a text file that uses XML to define all its parameters.

This format is only available for data sets whose size does not exceed 750,000 cells.

SDMX format

The Statistical Data and Metadata Exchange (SDMX) initiative is sponsored by seven institutions (the BIS, the ECB, Eurostat, the IMF, the OECD, the UN and the World Bank) in order to provide standards for the exchange of statistical information.

...