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

Find more posts tagged with

Importing and Exporting

Enhancement Request

Comments

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

Sign in to join the conversation!

Quick Links

Trending discussions

Sheet -Ganhtt Chart
Is it possible to display both the planned and actual duration for a single task on a Smartsheet Gantt chart? I would like the Gantt bar to show the planned duration (e.g., in blue) based on a Planned End Date column, and then show the actual duration (e.g., in green) based on an Actual End Date column. Can the Gantt view…
Color-Coded Tags in Board View
I noticed in the Board View tags are grey by default but in the how to videos, in the Board View some of the tags are colorful. I'd like to leverage that same functionality as I'm building a research repository with many different types of research in it and a visual cue would be lovely. Can anyone assist? I attached a…
Can we run the request for update to include all the rows that applied to one condition?
We want to know if it is possible to send request for update in one email, but with multiple rows at the same time. For example, staff A has 4 open referrals, I want to send one request for update automatically to them where they will receive only one email without having to overload them daily with all the open referrals…