Grants.gov

Import XML Grant Data Into MS Excel

Grants.gov published a step-by-step tutorial explaining how to extract and import XML data from its database into Microsoft Excel as a workaround while the "Export Detailed Data" functionality remains temporarily unavailable following the October release. The guide covers downloading the daily XML ZIP file from the website footer, extracting the XML file, importing it into Excel using the Get Data function, and using Power Query Editor to properly load Opportunity Forecasts and Synopsis data without losing data integrity. Users can access a decade of funding opportunity data through this method.

How to Report Grant Fraud and Protect Funding

Grants.gov published guidance reminding federal financial assistance recipients of their fraud-reporting obligations under federal law. Recipients and subrecipients must report suspected award-related waste, fraud, and abuse to their awarding agency's Office of Inspector General. The guidance also outlines cybersecurity best practices including zero-trust policies, role-based access controls, and the principle of least privilege.

Grants.gov Keyword Search Tips for Grant Funding Opportunities

Grants.gov published instructional guidance on 11 April 2024 explaining how its search engine matches keywords against grant opportunity titles, descriptions, and related documents, returning results in order of relevance. The article covers search operators including OR (||), AND (&&), and NOT (!), wildcard characters (* and ?), and phrase matching with quotation marks. Grants.gov notes that AND, OR, and NOT operators must be entered in uppercase letters, and that wildcard characters cannot be used alone without accompanying letters or numbers.