Ran the CSV through our deduper first. Imported into HubSpot in two clicks, every column mapped automatically. Couple of small gaps but workable.
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.