Loading data from excel into Smartsheet API to an existing sheet

Sujeeth Nidumolu

I have data in Excel which I have loaded and cleaned in Python and I want to load the same into Smartsheet through API. This data goes into the existing sheet in Smartsheet, which is typically adding new data into the sheet. I have gone through few articles about "Add Rows" but it doesn't explain about loading data with multiple rows.

Genevieve P.

Hi@Sujeeth Nidumolu

The "Add Rows" operation supports both single andbulkPOSToperations. You can specify multiple rows in the request, however all rows must be inserted at the same location (for example, theabove,parentId,siblingId,toBottom, ortoTopattributes must be the same).

Here are the links to the documentation that specifies this:

• Add Rows (Python)
• Bulk Operations (Python)

You may also want to take a look at the Smartsheet Samples in GitHub. I found this sample which may help:python-read-write-sheet

Cheers!

Genevieve

Tony Rice

I can't be the only one with a use case of mirroring an Excel spreadsheet (or CSV or whatever) into a SmartSheet grid on a regular basis.

The API supports extracting a SS grid in excel format. It should support updating an existing grid with an uploaded excel spreadsheet.

This is very possible via the raw REST API and the SS supported Python package. I wrote something up in Python in a couple of hours that pulls a grid via the API, reads an excel file and sends the necessary update_rows and add_rows API calls. It's similar to thepython-read-write-sheet上面提到的例子,但更generic (the column names are readily available on both sides of the equation)

But it seems like a use case that should be supported natively by SmartSheet's API offerings.

I'll clean up the code, get the okey-dokey from my employer and share it on GitHub soon.

Maxim Lobko

Hi@Tony RiceI'm looking to solve same problem. have you been successful with the code? if you could share it on GitHub I think it would be great.

FOttolini

I can't be the only one with a use case of mirroring an Excel spreadsheet (or CSV or whatever) into a SmartSheet grid on a regular basis.<\/p>

The API supports extracting a SS grid in excel format. It should support updating an existing grid with an uploaded excel spreadsheet. <\/p>

This is very possible via the raw REST API and the SS supported Python package. I wrote something up in Python in a couple of hours that pulls a grid via the API, reads an excel file and sends the necessary update_rows and add_rows API calls. It's similar to the python-read-write-sheet<\/a> example mentioned above, but far more generic (the column names are readily available on both sides of the equation)<\/p>

But it seems like a use case that should be supported natively by SmartSheet's API offerings.<\/p>

I'll clean up the code, get the okey-dokey from my employer and share it on GitHub soon.<\/p>","bodyRaw":"[{\"insert\":\"I can't be the only one with a use case of mirroring an Excel spreadsheet (or CSV or whatever) into a SmartSheet grid on a regular basis.\\nThe API supports extracting a SS grid in excel format. It should support updating an existing grid with an uploaded excel spreadsheet. \\nThis is very possible via the raw REST API and the SS supported Python package. I wrote something up in Python in a couple of hours that pulls a grid via the API, reads an excel file and sends the necessary update_rows and add_rows API calls. It's similar to the \"},{\"attributes\":{\"link\":\"https:\\\/\\\/github.com\\\/smartsheet-samples\\\/python-read-write-sheet\"},\"insert\":\"python-read-write-sheet\"},{\"insert\":\" example mentioned above, but far more generic (the column names are readily available on both sides of the equation)\\nBut it seems like a use case that should be supported natively by SmartSheet's API offerings.\\nI'll clean up the code, get the okey-dokey from my employer and share it on GitHub soon.\\n\"}]","format":"rich","dateInserted":"2021-02-13T16:21:19+00:00","insertUser":{"userID":132008,"name":"Tony Rice","url":"https:\/\/community.smartsheet.com\/profile\/Tony%20Rice","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/AAP61DT79SC9\/nYMLAX4SSUYE4.jpeg","dateLastActive":"2021-06-02T18:29:39+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/279554#Comment_279554","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/279554#Comment_279554

The problem with the python-read-write-sheet is that it returns a random newly created Smarthsheet id. Using this snippet as an example, how to tell the API to write data to a specific Smartsheet?