UTF-8, or “Unicode Transformation Format, 8 Bit” is a marketing operations pro’s best friend when it comes to data imports and exports. It refers to how a file’s character data is encoded when moving files to and from Salesforce and Pardot. Read on to see why UTF-8 matters when it comes to CSV files.

How do I make a CSV file into UTF-8?

Open your file in Excel and save as CSV (Comma Delimited). Then, scroll down and choose Tools. Choose Web Options from the Tools drop-down menu. Then, select the Encoding tab and choose UTF-8 from the Save this document as: drop down menu and select OK.

What is difference between CSV and CSV UTF-8?

CSV is referring to the type of file or how the data is formatted and UTF-8 is referring to the character encoding being used. Just CSV would indicate the encoding is not defined.