Convert a Column or Rows of Data into Comma Separated Values

CSV. This is the acronym for comma separated values or Cash Surrender Value (if you are selling insurance). But this is not an insurance blog so I'll stick with the former definition. If you work with data, sometimes you get it in one format and you've got to put it into another format to get more data. In this case you get a list of values in a column and you'd need to take that list and input it into some program to get more data. But the input there is one input field and it takes the list in a CSV format. Basically all those separate values together, but separated by commas. This task is not so bad if you've got a few values like this:
1

2

3

Then you'd just need to convert this to the CSV format of 1,2,3.

But what if you had a hundred values? or maybe a thousand values? Doing this manually would just suck all the time from your life. Well here's Excel to the rescue. You can actually do this quite easily. So check out the video to see how.

0:00 Intro
1:30 CONCATENATE Function
2:34 Fill Handle to Copy Formula

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

#excel
#msexcel
#doughexcel

-~-~~-~~~-~~-~-
Please watch: "Convert Table in a PDF File to Excel"
-~-~~-~~~-~~-~-

[paulmcdevitt]

Brilliant. Nice use of existing formula to do something very useful. Needed to create a list of country ISO codes separated by commas to enter into an antispam filter. Saved hours...:)

[gabitirsinable]

you got a subscriber, you saved my wife's life doing manually 5000 lines of phone numbers, THANKS !!

[sarahross]

THANK YOU FOR MAKING THIS SO CLEAR AND EASY FOR SOMEONE LIKE ME WHO ABSOLUTELY HATES EXCEL. YOU ARE A SAINT.

[hollywillowbrook]

Thanks so much, Doug! I couldn't get a CSV file to work to transfer my spreadsheet mail list to my gmail contacts so I could let folks new about my new tarot course "Learn to Read Tarot in a Weekend"... This was such a simple and elegant solution! You're my hero ♥

[PoVTube]

The best people in the world are found on youtube. Thank you sir for this great tip!

[nikpatil]

It's a amezing technique you have given to everyone who will used the excel & want to merge the data in one cell. Thanks a lot.

[sonuchopra]

Love you sir, You don't know, my how much time you have saved. Thanks for your valuable video, you know what you are saving our time and God will bless you with so much time to spend with your family, and I mean it.

[retlem]

You, Sir, are a life saver! Man this is very helpful when you have 22, 000 keywords to export for SEO into Excel! THANK YOU!

[tfreeb]

This helped me today a great deal. I knew how to do it in reverse, but not the other way. THANK YOU! I had a group of over 300 zip codes. Manual input was not an option!

[MrMiller]

This is the best Youtube video I have ever seen. Thanks so much for your help!!!

[Itamey]

Awesome! Straight to the point! Appreciation from Kenya!

[jeroen]

short and sweet, exactly what I needed, great job Dough!

[MikeJMcCormack]

Well done Doug! You saved me hours of work! Thank you!

[stevecampbell]

Thank you Doug H! I will be using this daily in queries!

[vasudevaragul]

This is exactly what I was looking for. Thank you.

[PeterLech]

Excellent. I never would have figured this out on my own, plus you taught me a few new things. Thanks so much!

[TheRoadtoFinalLight]

Worked like a charm, for newer Excel versions you might need to use the ; as a separator instead of a comma. Thanks Doug. Timesaver

[christieindah]

Hi Dough, i was looking for this such of formula for hours.
Thank you soooo much!

[phantom]

Useful and easy to follow! thanks for the quick video

[nikkostadinov]

This is very clever and easy way. Working perfect! Thank you!!!