How to Format XLS to CSV

The XLS file format was the standard file format for Microsoft Excel files prior to Microsoft Excel 2007. You can still open and edit .xls files in Excel 2007, as well as save a file as a different file format. One of the available file formats to which you can save is comma separated values or .CSV. No formats or formulas are saved with CSV -- it only saves simple text. CSV separates each value of a record using a comma or a semi-colon.

Things You'll Need

• Microsoft Excel

Instructions

1. Open the .xls file that you want to convert.

2. Click on the Microsoft Office button in the upper-left corner, then click on "Save As."

3. Click on the drop-down menu next to "Save as Type" and select "Comma Delimited (.csv)."

4. Click "Save."

References

• Microsoft: Save a Workbook in Another File Format