Text to Excel: Build Reliable Rows and Columns

Text becomes a useful spreadsheet when you define two boundaries: what starts a new row, and what separates the values in that row. A list of names needs one column. A contact export may need five. There is no reliable way to infer those fields from ordinary paragraphs without deciding what the fields should mean.

Choose a separator that belongs to the structure

A tab is useful when copying a table from Word. A comma is common in CSV exports; a semicolon is common when commas appear inside decimal numbers. Do not choose a space for names such as “Amina Khan”: the space belongs to the name. Use the preview to verify where each field lands.

Turn the prepared text into a workbook

1. Copy the table or delimited list, then paste it into Text to Excel. You can also select a supported text file.
2. Choose the delimiter that matches the source and inspect several rows, including one containing an empty field.
3. Correct the preview and give the columns meaningful headers. A list with no separators can stay in one column.
4. Export the XLSX, reopen it and check identifiers, dates and numeric columns.

For a Word document, copy its table rather than uploading the DOCX into a text-file input. The converter works with text; it does not translate Word’s page layout, images or styles into a workbook.

Which values become workbook numbers

Headers remain text. For other rows, the exporter recognizes an optional minus sign, an integer with no extra leading zeros and an optional dot fraction. A finite match becomes numeric only when the trimmed source is shorter than 16 characters. Thus 00127 remains text, 12.50 becomes the number 12.5, and 12345678901234567890 remains text. The source decimal display format is not retained; apply a two-decimal format in the receiving workbook if required.

Dates such as 03/04/2026, comma decimals, currency, exponents and plus-prefixed strings remain text. Empty fields stay at their original column positions; empty XLSX cells are omitted from the XML. Delimited parsing preserves surrounding whitespace, while numeric recognition tests a trimmed value. CSV has no cell types, and formula-like text is prefixed with an apostrophe. Import identifier columns as Text when opening CSV in another application.

Check quotes, empty fields and embedded lines

In CSV, quotes can protect a comma that is part of a value: "Khan, Amina",London represents a name and a city. A naive split at every comma would produce three columns. Check a row containing punctuation before trusting a large import. If its preview splits incorrectly, use a proper CSV importer in your spreadsheet application.

An empty middle field still occupies a column. In 00127;;12.50, the amount belongs in the third column. Quoted line breaks remain in one cell. Malformed quotes and uneven record widths pause export: fix the delimiter, quote the whole field, or insert the missing empty-field separator, then inspect the preview again.

Give prose a structure before converting

For meeting notes, decide on columns such as Task, Owner and Due date, then put one task on each line with tabs between fields. Keep missing dates empty instead of inventing them. This small preparation produces a workbook that can be sorted and filtered without merging unrelated sentences.

Treat imported text beginning with a formula character cautiously. Preserve external data as text until you decide that a formula should run. Save the original text alongside the workbook so a formatting mistake can be corrected without retyping the source.

Sources and checks

Choose the delimiter and inspect the preview before applying the split. Reserve empty destination columns to avoid overwriting other data. Microsoft: Text to Columns.

A checked example

Synthetic examples checked in Chromium on Linux, September 9, 2026. The HEIC input is a licensed sample.

Using Comma and headers, this multiline input produces one data row: Name is Example; Notes contains both lines, including the comma. Reopened CSV output. The splitter retains both input records because it has no separate header option.

The value-type input and saved workbook show 00127 as text, 12.50 as numeric 12.5, a 20-digit identifier and 03/04/2026 as text, and a blank third cell with later values still in columns D and E. CSV cannot store these types; choose Text when importing identifiers.

Frequently asked questions

Why are my dates reversed?

A spreadsheet can interpret dates using its locale. Use an unambiguous source format and check day and month after export; formatting a wrong date does not recover its original meaning.

Will a Word paragraph become a table automatically?

No dependable field structure exists in a paragraph. Define the columns and separators first, or copy an existing table.

Why is an amount stored as text?

Ordinary short dot-decimal values become numbers. Comma decimals, currency symbols, exponents, plus-prefixed values, dates and long identifiers remain text. Verify the source convention before deliberately converting those cells in your spreadsheet.

Before you finish

Use the checks above on the saved result before replacing your original.