Copy and paste multiple cells from Excel into HubSpot smart list

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.

8 Replies
Occasional Contributor

Here's a trick, if you are going to copy multiple cells in from excel into a list in HS, have the cell in the row right next to the one your copying into HS contain a semi-colon. Example:

<Cell 1 with data> < ; >
<Cell 2 with data> < ; >

Copy/Paste this into your list and it will take the fields separately. Enjoy!

Occasional Contributor

I tried using this trick and it doesn't seem to work for me. Is there something that I'm missing? Can you share a screenshot of how you're able to separate the field data when pasting from excel?

Occasional Contributor

Sure, using an email field as an example:

Copy Emails + semicolon field
Screen Shot 2019-10-15 at 5.31.29 PM.png

Then paste them into the list parameter

Screen Shot 2019-10-15 at 5.32.57 PM.png

Hope this helps!

New Contributor | Platinum Partner
New Contributor | Platinum Partner

@JSG3 IF I COULD BUY YOU A BEER I WOULD

 

Smiley Very Happy

Occasional Contributor

Thanks for the tip! This is awesome Smiley Happy

New Contributor

Thank you so much. This is a big time saver.

Regular Contributor | Partner
Regular Contributor | Partner

Thanks @JSG3 !

New Contributor

@JSG3 This is awesome. We can actually do something in smart lists that you can do in Marketo. Love it!