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
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,, 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.

Who is Participating?
yo_beeConnect With a Mentor Director 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.
Export file and choose CSV
Sunil ChauhanConnect With a Mentor Expertise in Exchange Server, Office 365 & Powershell ScriptingCommented:
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.