Ran the CSV through our deduper first. Imported into HubSpot in two clicks, every column mapped automatically. Recommended.