Excel import on Existing smartsheet

Asheesh

Hi Team,

is there a way to update existing smartsheet with newly excel import. our use case is, import the excel sheet 1st which will create a unique smartsheet. after that we need User to make requied udpates on excel and import the updated excel sheet in smartsheet where it should import the data in existing sheet. for now its creating new sheet everytime. since we have links defined to our 1st sheet, so need to maintain that.

Samuel Mueller

@Asheesh the best way to do this is with the Smartsheet premium app Data Shuttle.

Data Shuttle | Smartsheet

You could also create a custom API script to do this, but Data Shuttle works really well. and requires no coding.

Asheesh

Thanks @Samuel Mueller. I believe data shuttle comes with additional cost not default with Enterprise licenses. regarding custom API scripts, i believe there will be multiple sources, so API won't work for us. i also read some think like stage sheet where we can maintain the multiple import and have link between stage sheet to master sheet.