How to create CSV file on Mac?

Creating a CSV file on a Mac for use in ContentStudio is easy. ContentStudio automatically accepts CSV files in the correct format, so you just need to save your Excel file as a CSV UTF-8 file. Follow the steps below to do it.

Steps to create a CSV file on Mac

1. Open your Excel file on your Mac.

2. Tap on File in the Mac navigation bar and select Save As.

3. In the new window, select the file format type as CSV UTF-8 (Comma delimited).

4. Click the Save button to export your Excel file as a CSV UTF-8 file.

FAQs

Q1: Can I use a regular CSV instead of CSV UTF-8?

You might, but sometimes special characters or emojis won’t display correctly. CSV UTF-8 ensures everything uploads perfectly.

Q2: Can I save multiple Excel sheets as one CSV?

No, only the active sheet will be saved in a CSV. Make sure your data is all on the sheet you want to export.

Q3: Will ContentStudio accept my CSV immediately after saving?

Yes! As long as you saved it as CSV UTF-8 (Comma delimited), you can upload it directly—no extra conversion needed.

Q4: Can I include emojis or special characters in my CSV?

Absolutely! CSV UTF-8 supports emojis, accents, and other special characters.