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.
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.
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:
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:
Step 6: Another warning dialog box comes out asking you to leave out any incompatible features with a CSV file, click Yes. See screenshot:
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.
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:
Step 2: In the Export Range to File dialog box, click the 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:
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:
Step 4: And then click Save button, the selected data will be saved as the CSV file.
- 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.
- Export Excel data as HTML
- Export Excel data to Text files
- Save a selection as individual file
- Save selection or entire workbook as PDF