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. It's been years now. Just throw up a link which exports to an Excel, and ideally, groups similar properties together.
First column lists the properties. Second column indicates what group they are in (for example: Names, Email Addresses, Phone Numbers, Street Addresses, etc.). Third column indicates whether the field is a Hubspot default field or a user-created field.
I'm sure there are other useful columns, but those three are a minimum.
Hubspot, don't let the perfect be the enemy of the good. You can improve it later! Just get it done.
(For anyone reading: the workaround now, mentioned a few times in this thread, is to export contacts and select "all properties".... the column headings give you the list of properties. Not ideal, but better than nothing).
Upvoting this on behalf of a customer. Looking forward to this idea becoming a reality! Some customers would like to review their properties offline in order to clean up unused properties or options.
I also would find this very useful, our properties need a review and I find the only solution is to manually copy and paste them each out into excel to perform an audit. This is not helpful for GDPR where we should really be able to have a good understanding of the data we hold on people to ensure this is easy for us to manage I do hope this is actioned soon.
REALLY REAL HACK SOLUTION (Strap in kids! It's actually pretty easy...)
1. Settings > Properties > Choose "Filter by:" of your choice (e.g. Contact Properties, Company Properties, etc.)
2. Scroll to bottom and change "10 per page" to "100 per page."
3. Highlight all the data in the list by clicking and holding your mouse/track pad while scrolling down.:
4. Drop into Excel sheet. There will be merged cells, don't worry about them yet. If the first property doesn't line up with the rest, insert cells to push the data to align with the rest. It should look like this:
5. Go to the next page of properties and repeat this process, dropping the next 100 under the first 100 in Excel.
6. Highlight the entire Excel sheet and unmerge all cells.
7. Sort the entire Excel sheet by values in column C. Your information should now be split by useful information and extra garbage, looking like the image below at the split. Your useful data rows should match how many properties are in listed in your "All Properties (#)" total. If not, you missed some while copying.:
8. Delete all the garbage rows below your useful data. Add the header names back in if they didn't come over; Name, Group, Created by, Used in, etc.
9. Congratulations, you can now sort by the criteria of your choice.
Thanks for the idea HMill. I did all those step before I decided to put in the suggestion for Hubspot to create export capablity. All that work defeats the purpose of having a CRM, especially when you have over 300 properties. The data is there, it should not be difficult for Hubspot to create export capability. I'm surprised they still haven't completed it yet.
I agree this would be nice. Especially if you could export Name, Internal Name and Field Type.
An imperfect workaround:
Export a contact list
Select All Properties
In your resulting spreadsheet, you'll have columns for all properties. Then just copy those headers and Paste as Transposed and now you have a list of all your properties. Doesn't solve things like knowing field types, but maybe a start?
Convert the resulting JSON to CSV (Parabola is a super easy way to do this if the file is too big. Just set up a new flow with JSON file, set Top Level Keys to results. Actually, if you use Parabola, just do an API import and you can skip Postman altogether!)
Thank you for your continued feedback here. I'm delighted to let you all know that this is something in active development and should be available soon. We'll update this post once it is in beta!
Well done, jakespirek! This is the first answer I've seen that addresses the underlying problem with exporting fields and options. I struggled with finding a JSON-CSV converter that could handle the output appropriately, but https://www.coolutils.com/online/JSON-to-CSV worked for me because it created a results file and an options file as part of a ZIP archive it generated. Parabola gave me the same output/open errors as several other converters, though that's likely the result of my not knowing what additional parameters to provide. Anyway, very nice solution. Thanks!
I'm excited to share we've implemented a Export Property Definitions feature, thanks to your feedback. You can now export all property definitions for your Contacts, Companies, Deals, and Tickets! Always nice to share some good news.
We don't have everything from Taylor's original request in the first release. Here are the columns included:
Name
Label
Type
Description
Group name
Form field
Options
Read only value
Read only definition
Calculated
External options
Deleted
Hubspot defined
Created user
This is in limited beta for a short period, and then we'll be rolling it out to all hubs over the coming weeks. Excited to see how you can use this to de-clutter your hub and reclaim master of your HubSpot domain.
Waiting with baited breath for an updated on this one.. Would be super useful. I have a property with over 500 options in dropdown that is in urgent need of review and editing. To be able to download this property with all options would be very helpful.
Debe ser un usuario registrado para añadir un comentario aquí. Si ya está registrado, inicie sesión. Si todavía no está registrado, hágalo e inicie sesión.