top of page

You are learning The Excel Interface

How do I save my workbook as a different file type (e.g., .csv)?

Here's how to save your Excel workbook as a different file type, like a CSV (Comma-Separated Values) file:

1. Open your workbook: Make sure the Excel workbook you want to save in a different format is open.
2. Go to File: Click on the "File" tab in the top left corner of the Excel window.
3. Select Save As: In the "File" menu, choose the "Save As" option.
4. Browse to your save location: A dialog box will appear. In the "Save As" type box, navigate to the folder where you want to save the converted file.
5. Choose the file format: Click the dropdown arrow next to "Save as type." You'll see a list of different file formats Excel can save in.
6. Select CSV Format: For saving as a CSV file, choose the option relevant to your needs. Here are two common choices:
- CSV (Comma delimited): This is the most common CSV format, separating values with commas.
- CSV UTF-8 (Comma delimited): This format uses UTF-8 encoding, which can handle a wider range of characters compared to standard CSV. Choose this if you have special characters or international characters in your data.
7. Name your file (Optional): In the "File name" box, you can enter a new name for your saved file if you wish. By default, it will likely use the original filename with the new extension.
8. Click Save: Once you've chosen the file format and location, click the "Save" button to save your workbook as the selected file type (e.g., .csv).

Important Notes:

* Saving as a CSV file will remove most formatting from your Excel workbook. For instance, font styles, cell colors, and borders won't be preserved in the CSV file.
* CSVs are plain text files suitable for transferring data between different programs that can read CSV formats. They are not ideal for complex data with formatting or formulas.

bottom of page