• 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

Batch export/save each sheet or multiple sheets to individual CSV files in Excel  good 3

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

Recommended Productivity Software

Office Tab: Use tabbed interface in Office as the use of web browser Chrome, Firefox and Internet Explorer.
Kutools for Excel: Adds 120 powerful new features to Excel. Increase your productivity in 5 minutes. Save two hours every day!
Classic Menu for Office: Brings back your familiar menus to Office 2007, 2010, 2013 and 2016 (includes Office 365).

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


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. It shows a warning dialog box asking you to save only the active sheet as a CSV file, click the OK button. See screenshot:

5. Another warning dialog box comes out asking you to leave out any incompatible features with a CSV file, click the Yes button. See screenshot:


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:


Is your problem solved?

Recommended Productivity Tools

The following tools will greatly save your time and effort, which one do you prefer?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: 120 powerful new functions for Excel, Increase your productivity in 5 minutes. Save two hours every day!
Classic Menu for Office: Bring back familiar menus to Office 2007, 2010, 2013 and 365, as if it were Office 2000 and 2003.

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 More than 120 powerful advanced functions which designed for Excel:

  • 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