Export to Excel

Export prospect lists from Vainu

Updated over a week ago

Which version of Vainu are you using?

1. How can I download a company list?

After creating the prospect list you hoped for, you can download the list by clicking the Download button in the top right corner of the list view.

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

2. How can I select the data for my exports?

Once you have clicked Download, a new menu appears, and it lets you decide what attributes you want to add to your download. Depending on whether you use the Nordic business id database or the Global domain database, export has different attributes to choose from.

Nordic business id database fields:

Basic:

  1. Business name

  2. Business ID

  3. Legal entity

  4. Status

  5. Website

  6. Phone

  7. Email

  8. Registration Year

  9. Employer Registration date

  10. Industry

  11. Vainu Custom Industry

  12. Address

  13. Postal

  14. City

  15. Visiting Address

  16. Visiting Postal

  17. Visiting City

Finance:

  1. Staff Number (latest)

  2. Turnover (latest) EUR

  3. Profit (%)

Web Profile:

  1. Technologies

  2. Digitalization index

  3. Languages

  4. Social media

  5. LinkedIn link

  6. Twitter link

  7. Youtube link

  8. Facebook link

  9. Twitter followers

  10. SoMe index

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

Global domain database fields:

  1. HQ Country

  2. Business Units

  3. Countries of operations

  4. Vainu Custom Industry (all)

  5. Vainu Custom Industry (high class)

  6. Company size

  7. Descriptions

  8. Social media links

  9. Website Traffic

  10. Digitalization index

  11. Office location count

  12. Technologies

  13. Website languages

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

Once the attributes are chosen, you can decide in which order they will appear on your download!

3. What formats are available for exports?

In the vainu.app, there are two available formats for export; CSV and JSON. After the file type is chosen, you can see the number of companies in the file, the number of data points, and the actual data points. In CSV, the menu shows you the columns that the file will have, and JSON shows you the results that the file will contain.

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

4. Can I export contact information?

You can download contact data from the vainu.app as a separate CSV or JSON file. Once you have clicked Download, a new menu appears, and it lets you select Employees to your download. Again, you can select the company data points you want to export (2. in this article).

Screenshot 2023-03-22 at 10.47.52

File type: CSV – You'll get a zip file with 2 CSVs.

Screenshot 2023-03-22 at 10.48.33

File type: JSON – shows you the results that the file will contain.

Screenshot 2023-03-22 at 11.01.28

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

The amount of companies in each export is counted towards the set export credit limit on the Vainu contract. Find more about Credit Dashboard here: Vainu Credit Dashboard

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.

💬 Should you have any questions, please contact us through the chat in the bottom right corner or by sending an email to support@vainu.io

Did this answer your question?