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:-

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

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.

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

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.