Convert TXT to XLSX

Turn TXT files into XLSX. One sheet named after the file, cut to 31 characters, from 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.

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 spreadsheet.Each line becomes a row, and each field becomes a cell in one XLSX file.

  1. What you get

    An Excel workbook built from text that is laid out as a table. The fields on each line are split by a separator and placed in cells.

    If you leave Delimiter out, it is guessed from the rows. Set Delimiter to comma, semicolon, tab or pipe when you know which character separates the fields. Spreadsheets in many European locales use semicolons.

  2. Column names

    Set Header row to on when the first line holds column names rather than data. With Header row on, the first row stays text. Header row is off by default, so the first line is treated as data.

  3. Text that is not a table

    Text that no separator splits into a table, such as prose, stops the conversion with unsupported_elements. If your file is ordinary sentences, it has no rows and columns to turn into cells.

    To go the other way, use XLSX to TXT.

TXT and XLSX.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
  2. 02 · header

    Header row

    Whether the first row holds the column names rather than data.

    default false

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 · XLSX

Excel Workbook

Excel's workbook format since 2007. Sheets, formulas, formats and charts in zipped XML.

Extensions
.xlsx
MIME type
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Kind
Documents

In your code.The same TXT to XLSX conversion through the API, for your app or your agent.

terminal
$ cv convert report.txt report.xlsx
$ cv convert report.txt report.xlsx

Questions.What people ask about TXT to XLSX.

01OF 04

It uses the Delimiter. If you leave it out, the delimiter is guessed from the rows. You can choose a comma, semicolon, tab or pipe.

LOG is listed with TXT as a plain text extension for this conversion. It works the same way when the lines are laid out as rows with a separator.

Only if you set Header row to on. It is off by default. When it is on, the first row stays text.

No separator splits the text into a table. Prose is a common case.

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