Find out how to export data for offline analysis
If you want to export data from our platform for further analysis, you can do so in CSV or XLSX formats.
You have the option to select which parts of the data you wish to export, which you will receive as a column-based view* of company data. All downloads will be restricted to the first 20,000 results. If you select any field within ‘financials’, the data will switch to row-based.
*we have removed our old column-based view of company data (Jul 2024).
To download an export just press the three dots next to your list name and select Download List from the menu.
You can download data directly from EXPLORE, ANALYSE and ML LISTS.
You will then be presented with a choice of format and data to include. If you choose CSV, you will receive a zip file with a number of separate CSV files, whereas the XLSX version will be one file with multiple sheets.
Each checkbox represents a column in the spreadsheet. There are over 80 different checkboxes, grouped into 8 categories. Financial and employee data is broken down yearly, and only given if it is available.
BASIC
This covers essential data about a company, for example, company numbers and RTICs.
COMPANY
Contains further company information that may be of interest, e.g., innovation score.
CONTACTS
Email, phone number and socials of each company if known.
FINANCIALS
In-depth financial data, including estimated turnover, wages/salaries and profit after tax. This data is broken down yearly where available.
GROWTH
Metrics relating or contributing to the growth of a company, e.g. best estimate growth percentage per year, and Dealroom & Innovate UK funding data.
LOCATION
Geographical information about a company, for example, its registered address, constituency and LEP. Make sure you understand the difference between the available geographies.
PEOPLE
Employee data and founder/director gender data.
SECTORS
View which SIC and/or CIC code a company is classified within.
In summary, with the download, you’ll receive:
- A column-based view of the company data you chose to include (unless you choose financial fields).
- Directors’ details for each company within the list
If downloading from an ML LIST, you’ll also receive:
- A breakdown of the scoring system used by the classifier
- Details of the training set you provided when you created the list e.g. companies to include
API: If you need more than 20,000 records, you may find our API a better solution, information of that can be found on our API page.