Open the file in Excel, click File/Save As.

Start with your custom labels file saved in an Excel workbook format (.xls.

Follow the steps to produce a CSV file with the UTF-8 encoding. You can make sure TextEdit saves files in Unicode (UTF-8) by going to TextEdit > Preferences… > Open and Save, and making sure the Save As setting is “ Unicode (UTF-8)”.To use Custom Labels and Messages Settings in Survey or Marketing Cloud Landing Pages, you need to upload a CSV (.csv) file with UTF-8 encoding.

Make sure that everything is correct macOS Make sure that the encoding is set to UTF-8.ġ1. Navigate to the folder where you want to save your file.Ĩ. Right click on the file | click Open With.ĥ. If you’re still having encoding issues, you can try these steps:Ģ. If you’re using the Import Wizard, make sure that you choose right encoding option “Unicode (UTF-8)” on “Upload the file” step. You can use this CSV file for importing through Import Wizard or Apex Dataloader. – If you run into a problem in this step, don’t save the file in Excel, it’ll cause encoding issues. Open the CSV file and verify if the data is okay. If it is not changed, check Windows Folder options (new window). – The file icon should be changed to MS Excel now. Change the file extension from “*.txt” to “*.csv”. Name the file, and change the Encoding: to UTF-8.ĩ.

– Replace all tab characters with comma using Replace function ctrl+H.Ĩ. – Select a tab character by dragging the character between two column headers and press ctrl+c.

The file needs to be tab delimited, replace tabs with a comma (“,”).

– Some characters can look like a box, this is because Notepad can’t display some unicode characters, you can ignore this.Ħ. Open the unicode text file using Microsoft Notepad. Put any name for the file and choose “Unicode Text (*.txt)” for “Save as type.

How to change encoding in excel