Skip to content

Downloading your search results

GrantNav allows you to download any search results. This enables you to refine your results further and perform your own analysis, reports, and visualisations.

Grants search results can be downloaded in two ways from the main search page:

  • A basic download of the results, by selecting either of the download icons
    • CSV (which can be opened in spreadsheet programmes like Excel) or 
    • JSON (a more technical machine-readable format)
  • A customisable CSV file by selecting the “Custom CSV” button, which enables you to select which fields are included in the download.
Three buttons that are visible at the top of a GrantNav search page. A JSON file icon button that will download the data from your search in JSON format, a CSV file icon button that will download the date from your search in CSV format, and a button that says Custom CSV which enables you to select which fields are included in the download.

What data is downloaded?

The search results download includes the same grants that were returned for your search by taking into account any criteria set in the search bar or filters.

If no search or filter criteria are set, the entire dataset of over 1 million grants will be downloaded. Be aware that this can take a while as it’s a very large file!

CSV or JSON download buttons

Files downloaded using the “CSV” or “JSON” download buttons will include the following fields:

  • 360Giving Data Standard 10 required fields
  • 360Giving Data Standard recommended fields for funders
  • Other fields that appear in the filters, for example the Type of Recipient and additional data added by 360Giving such as Region and District

Custom CSV download button

The Custom CSV download allows you to choose any of the 360Giving Data Standard fields or Additional Data fields added by GrantNav.

Screenshot of the pop-up that appears when you click on ‘Custom CSV’. It includes sections that allow you to add and remove columns to create a custom download file.

Tips for using the Custom CSV:

  • Selecting ‘Add Recommended’ will add the fields included in the basic CSV and JSON downloads
  • Related fields are grouped together, for example, “Recipient Org” contains all the fields relating to Recipient Organizations.
    • A grouped field is identified by the “>” symbol
    • You can select all the fields in a related group by choosing “select all” on the top-level heading
    • You can click on the heading to expand it and select individual fields within
  • Selecting ‘Add all’ will add all the available columns (note: this is over 100 columns)
  • Use the ‘Search for a field name’ input to find specific fields to add to your chosen field list
  • There is a note at the top that tells you how many grants you are downloading and an estimate of the file size

Please note that not all of the original fields that were published by the funder are available to download in GrantNav. It contains only the key fields. If you want to look at all the fields published in the original data you can download the individual files you are interested in from the Data Quality Dashboard. To find out more please read our guidance for technical users.

Related resources:

Contents

  1. GrantNav and GrantVis User Guide
    1. Navigating the site
    2. Detail pages
    3. Using the Search Bar
    4. Refining your search
    5. Downloading your search results
    6. Visualising your results in GrantVis

Yes No Disable Analytics