Need help copying data from Excel and separating the data in a .CSV by commas (see screenshot for example)

Need to know how to grab all the data from the column FIRST NAME and LAST NAME in the Excel list and export them to a CSV seperate by commas

Excel list
2017-12-21_14-35-47.png
This CSV file is for the purpose of creating 300 user email account in Office 365. So, from the Excel list (screenshot above), I would need email, First Name, Last Name, and First and Last Name to be seperated by commas in the CSV file. For example, 1234@sample.com, john, doe, John S Doe . Is this something I need to do in the CSV file? Some sort of setting? Those who have worked with Office 365 and need to create mass email accounts will likely know what I am talking about or have gone through this.

2017-12-21_14-31-06.png
joukiejoukAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

yo_beeDirector of Information TechnologyCommented:
Is this a single EXCEL file?
If so you can do a save as > change the format drop down to CSV for file type.
Or
Export file and choose CSV
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Sunil ChauhanLead AdministratorCommented:
open a new workbook, select and copy the entire column you need in the new book one by one, once you have all the column you need in CSV, go to file and select save as and choose to save as the .csv format.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Exchange

From novice to tech pro — start learning today.