Connect Smartsheet with MS Excel

This discussion was created from comments split from: Connect Smartsheet with MS Excel.

Answers

  • Hi please how would I be able to connect Ms Excel file to smart sheet to be able to get live data from the smartsheet to be displayed on the Excel file

  • Marcela
    Marcela Employee

    Hi @Jam

    You can accomplish this through the Smartsheet Live Data Connector. It enables you to interact with and visualize data stored in Smartsheet using tools such as Excel, by providing Open Database Connectivity (ODBC). To start, ensure you have the latest version of the ODBC Driver. Once it's properly installed, you can create charts, graphs, pivot tables, and other visualizations in Excel using your Smartsheet data. Please note, this feature requires a Smartsheet Business Enterprise plan.

    For more details and step-by-step guide, refer to the Smartsheet Live Data Connector documentation.

    Best Regards,

    Marcela

    Need more information? 👀 | Help and Learning Center

    こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions