skip to main content

Joined-up Data Standards

Joined-up Data Standards Navigator spreadsheet tool

Our Google Sheet Add-on allows you to translate elements of data standards directly within your spreadsheet, to save time working out which fields in one data standard can be matched to those in another.

For example, you can use the spreadsheet tool to query whether the ‘health’ sector code in the OECD DAC’s Creditor Reporting system directly compares to the same field in COFOG, or to learn which World Bank sector codes are relevant when monitoring a particular SDG indicator.

Currently the tool is available as a Google Sheet Add-on. It can be used directly in a Google Sheet and results can be downloaded in Microsoft Excel format. A Microsoft Excel macro will be available in the future.

How to get the tool:

  1. From your active Google Sheet, select “Get add-ons” from the top “Add-ons” menu.
  2. Search for "Joined-up Data Standard Navigator spreadsheet tool"
  3. Click on '+ FREE'
  4. Sign in to your Google Account if prompted
  5. Review the summary of add-on’s requirements and select 'Allow'.
  6. JUDS Navigator spreadsheet tool’ is now available in your 'Add-on' dropdown menu within your Google Sheet.

Once downloaded, the tool offers two functions:

  • translateSectorCode()
  • translateGeoCode()

To learn more about how to use this tool, please go to our FAQs.

This version is in beta. If you would like to be notified when we release a new version please fill out your details here