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

While working on an Excel Worksheet, sometimes you may need to work with a set of information like customer information, product information, or contacts of students or others. These pieces of data need to be appropriately handled. As a result, you need to convert the excel file into a CSV file to preserve the contact information. In this article, I will show you how to make a CSV file in Excel for contacts. This is a concise and precise process. Hopefully, this article will help you to enhance your skill.


Download Practice Workbook

Please download the workbook to practice yourself


What Is a CSV File?

A comma-separated values file, or CSV, is something you will unavoidably come across if you work with spreadsheet programs like Microsoft Excel. A CSV file is a plain text file. This file can be opened in a variety of 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-by-Step Procedures to Make a CSV File in Excel for Contacts

From here, I will show you how to make a CSV file in Excel for contacts. I hope you will find interest in this article. Hopefully, this will increase your Excel skill. Let’s follow the procedures step by step to complete the method. I have added illustrations for your better understanding.


Step 1: Create a dataset

This is the first step of this procedure. I will create a dataset about Customer information of ABC Traders. Have a look at the following points.

  • I have added a dataset of Customer information for ABC Traders.
  • The dataset has three columns, B, C, & 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 Convert Multiple Excel Files to CSV (3 Suitable Ways)


Step 2: Go to Save As Option

This is is the second step of this method. I will show the next step of how to make a CSV file for contacts. Look at the following steps.

  • First, go to the file option in your toolbar.

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

  • Then you can see the home tab on the left side of the window.
  • After that, you will find the Save As option there.

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

  • Then, select the Save As option.
  • Hence, click on the Browse option.

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

Read More: How to Convert Excel Files to CSV Automatically (3 Easy Methods)


Similar Readings


Step 3: Select CSV Option

This is the third step of the procedure. I will show you how to select the CSV option and where you will find the option. So, without any further delay, let’s jump into the step.

  • After selecting the browse option, you need to select a file where you will save the file.
  • Then, rename the file.
  • After that, 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

  • Then, find out the CSV option from the list of options.
  • After that, select it.

  • Hence, you will see the CSV option in the Save As type box.
  • Then, select the Save option.

Read More: How to Apply Macro to Convert Multiple Excel Files to CSV Files


Step 4: Final Result

As a result, you will find the file in CSV format.

Read More: How to Convert Excel to CSV without Opening (4 Easy Methods)


Things to Remember

  • You should remind in your mind that this process is applicable only for Excel 2016 and the upper version of Excel.

Conclusion

In this article, I have tried to explain how to Make a CSV File in Excel for Contacts. I hope, you have learned something new from this article. Now, extend your skill by following the steps of these methods. You will find such interesting blogs on our website Exceldemy.com. I hope you have enjoyed the whole tutorial. If you have any kind of queries feel free to ask me in the comment section. Don’t forget to give us your feedback.


Related Articles

Souptik Roy

Souptik Roy

Hello there. This is Souptik Roy. I graduated from Naval Architecture & Marine Engineering department. I am trying to explore the world of Microsoft Excel and want to increase my analytical power apart from my Engineering degree, as I have a curious mind. this is why I am trying to learn Excel Operations and write articles to help others.

We will be happy to hear your thoughts

Leave a reply

5 Excel Tips
You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo