What character set are CSV exports supposed to be in?

I have been having a lot of difficulty with data exported from my nation's People database. The problem is with accented characters and sometimes things like em and en dashes, apostrophes and inverted commas.

I generally have to read the CSV file into an intelligent text editor (like BBEdit in Mac OS), convert it to a known-good character set and then re-import it to the spreadsheet program.

But recently I've encountered a CSV export where I cannot find a character set that allows me to render accented characters correctly. I've tried UTF-8 (BOM and no BOM) ISO-Latin-1, ISO-Latin-9, Windows-Latin-1 and Mac OS Roman. All garble the accented characters.

And yet when I look at the user's profile in NationBuilder - specifically the custom fields I've had to set up - the data is fine. Accented characters render correctly.

This adds a lot of manual labour to the process of exporting (in my case) hundreds of records, because if I cannot get export working for accented characters I have to copy and paste data for each field for each record into the exported document.

Official response from
Hey Chris, UTF8 Is the supported character sets supported by our Exports. However, if you're experiencing problems, please send us some examples at help@nationbuilder.com and we'll be happy to help figure out a solution

Complete and current information on how to use NationBuilder is available in the documentation section.

Share this post

Showing 4 reactions

How would you tag this suggestion?
Please check your e-mail for a link to activate your account.