Import default for CSV files - I'd like to have change the default.

I have several CSV files each day to import into an excel spreadsheet.  I need the formatting to remain the same in the cells into which they are imported.  Calculations and other things are done based formulae I have set.

Every import I have to change the default from "Adjust column width" (1st screen shot) to the second screen shot.

I don't want the columns adjusted.

How can I change the default to be what I have pasted above?




Thank you for posting your query in Microsoft Office Community.


As per your query, there is no option available to change the default of importing CSV file. I suggest you to post your feedback in Excel user voice from the below link:


Hope this information helps. Please post to us if you need any further assistance with Office.


Thank you.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.


Question Info

Last updated February 22, 2018 Views 26 Applies to: