Import data into Pyramid Analytics

daoppong

Does anyone know how to import smartsheet data into Pyramid Analytics application? I'm working with a team, and we have some data in Smartsheet, which we are bringing into this application. Any thoughts and ideas will be appreciated.

Lee Joramo

I am not familiar with Pyramid Analytics. But Smartsheet provides a number of ways to export data:

• Manual from the sheet `File -> Export` and choose your format
• Data Shuttle to setup Import/Export automatons
• ODBC connections
• Writing your own program using the Smartsheet API to directly access data as JSON, Excel or CSV
• Other third-party connections found in Smartsheets Partners listings. I have never used any of these, but CData is an example.

For myself, I would first look to Data Shuttle and then then writing a custom API program.