• Tools and Templates

HMIS CSV Data Quality Tool (Excel)


Date Published: January 2022


Homeless Management Information Systems (HMIS) have become a major data source about homelessness in the U.S. for multiple funders, including HUD, the U.S. Department of Veteran Affairs (VA), Health and Human Services (HHS), plus state and local governments and other non-governmental funders and communities. Good data quality is foundational to reporting to these agencies and communities for better policy making and improved funding opportunities. Some federal reports using HMIS data include the System Performance Measures (SPM), the Longitudinal Systems Analysis (LSA), the Housing Inventory Count (HIC), the Point in Time (PIT) Count, and others.

The HMIS CSV Data Quality (DQ) Tool was developed for local use by Continuums of Care (CoCs), and it is not required by HUD. It applies logical data checks to a CoCs HMIS CSV Export, a tool common to every HMIS implementation. The DQ Tool is then able to list primary IDs associated with common data quality issues.

Resource Links

Author Organization
  • HUD
Resource Approver
  • HUD Approved