Sample data

New company data: what's in every list

New company data in our lists comes straight from the Companies House register, one row per company, in a CSV file: a spreadsheet that opens in Excel or Google Sheets. Below are the columns, a real sample from Wednesday 18 Nov, and what is deliberately left out.

  • Data to 18 Nov
  • Companies House
  • Cancel any time

The columns in every file

Short answer

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.

Columns in order. Examples from a company incorporated on 18 Nov; address lines are hidden on this public page.
ColumnWhat it holdsExample
company_nameName as registeredBLOI CONSULTING LTD
company_number8 characters; SC = Scotland, NI = Northern Ireland, OC = LLP17587462
company_typePrivate limited, LLP, guarantee company and so onltd
incorporation_dateThe date on the certificate of incorporation2026-11-18
sic_codesUp to four SIC 2007 codes, separated by semicolons62020
sic_sectionSection letter and name of the first SIC codeJ: Information and communication
address_line_1First line of the registered office(subscribers only)
address_line_2Second line, often blank(subscribers only)
localityPost townLondon
countyOften blank: Companies House doesn't require it
postcodeFull registered office postcodeEC2A …
regionUK region from the postcode
companies_house_urlLink to the company's public recordfind-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

Short answer

These ten companies were incorporated on Wednesday 18 Nov, one from each of ten industries. The public sample shows town and postcode district only.

sample-2026-11-18.csv
company_namecompany_numbersic_codeincorporatedtownpostcode_district
BLOI CONSULTING LTD17587462620202026-11-18LondonEC2A
BISHOPSA2 HOUSE LIMITED17587463552092026-11-18BootleL20
ANPI BRICKWORK LIMITED17587464439992026-11-18DerbyDE21
ODG PROPERTY LAW LIMITED17587467691092026-11-18NorthamptonNN6
IL CORTILE LTD17587468682092026-11-18NorwichNR1
SHEABEE NATURALS LIMITED17587470464502026-11-18NottinghamNG6
QUICK PEST SOLUTIONS LTD17587478812912026-11-18LondonSE18
TRADESMEN CORP LTD17587482139102026-11-18ManchesterM12
ALAST LTD17587491855902026-11-18DoverCT16
POWIS SMITH LTD17587497642092026-11-18EastbourneBN21
10 of 2,526 companies incorporated on 18 Nov. Contains public sector information licensed under the Open Government Licence v3.0. Source: Companies House.

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

Short answer

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.

Company types, incorporated in the 30 days to 18 Nov
TypeCompaniesShare
Private limited company62,16196.7%
Private company limited by guarantee1,5632.4%
Limited liability partnership (LLP)2210.3%
Limited partnership1260.2%
Registered overseas entity850.1%
Guarantee company (‘Limited’ exemption)620.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

Short answer

Each company chooses up to four SIC codes when it registers. Industry filters use the first one; the file includes all of them.

The most common first SIC codes, the 30 days to 18 Nov
SIC codeWhat it coversNew companiesShare
47910Retail sale via mail order houses or via Internet5,4298%
62012Business and domestic software development3,0985%
68100Buying and selling of own real estate2,8094%
70229Management consultancy activities other than financial management2,5564%
68209Other letting and operating of own or leased real estate2,3854%
64209Activities of other holding companies not elsewhere classified1,9973%
56103Take-away food shops and mobile food stands1,6012%
62020Information technology consultancy activities1,2752%

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

Short answer

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

Short answer

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.

Sources

  1. 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.
  2. ONS: UK SIC 2007 (Standard Industrial Classification)
  3. Open Government Licence v3.0
  4. Daily UK incorporation and dissolution statistics: UK Business Stats