Plain text files are easy to create but hard to work with. You cannot sort them, filter them, or total a column. A spreadsheet can do all of that, and converting a text file into one should not mean retyping every line. This guide shows how to convert a TXT file into a modern Excel .xlsx spreadsheet, with each line becoming a row.
How a TXT file becomes a spreadsheet
The conversion follows two simple rules. Each line of your .txt file becomes one row in the spreadsheet. Each tab-separated value on that line becomes one cell. A tab is the invisible character made by the Tab key, and it is the standard way to separate columns in plain text. If your file uses commas instead of tabs, replace them with tabs first, or each line will land in a single cell. The modern .xlsx format is the default for Excel since 2007, and it opens in Excel, Google Sheets, and LibreOffice Calc, so the result is easy to share.
How to convert a TXT file to Excel XLSX
- Prepare the text file with one record per line. Each line should hold one item, such as one product or one contact, with its values separated by tabs.
- Check the tabs. Open the file in a text editor and confirm the values on each line are separated by tabs, not by spaces or commas.
- Upload the file. Choose the .txt file from your device and wait for it to load.
- Click Convert. The tool builds the spreadsheet in your browser, with no sign-up, and prepares the download.
- Download the result as converted.xlsx. Save it under a clear name, such as stock-list.xlsx, so you can find it later.
- Open it and check it. Open the file in Excel or Sheets, and confirm each row and column landed correctly. Sort or filter a column to confirm it behaves like a real spreadsheet.
A worked example
A small shop keeps its stock list as a plain text file: one product per line, with name, price, and quantity separated by tabs. The owner uploads the file, clicks Convert, and downloads converted.xlsx. Opened in Excel, the list is a proper table, ready to sort by price or filter by quantity. The original text file stays untouched, so if anything looks wrong, the owner can fix the text and convert again.
Mistakes to avoid
- Do not mix tabs and commas in one file. Pick one separator and use it on every line, or the columns will not line up.
- Do not expect the result to have formatting. Plain text has no bold or colours, so the spreadsheet will be plain, and you can format it afterwards.
- Do not overwrite your original text file. Keep it as the master copy, so you can fix errors and convert again.
- Do not skip the check. Open the downloaded file and confirm the rows and columns are where you expected before you delete anything.
Try it faster with the free tool
The free TXT to XLSX (Excel) Converter below turns a plain text file into a modern Excel .xlsx spreadsheet: each line of your .txt file becomes one row, and each tab-separated value on that line becomes one cell. Upload the file, click Convert, and download the result as converted.xlsx. It runs fully in your browser, and no sign-up is needed.
Try it here: TXT to XLSX (Excel) Converter.
One line per row, one tab per cell, and a check in Excel. That is the whole conversion, and it beats retyping every line.
Questions readers ask
What if my file uses commas, not tabs? Replace the commas with tabs before converting, or each line will land in a single cell. A text editor’s find-and-replace can do this in seconds, as long as your values do not contain commas themselves.
Can I convert a file with thousands of lines? Yes. Each line becomes one row, so a long file becomes a long spreadsheet. Check the first and last rows after converting, because errors usually show up at the edges.
Will formulas in the text work? No. Plain text has no formulas, only values. The spreadsheet will hold the values, and you can add formulas afterwards in Excel or Sheets.