Classic Batchbook FAQs and Knowledge Base Importing and Exporting DataHow do I convert an Excel file into a CSV file?

How do I convert an Excel file into a CSV file?

To convert an Excel file into a CSV file, you simply need to save it as another format.

How to save as CSV in Excel 2007

  1. Click the Office button at the top left of the window.
  2. Select Save As from the pull-down menu and then click Other Formats.
  3. From the Save as type pull-down menu, select CSV (Comma delimited).
  4. Click Save.

How to save as CSV in Excel 2003

  1. In Excel, click File.
  2. Select Save as from the pull-down menu.
  3. Under Format (or Save as type), choose CSV (comma delimited).
  4. Click Save.

That should retain the file name and format, but the last three letters will be .csv instead of .xls on the file.