Bought for a one-time project. Encoded UTF-8 with no character-set surprises in Excel. Bought it for our tissot store locations outreach in United Kingdom. Otherwise no complaints.
Good to know what worked and what didn't, the points you raised are on the refresh checklist for the next pull. Drop a note via Help → Contact Support and we'll line up a fresh export for you.