CRM

Guido
Member

Export Companies and related Contacts

SOLVE

I would like to generate an export of selected companies with the information of name and telephone-number from the related contact in one excel-table! is this possilbe?

2 Accepted solutions
BrettLanguirand
Solution
HubSpot Employee
HubSpot Employee

Export Companies and related Contacts

SOLVE

Hello @Guido,

 

Welcome to the Hubspot Community and thank you for your question.

 

It isn't possible to export Companies with associated contact properties as columns in one file, however I came up with a workaround that might come close to what you are looking to accomplish.

 

You can create a new view in contacts, add the desired filters on the left, and edit your columns so that the information that you want in the Excel file is shown.  You can then export the view of contacts, and select "Include only current columns" (or you can choose to include all properties) This will allow you to see your contacts, their phone numbers, email addresses, etc, as well as the Company that they are associated with.  The company name is the only piece of company information that you'd be able to add to a contact export, because "Associated Company" is the only contact proeprty with company information.

 

Let me know if you have any questions, or if you'd like me to clarify anything.

 

Thanks,

Brett

View solution in original post

karstenkoehler
Solution
Hall of Famer | Partner
Hall of Famer | Partner

Export Companies and related Contacts

SOLVE

Hey everyone,

 

This is now possible in HubSpot – not sure if this was introduced quietly or if I simply missed it.

 

You can export contacts with associated copmany information.

 

To do so, create a list of the contacts that you want to export with their company information. (This solution does not work from a contact view, it has to be a list.)

 

In your list, click Actions:

 

karstenkoehler_0-1622632827471.png

 

 

You should now have the option to also include company properties in your export file:

 

karstenkoehler_1-1622632850990.png

 

As you can see this solution is one way: exporting contacts with associated company information (not: companies with associated contacts). However, with a bit of Excel magic, the export file can be transformed in such a way.

 

Hope this helps!

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

View solution in original post

38 Replies 38
CarlosM
Contributor

Export Companies and related Contacts

SOLVE

This isn't what we are looking for - we need to create a company list then extract all the emails from that list. Creating a list of contacts and its associated company information doesn't do that.

MartinGammon
Participant

Export Companies and related Contacts

SOLVE

After you have exported the data, you can sort or otherwise manipulate it in Excel for your purposes.

0 Upvotes
CarlosM
Contributor

Export Companies and related Contacts

SOLVE

I have a list of particular companies I wish to export the email addresses from. I can do this from a contact list, not a company list.

0 Upvotes
karstenkoehler
Solution
Hall of Famer | Partner
Hall of Famer | Partner

Export Companies and related Contacts

SOLVE

Hey everyone,

 

This is now possible in HubSpot – not sure if this was introduced quietly or if I simply missed it.

 

You can export contacts with associated copmany information.

 

To do so, create a list of the contacts that you want to export with their company information. (This solution does not work from a contact view, it has to be a list.)

 

In your list, click Actions:

 

karstenkoehler_0-1622632827471.png

 

 

You should now have the option to also include company properties in your export file:

 

karstenkoehler_1-1622632850990.png

 

As you can see this solution is one way: exporting contacts with associated company information (not: companies with associated contacts). However, with a bit of Excel magic, the export file can be transformed in such a way.

 

Hope this helps!

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

TayshaProvost
Participant

Export Companies and related Contacts

SOLVE

Hi there, I'm sorry for a late answer. It is also possible via Skyvia Excel add-in. You can export all data at the same time in a few clicks.

0 Upvotes
MBeck
Member

Export Companies and related Contacts

SOLVE

I have the same requirement as everyone else on this thread.  Hubspot, please give us an easy way to export a group of companies and their associated contacts.  Thanks,

MartinGammon
Participant

Export Companies and related Contacts

SOLVE

I use a workaround for this that works well but is a bit convoluted.

 

Filter either the contacts or the companies you want and then, when you export, select All Properties. Then export either ALL contacts or ALL companies (the opposite of the database you filtered first time) and again select All Properties when exporting

 

Now open the two spreadsheets and you will find that in the Companies sheet there is a unique ID for associates Contacts and vice versa. Use VLook function to link them together.

 

As I said, it's not pretty but it does work.

Simon_Spanswick
Member

Export Companies and related Contacts

SOLVE

I'm struggling with this. 

 

I have filtered the companies we need to extract contacts from. There are around 50 of these and I have a spreadsheet with the company data, including the unique Hubspot ID.

 

I've got a second sheet with all 14,000 contacts, including their Hubspot company ID. I need to get the 800 or so contacts that are in the 50 companies I've filtered.

 

I've tried to work out how VLook can match the data, but cannot see how it can do this. Does anyone have a simple solution for VLook or an Excel plug-in that can do this task?

0 Upvotes
MartinGammon
Participant

Export Companies and related Contacts

SOLVE

Simon

Are you still struggling with this or have you found a way to use VLookup to do what you need?

0 Upvotes
Simon_Spanswick
Member

Export Companies and related Contacts

SOLVE

Martin

 

I'm sorry not to have replied earlier. We managed to do this a few months ago, and now are trying again. However, I simply cannot work out how we managed to get the VLOOKUP function to work the last time! 

 

We simply want to get the e-mails of staff at filtered companies out. We have a total export of all Hubspot contacts in one spreadsheet and all the filtered companies in another. Getting the look-up right is eluding us at present.

 

Any pointers would be gratefully received.

 

Simon

0 Upvotes
markkofman
Top Contributor

Export Companies and related Contacts

SOLVE

Just wanted to share 2 videos that might help out with the report you are trying to do

 

1. This video is a very basic overview of how you can join two tables using a VLOOKUP in Excel - https://www.youtube.com/watch?v=M6ymclM1Ncw. I know there are ton's of other videos out there showing the similar thing, but this one specifically is showing an example of merging company and contact data

 

2. Other option that will be even more simple is to use Import2 Wizard for your export tasks. With that, you can do a joint report/export in just a few simple steps. Here is another video introducing how this works: https://www.youtube.com/watch?v=CCqOS_O10JI 

 

Hope this helps

MartinGammon
Participant

Export Companies and related Contacts

SOLVE

Simon

You link the two on the CompanyID field. This will be in both the company database and the contacts databases (where it will be called something like AssociatedCompanyID).

Make sure you have output ALL fields in the contacts database.

 

0 Upvotes
meenalmalhotra
Participant

Export Companies and related Contacts

SOLVE

Once you have downloaded 2 files:
1. Companies that you want contacts for
2. All Contacts(or I generally use filter of country, other customized field to avoid downlaoding huge chunk of it)(Tip: Make sure you download contacts where "Associated Company" is "Known")

 

You can now use vlookup formula on downlaoded contacts file, by comparing "Associated Company ID" in  downloaded conatcts file with "Company ID" in downloaded Companies file. All the matches then can be filtered into a new sheet.

 

There are plenty vlookup tutorials available online. It seems hard in beginning, but once you are used to it, it works like a charm. Hope this helps.

0 Upvotes
acw
Member

Export Companies and related Contacts

SOLVE

Did you find a solution yet? This is also something I want to do - targetting specific company types and pull out the contacts for those types.

acw
Member

Export Companies and related Contacts

SOLVE

Sorry for the delay replying I was going to try the excel trick people are recommending - but haven't had time as yet.  It would be great if hubspot could find a simpler fix for this though as it's not an unusual thing for their clients to want to do.

0 Upvotes
MBeck
Member

Export Companies and related Contacts

SOLVE

I found that you can now do this through the report tab.  You can base your query on contact and company properties.  Way to go Hubspot!

 

Oliver75
Contributor

Export Companies and related Contacts

SOLVE

Hi MBeck,

Thank you for the valuable advice!

With a report, the export of combined contact and company data works!

1. You just have to create a custom report with mixed data (contact + company).
2. Add the company data like street, post code, city etc.
3. Optional: You can sort the columns in HubSpot.
4. Hit the export function and there you go!

Cheers,
OIiver

acw
Member

Export Companies and related Contacts

SOLVE

I guess this assumes you have the reports builder functionality / professional version of hubspot? rather than the starter packs?

0 Upvotes
Oliver75
Contributor

Export Companies and related Contacts

SOLVE

We licensed the Enterprise Edition of HubSpot. I don't know if its already available in the Pro version, but with the Enterprise it works.

0 Upvotes
MartinGammon
Participant

Export Companies and related Contacts

SOLVE

Can you give us a bit more detail on how you do this, please? It is not obvious to me.

Thanks.

0 Upvotes