Updating exciting sheet with imported data

Joan Bond

Hi

I'm building a report on a sheet, I'm looking to update this sheet with imported data weekly so the reports will update automatically.  I can't seem to update the existing sheet with an import or have the ability to save over the sheet.

is there a way of either, importing data into an exisiting sheet or being able to save over an existing sheet?

 

Thanks

Mike Wilday

Have you tried copying and pasting from your original source into the Smartsheet?

Joan Bond

I would but my data has more than 500 rows and 50 columns so it becomes a pain to do a copy and past

 

Mike Wilday

I don't think that's possible from what I'm seeing here: 

https://community.smartsheet.com/discussion/importing-excel-existing-sheet

https://community.smartsheet.com/discussion/importing-csv-google-sheet-or-excel-data-directly-existing-sheet

J. Craig's solution of importing and moving or copying the rows from the new import might be easier than copying from the source file. 

Joan Bond

Thanks ... I shall give that a go

Richard Rymill SBP

Craig's solution is nice and quick but if you need to connect your Excel sheets directly with Smartsheet you will need to involve an outside App, like Appsheet or maybe Zapier or even an API? Depends on your precise need and the benefits of setting up some form of automation? 

The pain has to be worth the gain? So How important is this to your data Integrity and consistency without errors of Copy paste? 

Happy to discuss if there is sufficient need? 

RichardR 

Andrée Starå

Hi Joan,

Smartsheet just released a new add-on called Data Uploader that could be an option.

Please see the attached link/screenshot for more information.

https://www.smartsheet.com/datauploader

I hope this helps you!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting