• Home
  • Documents
  • Excel
  • How to export/save selection, active sheet or multiple sheets to CSV files in Excel?

How to export/save selection, active sheet, or multiple sheets to CSV files in Excel?

Sometimes we need to export workbook's data to CSV files when we need to send a CSV file of the Excel data to other users or to import a CSV file of the Excel data in other programs. Here we provide you with two methods to export and save workbooks as CSV files.

Export/save selection to a individual CSV file in Excel

Export/save active sheet to individual CSV file in Excel

Export/save multiple sheets to individual CSV files in Excel  good 3

Export/save each sheet as a separate PDF/TEXT/CSV file or individual workbook in Excel

Easily combine multiple worksheets/workbooks into single worksheet/workbook

It may be tedious to combine dozens of sheets from different workbooks into one sheet. But with Kutools for Excel’s Combine (worksheets and workbooks) utility, you can get it done with just several clicks!

ad combine sheets books 1

Kutools for Excel includes more than 120 handy Excel tools. Free to try with no limitation in 30 days. Read More      Free Download Now


arrow blue right bubble Export/save active sheet to CSV file with Save As feature


Save sheet as CSV with Save As feature

By default, the Excel workbook will be saved in the format of .xlsx. If you need to export the data of active worksheet to a CSV file, you can use the Save As command with the following steps:

1. Activate the worksheet you want to export or save as a CSV file, and click File (or Office Button) > Save As.

2. In the opening Save As dialog box, please select the destination folder you will save the CSV file into, name the CSV file in the File Name box, and then select the CSV (Comma Delimited) from the Save as type drop down list. See left screenshot:

3. Click the Save button in the Save As dialog box.

4. Two warning dialog box will come out, please click the OK button or Yes button to close them.


arrow blue right bubble Export/save  each sheet or multiple sheets as separate CSV files

For exporting each sheet or multiple sheets in active workbook as separate CSV files, the above VBA may be not convenient enough. This method recommends Kutools for Excel’s Split Workbook utility, which can help Excel user quickly export each sheet or multiple sheets as separate CVS files with several clicks.

Kutools for Excel - Combines More Than 120 Advanced Functions and Tools for Microsoft Excel

1. Click Enterprise > Workbook > Split Workbook. See screenshot:

Excel addin: export each sheet as a separate CSV

2. In the opening Split Workbook dialog box, please do as follows:

Excel addin: export multiple sheets as separate CSV files

(1) In the Workbook name section, please check the worksheets which you will export as separate CSV file;

(2) Go to Options section, check the Specify save format option, and select the CSV (Macintosh (*.csv) from below drop down list. See left screenshot:

(3) Click the Split button.

3. In the opening Browse For Folder dialog box, please specify the destination folder where you will save the exported CSV files into, and click the OK button.

And now all specified worksheets are exported as separated CSV files and saved into the specified folder. See screenshot:

Export mutliple sheets as separated csv files

Free Download Kutools for Excel Now


arrow blue right bubble Export/save selection as a separate CSV file in Excel

The Export Range to File utility of Kutools for Excel can help us export the specified selection from active worksheet as a CSV file in Excel easily.

Kutools for Excel - Combines More Than 120 Advanced Functions and Tools for Microsoft Excel

1. Select the range which you will export as CSV file, and click Enterprise > Import / Export > Export Range to File, see screenshot:

doc export excel data to csv 11

2. In the Export Range to File dialog box, (1) please check the CSV (Comma delimited) option in the File format section;  (2)check the Save the actual values option or Save values as shown on-screen option as you need in the CSV file options section; (3) specify the destination folder where you will save the exported CSV file in the Save directory box; (4) click the Ok button. See above screenshot:

3. In another Export Range to File, please type a name for this new CSV file, and click the Ok button.

doc export excel data to csv 10

So far the selected range has been exported as a separate CSV file.

Kutools for Excel's Export Range to File tool makes it possible to easily export a range of date to a file, either an Excel workbook, a CSV file, a text file, a simple HTML or all formatting HTML.  

Free Download Kutools for Excel Now

Easily mass save each sheet as a separate PDF/TEXT/CSV file or individual workbook in Excel

Normally we can save active worksheet as a separate .pdf file, .txt file, or .csv file with the Save As feature. But Kutools for Excel’s Split Workbook utility can help you easily save each workbook as separate PDF/TEXT/CSV file or workbook in Excel. See screenshot:

ad split workbook pdf 1


arrow blue right bubbleRelated Articles:


Recommended Productivity Tools

Office Tab

gold star1 Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.

Kutools for Excel

gold star1 Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!

gold star1 200 New Features for Excel, Make Excel Much Easy and Powerful:

  • Merge Cell/Rows/Columns without Losing Data.
  • Combine and Consolidate Multiple Sheets and Workbooks.
  • Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion.
  • Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,
  • More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools...

Screen shot of Kutools for Excel

btn read more      btn download     btn purchase

Add comment


Security code
Refresh