Problem with UTF-8 encoding/ umlaut characters
There seems to be a problem with the export of special characters (umlauts like äöü or the like) in insightly reports. When you open the exported excel or csv file, it looks fine at first sight. But under certain circumstances (for example when using the file as a data source for a Word mailmerge) a problem appears in the form of a space before the umlaut letter.
I tried to trace where this additional space comes from and I discovered that although you cannot see it when opening the file in excel or in notepad++, it is actually there. You can identify it by moving the cursor across one of the special characters using the cursor keys. You will notice that you need to press the key one extra time to move the cursor across the letter. And when the data is imported into word using mail merge, that hidden space seems to get inflated to its full size.