The LAR Formatting Tool is intended to help financial institutions, typically those with small volumes of covered loans and applications, to create an electronic file that can be submitted to the HMDA Platform.
Filers will not need to use the LAR Formatting Tool if they are able to format their HMDA data into a pipe delimited text file by using, for example, vendor HMDA software, the financial institution’s current Loan Origination Software (LOS), or applications such as Microsoft® Access® or Excel® that may be used for data entry and formatting.
Please review Section 2 of the HMDA Tools Instructions guide prior to downloading the tool.
Download the HMDA 2017 LAR Formatting Tool
Download the HMDA 2018 LAR Formatting Tool
Source : https://www.consumerfinance.gov/data-research/hmda/lar-formatting-tool