They sound like very strange sort of files. Are they multiply rows as well as columns? How are they meant to be read e.g. A1 then B1 and then A2 and B2? or A1,A2,B1,B2?
I suspect you're right that Excel is not the best medium for reading the files (from your description I can't imagine what would be) but if there is some logic in the way they are organised it might be possible to apply some formulae that will make it easier to read or to extract to Word or notepad.
In the meantime here are some "tricks" you may or may not know.
You can resize multiple columns at the same time by highlighting several complete columns and resizing one of them will resize all the highlighted columns to the same width.
Once you've done that - and while the columns are still highlighted - right click in one of the highlighted columns and select Format/Alignment and click on Wrap Text. This will increase the row size to accommodate the longest text in a given column.
See how this might help but if it is still too hard to read it might be best to look into some formula or VBA to solve the problem.