All Collections
Getting Started
Setting up your company
KPIs
Creating a Master Google Sheet
Creating a Master Google Sheet

Transfer KPI results input manually or imported from Excel to Google Sheets or consolidate KPIs from multiple Google Sheets into one

Updated over a week ago

Contents:

Why transfer KPIs?

Using the Fathom template when making a Google Sheet connection enables you to easily:

  • Transfer non-financial KPI results that have been entered manually into Fathom to Google Sheets
    ​
    ​

  • Transfer non-financial KPI results that have been imported into Fathom from Excel to Google Sheets
    ​
    ​

  • Consolidate results from multiple Google Sheets into one master Google Sheet for the company

You may want to transfer Excel sourced or manually entered non-financial KPIs to Google Sheets to enable automatic updates. Automatic updates are not possible for Excel sourced or manually entered KPI results.

How to transfer KPIs to Google Sheets

  1. Go to the non-financials page for the company

    1. Go to 'Settings' for the company

    2. Select 'Step 4 - KPIs'

    3. Select the 'Non-financial KPI results' option
      ​
      ​

  2. If you want to transfer non-financial KPIs from multiple Google Sheets into one master Google Sheet,

    1. Select the ‘Plug’ icon in the top right corner

    2. Select the Google Sheet with KPIs to be transferred

    3. In the menu that opens on the right, select ‘Disconnect’. You will not lose any KPI results already imported into Fathom.

    4. Disconnect any other Google Sheets that you want to transfer to a master Google Sheet

    5. Select the ‘Plug’ icon again

    6. Choose to ‘Connect new Google Sheet’

    7. Use the Fathom template

    8. A new Google Sheet will be created that lists the results for all of the non-financial KPIs for the company.
      ​
      💡Pro Tip: Any KPIs not sourced from a currently connected Google Sheet will be connected to the new master Google Sheet.
      ​
      ​

    9. Access the new Google Sheet by selecting the ‘Plug’ icon once again. The sheet named ‘Company Name Custom KPIs Import’ is the new, master Google Sheet.
      ​
      ​

  3. If you want to transfer manually entered or Excel imported non-financial KPI results to Google Sheets,

    1. Select the ‘Plug’ icon in the top right corner

    2. Choose to ‘Connect new Google Sheet’

    3. Use the Fathom template

    4. A new Google Sheet will be created that lists the results for all of the non-financial KPIs for the company.
      ​
      💡Pro Tip: Any KPIs not sourced from a currently connected Google Sheet will be connected to the new master Google Sheet.
      ​
      ​

    5. Access the new Google Sheet by selecting the ‘Plug’ icon once again. The sheet named ‘Company Name Custom KPIs Import’ is the new Google Sheet.

Additional knowledge & common questions:

Did this answer your question?