Convert TXT to TSV
Turn TXT files into TSV. The text read as a table whose fields are separated by commas, semicolons, tabs or vertical bars, whichever splits most of its lines into the same number of fields unless delimiter says which, written with tabs between the cells, each keeping its text; cells holding a tab, quote or line break are quoted.
Converted in an isolated sandbox on our serversDeleted after 24 hours
Drop TXT files on the dialor turn it to pick what to do
Rows of text become a table.Text split by a separator is written out as tab-separated values.
What you get
One TSV file. Each line of the text becomes a row, and the separator in each line marks where one field ends and the next begins.
The separator is guessed from the rows unless you choose one. Set Delimiter to comma, semicolon, tab or pipe to say which character splits the fields.
What stops the conversion
Text that no separator splits into a table fails with
unsupported_elements. Prose is the usual case. Sentences with no repeated separator between fields have no columns to build.Choosing the delimiter
Leave Delimiter out when the rows use one clear separator, and it is guessed from them. Set it when you know the separator, for example semicolon for a file from a spreadsheet in a European locale.
To work with the result further, see every TSV conversion.
TXT and TSV.What each format is, and the options this conversion takes.
- 01 · delimiter
Delimiter
The character between fields. It is guessed from the rows when left out. Spreadsheets in many European locales use semicolons.
commaA comma.semicolonA semicolon.tabA tab.pipeA vertical bar.
The formats
Plain Text
Plain text with no formatting at all. The smallest, most portable form of a document.
- Extensions
- .txt .log
- MIME type
- text
/plain - Kind
- Text and data
Tab-Separated Values
Tab-separated values.
- Extensions
- .tsv .tab
- MIME type
- text
/tab -separated -values - Kind
- Text and data
In your code.The same TXT to TSV conversion through the API, for your app or your agent.
$ cv convert report.txt report.tsv$ cv convert report.txt report.tsvQuestions.What people ask about TXT to TSV.
No. The text must be split into fields by a separator. Prose with no such separator fails with unsupported_elements.
No. If you leave Delimiter out, it is guessed from the rows. Set it to comma, semicolon, tab or pipe when you want to choose it yourself.
Yes, the TXT format covers files with the txt and log extensions. A log converts only if its lines are split into fields by a separator.
One file in TSV format, with the extensions tsv or tab.