Child pages
  • Import a TSV file in MS Excel

Versions Compared

Key

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

...

  • The first line is the header. Its structuration is always the same:

    • The names of the first aggregated column come first (in the example: "FREQ,UNIT,INDIC_AG,GEO\TIME_PERIOD")

    • All the time intervals are present just after the header (in the example; "2000", "2003", etc)

  • All the other lines contain the data.

    • information in the first column is the identifier of the time-series

    • other columns contains statistical data, a whitespace and additional attributes when available
      (warning) whitespace is always present even if no additional attributes are available 

On the screenshot, each orange arrow is in a fact a "TAB" character. It is used as a separator between one data and its neighbours. It is also used as a separator between one column header and its neighbours.

...