Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

How to export Excel data to CSV?

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 several methods to export and save worksheet data as CSV files.

  1. Export data in active worksheet to CSV 00:03
  2. Export data in active worksheet to CSV UTF-8 00:48
  3. Export filtered table to CSV 02:22
  4. Export data in selection to CSV 04:00
  5. Export each worksheet to CSV in bulk 05:16

Quickly split a workbook to separate Excel / PDF / TXT / CSV files in Excel

Normally we can split a workbook to individual Excel files with the Move or Copy feature in Excel. But Kutools for Excel's Split Workbook utility can help you easily split a workbook and save each worksheet as a separate PDF/TEXT/CSV file or workbook in Excel. Full Feature Free Trial 30-day!

ad split workbook csv2

Kutools for Excel - Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit card required! Get It Now

Export data in active worksheet to CSV

By default, the Excel workbooks are saved as XLSX file in Excel 2007 or later versions. If you need to export the data in the active worksheet to a CSV file, you can use the Save As feature as follows:

1. Activate the worksheet you want to export to a CSV file and click File > Save As > Browse.

2. In the Save As dialog box, please:

Kutools for Excel

Stand out from the Crowd

300 Handy Tools
Solve 80% Problems in Excel
Free Trial Now

Say goodbye to terrible VBA and formulas!

(1) Select the destination folder you will save the CSV file into;
(2) Name the CSV file in the File Name box;
(3) Select CSV (Comma Delimited) from the Save as type drop down list;
(4) Click the Save button. See screenshot:

3. Now a dialog comes out warns you it will save only the active sheet. Please click the OK button to go ahead.

4. Another dialog opens and warns you some features might be lost. Please click the Yes button to finish saving.

So far, all data in the active worksheet has been saved in a CSV file.

Export data in active worksheet to CSV UTF-8

If you require the exported CSV file is encoding as UTF-8, this method will help you achieve it.

1. In Excel, activate the worksheet whose data you will save as CSV, and click File > Save As > Browse.

2. In the Save As dialog, please:
(1) Open the destination folder you will save the new file in;
(2) Name the file in the File name box;
(3) Specify Unicode Text(*.txt) from the Save as type drop down list;
(4) Click the Save button. See screenshot:

3.Now dialogs come out and warn you only the active worksheet will be saved and some features would be lost. Please click the OK and Yes buttons successively.

4. Close the Excel window. And double click the new .txt file to open it in the Notepad window (or other default text editor as you preset).

5. In the Notepad window, please click File > Save As.

6. In the Save As dialog, please:
(1) Specify the Save as type as All Files (*.*);
(2) Change the file name extension to .csv in the File name box;
(3) Select UTF-8 from the Encoding drop down list;
(4) Click the Save button.

Now all data in the active worksheet is exported as a CSV file encoding as UTF-8.

Want to split your workbook as an expert now, and win the appreciation of others?

split icon 0

Split Workbook will split the current workbook with 3 clicks only, save all worksheets as separated files in bulk, and save 90% time for you to enjoy life.

  1. All worksheets can be saved in 5 file formats: PDF, CSV, TXT, XLS, and XLSX, meet 98% work needs, make you more likable in work.
  2. Each new file carries the name of the worksheet automatically, save your time on renaming them one by one manually, far away from mouse hand.
  3. Split Workbook is one of 300 features provided by Kutools for Excel, which will help you stand out from the crowd, never worry about job cut.
  4. Choice of 110,000+ highly effective people and 300+ famous companies. Full feature free trial 30-day, no credit card required.

Export filtered table only to CSV

In some cases, you may have filtered a table by certain criteria, and want to export the only filtered data to a CSV file. For example, I have filtered all sales records of peach from a fruit sales table as below screenshot shown. Now I will guide you to export the only filtered peach sales records to an individual CSV file in this method.

1. Select all filtered records in the table, and press Ctrl + C keys together to copy them.

2. Create a new worksheet, select Cell A1 in it, and press Ctrl + V keys together to paste the copied records.
Now you will see only the filtered records are pasted to the new worksheet. See screenshot:

3. Stay in the new worksheet and click File > Save As > Browse.

4. In the Save As dialog, please:
(1) Select the destination folder you will save the CSV file into;
(2) Type a name for the CSV file in the File name box;
(3) Select CSV (Comma delimited) (*.csv) from the Save as type drop down list;
(4) Click the Save button.

5. Now dialogs come out and warn you only the active worksheet will be saved and some features would be lost. Please click the OK and Yes buttons successively.

Now only the filtered data in the table is exported to a new CSV file.

Kutools for Excel - master Excel in 3 minutes

Want to Improve your work ability in Excel now, bring your family a better life?

  • Improve 80% work efficiency, solve 80% Excel problems, save you 2 hours every day to improve yourself and accompany family.
  • Say goodbye to painful formulas and VBA codes, free up your memory! Reduce thousands of mouse clicks, farewell to mouse hand.
  • 300 handy tools for 1500 work scenarios, help you work better and stand out from the crowd, never worry about job cut.
  • Spend $39.0, worth more than $4000.0 training of others, save every penny for you to enjoy life.
  • Choice of 110,000+ highly effective people and 300+ famous companies. Full feature free trial 30-day, no credit card required.
Read More          Download Now

Export data in selection to CSV

The Export Range to File feature of Kutools for Excel can help us export the selection to a .csv file easily in Excel.

Kutools for Excel - Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit card required! Get It Now

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

2. In the Export Range to File dialog, please:
(1) Check the CSV (Comma delimited) option;
(2) Click the Browse button  to specify the destination folder you will save the new CSV file into;
(3) It’s optional to check the Open the file after exporting. option;
(4) Click the Ok button.

Kutools for Excel - Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit card required! Get It Now

3. In the second Export Range to File dialog, please enter a name for the new CSV file, and click the Ok button.

Now all data in the specified selection is exported to a new CSV file.

The Export Range to File feature can export a range of data to a single Excel workbook, a CSV file, a simple or all formatting HTML file. Get it now!

Export each worksheet to a separate CSV file

This method recommends Kutools for Excel’s Split Workbook feature to quickly export each worksheet to a separate CVS file in bulk with several clicks.

Kutools for Excel - Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit card required! Get It Now

1. Click Kutools Plus > Split Workbook. See screenshot:

2. In the Split Workbook dialog box, please do as follows:
(1) Check the worksheets which you will export to CSV in the Worksheet name section;
(2) Check the Save as type option, and select CSV (Macintosh (*.csv) from below drop down list.
(3) Click the Split button.

3. In the 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 each checked worksheet is exported to an individual CSV file in bulk. See screenshot:
doc export data to csv 017

The Split Workbook feature can save or export each worksheet of active workbook to an Excel workbook, Excel 97-2003 Workbook, or TXT/CSV/PDF file separately. Get it now!

300 tools help you stand out from the crowd now

with Kutools for Excel - never worry about job cut

Kutools for Excel brings 300 handy tools for 1500 work scenarios, helps you work faster and better than your colleagues, and easily win trust of your boss. You will be the last one in the list of layoffs, and easily maintain a stable and better life for your family!

  • To be a master of Excel in 3 minutes, and easily win appreciation of others.
  • Improve 80% work efficiency, solve your 80% problems in Excel, not work overtime.
  • Speed up your work, save 2 hours every day to improve yourself and accompany family.
  • Say goodbye to complicated formulas and VBA code, free up your memory.
  • Reduce thousands of keyboard operations and mouse clicks, far away from mouse hand.
  • Spend $39.0, worth more than $4000.0 training of others.
  • Choice of 110,000+ highly effective people and 300+ famous companies, work stable in Excel.
  • Full feature free trial 30-day, no credit card required.
Read More ...
Free Trial Now
 
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 · 5 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 · 5 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 · 5 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 · 5 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 · 5 years ago
    Does this tool support CSV (MS DOS) delimited ?
  • To post as a guest, your comment is unpublished.
    Jagdish Hinduja · 5 years ago
    Hi,

    I tried the 1st option for create a CSV file. I was successful in doing that. However, when I am importing the csv file on an .aspx page, it is not importing the file successfully. Can someone please help? It is urgent
  • To post as a guest, your comment is unpublished.
    Heather Thompson · 5 years ago
    Maybe this will help. Kutools for Excel might be the answer.