Fine for the prospecting list. Imported into HubSpot in two clicks, every column mapped automatically. Bought it for Canada's petro canada locations for canada [ ] segment specifically. 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.