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. 

HubSpot updates
50 Replies
ClariceGr
Occasional Contributor

Yes please! This would be so helpful. 

KNE
Occasional Contributor

Yes, I agree. My vote is yes!

 

This would help with bulk imports and avoiding getting error counts.  

CaseyBeanBKS
Regular Contributor

This is necessary for any major data clean up project! The data is there, why isn't there an easy way to export it? Get on it, HubSpot!

BastiSchuhl
Regular Contributor

Is there any update on this? As mentioned before, this is an absolutely essential feature for large data clean up projects. Has this been submitted in the Product forum, yet? Thanks! 

 

Lourdes
Regular Contributor

Hello all, just FYI, I made nearly the same suggestion separately. The moderator asked me to post my comment on this thread. By the way, good news:  they're working on it and it looks imminent. (I posted the comment below on June 21, 2019)

It would be helpful, when preparing data for import, to be able to export a complete list of all the properties in Hubspot, both default and custom.  Right now, I'm preparing a massive import but to match the fields, I need the list.  I also need to share the list of properties with my colleagues, so that they know what data we have.  Ideally, it would

--export in a .csv or Excel

--include the breakdown of any multi-checkbox or dropdown properties.  (For example, I have one multicheckbox property with about 90 checkbox options). 

--include a column organizing the properties by a category (for example, Phone, Address, Professional, Stats, etc.

--include who created the field (Hubspot or the user)

--include the definition of the field, either Hubspot's default definition or the user's definition provided when creating the property).

This should be fairly easy to export,  I believe. The fields already exist. They just need to be put in a report.  

I have just had to create, manually, a report like this, and it would be nice to be able to just export it in the future. 

I'm attaching a screenshot of a portion of my list. This took a couple of hours to do. 

I realize that Hubspot has certain categories (Contact, Web, etc.).  Please note that my categories are different because they are EXPRESSLY FOR batching together similar fields, in order to match my import fields to Hubspot fields.  For example, I have some data now in which there are 20 phone fields! I need to narrow them down. For that, I need to see all my phone fields, and all Hubspot phone fields. Same with emails.  Not the very broad category "Contact Data" which has everything from phone fields to whether someone is deceased. 

Anyway this would be a huge help. 

I just saw that I can't attach a screenshot, nor copy-paste an image into this field. So there's another suggestion. 

annieseattle
Regular Contributor

Please make this happen.  It's really such a simple development effort to just add an export button to export the values associated with a particular property.  It would save so much time.  Thanks in advance for listening.

yeeling
New Member

recently raised up the same request of exporting all the data fields and picklist values via support as well today. Currently there isnt a function to export the fields/values, neither is there an existing cvs / xls from Hubspot that they can share with us.

 

it's a basic requirement for us to migrate from existing CRM to hubspot to ensure that data gets mapped properly before migration and also for development of integration.  Not sure for how long more do we have to wait to get hold of that.

Loki
Regular Contributor

This is definitely something HubSpot should consider implementing. We need to be able to export all existing properties against Contacts/Companies/Deals ...etc instead of having to select each properties individually in the "Custom Report" section. Even then we might be limited in terms of number of properties we're able to export at once. 

Erick1
New Contributor

We fully support this request.

sgenolet
New Contributor

I agree, this would save alot of time. I also, need to align property fields with Salesforce and it would make it so much easier to be able to export a list of the property fields and all the information that goes with them; type, picklist, how many contacts, etc.