Import a UK Companies House list
Upload a UK company spreadsheet. Match company numbers and people, then reconcile misses with Companies House.
When you already have a UK company file — company numbers, names, postcodes — open Enrich Leads, choose Enrich UK Companies House, then Import list.
Upload the spreadsheet
- Sign in at app.leadhootz.com and open Enrich Leads.
- Choose Enrich UK Companies House.
- Upload a CSV or Excel file. Company number is the main match. Company name is used when the number is missing or the company is not in the database yet.
- Map columns if they were not picked up. Company number and company name drive the match. Address, town, postcode, phone, employees, and industry help reconcile rows that miss.
What the match does
Each row is matched by company number first, then Companies House. A Companies House match is shown in green while the lead-search and email waterfalls look for people. People we find are saved with the company.
Rows that miss the database go to Companies House. Those are reconciled with the company name, postcode, and work-email domains.
After the import
Open the lead list when the run finishes. From there you can enrich emails and phones, share a research view, or enroll a campaign. A people file (name, company, domain, title) still uses a normal Lead List import — this walkthrough is for UK company files.