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

Options

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

Answers

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Options

    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!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!