Importing Excel spreadsheet to an existing Smartsheet
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.
Answers
-
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,
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 494 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives