How to Convert a Text File to Excel Using Delimiters

You've got a plain text file full of data, and you need it in Excel so you can actually work with it. The good news is that Excel has a built-in import wizard that reads delimiters to figure out where each column starts and ends. Once you understand how that works, moving data from TXT to a spreadsheet takes only a few minutes.

What Is a Delimiter, Exactly?

A delimiter is just a character that separates pieces of data in a text file. Think of it as an invisible column divider. When Excel sees that character, it knows to start a new cell.

The most common delimiters you'll run into are listed below. Knowing which one your file uses before you open the import wizard saves a lot of back-and-forth.

If you're not sure what delimiter your file uses, open it in Notepad or any plain text editor. You'll be able to spot the repeating separator character pretty quickly.

💡 Tip: If your file uses an unusual delimiter like a pipe or tilde, you can swap it to a comma or tab first using the online delimiter converter at Delimiter.site. That can make the Excel import step much smoother.

How to Import a TXT File Into Excel

The steps below apply to Excel 2016 and later, including Microsoft 365. Older versions are similar, though the menu labels might look slightly different.

1. Open Excel and go to Data in the top menu bar.
2. Click Get Data, then choose From File, then From Text/CSV.
3. Browse to your TXT file and click Import.
4. Excel will show a preview and try to detect the delimiter automatically.
5. Check the preview. If the columns look wrong, change the delimiter in the dropdown.
6. Click Load to bring the data into your spreadsheet.

In older versions of Excel, this process goes through the Text Import Wizard, a three-step dialog that walks you through choosing file origin, delimiter type, and column data format. It's a bit more manual, but gives you very fine-grained control.

Using the Text Import Wizard (Older Excel)

If your Excel opens the classic wizard automatically when you open a TXT file, here's what each step does.

• Step 1: Choose whether the file is delimited or fixed-width. Almost always, you'll pick delimited.
• Step 2: Select your delimiter character. You can check multiple boxes if needed.
• Step 3: Set the data format for each column, like text, date, or general.

The preview pane updates in real time as you make changes, so you can see exactly how the columns will split before committing.

⚠️ Watch out: If your data contains commas inside quoted fields (for example, "Smith, John"), make sure the wizard recognizes the text qualifier (usually a double quote). Otherwise those commas will break your columns incorrectly.

Fixing Delimiter Problems Before You Import

Sometimes the cleanest approach is to fix your text file before touching Excel at all. If your delimiter is inconsistent or the wrong type for your use case, a quick conversion saves a lot of cleanup later.

You can use the delimiter converter to swap one delimiter for another in seconds, right in your browser. No software to install, no formulas to write.

You might also want to check for duplicate rows before importing. A duplicate line remover can strip those out of your text file before it ever reaches Excel, keeping your spreadsheet clean from the start.

Key Points

• A delimiter is the character that tells Excel where one column ends and the next begins.
• Common delimiters include commas, tabs, pipes, and semicolons.
• Excel's TXT import tool (or the Text Import Wizard in older versions) handles most delimiter types automatically.
• Always check the preview before loading to catch column-splitting errors early.
• Converting or cleaning your delimiter before importing makes the whole process faster and less error-prone.

Make the Process Repeatable

If you import text files into Excel regularly, it's worth building a small checklist. Open the file in a text editor, confirm the delimiter, clean up any obvious issues, then run the import. That three-step habit prevents most of the common headaches.

And when you need to prep your files quickly, tools like the Delimiter Tool are there to handle the formatting work so you can focus on the data itself.