TSV

TSV Data Source

The term TSV refers to Tab Separated Values files, and are written .tsv. These files are used to store
data in data tables – with each column of data being separated by tabs. They work in a similar way to
CSV files, with the plain text data being separated by tabs in the place of the commas. This file
format enables data tables to be moved between different spreadsheet software applications.

TSV files can be opened with a number of different programs including Microsoft Excel,
OpenOffice.org Calc, LibreOffice Calc, UltraEdit, and Notepad++. Each record in a TSV file is on a new
line, with each column being separated with tabs.

TSV files are an excellent way to store raw data, which can then be opened with different programs.
Raw data, however, is far more useful when it is being used in your own data storage facility – or,
indeed, when it is combined with other data. The process of moving this data can be done through
ETL or ELT.

ETL Your TSV Files

Gravity Data’s Extract, Transform, Load (ETL) or Extract, Load, Transform (ELT) enables you to move
your structured data that is within the TSV file through to your business’s storage process or data
warehouse. This allows you to have the best, meaningful information at your fingertips, enabling you
to gain useful insights into the running of your business.

Gravity Data’s ETL or ELT tool can be used to carry out this process simply and rapidly, giving you the
information to make business decisions as and when it is needed.

TSV Files Use Cases

Tab Separated Values files can be very useful for businesses that collect raw data. Some of their use
cases include:

• Facilitating the movement of files between different spreadsheet software applications
• Store raw data in a plain text format

Features of TSV Files

TSV files can be used across multiple different programs. Some of their features include:

• .tsv format
• Used with Microsoft Excel, OpenOffice.org Calc, LibreOffice Calc, UltraEdit, and Notepad++

TSV ETL - Try it free TSV Setup Guide