How to convert excel file to csv
Answers
If you need to export an Excel file to some other application, e.g. to the Outlook Address book or Access database, you can convert your Excel worksheet to CSV first and then import a .csv file in another program. Below you will find the step-by-step instructions to export an Excel workbook to the CSV format by using Excel's Save As command.
In your Excel workbook, switch to the File tab, and then click Save As. Alternatively, you can press F12 to open the same Save As dialog.
To convert an Excel file to CSV, switch to the File tab and click Save As.
In the Save as type box, choose to save your Excel file as CSV (Comma delimited).
Save your Excel worksheet as a CSV (Comma delimited) file.
Besides CSV (comma delimited), a few other csv formats are available to you:
CSV (comma delimited). This format saves an Excel file as a comma-separated text that can be used in another Windows program or another version of Windows operating system.
CSV (Macintosh). This format saves your Excel workbook as a comma-separated file for use on Mac operating system.
CSV (MS-DOS). Saves your Excel file as a comma-separated file for use on the MS-DOS operating system.
Unicode Text (*txt). This is a computing industry standard supported by almost all current operating systems including Windows, Macintosh, Linux and Solaris Unix. It can handle characters of almost all modern languages and even some ancient ones. So, if you Excel file contains data in a foreign language, save it in the Unicode Text format first and then convert to CSV, as explained in Exporting Excel to CSV UTF-8 or UTF-16.
Note. All of the above mentioned formats save only the active Excel sheet.
Choose the destination folder where you want to save your Excel file in the CSV format, and then click Save.
After you click Save, Excel will display two dialogs. Don't worry, these are not error messages and everything is going right.
The first dialog reminds you that only the active Excel spreadsheet will be saved to the CSV file format. If this is what you are looking for, click OK.
Only the active Excel spreadsheet will be saved to the CSV format.
If you need to save the contents of all the sheets your workbook contains, click Cancel and then save each spreadsheet individually as a separate Excel file (workbook). After that save each Excel file as CSV.
Clicking OK in the first dialog will display a second message informing you that your worksheet may contain features unsupported by the CSV encoding. This is Okay, so simply click Yes.
A worksheet may contain features unsupported by the CSV encoding.
This is how you convert Excel to CSV. The process is quick and straightforward, and you are unlikely to run into any hurdles along the way.
How to convert Excel file to CSV
If you need to export an Excel file to some other application, e.g. to the Outlook Address book or Access database, you can convert your Excel worksheet to CSV first and then import a .csv file in another program. Below you will find the step-by-step instructions to export an Excel workbook to the CSV format by using Excel's Save As command.
In your Excel workbook, switch to the File tab, and then click Save As. Alternatively, you can press F12 to open the same Save As dialog.
To convert an Excel file to CSV, switch to the File tab and click Save As.
In the Save as type box, choose to save your Excel file as CSV (Comma delimited).
Save your Excel worksheet as a CSV (Comma delimited) file.
Besides CSV (comma delimited), a few other csv formats are available to you:
CSV (comma delimited). This format saves an Excel file as a comma-separated text that can be used in another Windows program or another version of Windows operating system.
CSV (Macintosh). This format saves your Excel workbook as a comma-separated file for use on Mac operating system.
CSV (MS-DOS). Saves your Excel file as a comma-separated file for use on the MS-DOS operating system.
Unicode Text (*txt). This is a computing industry standard supported by almost all current operating systems including Windows, Macintosh, Linux and Solaris Unix. It can handle characters of almost all modern languages and even some ancient ones. So, if you Excel file contains data in a foreign language, save it in the Unicode Text format first and then convert to CSV, as explained in Exporting Excel to CSV UTF-8 or UTF-16.
Note. All of the above mentioned formats save only the active Excel sheet.
Choose the destination folder where you want to save your Excel file in the CSV format, and then click Save.
After you click Save, Excel will display two dialogs. Don't worry, these are not error messages and everything is going right.
The first dialog reminds you that only the active Excel spreadsheet will be saved to the CSV file format. If this is what you are looking for, click OK.
Only the active Excel spreadsheet will be saved to the CSV format.
If you need to save the contents of all the sheets your workbook contains, click Cancel and then save each spreadsheet individually as a separate Excel file (workbook). After that save each Excel file as CSV.
Clicking OK in the first dialog will display a second message informing you that your worksheet may contain features unsupported by the CSV encoding. This is Okay, so simply click Yes.
A worksheet may contain features unsupported by the CSV encoding.
This is how you convert Excel to CSV. The process is quick and straightforward, and you are unlikely to run into any hurdles along the way