Common Approach logo Impact Data Converter

Common Approach Impact Data Converter

Spreadsheets into RDF and back, aligned with the Common Impact Data Standard
Convert Impact Data Capsule to Excel template Convert Excel template to Impact Data Capsule

The Impact Data Converter is a web application created by Common Approach.

It can be used in three ways:

  1. To convert an Impact Data Capsule into a Social Finance Fund template Excel spreadsheet (.xlsx file): Upload your impact data capsule, and the data converter will create an Excel file that you can download and edit. The Social Finance Fund template contents are specific to participants in Canada’s Social Finance Fund.

    Do you have an Impact Data Capsule that you want to convert to an Excel template? Convert now >>
  2. To convert a Social Finance Fund template Excel spreadsheet (.xlsx file) into an Impact Data Capsule: Upload the template to the converter, and the data converter will create an impact data capsule for you to download and send to your funder or investor, or view using the Common Impact Data Standard Airtable Extension. The Social Finance Fund template and the resulting impact data capsule file contents are specific to participants in the Government of Canada’s Social Finance Fund.

    Do you have an Excel template that you want to convert to an Impact Data Capsule? Convert now >>
  3. To convert data from custom sources into an Impact Data Capsule: Upload data from multiple custom sources (Excel, CSV, JSON, API endpoint), and the data converter will create an impact data capsule for you to download and send to your funder or investor. This option requires a developer to create a customized data transformation file that is specific to your data sources.

    This feature is being tested and expected to be available to the public by early 2026.

For support with the Impact Data Converter, please contact info@commonapproach.org.

From Impact data capsule to SFF template (Excel)

Step 1: File upload & validation

Use the Browse button below to find and select your Impact data capsule file that you want to convert to a fillable SFF template (Excel) template.

Step 2: File validation

Step 3: Download template

Download English SFF template (Excel)
Download French SFF template (Excel)

From SFF template (Excel) to Impact data capsule

Step 1: Upload SFF template

Use the Browse button to find and select your SFF template (Excel) file.

Step 2: Choose which data to include in Impact data capsule

Select which year of data to export to Impact data capsule.

Select which tab(s) of data to export to Impact data capsule.

Step 3: File validation

Step 4 : Download Impact data capsule

Download Impact data capsule

Custom Transformation

If you are seeing this page, then you do not have access to any custom transformations. If you believe that you should, please contact info@commonapproach.org.

From ACBN dataset to Impact data capsule

This application allows you to convert your Excel data template into an Impact data capsule that feeds into your Impact dashboard.

Step 1: Upload Dashboard Tracking File

Upload your dashboard tracking Excel file (.xlsx)

Step 2: Generate Impact data capsule

Generate an Impact data capsule from your Excel data template.

Step 3: Download Impact data capsule

Download the Impact data capsule and use it to update your Impact dashboard.

Step 4: Update your Impact Dashboard

  1. Find the location of your previous Impact data capsule (should be called "acbn.json")
  2. Replace the previous Impact data capsule with the newly generated Impact data capsule
  3. Find your Impact Dashboard Tableau workbook (should be called "acbn.twbx")
  4. Open the workbook and navigate to the "Data" tab on the top menu
  5. Refresh the data by clicking on the "Refresh" button
  6. Wait for the data to refresh
  7. Verify that the data is updated in your Impact Dashboard

From Fair Finance Fund Datasets to Impact data capsule

This application allows you to convert your master loan data and impact indicator tracking data into an Impact data capsule that feeds into your Impact dashboard.

Step 1: Upload Data Files

Master Loan Data File
Download your master loan data spreadsheet as an Excel file (.xlsx) and upload it here. This file should contain the "ALL CLIENTS Master Loan Clients" sheet with all approved loan clients.
Impact Indicator Tracking File
Download your impact indicator tracking spreadsheet as an Excel file (.xlsx) and upload it here. This file should contain the "Master Tracking By Indicator" sheet with annual aggregated data.

Step 2: Generate Impact data capsule

Generate an Impact data capsule from your master loan data and impact indicator tracking data.

Step 3: Download Impact data capsule

Download the Impact data capsule and use it to update your Impact dashboard.

Step 4: Update your Impact dashboard

  1. Find the location of your previous Impact data capsule (should be called "fff.json")
  2. Replace the previous Impact data capsule file with the newly generated Impact data capsule
  3. Find your Impact dashboard Tableau workbook (should be called "fff.twbx")
  4. Open the workbook and navigate to the "Data" tab on the top menu
  5. Refresh the data by clicking on the "Refresh" button
  6. Wait for the data to refresh and verify that the data is updated in your Impact dashboard

From Food First NL dataset to Impact data capsule

This application allows you to convert your Google Sheet template into an Impact data capsule that feeds into your Impact dahboard.

Step 1: Upload Dashboard Tracking File

Download your dashboard tracking Google Sheet as an Excel file (.xlsx) and upload it here.

Step 2: Generate Impact data capsule

Generate an Impact data capsule from your data.

Step 3: Download Impact data capsule

Download the Impact data capsule and use it to update your Impact dashboard.'

Step 4: Update your Impact dashboard

  1. Find the location of your previous Impact data capsule (should be called "ffnl.json")
  2. Replace the previous Impact data capsule with the newly generated Impact data capsule
  3. Find your Impact dashboard Tableau workbook (should be called "ffnl.twbx")
  4. Open the workbook and navigate to the "Data" tab on the top menu
  5. Refresh the data by clicking on the "Refresh" button
  6. Wait for the data to refresh
  7. Save the workbook to Tableau Public, following the instructions provided by Purpose Analytics
  8. Verify that the data is updated in your Impact dshboard

From Newfoundland-Labrador Federation of Co-operatives dataset to Impact data capsule

This application allows you to convert your Excel data template into an Impact data capsule that feeds into your Impact dahboard.

Step 1: Upload Dashboard Tracking File

Upload your dashboard tracking Excel file (.xlsx)

Step 2: Generate Impact data capsule

Generate an Impact data capsule from your data.

Step 3: Download Impact data capsule

Download the Impact data capsule and use it to update your Impact dashboard.'

Step 4: Update your Impact dashboard

  1. Find the location of your previous Impact data capsule (should be called "nflc.json")
  2. Replace the previous Impact data capsule with the newly generated Impact data capsule
  3. Find your Impact dashboard Tableau workbook (should be called "nflc.twbx")
  4. Open the workbook and navigate to the "Data" tab on the top menu
  5. Refresh the data by clicking on the "Refresh" button
  6. Wait for the data to refresh
  7. Save the workbook to Tableau Public, following the instructions provided by Purpose Analytics
  8. Verify that the data is updated in your Impact dshboard

From OCLF datasets to Impact data capsule

This application allows you to convert your loans, clients, and survey data into an Impact data capsule that feeds into your Impact dashboard.

Step 1: Upload Data Files

Loans Data File
From ESPO -> Impact Measures, export the Loans report as a CSV file, and upload it here.
Clients Data File
From ESPO -> Impact Measures, export the Clients report as a CSV file, and upload it here.
Survey Data File
Upload your consolidated survey data file as an Excel file (.xlsx). This file should contain workshop survey responses consolidated across multiple sheets.

Step 2: Generate Impact data capsule

Generate an Impact data capsule from your loans, clients, and survey data.

Step 3: Download Impact data capsule

Download the Impact data capsule and use it to update your Impact dashboard.

Step 4: Update your Impact Dashboard

  1. Find the location of your previous Impact data capsule (should be called "oclf.json")
  2. Replace the previous Impact data capsule with the newly generated Impact data capsule
  3. Find your Impact Dashboard Tableau workbook (should be called "oclf.twbx")
  4. Open the workbook and navigate to the "Data" tab on the top menu
  5. Refresh the data by clicking on the "Refresh" button
  6. Wait for the data to refresh and verify that the data is updated in your Impact Dashboard

From The SEED datasets to Impact data capsule

This application allows you to convert your data from WooCommerce, Square, and AirTable into an Impact data capsule that feeds into your Impact dashboard.

Step 1: Upload Data Files

Existing Impact data capsule
Locate your existing Impact data capsule (theseed.json) and upload it using the file selector here.
Shelldale Garden Registration
Download your Shelldale Garden Registration table from Airtable as a CSV file, then upload it using the file selector here.
Shelldale Garden Annual Survey
Download your Shelldale Garden Annual Survey table from Airtable as a CSV file, then upload it using the file selector here.

Step 2: Select Date Range

Use the date selectors below to select the start and end date of the period you need to update your Impact indicators for. For example: If your data is current up to September 2025 and you need to update it for October 2025, selected the start date as October 1, 2025 and the end date as October 31, 2025.

Step 3: Generate Impact data capsule

Generate an Impact data capsule from your data.

Note that this process connects to your WooCommerce and Square API endpoints and may take a few minutes to complete. Track the progress with the loading spinner.

Step 4: Download Impact data capsule

Download the Impact data capsule and use it to update your Impact dashboard.

Step 5: Update your Impact Dashboard

  1. Find the location of your previous Impact data capsule (should be called "theseed.json")
  2. Replace the previous Impact data capsule with the newly generated Impact data capsule
  3. Find your Impact Dashboard Tableau workbook (should be called "theseed.twbx")
  4. Open the workbook and navigate to the "Data" tab on the top menu
  5. Refresh the data by clicking on the "Refresh" button
  6. Wait for the data to refresh and verify that the data is updated in your Impact Dashboard

InvestECO — Convert data to Impact data capsule

Upload your data file and generate an Impact data capsule for InvestECO.

Step 1: Upload data file

Upload your data file.

Step 2: Generate Impact data capsule

Generate an Impact data capsule file from your data.

Step 3: Download Impact data capsule

Download the Impact data capsule file.

Area One Farms — Convert data to Impact data capsule

Upload your data file and generate an Impact data capsule for Area One Farms.

Step 1: Upload data file

Upload your data file.

Step 2: Generate Impact data capsule

Generate an Impact data capsule file from your data.

Step 3: Download Impact data capsule

Download the Impact data capsule file.

Raven Indigenous Capital Partners — Impact Data Toolbox

Use the tabs below to update your Airtable with survey and/or story data, and generate an Impact data capsule for Raven Indigenous Capital Partners.

Update Airtable

Step 1: Authenticate Airtable

Click Authenticate and sign in with your Airtable account. When prompted, ensure you select the IMM Data base. If you do not have access, contact your administrator.

Step 2: Upload data files

Select Survey file
Upload your Survey Excel file.
Select Story file
Upload your Impact Stories Excel file.
Select SELI-GLI file
Upload your SELI-GLI Assessment Excel file

Step 4: Review data to be added to Airtable

Survey
SELI-GLI
Stories

Step 5: Update Airtable

Generate Impact data capsule

Step 1: Authenticate Airtable

Click Authenticate and sign in with your Airtable account. When prompted, ensure you select the IMM Data base. If you do not have access, contact your administrator.

Step 2: Generate Impact data capsule

Download Impact data capsule

Raven Indigenous Outcomes Fund — Impact Data Toolbox

Use the form below to authenticate Airtable and generate an Impact data capsule for the Raven Indigenous Outcomes Fund.

Step 1: Authenticate Airtable

Click Authenticate and sign in with your Airtable account. When prompted, ensure you select the Fund IMM Database base. If you do not have access, contact your administrator.

Step 2: Generate JSON

Download Impact data capsule