Enhancement Request: Allow Excel import without formatting

J. Craig Williams

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

Shaine Greenwood

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.

J. Craig Williams

Shaine

They don't.

Craig