Ran the CSV through our deduper first. Encoded UTF-8 with no character-set surprises in Excel. Bought it while building a adventure resort prospecting workflow for Australia. Otherwise no complaints.
Good to know what worked and what didn't, we hear you on the gaps — the next monthly refresh tightens those exact columns. Drop a note via Help → Contact Support and we'll line up a fresh export for you.