How do you save an Excel file as a CSV file?


Quick Answer

To save an Excel document in CSV format, first open the document, click the File tab in the menu bar and select Save As. Once the Save As window appears, choose a destination for the CSV file you wish to create, and type the name of the document. Next, navigate to the Save As Type section, click the drop-down menu, and select CSV (Comma delimited) (*.csv) from the list of available options. Click Save at the bottom of the window.

Continue Reading

Full Answer

A dialog box saying that only the active spreadsheet will be saved in CSV format should appear. If you need to save the contents of all your worksheets, click Cancel, save each spreadsheet individually as a separate Excel file and then save each file in CSV format. Otherwise, click OK.

A second dialog box informing you that your worksheet may contain features unsupported by the CSV encoding should appear. Click Yes. If the CSV file is to be used on a Mac, select the CSV (Macintosh) format, instead of CSV (Comma delimited) (*.csv). If the file is meant for a computer running MS-DOS, select CSV (MS-DOS). Through specialized tools such as Export Range to File, you can export Excel data from a specific range in CSV format.

Learn more about Software

Related Questions