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, 5 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

Join 150,000 companies around the world that use Campaign Monitor to run email marketing campaigns that deliver results for their business.

Get started for free