The columns in every file
Each file has 13 columns: name, number, type, incorporation date, SIC codes and section, the registered office address, region and a link to the public record.
| Column | What it holds | Example |
|---|---|---|
company_name | Name as registered | BLOI CONSULTING LTD |
company_number | 8 characters; SC = Scotland, NI = Northern Ireland, OC = LLP | 17587462 |
company_type | Private limited, LLP, guarantee company and so on | ltd |
incorporation_date | The date on the certificate of incorporation | 2026-11-18 |
sic_codes | Up to four SIC 2007 codes, separated by semicolons | 62020 |
sic_section | Section letter and name of the first SIC code | J: Information and communication |
address_line_1 | First line of the registered office | (subscribers only) |
address_line_2 | Second line, often blank | (subscribers only) |
locality | Post town | London |
county | Often blank: Companies House doesn't require it | |
postcode | Full registered office postcode | EC2A … |
region | UK region from the postcode | |
companies_house_url | Link to the company's public record | find-and-update… |
Files are UTF-8 CSV with a header row, comma separated and quoted where needed, so names with commas or apostrophes open cleanly. The email body gives the count and the most common SIC codes, so you can see at a glance whether today is worth opening.
Sample: real companies from 18 Nov
These ten companies were incorporated on Wednesday 18 Nov, one from each of ten industries. The public sample shows town and postcode district only.
| company_name | company_number | sic_code | incorporated | town | postcode_district |
|---|---|---|---|---|---|
| BLOI CONSULTING LTD | 17587462 | 62020 | 2026-11-18 | London | EC2A |
| BISHOPSA2 HOUSE LIMITED | 17587463 | 55209 | 2026-11-18 | Bootle | L20 |
| ANPI BRICKWORK LIMITED | 17587464 | 43999 | 2026-11-18 | Derby | DE21 |
| ODG PROPERTY LAW LIMITED | 17587467 | 69109 | 2026-11-18 | Northampton | NN6 |
| IL CORTILE LTD | 17587468 | 68209 | 2026-11-18 | Norwich | NR1 |
| SHEABEE NATURALS LIMITED | 17587470 | 46450 | 2026-11-18 | Nottingham | NG6 |
| QUICK PEST SOLUTIONS LTD | 17587478 | 81291 | 2026-11-18 | London | SE18 |
| TRADESMEN CORP LTD | 17587482 | 13910 | 2026-11-18 | Manchester | M12 |
| ALAST LTD | 17587491 | 85590 | 2026-11-18 | Dover | CT16 |
| POWIS SMITH LTD | 17587497 | 64209 | 2026-11-18 | Eastbourne | BN21 |
In a subscriber's file the same rows carry the full registered office address, the company type, every SIC code and the region, as in the column table above.
Which kinds of company appear
97% of companies incorporated in the 30 days to 18 Nov were private limited companies. The rest are guarantee companies, LLPs, partnerships and a few overseas entities.
| Type | Companies | Share |
|---|---|---|
| Private limited company | 62,161 | 96.7% |
| Private company limited by guarantee | 1,563 | 2.4% |
| Limited liability partnership (LLP) | 221 | 0.3% |
| Limited partnership | 126 | 0.2% |
| Registered overseas entity | 85 | 0.1% |
| Guarantee company (‘Limited’ exemption) | 62 | 0.1% |
Every type is included by default. If you only want private limited companies, filter the company_type column on ltd; guarantee companies are often charities, clubs and residents' management companies, which some buyers prefer to skip.
How industries are coded
Each company chooses up to four SIC codes when it registers. Industry filters use the first one; the file includes all of them.
| SIC code | What it covers | New companies | Share |
|---|---|---|---|
| 47910 | Retail sale via mail order houses or via Internet | 5,429 | 8% |
| 62012 | Business and domestic software development | 3,098 | 5% |
| 68100 | Buying and selling of own real estate | 2,809 | 4% |
| 70229 | Management consultancy activities other than financial management | 2,556 | 4% |
| 68209 | Other letting and operating of own or leased real estate | 2,385 | 4% |
| 64209 | Activities of other holding companies not elsewhere classified | 1,997 | 3% |
| 56103 | Take-away food shops and mobile food stands | 1,601 | 2% |
| 62020 | Information technology consultancy activities | 1,275 | 2% |
SIC codes are self-declared and broad. 47910 (retail sale via mail order or internet) is the single most common code because almost every online shop picks it, whatever it sells. 68100 and 68209 are overwhelmingly buy-to-let and property investment companies. Reading the code alongside the company name tells you a lot: "Smith Brickwork Ltd" with 43390 is a tradesman; "Smith Holdings Ltd" with 64209 is a holding company. The ONS publishes the full SIC 2007 hierarchy.
Registered office is not always the trading address
The address is the registered office, which can be an accountant's or a formation agent's address. Ten postcodes accounted for 15% of new UK companies in the 30 days to 18 Nov.
Most small companies use their home or trading address, so for a local list the registered office is a good guide to where the
business is. But company formation agents and virtual office providers register thousands of companies at a handful of addresses, mostly in central
London. In the 30 days to 18 Nov, 9,641 of the 64,259 new companies shared just ten postcodes. They're in the file (they are real companies), and the
postcode column makes them easy to spot and sort. For postal campaigns, mail sent to a formation agent is usually forwarded, but slowly.
What lists leave out
Lists contain no information about people: no directors, no dates of birth, no personal addresses, no phone numbers and no email addresses.
The public register also records each company's officers and people with significant control. We don't include them. Company-level data is all most buyers need to make a first approach, by post addressed to "The Directors" or through the company's own website once it has one. We may add named contacts later, but only after a full legitimate interests assessment and an updated privacy notice; see the legitimate interests note. Companies that ask to be removed are screened out of every file before it is sent.
FAQs
What file format are the lists?
CSV (comma-separated values), UTF-8 encoded with a header row. It opens in Excel, Numbers and Google Sheets and imports into most CRMs.
Why is the county column often empty?
Companies House doesn't require a county, and most new companies leave it blank. Use the region and postcode columns for location.
Can I get a sample for my own filters?
Yes. Email hello@newcompanylists.co.uk with your area and industries and we'll send last week's count and a handful of rows.
How far back does the data go?
Lists are forward-looking: your first file covers the day (or week) before it's sent. We keep about 120 days of history, from 15 Oct at the moment, for counts and back-fills.
Is this the same as the Companies House bulk file?
It is built from the same public register, but filtered to your areas and industries, limited to new companies and sent to you automatically, so there's nothing to download or clean.
Start your new company list
What you get
Every weekday, thousands of new companies start up in the UK. We email you a list of them.
- You pick the area and the type of business.
- We email you a spreadsheet every weekday morning (or once a week on Monday, if you prefer). It opens in Excel or Google Sheets (it is a CSV file).
- Each row is one new company: its name, company number, address, type of business and the date it started.
- Local: one area, up to 3 types of business: £19 a month + VAT (£22.80).
- National: the whole UK, every type of business: £49 a month + VAT (£58.80).
- Pay yearly and get 2 months free: Local £190 a year + VAT (£228), National £490 a year + VAT (£588).
- Cancel any time. No contract.
What you don't get: no phone numbers, no email addresses and no names of directors or owners. Just company details from the public Companies House register.
An area is one region (like the North West) or one postcode area (like LS for Leeds).
Questions first? Email hello@newcompanylists.co.uk.
Related pages
Sources
- Companies House register, read every morning by New Company Lists (data to 18 November 2026): Companies House: Find and update company information. Contains public sector information licensed under the Open Government Licence v3.0. Source: Companies House.
- ONS: UK SIC 2007 (Standard Industrial Classification)
- Open Government Licence v3.0
- Daily UK incorporation and dissolution statistics: UK Business Stats