1

There is not too much data so considering keeping it in an excel workbook, but can also do it with SQL whichever could work better.

Thanks!

Panthersfball234
  • 95
  • 2
  • 10

1 Answers1

2

You can download a sheet to a CSV or XLSX file using the GET /sheets/{sheetId} endpoint and an Accept header as documented here:http://smartsheet-platform.github.io/api-docs/#get-sheet-as-excel-pdf-csv Then it's up to you to import into Excel or SQL server.

There is also an ODBC connector: https://www.smartsheet.com/apps/smartsheet-odbc

Steve Weil
  • 863
  • 5
  • 8
  • The link appears to not be working. Seems interesting. Can you please provide more detail? Which programming language is this? – Panthersfball234 Mar 21 '18 at 12:42
  • Sorry about the bad link - corrected. This is an HTTP/REST API that can be called from any language, or even a shell/command script. We have client SDKs to ease use from C#, Java, Node.js, Python, and Ruby. – Steve Weil Mar 21 '18 at 19:42