Export Parent Company Name


I created a report showing a list of companies that have an associated parent company.  The report shows exactly what I want.  The issue is when I export that report data.  Rather than getting the parent company name, I get the parent company ID.  A random numeric value is totally useless.  I want/need the actual parent company name.  There must be some way on the back end to do a lookup and pass through the company name after looking up the company ID.  Please fix this!!

HubSpot updates
5 Replies
Contributor | Elite Partner

We use this HubSpot Google Sheets integration to automatically sync the company data to a Google Sheet.

We then use the Google Sheet Import Range function to import this data into another sheet which we can add functions to.

We then do a lookup on this sheet using the Parent ID against the Company ID to add the Parent Company Name as a Column which can then be used in other reports, etc. 


I concur with this! It must be a very simply enhancement to allow for the export of the parent organisation name next to the parent company ID. Please can this be added to the functionality Hubspot?


Agree - facing the same issue!!


I'm trying to report on the number of deals each of my child companies has within a parent. In an ideal world I would like to see:

Parent company/Child company names/number of deals under parent umbrella


I'm on the free version of Hubspot (for the short term) so I can't build custom reports. In the interim I have created a list which shows the child company/parent company/number of deals under child company. I now want to export the list and sort by parent company so that I have the original view I need (how many deals under a parent with the child orgs listed). My issue now is that when I export the list, the parent company names dissapear and are replaced with unique idenitifier numbers?? Anyone know how to fix this??


For us, we have a complex market as we sell to the NHS landscape. In this matrix you have an Integrated Care System (this would be the 'parent' company although that isn't strictly true) and then horizontally you will have several hospital trusts and local authorities ('child' organisations). Each of the parents are assigned to a senior member of the team but the children could be assigned to any other member of the team. On a weekly basis I need to pull a list of all of the deals we have in the pipeline to include the parent and the child. This allows me to see where we are really engaging with a parent and also where we may be engaging with a parent but no children. I present this to the senior leadership team and sort by Parent.

Currently, I am pulling the list of opportunities (I can see the parent on my screen but can't sort by parent) but when I export I can only see the unique identifier number for the parent. This means I have to go back and manually note the Parent.

If Hubspot wants to be a CRM of choice for organsiations such as consultancies (not just transactional businesses) we need this functionality!



This actually used to work until a few weeks ago, where the PARENT company name, was showing in the Associated Companies column in the export. This dissapeared recently and when I contacted HS, they say apparently it was a bug (where PARENT company was showing in the Associated Company) so now is fixed. This does now seem like a bug to me; and now I ahve to play around with sheets and formulas, when the information is already there.


HS IT team, please fix this so we can actually make use of the exported data without having to resort to other programmes.


Completely Agree!  This seems so very basic.  Why would the Parent Company ID be exported instead of the Parent Company name?  This is a CRM / Marketing tool, not an IT tool.  Generally people are reading these reports/data, not programs or processes.


If anyone wants the Parent Company ID, then that should be a seperate field. 

Is there a Parent Company Name field AND a Parent Company ID field,  OR is there only a "Company Name" field?  I expect there is only a Company name field...and no Parent Company Name field...as the Parent / child is just a relationship between two "companies".   


Even if this is the case, the report / export tool should be able to allow a choice of using the Parent ID OR the Company name... or simply include both as seperate fields, OR possibly concatenate the Parent Company ID with the Company name, like  ABC Company 546789689.  This is not perfect but at least the data would be there and further massaging of the data could trim off the ID if necessary.