Converting a .txt file with tab as separators into a excel spreadsheet

Question

I have lines of data in a text file where each entry is separated by tab. I want them in different columns and each line to form a separate row in Excel.

I tried using Data > Import but it all comes in on single column. Is there a way to do this ?

score 5 · Answer 1 · answered Oct 15 '14 at 05:49

Select all of the data, paste into excel and then use the 'text import wizard' from the dropdown. Use the 'delimited' data type with tab separators and you should be set.

Also please add full information in future questions (version of excel, etc.).

score 3 · Answer 2 · edited Jun 12 '20 at 13:48

3

Go to the Data tab and select text to columns under data tools then select delimited and hit next. Then select Tab [or] Space¹ as the delimiter and hit finish

enter image description here

¹You may need to check treat consecutive delimiters as one

_{brought to you in part by our sponsors}

edited Jun 12 '20 at 13:48

Community

1

answered Oct 15 '14 at 08:22

Raystafarian

21,963
12
64
91

score 1 · Answer 3 · answered Oct 15 '14 at 07:16

1

If I recall, Excel will ask when you open a specific file to specify the column delimiter if you OPEN the file as a .txt or .csv file.

answered Oct 15 '14 at 07:16

mdpc

4,489

Converting a .txt file with tab as separators into a excel spreadsheet

3 Answers3