How to Save as a CSV File in Excel 2013

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 –

  1. Open the worksheet in Excel 2013.
  2. Click the File tab at the top-left corner of the window.
  3. Click Save As at the left side of the window.
  4. Select the location where you wish to save the .csv file.
  5. Click the drop-down menu to the right of Save as type, then click the CSV (Comma delimited) option.
  6. Click the OK button to confirm that you understand that Excel is only saving the current worksheet.
  7. 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.

excel 2013 file tab

 

 

Step 3: Click the Save As button in the column at the left side of the window.

click save as button

 

 

Step 4: Choose the location where you wish to save your .csv file.

choose location for 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.

select the csv file type

 

 

Step 6: Click the OK button on the pop-up window. Note that this will not display if your workbook only has one worksheet.

click ok

 

 

Step 7: Click the Yes button to confirm that you realize that formatting will be lost by saving to the .csv file type.

click yes

 

 

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.

solveyourtech.com newsletter
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.