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.

[JSG3]

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!

[DGilman]

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?

[JSG3]

Sure, using an email field as an example:

Copy Emails + semicolon field


Then paste them into the list parameter



Hope this helps!

[kirastuart]

@JSG3 IF I COULD BUY YOU A BEER I WOULD

[TomS]

Thanks for the tip! This is awesome 🙂

[Gra80]

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

[CraigBailey]

Thanks @JSG3 !

[ColinCampbell]

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

[primatiood]

Hmmm, I was so excited, but it doesn't seem to work for me... Any ideas what can be the problem I don't paste emails but voucher codes. I have the voucher codes in column A and semicolon in column B (google docs), but when I copy and paste they come as one line of text, not separated...

[shatton]

Separating entries by ";" is only available for LISTS but not available for the Contact or Company filtering.

[mkranitz]

@shatton! This was the missing key. I'm sitting here like a goofball trying to paste it every way from sunday into a company filter, not a LIST! I popped it into a list and voila. THANKS all

😎

[farser]

@JSG3 you've made my day! and many more in future, no doubt. Cheers!

[HadarEisen]

@JSG3 Thank you, this is awesome!

[sgarforth]

Thank you @JSG3 

[paju]

@JSG3 I can't thank you enough!