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
- Smartsheet Customer Resources
- 63.8K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives