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.

  1. 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.

  2. 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.

  3. 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.

  1. 01 · delimiter

    Delimiter

    The character between fields. It is guessed from the rows when left out. Spreadsheets in many European locales use semicolons.

    • comma A comma.
    • semicolon A semicolon.
    • tab A tab.
    • pipe A vertical bar.
    comma · semicolon · tab · pipe

The formats

From · TXT

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
To · TSV

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.

terminal
$ cv convert report.txt report.tsv
$ cv convert report.txt report.tsv

Questions.What people ask about TXT to TSV.

01OF 04

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.

More conversions.Other ways in and out of TXT and TSV.