Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, and Excel in Office 365. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Comma-Delimited Differences for PC and Mac.
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 (10280) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and Excel in Office 365. You can find a version of this tip for the older menu interface of Excel here: Comma-Delimited Differences for PC and Mac.
Excel Smarts for Beginners! Featuring the friendly and trusted For Dummies style, this popular guide shows beginners how to get up and running with Excel while also helping more experienced users get comfortable with the newest features. Check out Excel 2013 For Dummies today!
Excel provides different file formats you can use to export your worksheet information. One such file format is CSV, or ...
Discover MoreIf you don't like the way that Excel exports information you intend to use with other programs, then your best bet is to ...
Discover MoreMRU (most recently used) files can be a great help when you work with a given set of common workbooks. Excel allows you ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2019-07-08 13:12:06
Bruce Krymow
On a PC using Excel 2016, what is the difference between "CSV UTF-8" (5th save as type option) vs "CSV" (16th save as type option) comma delimited .csv options?
2019-01-04 09:47:36
Carrie French
This was very helpful! Now I know how to get my Mac to treat .CSV files to display the data correctly.
2018-05-25 13:15:16
Yvan Loranger
In Linux [Unix] lines are terminated by LineFeed.
I have never had a problem using the CarriageReturn-LineFeed combo.
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2020 Sharon Parq Associates, Inc.
Please Note:
This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, and Excel in Office 365. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: 
Comments