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
