Skip to content
BOL Conferences Top Gun 23
Thread Options
#903624 - 02/12/08 09:21 PM Converting HMDA.dat to Excel
ccman Offline
Platinum Poster
Joined: Sep 2007
Posts: 924
Help with converting our HMDA Lar file to an excel spreadsheet. We would like to convert our lar to an excel spreadsheet for sorting and fair lending analysis. Can someone help in the "how to" department of doing this. Thanks.

Return to Top
HMDA

   
HMDA Academy
#903706 - 02/12/08 10:03 PM Re: Converting HMDA.dat to Excel ccman
ccman Offline
Platinum Poster
Joined: Sep 2007
Posts: 924
We're using the FFIEC version, if that helps.

Return to Top
#903738 - 02/12/08 10:35 PM Re: Converting HMDA.dat to Excel ccman
rlcarey Online
10K Club
rlcarey
Joined: Jul 2001
Posts: 80,336
Galveston, TX
It doesn't have an export function? It has been a long time since I actually looked at it.
_________________________
The opinions expressed here should not be construed to be those of my employer: PPDocs.com

Return to Top
#903761 - 02/12/08 11:30 PM Re: Converting HMDA.dat to Excel rlcarey
ccman Offline
Platinum Poster
Joined: Sep 2007
Posts: 924
Thanks anyway. I'll try contacting hmda.help.

Return to Top
#903773 - 02/13/08 12:42 AM Re: Converting HMDA.dat to Excel ccman
Truffle Royale Offline

10K Club
Joined: Jul 2003
Posts: 17,359
FFIEC Loan Producer?
In LP, use the icon on the top of the page to produce a HMDA.dat file
Save this as an Excel File With Headers
Open Excel and open this file
Under Data, select Pivot table and go from there
If you need help setting up a pivot table or chart, pm me and I'll walk you through the rest of it.
It's easy and the best free tool for scrubbing and analyzing HMDA ever. My examiner taught me how to use it. Andy Z wrote a couple articles for ABA magazine about it too.

Return to Top
#903873 - 02/13/08 02:21 PM Re: Converting HMDA.dat to Excel Truffle Royale
#12 Offline
Diamond Poster
Joined: Jun 2005
Posts: 1,338
If you're using the free FFIEC software, just choose export, then pick "for other purpose." In the Target file, choose where you would like to save it. At the bottom, choose ASCII Delimited. Hit begin. Then open excel, find the file (you may have to change to all files, not just .xls) and open it.
_________________________
CRCM

Return to Top
#903910 - 02/13/08 02:50 PM Re: Converting HMDA.dat to Excel #12
Truffle Royale Offline

10K Club
Joined: Jul 2003
Posts: 17,359
Sorry. Got my FF..Cs mixed up. Follow #12 advice. The offer to help do pivot tables and charts still holds tho.

Return to Top
#904070 - 02/13/08 04:50 PM Re: Converting HMDA.dat to Excel Truffle Royale
ccman Offline
Platinum Poster
Joined: Sep 2007
Posts: 924
THANKS EVERYONE.

Return to Top

Moderator:  SMQ, CRCM