How to Convert Excel File to CSV Format (5 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

The full form of CSV is ‘Comma Separated Values’. It’s a format where we can see the numbers and texts in plain text. Nowadays, this format is quite popular due to its simplicity. One can easily analyze the data through this format and make the required changes. In this article, we’ll show you the effective ways to Convert an Excel File to CSV Format.


How to Export Excel File to CSV Format: 5 Easy Ways

To illustrate, we’ll use the following Excel file as our source. For instance, the file contains the data about the Salesman, Product, and Sales of a company. We’ll transform respective Excel worksheets into separate CSV files.

convert excel to csv format


1. Convert Excel to CSV Format Through Save As Command

The easiest method for changing an Excel file is through the Excel File Save As command. Therefore, follow the below steps to Convert an Excel File to CSV Format.

STEPS:

  • First, open the Excel workbook and the desired sheet.
  • Then, click File.
  • As a result, the File window will appear. In the left-most pane, select Save As.

Convert Excel to CSV Format Through Save As Command

  • In the Save As window, click the drop-down icon as shown below and choose the CSV (Comma delimited) option.

  • Subsequently, press Save.
  • At last, it’ll create a CSV file which is shown in the following picture.

NOTE: After pressing Save, you’ll get a warning dialog box. It reminds you that only the active worksheet will get converted to a CSV file. And, to get all the sheets in CSV format, you’ve to perform the above steps for each worksheet.


2. Transform Excel to CSV UTF-8 without Destroying Special Characters

The above method is simple but it has a drawback. It can’t transform the special characters (Non-ASCII characters). So, learn the steps below to transform Excel to CSV UTF-8 without destroying Special Characters.

STEPS:

  • In the following dataset, we have a Salesman’s name in Korean.

Transform Excel to CSV UTF-8 without Destroying Special Characters

  • Firstly, go to File.
  • Afterward, select Save As.
  • In the Save As window, select CSV UTF-8 from the drop-down options.

Transform Excel to CSV UTF-8 without Destroying Special Characters

  • Next, press Save.
  • Consequently, it’ll create a new CSV file for the desired sheet and you’ll see the special character in that CSV file.


3. Excel File to CSV UTF-16 Conversion

Moreover, we can follow a different process to convert Excel files with special characters. Hence, learn the following process to carry out the operation.

STEPS:

  • First of all, open the Excel worksheet.
  • Press Save As in the File window.
  • After that, select Unicode Text from the drop-down list.

Excel File to CSV UTF-16 Conversion

  • Then, press Save. Hence, you’ll get a .txt file.
  • Now, open the text file and click Save As.
  • Consequently, a dialog box will pop out.
  • Next, type .csv at the end of the file name and choose All Files in the Save as type.
  • Select UTF-16 LE in the Encoding field and press Save.

  • As a result, it’ll return a CSV file that contains the special characters correctly.


4. Use Google Spreadsheets for Turning Excel Files into CSV

Additionally, we can use Google Spreadsheets for the conversion of Excel files. Now, follow the process below to perform the task.

STEPS:

  • Open a blank Google Spreadsheet at first.
  • Select Import from the File option.

Use Google Spreadsheets for Turning Excel Files into CSV

  • Then, select the desired Excel workbook and press Import data.

Use Google Spreadsheets for Turning Excel Files into CSV

  • Consequently, it’ll open the file in the spreadsheet.
  • Now, select File Download Comma Separated Values (.csv).

  • Next, open the downloaded file.
  • Lastly, you’ll get a new CSV file like it’s shown in the following picture.


5. Apply VBA to Change Multiple Excel Sheets to CSV Format

So far, we’ve covered the transformation of a single worksheet to CSV format. But, we can also convert all the worksheets present in an Excel workbook. For that purpose, we have to apply Excel VBA. In our last method, we’ll show you the steps to carry out the operation. So, see the following process.

STEPS:

  • In the beginning, select any sheet and right-click on the mouse.
  • Then, select View Code.

Apply VBA to Change Multiple Excel Sheets to CSV Format

  • As a result, the VBA window will emerge and a dialog box will appear.
  • Now, copy the below code and paste it into the dialog box.
Sub MultipleSheetsCSV()
Dim st As Worksheet
Dim path As String
Application.ScreenUpdating = False
path = ActiveWorkbook.path & "\" & Left(ActiveWorkbook.Name, InStr(ActiveWorkbook.Name, ".") - 1)
For Each st In Worksheets
st.Copy
ActiveWorkbook.SaveAs Filename:=path & "_" & st.Name & ".csv", FileFormat:=xlCSV, CreateBackup:=False
ActiveWorkbook.Close False
Next
Application.ScreenUpdating = True
End Sub

  • Next, press F5 after saving the file.
  • In the end, it’ll create separate CSV files for each worksheet in that workbook. In this example, we have 5 Hence, it returns 5 CSV files.


Download Practice Workbook

Download the following workbook to practice by yourself.


Conclusion

Henceforth, you will be able to Convert an Excel File to CSV Format following the above-described methods. Keep using them and let us know if you have any more ways to do the task. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.

<< Go Back to Export Excel to CSV | Export Data from Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Aung Shine
Aung Shine

Aung Shine completed his bachelor’s in Electrical and Electronics Engineering from Bangladesh University of Engineering and Technology. It has been almost 2 years since he joined SOFTEKO and actively working on the ExcelDemy project. Currently he works as a Team Leader where he guides his team members to create technical content. He has published 150+ articles and reviewed 50+ articles. He has also solved various user problems before. He has interests in Data Analysis, Power Query, Advanced Excel,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo