Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, and Excel in Microsoft 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.
Written by Allen Wyatt (last updated November 27, 2021)
This tip applies to Excel 2007, 2010, 2013, 2016, 2019, and Excel in Microsoft 365
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 Microsoft 365. You can find a version of this tip for the older menu interface of Excel here: Comma-Delimited Differences for PC and Mac.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!
Need to know what the full path name is for the current workbook? With a simple macro you can display the full path name ...
Discover MoreWhat would you do if every time you opened a workbook Excel told you it was locked? Here's how you can try to recover ...
Discover MoreYou can use a macro to read information from a text file. The steps are easy, and then you can use that information in ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2021-11-29 17:48:10
S Hume
There is also "CSV UTF-8 (Comma delimited) (*.csv)." What is the difference with that one?
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 © 2023 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 Microsoft 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