Opening tsv format Eurostat data

Question

I've been trying to open this data: http://ec.europa.eu/eurostat/estat-navtree-portlet-prod/BulkDownloadListing?sort=1&file=data%2Fdemo_gind.tsv.gz. I've already unzipped it and get the tsv file, but when I opened it in gedit, it looks like a binary file. Could anybody help me to open this file?

Solution

The file is correctly formatted even if not so readable for human beings.

TSV is a file extension for a tab-delimited file used with spreadsheet software. TSV stands for Tab Separated Values. TSV files are used for raw data and can be imported into and exported from spreadsheet software. TSV files are essentially text files, and the raw data can be viewed by text editors, though they are often used when moving raw data between spreadsheets.

You can import it inside Excel or Open Office. Otherwise you may convert it by using online service (example google sheets).

Comments

[Christophe Roussy]

.gz stands for gzip, which is pretty much like zip, rar, 7z and so on. You will need some software to unzip (decompress) the file, like for example 7zip: 7-zip.org

[hans-t]

It turns out that tsv file inside gz is an archive. I need to decompress the tsv once again. Thanks.

[Mike]

How did you decompress?

[aberna]

Fast and easy using the tool Ark.