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

D

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!!!
 
D

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.)
 
Top