Export All Properties in CSV.

We just switched over to HubSpot from Salesforce and are trying to do an audit on which properties we have - so we can find duplicates and either merge or delete them. It would be great if we could export all existing Properties in our system with their Name, Description, Type, # Contacts w/ Value, Workflows Used In, Lists Used In, etc. 

45 Replies
KirstenTange
New Contributor

IDEA:

We are merging two HubSpot accounts and had the need to compare properties in the two accounts. I came up with this as the easiest way to export properties.  

 

  1. Build a list of just one contact (for simplicity) and export it to Excel with ALL properties. That will give you an Excel sheet with a large number of columns. 
  2. From there it's easy to use the Excel feature to "transpose" columns into rows. https://support.office.com/en-us/article/transpose-rotate-data-from-rows-to-columns-or-vice-versa-34....
  3. Then you have your list of contact properties. 

 

Giordan
New Contributor

Big upvote from me and the Plume team on this one!

Vicky
Occasional Contributor

 It would be very helpfull. Actually I need it now. I need to export dpop down oprtions and I don't know how to do it.

acjandler
New Contributor

Looking for any possible way to export all the properties. Noting this is a 2017 thread... Is there any update on this from the Hubspot team? 

COReilly
Regular Contributor

This is a must for any Admin with a large environment.

TomS
Occasional Contributor

Same here!

fabiola_vegfund
Occasional Contributor

Totally agree on this one! I also need to create a match list with all the contact properties that we already have, where they come from and what they have on it. We're building a custom API integration and doing this manually is a PAIN.

Thanks for adding this to your dev to-do list.

Danagayle
New Contributor

This would be such a helpful feature. We are preparing to integrate with NetSuite and I am currently sitting here manually typing Label, Internal Name and Field Type into what looks to be a lenghty spreadsheet.  Exporting would save so much time. Thanks!

jjb868 Occasional Contributor | Gold Partner
Occasional Contributor | Gold Partner

 I completely agree. Was looking for the answer to this but found out it couldn't be done. 

namujg
Regular Contributor

Yes, HubSpot this is much needed!