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.
Save Multiple Sheets in Excel to CSV: 6 Easy Methods
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.
Sheet2 is the second worksheet, its data are shown in the following image.
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.
- 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.
- 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.
- 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.
- The following image shows data from CSV-3, the CSV file which we create from Sheet3.
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
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.
- 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.
- 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.
- The following image shows data from CSV-3, the CSV file which we create from Sheet3.
This is how we will be able to save multiple sheets in Excel to multiple CSV files.
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.
- 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.
- 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.
- The following image shows data from CSV-3, the CSV file which we create from Sheet3.
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.
- Press Save As in the File window.
- After that, select Unicode Text from the drop-down list
- 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.
- 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.
- 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.
- The following image shows data from CSV-3, the CSV file that we created from Sheet3.
This is how we will be able to save multiple sheets in Excel to multiple CSV files.
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:
- Open a blank Google Sheets at first as shown below.
- Select Import from the File option.
- Then, select the desired Excel workbook and press Import data.
- Consequently, it’ll open the file in the spreadsheet.
- Now, select File >Â Download >Â Comma Separated Values (.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.
- 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.
- CSV-1 is the first CSV file that is converted from Sheet1, its data are shown in the following picture.
- CSV-2 is the CSV file that is converted from Sheet2, its data are shown in the following picture.
- CSV-3 is the CSV file that is converted from Sheet3, its data are shown in the following picture.
This is how we will be able to save multiple sheets in Excel to multiple CSV files.
Read More: How to Save Excel as PDF
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:
- Firstly, go to https://convertio.co/xls-csv/ and click on Choose Files.
- 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.
This is how we will be able to save multiple sheets in Excel to multiple CSV files
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
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.
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”?
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.