How to Split Data Into Different Columns (Comma Delimited txt File to Microsoft Excel)

Have you ever been stuck with a "comma delimited" txt file that is almost impossible to work with?

Working with one GIANT block of text in a txt file is a nightmare, but luckily, it's pretty easy to copy and paste all the data and organize it with ease in Microsoft Excel (or for that matter, Google Sheets). Just follow these steps:

Copy and paste all of the text into a new excel file
Highlight the column that contains your list (in this example, column A).
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!

00:00 - Intro
00:22 - Copy and paste all of the text into a new excel file
00:48 - Highlight the column that contains your list (in this example, column A)
01:05 - Go to Data (in the toolbar), then click on "Text to Columns"
01:22 - Choose Delimited. Click Next.
01:47 - Choose Comma. Click Next.
01:56 - Choose General or Text. Leave Destination as is, or choose another column. Click Finish.
02:28 - How to separate names in Excel? Split first and last name into different columns
04:13 - What if you are using Google Sheets instead of Microsoft Excel?

Join Our Community!
REtipster Forum: https://retipster.com/forum
REtipster Facebook Group: https://retipster.com/facebookgroup

Follow Along!
YouTube: https://retipster.com/youtube
Facebook:   / retipster  
Instagram:   / retipster  
Twitter:   / retipsterblog  
Twitter:   / retipsterseth  
Pinterest:   / retipster  
LinkedIn:   / retipster  
TikTok:   / retipster