![excel on mac vs pc excel on mac vs pc](https://www.howtogeek.com/wp-content/uploads/2018/01/om_2.png)
The Mac includes CSV options for both Windows and MS-DOS systems. 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.
![excel on mac vs pc excel on mac vs pc](https://www.holistics.io/blog/content/images/2019/12/image-5.png)
In the PC world, lines are terminated with a carriage return/line feed combination, which can mess things up on the Macintosh. 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. If your export file is destined for use on a Macintosh, you should choose the second CSV option. The second format, for the Macintosh, is worth noting, however. 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. 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. However, there are a substantial number of differences in how Excel itself behaves between the two platforms, and in how VBA interacts with these platforms. There are actually three CSV formats included with Excel: In Excel 2011 for Mac, Microsoft has re-introduced VBA, and its even finally the same version of VBA that Excel for Windows has been using all along.
#Excel on mac vs pc how to
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. Comma-delimited files are often referred to as CSV (comma-separated value) files, and are often used for exchanging data between programs. Excel allows you to save worksheet data in a comma-delimited format, so you can use it with other programs.