QuickMergeYou have rows of text and you want them in a spreadsheet. Names and emails pasted out of a thread. A list of order numbers from a chat. Query output from a database client. A .csv that Excel insists on dumping into a single column.
None of these need software. All of them need the same small piece of knowledge, and the whole job takes about fifteen seconds once you have it.
The job in one sentence
Converting text to a spreadsheet means deciding where one cell ends and the next begins. That is the entire problem. A line break starts a new row — that part is never in doubt — and a specific character, called the delimiter, marks each column boundary within the row.
Everything that goes wrong in a text-to-Excel conversion is a disagreement about that character.
Delimiters, explained properly
A delimiter is just a character the parser has agreed to treat as a boundary rather than as content. Four are common:
| Delimiter | Where you meet it | Watch out for |
|---|---|---|
Comma , | CSV files, most exports | Values that contain commas — addresses, “1,200” |
| Tab | Copying from a spreadsheet or a web table | Invisible, so it is easy to assume it is spaces |
Semicolon ; | CSV exported in much of Europe | Excel may still expect commas and give you one column |
Pipe | | Database and log output | Rare in ordinary text, which is what makes it safe |
Copying a block of cells out of an existing spreadsheet or an HTML table almost always puts tab-separated text on your clipboard, even though it looks like it is aligned with spaces. That is why pasting straight into a converter usually works without any configuration at all.
Converting text to Excel
- Paste, or load a file. Open the text to Excel file converter and paste your rows into the editor, one record per line. A
.txtor.csvon disk can be loaded instead — it is read locally, not uploaded. - Confirm the delimiter. Auto-detect gets comma, tab, semicolon and pipe right most of the time, and the live counters tell you what it decided: rows, columns, and which delimiter it chose. If the column count looks wrong, pick the delimiter yourself from the dropdown.
- Read the preview. The table under the editor is the finished sheet, not an approximation. Anything misaligned there will be misaligned in Excel, so fix it now — usually by changing the delimiter or quoting a stray value.
- Name it and download. Set a worksheet name (Excel allows up to 31 characters) and a file name, then take the
.xlsx. It is a real workbook: numeric values are written as numbers, so sums and sorting work the moment it opens.
When it is a list, not a table
A single-column list — twelve email addresses, a set of SKUs, a list of file names — needs no delimiter at all. Paste it, and every line becomes one row in column A. Untick First row is a header if the first line is data rather than a label, or the top item disappears into the header row.
If your list is separated by commas on one line rather than by line breaks, replace the commas with line breaks first, or keep it on one line and accept a single row spread across many columns — whichever shape you actually want.
The four things that go wrong
A value contains the delimiter
The single most common failure. Smith, John in a comma-separated file becomes two cells unless it is quoted as "Smith, John". Quoted fields are parsed correctly, so wrapping the affected values fixes it. Switching to tab or pipe as the delimiter fixes it too, and is often easier when the data is full of commas.
Rows have different numbers of fields
If one row has five values and the next has four, the output looks shifted. The parser is behaving correctly; the input is ragged. Look for a stray delimiter, a record that wrapped onto two lines, or a footer line that is not data.
Leading zeros vanish
Postcodes, product codes and ID numbers beginning with zero survive the conversion intact, but a spreadsheet may re-interpret 00713 as the number 713 when it opens the file. If the exact string matters, format that column as text in the spreadsheet after import.
Dates get re-read
The same problem in a different costume. 03/04/2026 is the third of April in most of the world and the fourth of March in the United States, and the spreadsheet decides which based on its own locale, not on your intent. Where it matters, use ISO dates (2026-04-03) in the source text.
Why do this in the browser
Most rows people convert are boring. Some are not: customer lists, salary tables, exported user records, anything with an email address in it. Those are exactly the rows that should not be pasted into a web form that posts them to a server.
A conversion that runs in your browser removes the question entirely. The text you paste stays in the page, the workbook is assembled in the page, and the download comes from the page. There is no upload, so there is nothing to retain, log or leak — and no sign-up, because there is no account for anything to be attached to.
Frequently asked questions
How do I convert a text file to an Excel file?
Load the .txt or .csv in the text to Excel converter, or paste its contents in. Confirm the delimiter, check the preview and download the .xlsx. Nothing is installed and nothing is uploaded.
Why does my CSV open in one column in Excel?
Excel is guessing a delimiter based on your regional settings, and guessing wrong — usually because the file is semicolon-separated and Excel expects commas. Paste the text into the converter, set the delimiter explicitly, and download an .xlsx where the columns are already correct.
Is the output a real Excel file or a renamed CSV?
A real one. It is a genuine Office Open XML workbook assembled in your browser, with numbers written as numeric cells and text as string cells, so formulas and sorting work immediately.
How much data can I convert at once?
Tens of thousands of rows are comfortable in a modern browser. Because everything runs locally the real limit is your device’s memory, so very large datasets are best done in batches.
Can I convert a table from a picture instead?
Yes, but through a different route: screenshot to Excel for a screen capture, or image to Excel for a photo or scan. Both run text recognition first. Where you can select the text, pasting it is exact and much faster.
Will my data be uploaded or stored?
No. Parsing and workbook creation both happen in your browser, and closing the tab clears everything. There is no account and no server-side copy.
In short
Once you can name the delimiter, text-to-spreadsheet stops being a chore. Paste, confirm the split, read the preview, download. The preview is the part worth not skipping — it is the difference between finding a misaligned column now and finding it in a meeting.
Turn your text into a spreadsheet
Free, no sign-up, and your data never leaves the browser.
Open the text to Excel converter
Written by Mehran
Founder of QuickMerge. Practical guides built around the real behavior and limits of the tools. Connect on LinkedIn.