If you mean you don't want to open and save each file manually, then this can all be done in code provided the files names have a patten or better still all reside in one directory.
You can use the Dir() function to cycle through all the files in a specified directory as ipen & save them as a csv or other type as you like.
Setting Application.ScreenUpdating=False will speed up the process and you wiil not know it is happening! Progress can be tracked by writing to the application.statusbar="Processing 'currentfilename'" etc.
Unless you have a great many files and they are not very large it should not take too long !!
Hope this is usful, if I have the wrong end of the stick (this has been known!) I apologise.