Hi all, hope this can help someone.
You can export all of your properties from the Properties table in Settings and you’ll get a spreadsheet that will leave you with a column that will pack all of the dropdown (etc) values into one cell. It will look something like this:
[{"label":"Freshman","value":"Freshman","displayOrder":0,"hidden":false,"readOnly":false},{"label":"Sophomore","value":"Sophomore","displayOrder":1,"hidden":false,"readOnly":false},{"label":"Junior","value":"Junior","displayOrder":2,"hidden":false,"readOnly":false},{"label":"Senior","value":"Senior","displayOrder":3,"hidden":false,"readOnly":false},{"label":"Graduated","value":"Graduated","displayOrder":4,"hidden":false,"readOnly":false}
With a little finesse in Excel, using this formula in a blank column of cells, you can pick out the dropdown values:
=TEXTJOIN(", ",1,TOCOL(TEXTAFTER(TEXTSPLIT(A1,""","""),"""label"":"""),2))
Paste into the top of a column and drag it all the way down. After this, I will typically create ANOTHER blank column, copy the formula row with cleaned values that I just created and then paste “values” into the new blank column. Now you can remove your “formula” column and the original ugly values text column and just have one left with your cleaned up values.
*Note you have to paste “Values,” otherwise, you will just copy the forumla again and when you remove the original ugly values text column, it will “break” your formula and you won’t have any values.
It would be grrrrreeeeat if HubSpot allowed us to format the exports ahead of time, or just made the default export a little more wieldy, but until this, this has saved me HOURS of copying and pasting.
(Shout out to the kind person on Reddit who helped me with this Excel formula, because I am no pro.)