>Thanks for your response. At this time that is not an option. We are importing from a 3rdparty and that is how they are creating the files. Its difficult for us to ask our users to save as Cvs. Some of them are just not up to it.

You can export spreadsheet to CSV using atomation as part of your import process.