Importing Excel spreadsheet to an existing Smartsheet

Jayy S.

Hi,

I need to import Excel spreadsheet to an existing Smartsheet that already have DataMesh set up. It's not feasible to copy and paste 500 rows at a time since the Excel has many more rows than that. DataShuttle also would not work because while I can save the Excel in OneDrive, it requires additional permissions to connect SmartSheet to the company OneDrive due to possible confidential and private data.

If this is not an option, SS needs to make it an option, and increase the number of rows/columns that can be copied at one time.

ChristianFinke

Hi @Jayy S.

If DataShuttle and copy-pasting aren’t options, one workaround is to split the Excel file into smaller chunks and import each chunk individually. I know this isn't ideal with so many rows.

Or, if you have admin support, they might be able to help with the permissions needed to connect OneDrive to Smartsheet for a smoother import via DataShuttle.

Let us know if you need further assistance.

Best,

Maria Franklin

Hi!

I’m Maria from the Product team at Smartsheet. I’m looking to speak to a few users with data import use cases, and came across your post here. Would you be willing to meet with me, to talk through your import needs, and your experiences of importing data with Smartsheet to date? We are working on improving the import experience for users, and your input would be valuable. 

My email is maria.franklin@smartsheet.com if you’d like to get in touch to schedule some time. 

Best regards,
Maria

Darren Mullen

@Jayy S.Also if anyone comes across this post, we do have a way to do this that keeps your data private.

https://youtu.be/Y2BsWpV9vHc