How to Convert a Comma Delimited txt File to a Microsoft Excel xls File

Published: 10 October 2015
on channel: REtipster

75,098

441

Ever been stuck with a list in "comma delimited" format? Working with one GIANT block of text in a txt file is pretty much impossible, but luckily, it's not difficult to transfer it to a properly organized excel file by following these simple steps:

0:00 - Intro
1:11 - How to copy all the text
1:32 - What do to in Microsoft Excel
2:04 - Data, Text to Columns, Delimited, Check "Comma", General, Finish

Copy and paste all of the text into a new excel file
Highlight the column that contains your list.
Go to Data (in the toolbar), then click on "Text to Columns"
Choose Delimited. Click Next.
Choose Comma. Click Next.
Choose General or Text, whichever you prefer.
Leave Destination as is, or choose another column. Click Finish.

Give it a try and you'll see what I mean - it's pretty easy!

Watch video How to Convert a Comma Delimited txt File to a Microsoft Excel xls File online, duration hours minute second in high quality that is uploaded to the channel REtipster 10 October 2015. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 75,098 times and liked it 441 visitors.