How to Convert Excel Files to CSV Format File

In this blog post, I will explain how to convert Excel Files to CSV format files.

Here, we are going to use the below Excel dataset and we are going to convert this dataset into CSV (Comma Separated Value) format.

See the image below:-

Convert Excel File to CSV
Convert Excel File to CSV Image_01

First, go to the location of our dataset where we have saved it.

We named our Excel Dataset My Dataset, and when looking at the properties of this file, the extension is (xlsx).

Convert Excel File to CSV
Convert Excel File to CSV Image_02

Our goal is to convert the Excel file into CSV format (Comma Delimited).

Convert Excel Files to CSV Format File

To convert this file into the CSV format, you the below procedure step by step.

The first step in converting an Excel file into a CSV format is to open it.

Convert Excel Files to CSV
Convert Excel Files to CSV_Image_03

Now click on the ‘File’ menu and then click on the ‘Save As’ option.

Convert Excel Files to CSV
Convert Excel Files to CSV_Image_04

Then click on the ‘Browse’ folder to find the location to save our CSV formatted file.

Once you find the location then named our CSV formatted file as ‘My CSV Dataset’ or as you want.

See the image below.

Once you have named your CSV formatted file, follow the next step ‘Save as type‘ below the ‘File name’ box to save it.

Here you will find the many file formats by clicking on the ‘Save as type’ drop-down arrow.

See the image below:-

Find the ‘CSV (Comma delimited)’ format from the listed formats and click on it.

You have to select the CSV (Comma delimited) format for your file.

And click on the ‘Save’ button below.

Once you click on the save button, you will get the below message box.

Which is saying that ‘Some features in your workbook might be lost if you save it as CSV (Comma delimited).

Do you want to keep using that format?

Choose the option ‘Yes’ here from the listed options, Yes, No, and Help.

Once you press ‘Yes’, your Excel Dataset file is now converted into the CSV (Comma delimited) formatted.

Now go to the file location where you have saved this CSV file and check the file properties by right-clicking on it.

You will see that our file format is now converted to CSV (Comma delimited).

You can see it in the image above.

Now it is time to open this CSV formatted file.

Go to the location where our file is stored or saved.

Right-Click on the ‘My CSV Dataset’ file and then select ‘Open with’ from the listed options and choose ‘Notepad’ to open the CSV file.

See the image below:-

And see that your file “My CSV Dataset” is open in CSV format.

So here in this tutorial you have seen how we have converted our Excel formatted file into CSV (Comma delimited) file format.

If you want to learn more about this, please visit Microsoft Office Support.

I hope you find this tutorial useful.

Please put your comment or suggestion in the comment box below.

Related Post

VBA Macro to Dynamically Copy and Paste from One Sheet to Another

How to Lock Scroll Area in Excel with VBA (Step By Step Guide)

How to Hide Blank Rows in Excel Using VBA Macro

3 Quick Ways to Move or Copy a Worksheet into Another Workbook

3 Quick Ways to Change the Font Color in Excel VBA

How to Split Cells Diagonally in Excel (Step by Step Guide)

3 Easy Ways to Select the Visible Cells Only In Excel

How to Insert Blank Rows after Every (2nd or 3rd or nth) Row in Excel

5 Ways to Delete Blank Rows in Excel (With VBA Macro)

Leave a Comment

Your email address will not be published.