How to Make a CSV File in Excel for Contacts (With Easy Steps)

What Is a CSV File?

You will unavoidably come across a comma-separated values file, or CSV, if you work with spreadsheet programs like Microsoft Excel. A CSV file is a plain text file. This file can be opened in various programs, including the Notepad app and any program that supports plain text.

A CSV file commonly uses commas to denote informational separations. It’s a method for applications that can’t necessarily communicate directly with one another to share structured data, such as the contents of a spreadsheet. We can transfer data between two programs as long as they can both open CSV files. For instance, you can export contact data from Microsoft Excel as a CSV file and import it into Outlook’s address book.

Step 1: Create a dataset

I have added a dataset of Customer information for ABC Traders.
The dataset has three columns, B, C, and D, called Name, ID, and Email ID.
The dataset ranges from the B5 cell to the D10.

dataset of how to make a csv file in excel of contacts

Read More: How to Create CSV File from Excel

Step 2: Go to Save As Option

Go to the file option in your toolbar.

save as option of how to make a csv file in excel of contacts

You can see the home tab on the left side of the window.
Find the Save As option there.

save as option of how to make a csv file in excel of contacts

Select the Save As option.
Click on the Browse option.

save as option of how to make a csv file in excel of contacts

Step 3: Select CSV Option

After selecting the browse option, select a file where you will save it.
Rename the file.
You will find the Save As type option. Select the arrow at the right side of the option.

find the csv option of how to make a csv file in excel of contacts