---
title: "Extracting data from \"All Companies\" table"
description: "Extracting data from \"All Companies\" table"
---

[Skip to content](https://dealengine.tech/help-guide/extracting-data-from-all-companies-table#main-content)

[![Help Guide Logo](https://dealengine.tech/hubfs/Help%20Guide%20Logo.svg)](https://dealengine.tech/help-guide?hsLang=en)

Open main navigation

Close main navigation

 What are you looking for?

- There are no suggestions because the search field is empty.

1. [Help Guide](https://dealengine.tech/help-guide?hsLang=en)
2. [All Companies](https://dealengine.tech/help-guide/all-companies?hsLang=en)
3. [Other Features](https://dealengine.tech/help-guide/all-companies?hsLang=en#other-features)

# Extracting data from "All Companies" table

## Your platform allows you to export the company data into an Excel spreadsheet. You can download this data in your preferred file format, tailored to the company filters you've applied.

When exporting, you will have the option to select specific data sets. By default, the exported tables include the company name, website, and data sources. The exportable data covers a comprehensive range of information, such as a summary and overview of each company, data sources, custom properties, addresses, sectors etc.

You can also access detailed transactional data, employee statistics, shareholder information, and financial figures, as well as data on related companies like competitors.

At the moment, the exported spreadsheet has a default format and won’t represent any customisation applied to the table columns.

<iframe data-hsv-src="https://play-eu1.hubspotvideo.com/v/145866342/id/257763400910" referrerpolicy="origin" sandbox="allow-forms allow-scripts allow-same-origin allow-popups" allow="autoplay; fullscreen;" style="position: absolute !important; width: 100% !important; height: 100% !important; left: 0; top: 0; border: 0 none; pointer-events: initial" title="HubSpot Video" loading="lazy" data-hsv-id="257763400910" data-hsv-style="" data-hsv-width="1918" data-hsv-height="932" data-hsv-autoplay="false" data-hsv-loop="false" data-hsv-muted="false" data-hsv-hidden-controls="false" data-hsv-full-width="false"></iframe>

### Step by Step

- Head to “Companies Page”
- Click “All Companies”
- Enter you desired filter(s)
- Press the button “Extract to Spreadsheet” on the top right corner of the table
- Select the types of data you want to export. 
    - By selecting the option “Summary for each company” your export will contain one row per company and columns of interest.
    - You can easily select or deselect all options by clicking on the checkboxes icons located at the bottom of the page.
- Press “Export Excel Spreadsheet”
- Your file will be downloaded to your device. It will also be available to download from the System<https://www.notion.so/Data-Extract-System-Requests-c11fc84bc94942beb8b1b39695b96327?pvs=21>Requests<https://www.notion.so/Data-Extract-System-Requests-c11fc84bc94942beb8b1b39695b96327?pvs=21>page for 14 days, after which it will expire.

- [Getting started](https://dealengine.tech/help-guide/getting-started?hsLang=en)
- [Admin & Settings](https://dealengine.tech/help-guide/admin-settings?hsLang=en#main-content)

    - [Platform customisation](https://dealengine.tech/help-guide/admin-settings?hsLang=en#platform-customisation)
    - [User menu](https://dealengine.tech/help-guide/admin-settings?hsLang=en#user-menu)
    - [Data Management](https://dealengine.tech/help-guide/admin-settings?hsLang=en#data-management)
    - [Alerts & Emails](https://dealengine.tech/help-guide/admin-settings?hsLang=en#alerts-emails)
- [All Companies](https://dealengine.tech/help-guide/all-companies?hsLang=en#main-content)

    - [Using and Saving Filters](https://dealengine.tech/help-guide/all-companies?hsLang=en#using-and-saving-filters)
    - [Other Features](https://dealengine.tech/help-guide/all-companies?hsLang=en#other-features)
- [Company Profile](https://dealengine.tech/help-guide/company-profile?hsLang=en#main-content)

    - [Company Profile Options](https://dealengine.tech/help-guide/company-profile?hsLang=en#company-profile-options)
    - [Overview Tab](https://dealengine.tech/help-guide/company-profile?hsLang=en#overview-tab)
    - [Other Tabs](https://dealengine.tech/help-guide/company-profile?hsLang=en#other-tabs)
- [Recommendations](https://dealengine.tech/help-guide/recommendations?hsLang=en#main-content)

    - [Company Recommendations](https://dealengine.tech/help-guide/recommendations?hsLang=en#company-recommendations)
- [Collections](https://dealengine.tech/help-guide/collections?hsLang=en#main-content)

    - [Collections Page](https://dealengine.tech/help-guide/collections?hsLang=en#collections-page)
    - [Within a Collection](https://dealengine.tech/help-guide/collections?hsLang=en#within-a-collection)
- [News](https://dealengine.tech/help-guide/news?hsLang=en#main-content)

    - [Using and Saving Filters](https://dealengine.tech/help-guide/news?hsLang=en#using-and-saving-filters)
    - [News Articles](https://dealengine.tech/help-guide/news?hsLang=en#news-articles)
    - [Watchlist](https://dealengine.tech/help-guide/news?hsLang=en#watchlist)
- [Transactions](https://dealengine.tech/help-guide/transactions?hsLang=en#main-content)

    - [Using and Saving Filters](https://dealengine.tech/help-guide/transactions?hsLang=en#using-and-saving-filters)

[![Deal Engine logo](https://dealengine.tech/hs-fs/hubfs/Logo-blue-black.png?width=200&height=32&name=Logo-blue-black.png "Deal Engine logo")](https://filament.ai/?hsLang=en)

Copyright © 2026, Filament Consultancy Group Limited trading as Deal Engine 

```json
{
  "@context" : "https://schema.org",
  "@type" : "VideoObject",
  "contentUrl" : "https://stream.mux.com/VJ00EUJE1mBR4FNdtvOCyq1TC00CszUNhMglc6hZrMSCA/capped-1080p.mp4",
  "dateModified" : "2025-07-23T14:29:10.610Z",
  "duration" : "PT29S",
  "height" : 932,
  "name" : "All Companies Company data extraction",
  "thumbnailUrl" : "https://145866342.fs1.hubspotusercontent-eu1.net/hubfs/145866342/All%20Companies%20Company%20data%20extraction.mov/medium.jpg",
  "uploadDate" : "2025-07-23T14:29:04.518Z",
  "width" : 1918
}
```