Excel 2013 is compatible with a variety of different file formats, and you can even choose the default format in which Excel 2013 files are saved. The file type can also be selected on a file-by-file basis, which is helpful when you have contacts that require their data in a particular format.
One popular format is .csv, and Excel 2013 is able to create files with that file extension from any spreadsheet that you have opened in the program. Our guide below will show you how.
There are several things to be aware of before you save to the .csv file format –
- You will still have the original .xls or .xlsx file. Saving to .csv exports your worksheet as a copy of the original worksheet. Therefore, be sure to save the original .xls or .xlsx file after saving the .csv file if you have made any changes to your data.
- A .csv file can only be a single worksheet. If you have multiple worksheets in your workbook, then you will need to save each of them individually if you need all of the data as a .csv.
- Files in the .csv file format will not maintain any of the Excel formatting or features. A .csv file is a basic text document with “delimiters” that separate the different cells or fields. The file you create below will have comma delimiters.
Here is how to save in the .csv file format in Excel 2013 –
- Open the worksheet in Excel 2013.
- Click the File tab at the top-left corner of the window.
- Click Save As at the left side of the window.
- Select the location where you wish to save the .csv file.
- Click the drop-down menu to the right of Save as type, then click the CSV (Comma delimited) option.
- Click the OK button to confirm that you understand that Excel is only saving the current worksheet.
- Click the Yes button on the pop-up window to confirm that you understand you may be losing some features by saving in the .csv format.
These steps are also shown below with pictures –
Step 1: Open your worksheet in Excel 2013.
Step 2: Click the File tab at the top-left corner of the window.
Step 3: Click the Save As button in the column at the left side of the window.
Step 4: Choose the location where you wish to save your .csv file.
Step 5: Click the drop-down menu to the right of Save as type, then click the CSV (Comma delimited) option. Note that there are two other CSV options as well – CSV (Macintosh) and CSV (MS-DOS), in case your file needs require those formats instead.
Step 6: Click the OK button on the pop-up window. Note that this will not display if your workbook only has one worksheet.
Step 7: Click the Yes button to confirm that you realize that formatting will be lost by saving to the .csv file type.
If your .csv file needs require a different delimiter to separate the fields in your file, then learn how to change the delimiter in Windows 7 to use the character that you require.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.