Add a excel data sheet to an existing Smart sheet data base.

Poolboys

Hi,

I have an existing database on smart sheet that I used for my MailChimp campaign.

I now have the results of this campaign (who opened, who clicked) : I extracted the data from Mailchimp into excel.

I would like to import/ merge that excel data into my existing Smart sheet. How do I do this ?

Thanks for your help

Andrée Starå

Hi @Poolboys

I hope you're well and safe!

You could either use the Premium App, Data Shuttle or add a so-called helper sheet and use cross-sheet formulas (VLOOKUP or INDEX/MATCH) to match the data as long as you have something unique for each record that we can use. Then, you can copy the values in the main sheet and paste them as fixed or keep them connected to the other sheet.

Make sense?

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!