How to Create a CSV file in Excel

CSV is an open file format, meaning any spreadsheet or database program can open and read the file. This video explains how to create (or save) an Excel file as a CSV file.
If you are using Facebook and want to create a custom audience using your existing customer database, you will need to save your file as CSV to import, or upload it into Facebook. To learn how to upload a CSV file into Facebook
How to format a csv file to upload to Facebook - business/hel...

[@MrJresil]

Why can't every tutorial be this direct??? simple and right to the point. Thanks so much!

[@robertwanko219]

Simplicity is a virtue. Well done.

[@nitinmittal9442]

Simple and to the point Video, Thanks Arleen

[@DebbieLeighDriver]

oh god!! this was just what I needed!!! thank you!

[@kennethwhite2855]

Thank you, simple to the point..

[@sckstt]

This helps a lot. Thank youu, Arleen!

[@tasiacalvert2485]

Thank you ! This helped a lot !

[@kameronmonsefi6652]

Thank you! This was a big help.

[@mattiabianuccitrainer]

Thanks for these valuable informations! :)

[@thynobodi3558]

This was helpful with placing orders with suppliers thank you

[@mnhassan1]

Thanks.........you have explained in a very simple way.

[@dragonmage3802]

Thank you very much, this was very Informative

[@derekprinceweems]

Arlene thank you thank you thank you! Big help!

[@ronelegounlety8204]

Very Helpful. Thank You

[@crocolierrblx9365]

Thanks, this will come in handy when programming js.

[@22keann]

thank you for the tutorial.

[@euniceamede]

This tutorial is very easy to understand thank you.

[@dinardigre5522]

Thank you, good video!

[@md.moijeuddinmolla1328]

Very helpful. Thank you.

[@charlesditch]

Thanks Arleen!!!

[@sprintmall2940]

Thank you very much.

[@rayyanahmed321]

Thanks mam,love from Pakistan,Asia❤

[@multimixtube7702]

hi there, it was easy and understandable ,thanks

[@anelbullen8355]

Thank you very much Arleen. You vide helped me a lot!

[@ArleenWest]

Thank you!

[@aceaguilar3528]

Thank, Arleen. :)

[@TECHNICALHEDGE]

Thanks from #INDIA

[@boyankarshakov2576]

Thanks!

[@shubhamnamdeo3489]

Thank you!

[@abumasroorahmed4203]

to the point...thanks

[@iftekharalisaiyed]

WoW..!! Thanks a lot for creating such a knowledgeable and easy to understand....VIDEO...👍

[@randyblack334]

Nice Tutorial . . . about Microsoft Excel CSV (Comma Separated Values) .
'Buy' is a Word . . . that makes Randy want to wander the Desert in search of Peace .

[@kartikpahwa2674]

THANKS! :)

[@vaibhavgupta4413]

Thanks Arleen👍👍

[@ishfaqahmed555]

Thank you.

[@nope5380]

thank you

[@yosranaeem6385]

thank you your video helped me so much

[@ArleenWest]

You're welcome! I'm glad you found it helpful. :)

[@randomvideos254]

thank you mam so sweet...

[@TheMaxkas]

Thank you

[@sridhar9580]

Thanks....

[@ErronBarbeeYT]

Dr. Arleen You're a GOD

[@user-fn7ig6ln4q]

Thanks Arleen

[@josephgarza5973]

Arleen West! You are just incredible. Thanks for making such an easy to understand video on how to use such a simple sheet in creative and innovative ways. Thank you so much. I'm certain we can all find the value in such knowledge. I have a silly question...
If we label the columns does the data get stored and imported under that specific label?
For example, If I make the coma separated value file for importing to my contacts into my gmail contacts does the information get imported into its respective fields?

[@ArleenWest]

Hi Joseph and thank you for the lovely comment.
To answer your question, when you import data into any program or app you should be given the chance to map your columns to the corresponding fields in the program.
So if your column header (label) is Email Address you would map it to any email address field in Gmail contacts (i.e. email, home email, work email, other email, etc...).

[@josephgarza5973]

@@ArleenWest It's the truth Arleen West! How have you been? How's the reexamining coming along¡?

[@sunnybali5717]

Thank you its very helpful.

[@Abdulhalim-kl8pc]

Thank you mam

[@user-fd1tj4pn4o]

So good

[@kidstime7830]

Thxks

[@zamankhan6683]

Good

[@ondrejj7876]

Hello, where do you put the comma?

[@user-jx7ze4di7u]

Tq

[@munchkin3192]

Thank you so much
But may i ask?
Can I only use my customers phone number? I collect the data from E-commerece, i cant get the email

[@abhishekrowal447]

Your a fkn angel

[@adityaamansingh1820]

so can this CSV file be uploaded on my google account and sync with other devices? and i will be able to access these contacts on my phone.

[@ArleenWest]

Yes you can upload - or import - a CSV file to Google Contacts. :)

[@anphung4214]

Does it work if I just have the phone number and name?

[@noexpert65]

If I want to creat a csv file just to upload to facebook for retargeting... what info do I need in the file? Just the e-mail and phone???

[@ArleenWest]

Yep. Email and/or phone is all you need. :)

[@alcampos1596]

Hi Arlene. Thanks for helpful video on creating a .csv file. Can you also please help on importing images into .csv. I read accepted file sizes are 1-5mb and 300 dpi with accepted .jpg, .pdf, .eps, and tif. file types. Thanx in advance.

[@ArleenWest]

Hi Al. There's no easy way to import the pictures and have them come out nice and neat in your cells. This article provides some good instructions. www.rowshare.com/blog/tips/inserting-pictures-in-excel-as-easy-as-it-seems/. Make sure you resize the cells to be larger than each image before you lock them to resize with the cells. Good luck and thanks for watching!

[@alcampos1596]

Thanks for response! I did exactly as described however; once I close & reopen file images don't reappear. Is this correct? For test purposes, I created a simple file Big 12 college football teams address and helmet (Google Images jpegs) all under a mb. My hope is college address prints w/correct helmet. I'll send folder with helmet images for linking. Think this will work?
I really appreciate your help! :)
Al
@@ArleenWest

[@ArleenWest]

Not sure. I'm not having the problem you described in my test file.

[@viveksharma-tf7eb]

I'm facing problem to load data in python everytime I'm getting 'utf-8' codec can't decode byte 0xe9 in position 539: invalid continuation byte error can anyone suggest why this is happening

[@ArleenWest]

Try this CSV file checker. csvlint.io/

[@josephgarza5973]

Also, could you make a video and talk to us about using this file to interact with Facebook while sharing your screen? Could you show us how to do such a thing, pretty please?

[@ArleenWest]

I have one but it's out of date. I've had other requests for an update as well 😀 so I'll try to put something together soon. Please subscribe and enable notifications so you'll know when I do!
Thanks again for watching and taking the time to comment.

[@josephgarza5973]

@@ArleenWest That's awesome Arlene! You actually do a great job at making these videos, you know? That would be lovely Arlene. And, believe me, I have enabled the notifications so I can be aware of the new videos. XoXo!

[@josephgarza5973]

@@ArleenWest
Arleen, I'd like you to know that you can count on my help if you should ever need it, love. I edit training videos and do some really cool stuff. I use Camtasia. Have you heard of it? You can count on me if you need any help, dear.

[@ArleenWest]

@@josephgarza5973 Thank you!!! That is so kind and generous of you to offer. I have heard of Camtasia, and I've used it in the past. Right now I'm in the process of re-examining where I'm heading with all of this. I hate editing videos, even with Camtasia so I may take you up on your offer. Thanks again!

[@josephgarza5973]

@@ArleenWest
I'd just be delighted to help get your talent out there as best as we could get it, hun! I insist you take me up on that offer. I must insist. You are awesome and we want to get more of you!

[@elizabethkhodr9620]

how to read excel file with two columns and saved as csv? please help me

[@ArleenWest]

Hi Elizabeth. It doesn't matter how many columns your file has, you save it the same way as I demonstrated in the video.

[@elizabethkhodr9620]

@@ArleenWest thank u so much for creating such know a knowledgeable

[@kush_1711]

I am getting the Permission Error how can I fix that....

[@ArleenWest]

More details needed.

[@bartoszklepacki713]

Title should be "How to SAVE CSV file in Excel" Movie does not show how to create it. What data and in what way should we put in columns?

[@ArleenWest]

Thanks for the feedback.
Facebook's instructions on what the file needs can be found here - facebook.com/business/help/2082575038703844?id=2469097953376494.
You can download a sample csv file from within the create custom audience wizard. Good luck!

[@esaugalindo4733]

DO YOU KNOW HOW SEARCH YOUR COMPUTER USING A CSV TO FIND FILES ON YOUR CSV FILE?

[@ArleenWest]

Do you mean search your computer to find a CSV file that contains a specific word or phrase? Use the search function in your file browser.

[@ashishsaxena6112]

whats ut facebook id

[@muhammedeminkurtulan7350]

Thank you!

[@rakibulmojeb2055]

Thank you

[@quinnintoronto]

thank you

[@ArleenWest]

You're welcome!