I agree, I think that you'd have to perform a work around... steps would be something like:

1. Import to a temp table

2. Manipulate the records in the temp table

3. Export back to excel overwriting the old file