> ## Documentation Index
> Fetch the complete documentation index at: https://docs.thedatacity.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Downloading data

> Export company data from EXPLORE, ANALYSE and Smart Lists as XLSX, CSV or Parquet, choose fields and addresses, and preview rows before you download.

If you want to export data from our platform for further analysis, you can do so in XLSX, CSV or Parquet formats.

You have the option to select which parts of the data you wish to export, which you will receive as a row-based view\* of company data. All downloads will be restricted to the first 20,000 results. If you select any field within ‘yearly financials’, the data will contain multiple rows for each company (one row for each financial year).

\*we have removed our old column-based view of company data (Jul 2024).

You can download data directly from [EXPLORE](https://docs.thedatacity.com/using-industry-engine/tools/explore.md), [ANALYSE](https://docs.thedatacity.com/using-industry-engine/tools/using-analyse.md) and [Smart Lists](https://docs.thedatacity.com/using-industry-engine/tools/building-an-ml-list.md).

## Start a download

* **In EXPLORE**, click **Download** in the title row, next to **Analyse**. The download covers your current results, including your filters and any company name you've typed in the search box at the top of the page. The button is unavailable when there are no results.
* **In a Smart List**, click **Export** above the results.

## Choose your format and fields

The **Download list** window opens. Choose a format (**XLSX**, **CSV** or **Parquet**), then tick the fields you want. If you choose CSV, you will receive a zip file with a number of separate CSV files. The XLSX version will be one file with multiple sheets.

You can pick a saved selection from the presets menu, or click **Save preset** to reuse your current selection later. Use **Search fields…** to find a field, and **Select all** or **Clear all** to change many at once. When you're ready, click **Prepare download**.

### Preview your download

Expand **Preview** at the bottom of the window to see sample rows with the columns you've selected. It shows the first few companies in your results, so you can check the output before you download. In a Smart List, the preview also shows each company's score and whether it was in your training set.

### Choose which addresses to include

When you select a field from the **Location** group, an **Addresses** option appears. It controls which addresses appear as rows on the Locations sheet:

* **All addresses** (the default) includes every address held for each company.
* **Registered** includes only registered addresses.
* **Operating** includes only operating addresses.

### Password-protected files

If your data contains sensitive information, the file is password-protected. It still downloads in your browser straight away. A **Download password link** window then gives you a link to retrieve your password, and the same link is emailed to you.

## Available fields

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 for at least one company.

### BASIC

This covers [essential data](https://docs.thedatacity.com/our-data/third-party-data/companies-house.md) about a company e.g. company number, incorporation date and RTICs. It also includes **Measured GVA** and **Measured UK GVA**, which are only filled in for companies whose GVA can be [measured from their accounts](https://docs.thedatacity.com/our-data/key-data-and-definitions/gva-data.md).

### COMPANY

Contains further company information that may be of interest e.g. [innovation score](https://docs.thedatacity.com/our-data/proprietary-data/innovation-score.md).

It also includes **Dissolved Date**, the date a company was dissolved. This field is only available for UK companies.

### CONTACTS

Email, phone number and socials of each company if known.

### YEARLY FINANCIALS

In-depth financial data, including [estimated turnover](https://docs.thedatacity.com/our-data/key-data-and-definitions/estimated-turnover-employees-growth.md), 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 [investment](https://docs.thedatacity.com/our-data/third-party-data/investment-data.md) & [Innovate UK](https://docs.thedatacity.com/our-data/third-party-data/innovate-uk-data.md) funding data.

### LOCATION

Geographical information about a company, for example, its registered address, constituency and Strategic Authority. It includes **Measured Location GVA** for each address. [Make sure you understand the difference between the available geographies](https://docs.thedatacity.com/using-industry-engine/features/using-filters.md#locations).

### PEOPLE

Employee data and [founder/director gender data](https://docs.thedatacity.com/our-data/proprietary-data/gender-data.md).

### SECTORS

View which SIC and/or [CIC](https://docs.thedatacity.com/using-industry-engine/tools/my-lists.md#cics) code a company is classified within.

### In summary, with the download, you’ll receive:

* A row-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 a [Smart List](https://docs.thedatacity.com/using-industry-engine/tools/building-an-ml-list.md), you will 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

> [!NOTE]
>
> **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](https://docs.thedatacity.com/using-industry-engine/features/api.md).


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.