Log in
x
or
x
x
Register
x

or
0
0
0
s2sdefault

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

Easily combine multiple worksheets/workbooks/CSV files into one 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! Click for 60-day free trial!

ad combine sheets books 1


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.


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 Trial Kutools for Excel Now


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 Trial Kutools for Excel Now


Tip: In this Video, Kutools tab and Enterprise tab are added by Kutools for Excel. If you need it, please click here to have a 60-day free trial without limitation!


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. Click for 60-day free trial!

ad split workbook pdf 1


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 star1Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!

gold star1200 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

Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    bi · 3 years ago
    When i export from excel to csv comma delimited i cannot transfer characters displayed in different languages (names in Arabic for instance). How can i also transfer those to the CSV format file?
  • To post as a guest, your comment is unpublished.
    viji · 3 years ago
    This is a not clear i need more detail explain and about some old using old software in excell
  • To post as a guest, your comment is unpublished.
    Amandajean · 3 years ago
    When I export from excel to cvs I need each item to be on a different line. As it leaves a space so the computer does not read next record on the next line. Any ideas
  • To post as a guest, your comment is unpublished.
    jose vigonte · 3 years ago
    i cant really understand csv file..when i save it on a CD.then i open it the csv file get back to other format?
  • To post as a guest, your comment is unpublished.
    SIbi · 3 years ago
    Does this tool support CSV (MS DOS) delimited ?