When opening an exported CSV file in Excel for Mac, it is important that you manually import the CSV to a blank sheet, rather than opening the CSV directly using Excel.
- Export your desired CSV for example, existing ads.
- Open a blank sheet in Excel for Mac.
- In Excel, go to File > Import.
- Click CSV > Import and find the CSV file you want to import.
- Select these options:
- Ensure that 'File Origin' is set to Unicode UTF-8 similar to the sample photo in step 5.
- Click Next. Ensure that 'Comma' is the only delimiter used.
-
Click Finish.