CSV or Comma-separated values are a commonly used format that stores tabular data. It is commonly used for import/ export of data. The CSV format allows you to glance at the file and immediately diagnose if there is a problem with the data. CSV file is plain text so It is easy to read and understand without any learning curve.
Follow the steps below to convert Excel to CSV file.
- Open your Excel file then click on File/Office button.
2. Then click on Save As. This will open Save As dialog box.
3. Choose the destination folder where you want to save your Excel file in the CSV format.
4. Then select CSV (Comma delimited) for Save as type and click on Save.
5. 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.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.
6. Your CSV file will be saved at your chosen destination folder.
