Could you help us understand why you are importing submittal revisions?
The way I understand how the import functionality is designed is it allows a user to upload the submittal items in bulk into CW at the very beginning of the submittal process. All the revisions would then be handled within CW and not in an Excel spreadsheet.
Example, I work through the specs and build / import my item list in the excel template. I then handle any revisions using the revise feature in CW. By continuing to utilize the spreadsheet to handle revisions/updates/etc, no one on the project team can see the revisions until you upload the information into CW. I know I'm not disciplined enough to upload the spreadsheet everytime I make a change vs. handling the revisions/changes in CW so everyone can see the changes in realtime.
I know its tough moving away from Excel as I used to manage all my projects with these huge elaborate excel spreadsheets. The problem is no one else had access to the most up-to-date version as it was "locked" away on my computer. By utilizing CW, everyone on the project team (including Architects, Subcontractors, CM's, GC's, Owner's, etc.) has visibility to see what the latest status is of the submittals or real-time collaboration.
I would love to hear any thoughts you have. Many thanks. Jeff Marsh