Q: I need help formatting HMDA data into a pipe delimited text file. Is there a tool that can help?
A: Yes. Many Loan Origination Software (LOS) systems, in addition to vendor HMDA software, can produce a pipe delimited text file for submission to the CFPB’s HMDA Platform. Microsoft® Access® or Excel® may also be used for data entry and formatting.
The CFPB also provides a Loan/Application Register (LAR) Formatting Tool
into which filers can enter their HMDA data. This will produce a pipe delimited text file that can be submitted to the HMDA Platform. The filer can then proceed through the HMDA Platform to submit the LAR. This tool may be especially helpful for filers with small volumes of covered loans and applications.