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: retipster.com/forum
REtipster Facebook Group: retipster.com/facebookgroup
Follow Along!
RUclips: retipster.com/youtube
Facebook: / retipster
Instagram: / retipster
Twitter: / retipsterblog
Twitter: / retipsterseth
Pinterest: / retipster
LinkedIn: / retipster
TikTok: / retipster

[@shashwatjha9001]

Thanks a lot for this video. Precise and to the point!

[@herbertnicholas5777]

Thank you, this was helpful. Straight on point and easy to understand. Thanks.

[@Retipster]

Glad it helped!

[@4urbanlens338]

Like the way you simplified it with the 3 names example too. Learnt something handy today and saved me a bunch of time. Thanks

[@Retipster]

Glad it helped! Thanks for watching!

[@Skeletonfinger1]

You just saved me 2 hours of manual rewriting, thank you!

[@Retipster]

YES! That's what I like to hear! Thanks for watching. :)

[@princelanga8061]

Thank you!!! This was very helpful Sir.

[@virajkaluarachchi4978]

I am stucked on this and now i am solved that. Thanks a lot mate 😎

[@skylarlopez-kohler7298]

This made my day, thanks!

[@ajaykushwaha-je6mw]

Only because of this trick i am about to complete my month task in few days. Thank you sooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo much!

[@sirishajotheeswaranpadmase3416]

That's a great insight! Thank you !

[@christianimeh8229]

Thanks so much for the video. was just what i was looking for

[@Ttn_Sounan]

It's Helpful. Thanks for the content❤

[@ujwalakuramdasu9533]

Really very helpful......made task easy. Thanks

[@joppev]

Thank you! Huge help. Other videos couldnt help me and I ran into some problems, but not with your approach!

[@Retipster]

That's great to hear! Thanks for letting me know.

[@syedrahim694]

Thanks man... Its very much helpful

[@fatsonyandoro3697]

So helpful thanks 👍

[@animeforever8508]

wow, just what i needed, Thanks a lot man.

[@shaourghauri3408]

Thank you so much for this video. I was looking for this kind of help for 5 months

[@Retipster]

Alright! I'm so glad it helped!

[@jeonwonwoo4500]

THANK U SO MUCH! I'm currently doing my project about banking.

[@teohsuping5141]

Thank you for sharing.

[@Shayshay98987]

You saved my day! Thanks!

[@allRAryans]

Extremely helpful Seth ❤️🙏🏼👍🏼

[@Retipster]

Glad to hear that! Thanks for watching.

[@samahsaeed1261]

Thank you that was fast and helpful

[@shielajanetahoynon6489]

Life saver thanks a lot! I have an hour left on my activity deadline hehe.

[@user-ns2wk6wo6g]

straight to the point. Thank you.

[@Retipster]

Happy to help!

[@harshavardhan5510]

Thanks for helping

[@JohnKeyMusic]

Life savior! Thank you so much!

[@yusraal-sabahi5309]

You saved my life thank you ❤❤❤❤❤❤❤❤❤

[@colleenl3042]

Thank you! Thank you! Thank you!

[@tonytone141]

Great video!! Thanks for the info and the help!!

[@Retipster]

Thanks for watching!

[@mimsydreams]

OMG life saver! Thank you!

[@benjaminrawat4725]

Saved my life , thanks mate :)

[@md.abushama9164]

Many thanks.. Benefitted

[@pointsagencynet]

this helpful thank you😍

[@LeftSeatAdventures]

Just what I needed, thanks!

[@Retipster]

Thanks for watching!

[@miafrothingham5133]

YOU ARE A LIFESAVER!

[@Retipster]

Happy to help!

[@deniseguilavogui2918]

Thank you so much for the video

[@gihanmadusanka50]

Thank you for the video. Actually that's what I'm really looking for.

[@Retipster]

Glad to hear it! Happy to help.

[@sainathbuthagaddala5327]

loved a lot

[@aftabahmed6868]

thanks very useful video

[@xxShatteredPeacez]

You just saved me so much time! Thank you!!

[@Retipster]

Thanks for watching!

[@dipenbhuva2061]

Thank you :)

[@QariMuhammadAbbas]

Thank You So Much for sharing this Brilliant Technique very simply! Great Video!

[@Retipster]

Of course! Happy to help!

[@mariocarvalho1392]

Thank you so much!

[@Retipster]

You're welcome!

[@RichyFourVideos]

Holy shit this just saved me 2 days worth of manual data filtering

[@Retipster]

Alright! Glad to hear that!

[@tutorialswithamy3850]

THANK YOU SO MUCH!

[@Retipster]

Of course!

[@joosttoast8714]

Great help thanks!

[@Retipster]

You bet!

[@anissakecili]

thank you very helpful

[@technicalboardhphp4097]

Great job sir , u have really Indestructible knowledge of excel......

[@Retipster]

Wow, you're too kind. Thanks!

[@lilo-hiho]

Oh my god this is the most useful video on youtube you saved me thanks🙏🙏

[@Retipster]

Glad to hear that! haha Thanks for watching.

[@nobulawutwala2127]

Great Tutorial!

[@Retipster]

Thanks for watching!

[@anthony.m97]

Thankyou for this video

[@Retipster]

Sure thing!

[@user-bb1vl9tc9d]

Thank you so much. You are a live saver.

[@Retipster]

Glad it helped!

[@ameybhalerao1695]

Thank you sir

[@rogercarlsson3677]

Thanks a lot!

[@verawilliams9135]

Thank you so much you were a life saver!!!

[@Retipster]

Glad to help!

[@siphiwemashaile2129]

My man... just saved me a weeks of work...

[@Retipster]

Glad to hear that!

[@vijeys3138]

Thank you so much !!! U saved me hours !! Liked and subscribed to your channel

[@Retipster]

Awesome! Glad to hear that!

[@mykhailokaniuk4820]

Man, You're definitely worth the Hammer of Thor!)) Thanks a LOT!

[@Retipster]

Lol, thanks!

[@kv8671]

Thanks a lot

[@supul32]

Thank you!

[@Retipster]

Of course! Happy to help.

[@leondanster8998]

Thank you man u a star!!!!!!!!

[@techdelivers1017]

Thankyou brother :)

[@muhammedshebin9161]

Thank you man

[@Retipster]

Happy to help!

[@buvanasampath3592]

Thanks a lot for this information

[@Retipster]

Absolutely!

[@kondibaabhange]

It's great👏 🙏

[@lahcenrerbal5893]

Thank you so much

[@Retipster]

You bet! Thanks for watching!

[@mesfindelelegn1165]

thank you so much this is very important information

[@Retipster]

Thanks for watching!

[@ddalton8754]

Thank you!! Life saver for titration lab lol

[@nanjijemea4751]

life saver 🥺

[@mphorampatla]

thank you

[@yb_bakery]

Hey man, you don't know me, but I love you. Keep doing what you do - you inspire me to become an excel master.

[@Retipster]

Thanks, Yusuf! All the best to you!

[@jagathbandara992]

thanks a lot i was very much trouble in cv data intering

[@activelisting6793]

Thank you so much ^_^

[@IDCWoodcraft]

perfect. Thanks

[@Tsr2412]

thank you so much ! it saved a lot of my time..... once again tysm !!!!!

[@Retipster]

Glad to hear that!

[@user-it9gr4ek7e]

thank you very much

[@Retipster]

You're welcome!

[@fbergmansr]

Always wondered how to split raw data in Excel. This was great...THANK YOU!

[@Retipster]

You're welcome!

[@mfundohg958]

😭Thank you so much

[@mohamedshatarah7264]

THANK YOU ALOT

[@willdickens3927]

You saved my life bro

[@Retipster]

Glad to hear that!

[@rpedro17]

Hi there, thankx for your video. i have a question, if i always have same separator rule is it possible to creat some sort of script to apply each time to the txt file that i want to convert to excel ? i mean , each month i receive 10 txt files that i have to converto manually to excel, using separators, so is there any excell rule that will do that in to a automatic way ? knowing that i know all separator numbers... thank you in advance, sorry for my english :)

[@ishanakhtar2012]

you saved me, but i figured out my data was separated by semi-colons and checked other and specified the ";" sign instead of comma... Phew! Thank you!

[@Retipster]

That's great to hear! I'm glad you were able to figure it out. Whew!

[@rebateshome9255]

Thank You Sir

[@Retipster]

Glad to help!

[@sandeeplk8342]

Thank you so much....🙏

[@Retipster]

You're most welcome.

[@Brmmalesela]

Thank you

[@Retipster]

You're welcome!

[@barthwalabhishek]

Thanks

[@rahul-ti9cm]

amazing

[@cesaralzate6879]

thank u

[@jeffgoldsmith9619]

You the man

[@Retipster]

Thanks for watching, Jeff!

[@darwingarciajuarez4739]

Totally helpful!

[@aparnavijayan7754]

Thnk you

[@irfanrahmadi2135]

thanks a lot!!!!! i've been tired for searching opening txt file method that value contains lot of comma. it always breaks into columns automatically if i directly open from excel and convert delimited. this is exacly what i need.

[@Retipster]

Glad to hear that! Thanks for watching!

[@sabaaslam4766]

thanksss

[@swagatmishra9350]

Thanks..

[@darkky4983]

Hey Hello Sir,
I am trying to make comma separated number if number greater than 999 like 111.111 to 111.111 but 99999999.9999999 to 99,999,999.99999999(after decimal whatever the value are in file)and there are 1 column name x which have this type of value
Can you please help in this??

[@user-ic8td4tx2c]

Thanks,

[@Retipster]

You're welcome!

[@PhilRoberts-bh6fm]

This just helped the shit out of me. Thank you

[@Retipster]

Glad it all came out okay!

[@saivamsicheekati]

Tq 🙏

[@zhugeliang3905]

Please provide an example of the jumbled-up file for practice.

[@essaali6101]

Wowwwwwwwww, you saved me

[@Retipster]

Glad to hear that!