You have a list copied from an email, a report pasted from a web page, or data exported as plain text, and you need it in rows and columns. Retyping is slow and error-prone. This free text to Excel converter turns pasted text into a real spreadsheet: it detects how the columns are separated, shows a preview, and lets you download an .xlsx file or a .csv file. Everything happens in your browser, so your data is not uploaded.
How to convert text to Excel — step by step
- Paste your text into the box, or press Upload .txt to load a .txt, .csv or .tsv file.
- Leave “Split columns by” on Auto-detect. The tool looks at the first lines and picks the separator that appears most consistently. Change it manually if the preview looks wrong.
- Decide about the header. Keep First row is a header ticked if the first line contains column names.
- Check the preview. It shows how many rows and columns were found and displays the first 50 rows as a table.
- Download. Choose Download .xlsx for an Excel workbook or Download .csv for a universal text-based format.
Which separators are supported?
| Separator | Typical source | Example |
|---|---|---|
| Tab | Copying cells from a spreadsheet or a table on a web page | Name⇥Qty⇥Price |
| Comma | CSV exports from many apps and databases | Name,Qty,Price |
| Semicolon | CSV files from European regional settings, where the comma is a decimal sign | Name;Qty;Price |
| Pipe | | Log files and some database exports | Name|Qty|Price |
| Spaces | Simple lists aligned with spaces | Apple 3 1.50 |
Quoted values are handled correctly for comma, semicolon, tab and pipe: a line like "Smith, J",007,2 becomes three cells, not four, because the comma inside the quotes belongs to the name.
How numbers, codes and dates are treated
With Convert numbers ticked, plain numbers such as 3 or 1.50 become real Excel numbers, so you can sum, sort and chart them. The tool is careful with values that only look like numbers:
- Leading zeros stay. 007, 00123 or a postcode such as 01234 remain text, because converting them to numbers would delete the zeros.
- Dots are decimal points. 1.50 becomes 1.5. Numbers written with a comma as the decimal sign, or with thousand separators, remain text to avoid guessing wrongly.
- Dates stay as written. The tool does not reinterpret “03/04/2027”, because it could mean 3 April or 4 March depending on the country. Keeping it as text prevents silent mistakes; convert dates in Excel using the format you intend.
XLSX or CSV: which should you download?
.xlsx is the native Excel format. It opens in Microsoft Excel, Google Sheets, LibreOffice and Numbers, keeps numbers as numbers and text as text, and the tool sets sensible column widths for you. .csv is a plain-text format that almost every program can import. The CSV from this tool is saved in UTF-8 with a byte-order mark, which helps Excel show accents and non-English characters correctly. One caution: when Excel opens a CSV directly, it may automatically turn values such as 007 into 7 or long numbers into scientific notation. If that matters, download the .xlsx instead.
Real-world examples
Turning an email list into a contact sheet
Paste lines like Asha, asha@example.com, Pune, keep the comma separator, and download a three-column sheet ready for a mail-merge.
Cleaning data copied from a web page
Tables copied from a page usually paste as tab-separated text. Paste them here to get a clean spreadsheet without the page formatting.
Expense or inventory lists
Type items and amounts separated by commas or tabs while you are away from a computer, convert them later and add formulas in Excel.
Splitting one column into several
If names and cities are joined by a pipe or semicolon in one cell, paste the column here and choose that separator to split it instantly.
Preparing data for import
Many accounting and e-commerce systems accept CSV. Convert your list, check the preview, and upload the CSV to the system.
Tips for clean results
- Check the first few lines. Auto-detect uses them, so make sure they are representative and consistent.
- Remove stray blank lines. Empty lines are skipped, but lines containing odd spaces can create strange rows.
- Be consistent with quotes. If a value contains the separator, wrap it in double quotes.
- Use the Remove Duplicate Lines tool first if your list contains repeated entries.
- Keep headers short and unique. They make filtering and pivot tables easier later.
- Re-check totals. After converting, sum a numeric column in Excel and compare it with a figure you already know.
A worked example
Suppose you receive this list in an email and want it in a spreadsheet:
Item;Quantity;Price
Notebook;12;2.50
Pen box;5;7.25
"Marker, black";20;1.10
Paste it into the box. Auto-detect sees that the semicolon appears the same number of times on every line and chooses it. The preview shows four rows and three columns, the first row styled as a header. “Marker, black” stays in a single cell because it is inside quotes. With Convert numbers on, 12, 5 and 20 become numbers and 2.50, 7.25 and 1.10 become decimals, so in Excel you can add a total column with a simple formula such as multiplying quantity by price. Download the .xlsx, and you are done in under a minute.
Opening the result in Excel, Google Sheets or Numbers
The .xlsx file works everywhere. In Microsoft Excel, double-click the downloaded file. In Google Sheets, open sheets.google.com, choose File → Import → Upload and select the file. In Apple Numbers, open it from the Files app or Finder. If you downloaded the .csv, use the import command of your program and pick UTF-8 and the comma as separator, so that accents and symbols appear correctly. Once the data is in your spreadsheet program, you can format columns as currency or dates, add filters, build charts and create pivot tables.
Combining with other TextAgo tools
This converter works well as the last step of a small workflow. Extract text from a photographed table with Image to Text, tidy it with Remove Duplicate Lines, then convert it here. Or open a PDF in the Document Viewer, copy the table text and paste it here. All of these run on your own device.
Privacy and limits
Your data is converted in your browser and is not uploaded to TextAgo. The first time you create an .xlsx, your browser downloads an open-source spreadsheet library from a public content-delivery network; that request does not contain your data. TextAgo sets no limit, but very large datasets (hundreds of thousands of rows) depend on your device’s memory. The preview shows only the first 50 rows to stay fast, while the download contains all rows.
Troubleshooting
Everything ends up in one column
The separator was not detected. Choose it manually: Tab for pasted table cells, Comma or Semicolon for CSV text.
Some rows have extra or missing cells
The tool pads short rows with empty cells. Extra cells usually mean a value contains the separator; wrap it in quotes or choose a different separator.
Accents look wrong in Excel
Download the .xlsx version, or import the CSV through Excel’s “From Text/CSV” option and select UTF-8.
Numbers are aligned left like text
Tick Convert numbers. Values with thousand separators or comma decimals must be cleaned first.
Frequently asked questions about text to Excel
How do I convert a text file to an Excel spreadsheet?
Upload the .txt file or paste its contents, check that the preview looks right, and download the .xlsx file.
Can I convert a comma-separated or tab-separated file?
Yes. Both are detected automatically, as are semicolon, pipe and space separators.
Does it create more than one sheet?
The output has a single sheet named “Sheet1”. You can add sheets after opening the file in Excel.
Will formulas be created?
No. The converter produces values only; add formulas in your spreadsheet program.
Is my data sent to a server?
No. The conversion runs in your browser and the file is created on your device.
Is it free?
Yes — free to use, with no sign-up and no watermark.