How to get CSV files to show uncommon characters right

Ever had a problem getting characters like the Danish ÆØÅ to show right in a CSV file when you upload it to CM?

Here is the simplest solution:

1. Open Google Spreadsheet with a gmail account
2. Import your csv file
3. Download it as a csv file.

Booom :)

Kuddos to Google!

Diana Diana, 6 years ago

Hey MaxMoore,

Thanks for the tip! Another way that works is for anyone using Windows, open your .csv in Notepad, save as and set the character encoding as UTF-8 and save.

D. Potter
Campaign Monitor

See why 200,000 companies worldwide love Campaign Monitor.

From Australia to Zimbabwe, and everywhere in between, companies count on Campaign Monitor for email campaigns that boost the bottom line.

Get started for free