[Excel] How do I change the default import external data settings.

[djr]

I need to change the default settings for importing .csv files into Excel so
that I don't have to change the settings every time I do the action.

Is this possible?

Many thanks to anyone who can help me!!!

 

[Dave Peterson]

Maybe you could rename the .csv file to .txt and record a macro when you do it
once.

Then just rerun that macro the next time you need to import that file.

(Keep recording while you add headers/footers/filters/etc and make it really
useful.)