Enhancement Request: Allow Excel import without formatting
I would like to be able to import an Excel file without formatting.
Use Case:
I have a customer using an (older?) ERP. The ERP can export to Excel. After row 99 of data, the Excel file changes format. They probably thought that was a feature.
I'd like to import the Excel file to Smartsheet without formatting to avoid extra steps.
Converting to csv (an extra step) is not a viable option as the text contains both commas and semi-colons. Also, the ERP not US so there's already confusion between comma and period usage which I prefer not to exacerbate.
This request has also be posted to the Form
Craig
Comments
-
Craig—
In the mean time, you may need to clear all with the Clear button in Excel: https://support.office.com/en-us/article/clear-cells-of-contents-or-formats-9ff6b8ff-1afd-495f-8ad8-8c1f6f82a9d6
I wonder if you could automate that action somehow. Not sure if Zapier allows for that level of detail with their Excel integration.
-
Shaine
They don't.
Craig
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.3K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 477 Announcements
- 5K Ideas & Feature Requests
- 85 Brandfolder
- 150 Just for fun
- 72 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 302 Events
- 36 Webinars
- 7.3K Forum Archives