Written by Allen Wyatt (last updated August 2, 2025)
This tip applies to Excel 97, 2000, 2002, and 2003
Excel allows you to save worksheet data in a comma-delimited format, so you can use it with other programs. Comma-delimited files are often referred to as CSV (comma-separated value) files, and are often used for exchanging data between programs.
When selecting how to export you data, you need to be sure that you pick the export format that is appropriate for the system on which it will be used. There are actually three CSV formats included with Excel:
You can choose any of these CSV options by using the Save As Type drop-down list at the bottom of the Save As dialog box. There are subtle differences between all three formats, but for most people, the first and third formats are essentially the same—they both work on the PC. The second format, for the Macintosh, is worth noting, however.
If your export file is destined for use on a Macintosh, you should choose the second CSV option. This option results in a CSV file where each record (each line in the file) is terminated with a carriage return, as expected by the Mac. In the PC world, lines are terminated with a carriage return/line feed combination, which can mess things up on the Macintosh.
If you are creating the CSV export file on the Mac for later use on the PC, you will want to make sure that you select a CSV format appropriate for the target system. The Mac includes CSV options for both Windows and MS-DOS systems. You should be able to choose either option and have the file work just fine.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2519) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Comma-Delimited Differences for PC and Mac.
Program Successfully in Excel! This guide will provide you with all the information you need to automate any task in Excel and save time and effort. Learn how to extend Excel's functionality with VBA to create solutions not possible with the standard features. Includes latest information for Excel 2024 and Microsoft 365. Check out Mastering Excel VBA Programming today!
Need to save a workbook in more than one location? Here's a handy macro that can save your workbook in lots of different ...
Discover MoreWhen you save a workbook to disk, you may want to automatically save a duplicate workbook in a separate location. This ...
Discover MoreYou can, within a macro, save a workbook in several different file formats that are understood by Excel. However, you may ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Comments