Exporting data from Clicktools: Don’t lose your umlaut (or other non-standard ASCII characters)
We’ve had feedback recently suggesting that a few of you are losing your umlauts. Wait… I’ll explain.
If your Clicktools data contains words that use non-standard (non ASCII-128) characters, for example, umlauts (i.e. the u with dots over it: ü), your data may not display correctly when exporting to and viewing in Excel / csv.
Now, before I go into the specifics of how to avoid losing non-standard characters, I really should point out that while exporting data from Clicktools has its place, we do hope this doesn’t mean that you’re not taking advantage of the solution’s powerful CRM integration capabilities. If you’re having any trouble centralizing your Clicktools data in CRM, so that you can report and act on it within that environment, please reach out to us at firstname.lastname@example.org for help. We can make your life a whole lot easier.
That being said, if you must export to a file, there are steps you can take to ensure that the data containing non-standard characters appears properly.
Steps to Keep Non-standard Characters in Tact
When exporting responses or contact information from Clicktools, if this data contains non-standard characters, such as foreign names (e.g. Øvermo Björn), make sure you’re not saving your file as a .csv file because Excel will strip out these characters in transition. Excel’s .csv format does not support UTF-8 encoding.
Try using Google docs spreadsheets instead because Google adopts the UTF-8 encoding and protects all the letters. Nothing is lost and no file manipulation is required.
If you must use Excel, then try this approach. When exporting from Clicktools, choose the alternate Format for File Type. This will avoid removal of your non-standard characters, which the typical Excel / csv file format will do.
Next, DO NOT open in Excel but first save as a txt file. Then in Excel, open the txt file as a Unicode text file. You will see a text import wizard, in which you’ll need to select the option to open with Unicode (UTF-8).
Hope these tips help when you’re working with Clicktools exports!