1. Home
  2. Troubleshooting
  3. How to open TXT files in Excel

How to open TXT files in Excel

TXT is just a tab delimited format, so Excel can easily import them, you just need to go through a small Excel wizard.

Open Excel, then choose ‘File’ – ‘Open’ and locate your file. Please note you may need to change the Type to be ‘All Files (*.*) before you will be able to see your file.

txtexcel1

 

The ‘Text Import Wizard’ will then start. Just choose ‘Delimited’ on the first step.

txtexcel2

 

Then ‘Tab’ on the second step.

txtexcel3

Then select finish. The file will then open neatly in Excel.

 

Was this article helpful?

Related Articles