Import Text Files Into Excel
Once in a while you may encounter data in a text form. If you copy this data and paste it directly to Excel, all columns will be pasted into one column, rendering it unusable. But don’t worry, Excel provides users with a way to import text files into Excel without losing structure.
I’m going to use this txt file for this tutorial:
These records shows customer information records of a fictional company and extracted in text format (Customers.txt).
If you copy them and paste them into Excel, all the data will be pasted into one column. This will make your data useless. But there is an easy way to import text files into Excel without loss of structure.
- Open Excel and navigate to “Open File” menu.
- Locate the text file you want to open. If you can’t find it, type file name or change file type to txt.
- When you click ok, Excel will display Text Import Wizard. Move to 2nd screen.
- Here you need to tell Excel how your data is structured by choosing delimiters.
- Choose appropriate delimiter (space for this data). Then click next to continue.
- You can set data type for each column in 3rd screen. Choosing “General” is usually sufficient.
- When you click finish button, your data will be imported. Arrange column widths and you are good to go.
As you can see it is pretty easy to import text file into Excel.