Copy and paste multiple cells from Excel into HubSpot smart list

aulicki

Right now, if you want to add multiple criteria from an Excel doc into a HubSpot smart list, you have to copy and paste them each separately. I would love the functionality to be able to copy and paste multiple cells from Excel into a smart list at once for easy updating.

22 Replies
GreggPTX
Member

I think you misunderstood. You don't add the column and cells with ";" then upload the list, you add the column and the semicolons then highlight the cells with the value you want to add to your filter/smart list criteria/whatever, Copy them, then Paste them into Hubspot. For example, if you were creating a smart list and you only wanted to include Contacts with a Mailing Country value of Mexico, Canada, or Europe, you would create the list, select a Filter Type of Contact properties>Mailing Country, then select Is Equal to Any Of, then go to your spreadsheet and copy (Ctrl+C) the cells with the country names and the ; cells beside them and then Paste them (Ctrl+V) into the "Add Values" flled in Hubspot. The result would be this:

Screen Shot 2021-07-01 at 3.26.22 PM.png

Then you just save your new list. This saves you all the work of either typing each individual value or copying/pasting them in one at a time. Very handy for adding a bunch of different filter values at once.

Aakash
Member

@JSG3   I can't thank you enough!