Share via

Linking Smartsheet to Excel

Murphy, Ashton {PEP} 5 Reputation points
2023-11-29T14:24:40.57+00:00 
I'm trying to link Smartsheet to Excel. I followed the step by step on the Microsoft site. When I go into Excel 365, Go to Data -> Get Data -> Get Data From Another Source -> From ODBC

I select "My Smartsheet DSN" (which I created by following the steps from 

Now, the step by step shows and says I can connect/login to Smartsheet via an API Token for SSI login, but I don't see this option anywhere, It's only asking me for a username and password, I never had to set that up since my company allows me to log in through different means

Any help or advice would be appreciated!
Microsoft 365 and Office Excel For business Windows

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Murphy, Ashton {PEP} 5 Reputation points
    2023-11-29T15:47:19.17+00:00

    I resolved this through a youtube video.. You have to go in and enable a bunch of settings..

    1 person found this answer helpful.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.