Skip to main content
How to export to Excel 📊

Export prospect lists from Vainu to your spreadsheet software of choice

Updated over 3 months ago

Which version of Vainu are you using?

1. How to download a company list?

After creating the desired prospect list, download it by clicking the Download companies button in the top right corner of the list view.

Näyttökuva 2023-1-3 kello 14.53.03

2. How to select the data included in the export?

Upon clicking on the Download companies button, a new menu will appear, allowing you to choose the attributes you wish to include in your download. The available attributes vary between the Nordic business ID database and the Global domain database.

Nordic business ID database fields:

Basic:

  1. Business ID

  2. Business name

  3. Legal entity

  4. Status

  5. Number of employees (latest official)

  6. Estimated size (~employees)

  7. Website

  8. Phone

  9. Email

  10. Registration date

  11. Employer registration date

  12. Industry

  13. Main industry

  14. Vainu Custom Industries (all) (separate sheet)

  15. Vainu Custom Industries (high class)

  16. Direct marketing denied

  17. Address

  18. Postal

  19. City

  20. Visiting Address

  21. Visiting Postal

  22. Visiting City

Location:

  1. Address (street)

  2. Postal

  3. City

  4. Visiting address

  5. Visiting postal

  6. Visiting city

  7. Business units (separate sheet)

Financial:

  1. Revenue (latest)

  2. Gross profit (latest)

  3. Financial statements (separate sheet)

    1. Years

    2. Accounting period start

    3. Accounting period end

    4. Revenue

    5. Earnings (net income)

    6. Total assets

    7. Employee count

Web profile:

  1. Technologies

  2. Description

  3. Website traffic rank

  4. Website traffic class

  5. Languages

  6. Digitalization index

Social media:

  1. LinkedIn link

  2. Twitter link

  3. Twitter followers

  4. Youtube link

  5. Facebook link

  6. Social media index

Contacts (separate sheet)

Group data:

  1. Group name

  2. Subsidiary count

  3. Organizations of countries

  4. Parent organization Name

  5. Parent organization Country

  6. Parent organization Business ID

  7. Group employee count

  8. Group revenue

  9. Level in group

Näyttökuva 2023-1-13 kello 13.33.34

Global domain database fields:

  1. Domain

  2. HQ country

  3. Business units (separate sheet)

  4. Countries of operations

  5. Vainu Custom Industries (all) (separate sheet)

  6. Vainu Custom Industries (high class)

  7. Company size

  8. Descriptions

  9. Social media links

  10. Website traffic

  11. Digitalization index

  12. Office location count

  13. Technologies

  14. Website languages

Näyttökuva 2023-1-3 kello 14.56.57

💡 After selecting attributes, you can arrange their order in your download on the right-hand panel.

3. What formats are available for exports?

In vainu.app, exports are available in two formats: CSV and JSON. This section will not only display the number of selected companies and data points, but also gives you a preview of how the data will be structured in your chosen format.

Näyttökuva 2023-1-12 kello 10.27.56

4. Can I export contact information?

Yes, contact data can be downloaded as a separate CSV or JSON file in vainu.app as a separate CSV or JSON file. After clicking on Download companies, you can select Contacts from the list of available data points.

Screenshot 2023-03-22 at 10.47.52

If you select CSV, you'll get a zip file with 2 separate sheets: one for company data and another for contact data.

Screenshot 2023-03-22 at 10.48.33

If you select JSON, you'll get a single JSON file where company data and contact data is structured as shown in the picture below.

Screenshot 2023-03-22 at 11.01.28

5. How exporting affects data usage (credit-based model)?

The number of companies in each export counts towards the export credit limit set in your Vainu contract. You can use our Credit Dashboard to better understand your data usage and active usage limits.

With the Export feature, you can export a list of up to 200 companies 📞

You can easily export prospect lists from Vainu. First, you need to save the list you wish to export and then click Send to... icon and choose Excel/CSV to export.

Näyttökuva 2020-6-10 kello 10.27.36

The file is exported as .csv file. It is a standard format that can easily be used on multiple platforms and opened with multiple different spreadsheet programs. If the file does not open as expected, check out this article: Troubleshoot .csv file

Export feature:

With the basic export feature, you can export up to 200 companies/export.

Export includes these data points:


​Company name

  • Business ID

  • Address

  • Contact information

  • Website

  • Status

  • Form of company

  • Registration year

  • Industry

  • Link to vainu

  • Countries of operation

  • Social media links and figures

  • Technologies

  • Financial figures (employee count, turnover, among others)

The Restricted for Marketing field contains one of three possible values:
True: Company has denied direct marketing and the company should not be added to any direct marketing email or call lists.
False: Company has not denied direct marketing.
Empty: Company has not denied direct marketing.


Export does not function if the list is not saved first. Remember to set chosen search filters and save the list from the top right corner. ↗️

Export contact information (Profession class)

When you click the Export icon, a new pop-up window will open. If you need to get more information on the personnel working for a certain company, select a profession class to get all names relevant to the selected employee group. You can select one or more profession classes.
When you have selected to export profession classes it will result in duplicate rows on export, because each row represents one employee. Contact information, if available, can be found in the last columns.

Näyttökuva 2019-12-2 kello 16.16.36

Note❗ Vainu is not focused on collecting personal information and, for that reason, offers a limited amount of contact information. Our contact data sources are a combination of official registry sources and open online sources. In Finland and Sweden, we also provide manually gathered, human-verified contact records–the key decision-makers–adhering to GDPR compliance rules when collecting these records.

If you need to export a larger list, contact your Vainu contact person.

🕵🏻‍♀️ Contact Vainu Support if you have any questions! You can send an email to support@vainu.io or send a message through chat.

Did this answer your question?