http://appraiseractive.blogspot.com/2009/04/free-fannie-mae-1004mc-tools.html
I could email you Don's thing, which has extra goodies, it used to be free, so you get free version.
If you want that, PM me with your email address.
You can just look at it for the order you want the data in,
Download the info, make a copy, in case you **, then, follow instructions on how to do a macro in excel,
from HELP facility, or utube, etc. ----
Which amount to: Tell Excel "I'm starting a macro, record it" --and when done-- tell Excel "I'm done,
stop recording"
Save the macro, now it will do what you did by hand as automation.
((Hint: I always start by having THE MACRO put the cursor in the upper left corner,
and making a copy of the original data, then working with the copy ))