How to export Excel data 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 Excel data to CSV files with Save As command

Export Excel data to CSV files with Kutools for Excel

Kutools for Excel: add 120 new features in Excel. Save one hour every day.
Classic Menu for Office: brings back classic menus to Office 2010 and 2013 (includes Office 365).
Office Tab: brings tabbed interface to Office as the use of web browser Chrome, Firefox and Internet Explorer.

arrow blue right bubble Export Excel data to CSV files with Save As command

Hot
Amazing! Using Tabs in Excel like Firefox, Chrome, Internet Explore 10!

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:

Step 1: Activate the worksheet you want to export or save as a CSV file, and click the Save as button under the File tab in Excel 2010, it shows the Save as dialog box. In Excel 2007, click Office Button and Save As button to open it.

Step 2: Type the Name for the CSV file, and select the folder where it will be saved in.

Step 3: Then in the Save as type area, select CSV (Comma Delimited) from the drop down list. See screenshot:

doc-data-to-csv-1

Step 4: Click the Save button in the Save As dialog box.

Step 5: It shows a warning dialog box asking you to save only the active sheet as a CSV file, click OK. See screenshot:

doc-data-to-csv-2

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

doc-data-to-csv-3

Note: the Save as command only exports the data of active worksheet as a CSV file The CSV file formats that you can choose to export data in Excel 2007/2010 as:

CSV (comma delimited) format: Saves a workbook as a comma-delimited text file for use on another Windows operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sheet.

CSV (Macintosh) format: Saves a workbook as a comma-delimited text file for use on the Macintosh operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sheet.

CSV (MS-DOS) format: Saves a workbook as a comma-delimited text file for use on the MS-DOS operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sheet.


arrow blue right bubble Export Excel data to CSV files with Kutools for Excel

The Export Range to File tool of Kutools for Excel can help us export Excel data either from a whole worksheet or from a range as CSV file.

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

Step 1: Apply this utility by clicking Enterprise > Import / Export > Export Range to File, see screenshot:

doc-export-excel-to-csv4

Step 2: In the Export Range to File dialog box, click thedoc-data-to-csv-6 button to select the range which you want to export its data to CSV file. (If you need to export the whole worksheet to a CSV file, you can hold down Ctrl + A keys to select the whole worksheet.) Then check CSV (Comma delimited) option, see screenshot:

doc-export-excel-to-csv5

Step 3: Then click OK. In the pop up dialog box, select the location to save the new file, and input the file name that you need. See screenshot:

doc-export-excel-to-csv6

Step 4: And then click Save button, the selected data will be saved as the CSV file.

Notes:

  • Save the actual value: It will display the actual values in the final file.
  • Save values as shown onscreen: It will display the values in the final file as the same you read them on the computer screen.
  • Open the file after export: It will automatically open the final file after exporting the range.

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. Click to know more about this feature.


Related Articles:


Kutools for Excel

More than 120 Advanced Functions for Excel 2013, 2010, 2007 and Office 365.

screen shot

btn read more     btn download     btn purchase

Comments  

0#Layla2014-03-08 13:06
After exploring a number of the blog articles on your website, I really appreciate your technique of blogging.
I saved as a favorite it to my bookmark webpage list and will be checking back soon.

Take a look at my web site too and tell me how you feel.



My weblog; import & export
Reply | Reply with quote | Quote
0#Heather Thompson2014-03-31 19:22
Maybe this will help. Kutools for Excel might be the answer.
Reply | Reply with quote | Quote
0#Jagdish Hinduja2014-04-07 16:31
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
Reply | Reply with quote | Quote
0#SIbi2014-04-16 10:18
Does this tool support CSV (MS DOS) delimited ?
Reply | Reply with quote | Quote

Add comment


Security code
Refresh