How to Convert XLS to CSVby Liam Rodom Abraham
Moving spreadsheet data between programs can be difficult and frustrating. Luckily, comma-separated values (CSV) work with nearly all spreadsheet programs, including Microsoft Excel, Apple Numbers, and OpenOffice Calc. If you have an existing Microsoft Excel XLS file, it's easy to convert it to CSV so that you can use it anywhere.
Open the XLS file in Microsoft Excel.
Click the "File" menu and choose "Save As." If you are using Microsoft Excel 2007, click the Microsoft Office "Button" and choose "Save As."
Choose one of the CSV formats listed in the "Save as type" drop-down box. If you are using Windows, choose "CSV (MS-DOS)." If you are using Mac OS, you should choose "CSV (Macintosh)."
Choose a filename and a location to save the file.
- photo_camera BananaStock/BananaStock/Getty Images