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

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 and 2013 (includes Office 365).

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

Hint


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:


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