Excel Guides

Comma-Delimited Differences for PC and Mac in Excel

There are a few key differences to be aware of when working with comma-delimited files on a PC vs. a Mac.

On a PC, the default delimiter is a semicolon (;). On a Mac, the default delimiter is a comma (,).

If you open a comma-delimited file on a PC that was created on a Mac, you may see strange characters in place of the commas. This is because the character encoding is different on each platform.

To avoid this issue, you can change the character encoding when opening the file on a PC. In Excel, go to File > Open > Files of Type (or Format) and select "All Files". Then, select "Comma Separated Values (Macintosh)" from the drop-down menu.

If you need to share comma-delimited files between PC and Mac users, it's best to use UTF-8 encoding, which is supported by both platforms. To do this in Excel, go to File > Save As and select "UTF-8" from the drop-down menu next to "File Format".

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.