How to Save Multiple Sheets in Excel to CSV (6 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

CSV stands for Comma Separated Values. This means that values are separated only by commas in CSV files. CSV files are essential for database management. We also use Excel for data management. If you are looking for some special tricks to save multiple sheets in Excel to CSV, you’ve come to the right place. In Microsoft Excel, there are numerous ways to save multiple sheets in Excel to CSV. In this article, we’ll discuss six methods to save multiple sheets in Excel to CSV. Let’s follow the complete guide to learn all of this.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


6 Easy Methods to Save Multiple Sheets in Excel to CSV

We will use six effective and tricky methods to save multiple sheets in Excel to CSV in the following section. This section provides extensive details on six methods. You should learn and apply all of these, as they improve your thinking capability and Excel knowledge.


1. Using Save As Command

Here, we will demonstrate how to save multiple sheets in Excel to CSV. Let us first introduce you to our Excel worksheet so that you are able to understand what we are trying to accomplish with this article. There are three worksheets in our Excel workbook. Sheet1 is the first worksheet, its data are shown in the following picture.

Using Save As Command

Sheet2 is the second worksheet, its data are shown in the following image.

How to Save Multiple Sheets in Excel to CSV

Sheet3 is the third worksheet, its data are shown in the following image.

Using Save As command is the easiest and quickest way to save multiple sheets in Excel to CSV. Let’s walk through the steps to save multiple sheets in Excel to CSV

📌 Steps:

  • Firstly, go to the File tab.

How to Save Multiple Sheets in Excel to CSV

  • Next, select Save As and click on CSV (Comma delimited) option. Then, click on the Save button. As a result, the CSV file will be saved in the folder where the previous xlsx file is saved. If you want to save the new CSV format file in another location, you should click on the Browse option and specify a folder where you want to save the new format file.

How to Save Multiple Sheets in Excel to CSV

  • Therefore, we will be able to convert Sheet1 to a CSV-1. Now, we want to convert other Excel sheets into CSV files. Following the aforementioned procedures, we must convert Sheet2 into a CSV-2 file and Sheet3 into a CSV-3 file.
  • Now, you can see the CSV files in the following picture.

  • As a consequence, you will be able to save multiple sheets in Excel to CSV. If you want to open the file, you have to right-click on it and select the Open with option. Then select Notepad as shown below.

How to Save Multiple Sheets in Excel to CSV

  • The following image shows data from CSV-1, the first CSV file which we create from Sheet1.

  • The following image shows data from CSV-2, the CSV file which we create from Sheet2.

How to Save Multiple Sheets in Excel to CSV

  • The following image shows data from CSV-3, the CSV file which we create from Sheet3.

Using Save As Command

This is how we will be able to save multiple sheets in Excel to multiple CSV files.

Read More: How to Save Excel File as CSV (3 Handy Methods)


2. Convert Multiple Sheets to CSV as ‘CSV UTF-8′ Format

Here, we will use another method to convert Excel to CSV by using the CSV UTF-8 option. Let’s walk through the steps to convert Excel to CSV.

📌 Steps:

  • Firstly, go to the File tab.

Convert Multiple Sheets in Excel to CSV as ‘CSV UTF-8 Format’

  • Next, select Save As and click on CSV UTF-8 (Comma delimited) option. Then, click on the Save button. As a result, the CSV file will be saved in the folder where the previous xlsx file is saved. If you want to save the new CSV format file in another location, you should click on the Browse option and specify a folder where you want to save the new format file.

  • Therefore, we will be able to convert Sheet1 to a CSV-1. Now, we want to convert other Excel sheets into CSV files. Following the aforementioned procedures, we must convert Sheet2 into a CSV-2 file and Sheet3 into a CSV-3 file.
  • Now, you can see the CSV files in the following picture.

  • As a consequence, you will be able to multiple sheets in Excel to CSV. If you want to open the file, you have to right-click on it and select the Open with option. Then select Notepad as shown below.

How to Save Multiple Sheets in Excel to CSV

  • The following image shows data from CSV-1, the CSV file which we create from Sheet1.

  • The following image shows data from CSV-2, the CSV file which we create from Sheet2.

How to Save Multiple Sheets in Excel to CSV

  • The following image shows data from CSV-3, the CSV file which we create from Sheet3.

Convert Multiple Sheets in Excel to CSV as ‘CSV UTF-8 Format’

This is how we will be able to save multiple sheets in Excel to multiple CSV files.

Read More: How to Save Multiple Excel Sheets as One PDF (2 Easy Methods)


3. Embedding VBA Code

By using a simple code, you will be able to save multiple sheets in Excel to CSV. You have to follow the following steps.

📌 Steps:

  • Firstly, press Alt+F11 to open the VBA editor. Select Insert > Module.

Embedding VBA Code to Convert Excel to CSV

  • Next, you have to type the following code
Sub Save_Excel_to_csv()
Dim ws1 As Worksheet
Dim path_1 As String
Application.ScreenUpdating = False
path_1 = ActiveWorkbook.Path & "" & Left(ActiveWorkbook.Name, InStr(ActiveWorkbook.Name, ".") - 1)
For Each ws1 In Worksheets
ws1.Copy
ActiveWorkbook.SaveAs Filename:=path_1 & "" & ws1.Name & ".csv", FileFormat:=xlCSV, CreateBackup:=False
ActiveWorkbook.Close False
Next
 Application.ScreenUpdating = True
End Sub
  • Afterward, close the Visual Basic window. After that press Alt+F8.
  • When the Macro dialogue box opens, select Save_Excel_to_CSV  in the Macro name. Click on Run.

  • Therefore, you will get the CSV files in the following picture.

  • As a consequence, you will be able to multiple sheets in Excel to CSV. If you want to open the file, you have to right-click on it and select the Open with option. Then select Notepad as shown below.

How to Save Multiple Sheets in Excel to CSV

  • The following image shows data from CSV-1, the CSV file which we create from Sheet1.

How to Save Multiple Sheets in Excel to CSV

  • The following image shows data from CSV-2, the CSV file which we create from Sheet2.

  • The following image shows data from CSV-3, the CSV file which we create from Sheet3.

Embedding VBA Code to Convert Excel to CSV

Read More: How to Save VBA Code in Excel (3 Suitable Methods)


Similar Readings


4. Using CSV UTF-16 Encoding Option

Here, we will use another method to convert Excel to CSV by using the CSV UTF-16 option. Let’s walk through the steps to save multiple sheets in Excel to CSV.

📌 Steps:

  • Firstly, go to the File tab.

Excel File to CSV UTF-16 Conversion

  • Press Save As in the File window.
  • After that, select Unicode Text from the drop-down list

How to Save Multiple Sheets in Excel to CSV

  • Then, press Save. Hence, you’ll get a .txt
  • 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.

How to Save Multiple Sheets in Excel to CSV

  • Therefore, we will be able to convert Sheet1 to a CSV-1. Now, we want to convert other Excel sheets into CSV files. Following the aforementioned procedures, we must convert Sheet2 into a CSV-2 file and Sheet3 into a CSV-3 file.
  • Now, you can see the CSV files in the following picture.

How to Save Multiple Sheets in Excel to CSV

  • As a consequence, you will be able to multiple sheets in Excel to CSV. If you want to open the file, you have to right-click on it and select the Open with option. Then select Notepad as shown below.

How to Save Multiple Sheets in Excel to CSV

  • The following image shows data from CSV-1, the CSV file which we create from Sheet1.

  • The following image shows data from CSV-2, the CSV file which we create from Sheet2.

How to Save Multiple Sheets in Excel to CSV

  • The following image shows data from CSV-3, the CSV file which we create from Sheet3.

Excel File to CSV UTF-16 Conversion

This is how we will be able to save multiple sheets in Excel to multiple CSV files.

Read More: [Fixed!] Excel CSV File Not Saving Changes (6 Possible Solutions)


5. Utilizing Google Sheets

Here, we will use another method to convert Excel to CSV by using the Google Spreadsheets option. Let’s walk through the steps to save multiple sheets in Excel to CSV.

📌 Steps:

Use Google Spreadsheets for Turning Excel Files into CSV

  • Select Import from the File option.

How to Save Multiple Sheets in Excel to 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).

How to Save Multiple Sheets in Excel to CSV

  • Next, open the downloaded file.
  • Therefore, we will be able to convert Sheet1 to a CSV-1. Now, we want to convert other Excel sheets into CSV files. Following the aforementioned procedures, we must convert Sheet2 into a CSV-2 file and Sheet3 into a CSV-3 file.
  • Now, you can see the CSV files in the following picture.

Use Google Spreadsheets for Turning Excel Files into CSV

  • As a consequence, you will be able to multiple sheets in Excel to CSV. If you want to open the file, you have to right-click on it and select the Open with option. Then select Notepad as shown below.

How to Save Multiple Sheets in Excel to CSV

  • CSV-1 is the first CSV file that is converted from Sheet1, its data are shown in the following picture.

Use Google Spreadsheets for Turning Excel Files into CSV

  • CSV-2 is the CSV file that is converted from Sheet2, its data are shown in the following picture.

How to Save Multiple Sheets in Excel to CSV

  • CSV-3 is the CSV file that is converted from Sheet3, its data are shown in the following picture.

Use Google Spreadsheets for Turning Excel Files into CSV

This is how we will be able to save multiple sheets in Excel to multiple CSV files.

Read More: How to Save a Worksheet in Excel (2 Handy Approaches)


6. Using Online Converter

Here, we will use another method to save multiple sheets in Excel to CSV by using an online website converter. Let’s walk through the steps to save multiple sheets in Excel to CSV.

📌 Steps:

Convert Multiple Sheets in Excel to CSV Using Online Converter

  • Next, select the file from your computer that you would like to convert Excel to CSV and click on Open.

  • Now, select CSV as a conversion option and click on Convert.

  • Finally, you will be able to convert Excel to CSV and click on Download to download the file.

  • Therefore, we will be able to convert Sheet1 to a CSV-1 Now, we want to convert other Excel sheets into CSV files. Following the aforementioned procedures, we must convert Sheet2 into a CSV-2 file and Sheet3 into a CSV-3 file.
  • Now, you can see the CSV files in the following picture.

Convert Multiple Sheets in Excel to CSV Using Online Converter

This is how we will be able to save multiple sheets in Excel to multiple CSV files


Conclusion

That’s the end of today’s session. I strongly believe that from now you may save multiple sheets in Excel to CSV. If you have any queries or recommendations, please share them in the comments section below.

Don’t forget to check our website Exceldemy.com for various Excel-related problems and solutions. Keep learning new methods and keep growing!


Related Articles

Saquib Ahmad Shuvo

Saquib Ahmad Shuvo

Welcome to my Profile. I am working on and researching Microsoft Excel right now, and I will be posting articles about it here. I received a B.Sc. in Naval Architecture and Marine Engineering from the Bangladesh University of Engineering and Technology (BUET). Having studied naval architecture, I have a strong interest in research and development. Always try to learn from different sources and come up with creative solutions.

2 Comments
  1. are you serious with this guide?
    besides the vbs method, you are actually “advising” to repeat the save as steps?
    how is this a “guide”?

  2. Greetings, IVAN
    I appreciate your question. This article explains how to save multiple Excel sheets to CSV. We demonstrate not only the VBA method but also two very effective methods: using Google Sheets and using an online converter. Here, we also illustrate some basic methods to save multiple sheets of Excel to CSV by using Save As command, ‘CSV UTF-8′ Format, and CSV UTF-16 Encoding Option.

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo