HELP!! How do I Merge Excel Smartsheets to an existing Smartsheet?

Maria Michel

I had changed cells by mistake, deleting a lot of column information. Smartsheets sent me the smartsheets via excel.

I tried to merge to the existing sheets that lost the data. It does not have any of the attachment, comments, or reminders.

How do i do this???

Sean Morgan

Hello @Maria Michel ,

The Excel file you have been sent will only contain the raw/string text data as well as comments. Attachments and Workflows cannot be exported into the recovery Excel file due to Excel not directly supporting the same features Smartsheet has.

To merge the data back into your Smartsheet, you will have to copy and paste the data back into the respected areas of your sheet. The comments from your sheet should be stored within a separate tab in the Excel file, detailing their original position in the sheet E.G Row 1. These too can be placed back in your Smartsheet by copying and pasting.

See more on the best practices for getting this data back into your sheet: https://help.smartsheet.com/articles/518318-tips-for-using-copy-and-paste

If you have not done so already, I would advise you to create backups of your data to combat accidental deletion. You can use the built in backup tool seen here: https://help.smartsheet.com/articles/506499-back-up-your-data

Or use the API backup tool for an organization wide backup: https://www.smartsheet.com/marketplace/apps/backup-tool-by-smartsheet

Let me know if you have any questions.

Regards

Sean