Export an Excel File to a CSV File

Add to Favorites

How to export an Excel file to a CSV file (comma separated values file).  This allows you to turn any Excel spreadsheet into a CSV file that you can then use to send to another person or easily upload into a database system.

Steps to Export a Worksheet to a CSV File

  1. Make sure your data is positioned exactly as you want it to be positioned.  (Editing a CSV file later if you don't have access to Excel is a real pain.)
  2. Click File > Save As (Office Button > Save As in Excel 2007)
  3. In the window that opens, go to the Save as type drop down menu at the bottom and change the selection to CSV.

    There may be a few options for CSV but the basic one (CSV (Comma delimited)) is the one you want to choose.
  4. Hit the Save button to save the file.
  5. If you have multiple worksheets in your workbook, you will see this warning:

    CSV files can't store multiple tabs of information.  They can only store one worksheet at a time per CSV file.  As such, only the currently visible worksheet will be saved.
  6. Hit the OK and then you might see another warning that says that any incompatible features will not be saved.  Basically, Excel can do a lot of things but a CSV file can only store basic text.

    Hit Yes to continue saving your CSV file.
  7. After all the warning messages, we are finally done.

The new file will look almost exactly like an Excel file but it is not an Excel file.  Here is the new file's icon:

If you open the new file in Excel, it won't look much different, but, open it with a basic text editor, like Notepad, and it will look like this:

Notes

CSV files cannot store any of the "fancy" features available in Excel, such as charts, formulas, functions, etc.  A CSV file will only store plain text and all formulas and functions will be converted to their displayed output.

If you open a CSV file with Excel, it will look almost exactly like a regular Excel file except that it won't have any fancy Excel features saved in the file.

CSV files, though seemingly useless, are great for when you need to export, transmit, and re-upload large amounts of data, especially when the destination is a database.

Make sure to download the sample Excel file and CSV file included with this tutorial so you can see how this works.


Downloadable Files: Excel File 1, Excel File 2

Similar Content on TeachExcel
Reference Other Excel Files with Formulas and Functions
Tutorial: In Excel you can use formulas and functions to reference data that is stored in another Ex...
Add Comments to Cells with an Excel Macro
Macro: Add comments to cells in Excel with this macro. This allows you to quickly and easily add ...
Run a Macro when a User Does Something in the Worksheet in Excel
Tutorial: How to run a macro when a user does something in the worksheet, everything from selecting ...
Install a Macro into an Excel Spreadsheet
Tutorial: This tip will show you how to copy an Excel Macro into your workbook or spreadsheet. You w...
Create and Manage Tables in Excel
Tutorial: Here, I'll show you everything you need to know to get started using tables in Excel; how...
Make Your Macros Available in All Workbooks in Excel
Tutorial: In Excel, you can make it so all of your macros can be easily accessed by any Excel workb...