---
title: As a company user, how can I import metrics from Google spreadsheets?
description: How to integrate or import metrics from Google spreadsheets for company user.
---

[Skip to content](https://support.rundit.com/how-to-integrate-or-import-metrics-from-google-spreadsheets#main-content)

[Submit a ticket](https://support.rundit.com/kb-tickets/new?hsLang=en)

[![Rundit](https://support.rundit.com/hs-fs/hubfs/rundit_logo.png?height=40&name=rundit_logo.png)](https://rundit.com/?utm_source=supportcenter)

- [Support Center Homepage](https://support.rundit.com/)

Open main navigation

Close main navigation

- [Support Center Homepage](https://support.rundit.com/)
- [Submit a ticket](https://support.rundit.com/kb-tickets/new)
- [Sign in to Rundit platform](https://app.rundit.com/#/login)

[Sign in to Rundit platform](https://app.rundit.com/#/login)

 Welcome to Rundit Support Center

- There are no suggestions because the search field is empty.

1. [Support Center](https://support.rundit.com/?hsLang=en)
2. [Rundit for Portfolio Companies - Get started](https://support.rundit.com/rundit-for-portfolio-companies-get-started?hsLang=en)
3. [Metrics](https://support.rundit.com/rundit-for-portfolio-companies-get-started?hsLang=en#metrics)

# As a company user, how can I import metrics from Google spreadsheets?

## Learn how to import metrics from Google spreadsheets as a company user.

To import metrics from Google spreadsheets:

 

1\. From the left navigation bar, go to **Metrics**

2\. Click "I**mport from Google Sheets**" below the Metrics table

![](https://support.rundit.com/hs-fs/hubfs/image-png-Jan-20-2025-11-28-59-9598-AM.png?width=670&height=346&name=image-png-Jan-20-2025-11-28-59-9598-AM.png)

 3\. Sign in to your Google account 

**Note**:

- Make sure your Excel file is converted into a Google Sheet file (Rundit does not read regular Excel files) and follows the [**metric template**](https://docs.google.com/spreadsheets/d/1jhkxBV6ysss4nTOYWfIoV8YBu9W84tqJoxWxbTW9h0M/edit?usp=sharing).

4\. Select source (the right spreadsheet). Make sure the sheet is NOT in XLSX format, but in Google Sheet format. If it is XLSX, click *File \> Save as a Google Sheet.*

![](https://lh4.googleusercontent.com/-bAdo8pG00bLwDmsrdSRNzm9OMmVljTzbU9vRepLFLgBCdiKjplLz_27y9wkPg0Y0jxI4-iYhbE5AXKmmVbMDc7ITeoRFOI_GqcnLZsyuBZthHxtdFzIX6uTMau4WwkFSYaYMOOaKT_nlwowvPbEIco)

5\. Select the time period. Make sure the time periods are in chronological order from left to right. 

![](https://support.rundit.com/hs-fs/hubfs/image-png-Jan-20-2025-11-45-23-1065-AM.png?width=670&height=42&name=image-png-Jan-20-2025-11-45-23-1065-AM.png)

![](https://lh3.googleusercontent.com/jMm16Kn1P54_Zbz4LKaHWXapybpHx4r6bylTtpaYMB7A5sH_qbn1s1RECS9PuRjEEyzXi8s8ggq57Na071eQC8veTM2LFA1avunlJZGtQj47xgPbPlOLIEzSgBrs4kiLvV9LwUeRNPr8vUE6Gr7MR-o)

6\. Select the date row number.

![](https://lh4.googleusercontent.com/WT-HNce4MDjmElBMeVOnCgbx9522MLcqNpUNycS9uBdkZw4EVi2wQkhTNLbUTj8OLxJvyuIwkKutvmVDjEuCGV5BaRoaB-Nhg2mW7MFjUjRM_OrTqXktxFuevFzaZJD8PyvTC-Lf7XEoM_SqJ-M7qh0)

7\. Choose the associated rows in your Google Sheet for your Metrics.

![](https://lh6.googleusercontent.com/PFoCGS0hgAEW8LIAwGSqqYEFcHQRHOYcigU1gH6zdd-8YPMsb1u_P3HEKBRDiehZRNbmJO1QArApPt0PBbu5_MpiPdRB7n9s3s9XggVqANfSnvuvYIi24BRfhbW5apVrhmvpewq4695mX4f3hbU72G0)

8\. To enable automatic syncing, select "Automatically re-sync the sheet." Rundit will check for updates daily and import any changes.

![](https://support.rundit.com/hs-fs/hubfs/image-png-Nov-21-2025-02-29-42-5256-PM.png?width=498&height=135&name=image-png-Nov-21-2025-02-29-42-5256-PM.png)

**Please follow the instructions when importing data from Google sheet:**

- When inserting historic metrics data, use only full values, not abbreviations. For example, don't use 1 K or 1 M, use 1000 or 1000000.
- When importing monthly values, the dates have to be in a date format (when double clicking a date, a small calendar pops up)
- When aiming to sync both quarters and years, make sure the structure of the date row is this: Q12021, Q2021, Q32021, Q42021, Y2021, Q12022… The reporting periods have to be chronologically in order from left to right.

- [Rundit for Investors - Get started](https://support.rundit.com/rundit-for-investors-get-started?hsLang=en#main-content)

    - [Investors](https://support.rundit.com/rundit-for-investors-get-started?hsLang=en#investors)
- [Account settings](https://support.rundit.com/account-settings?hsLang=en#main-content)

    - [User Settings](https://support.rundit.com/account-settings?hsLang=en#user-settings)
    - [Organization Settings](https://support.rundit.com/account-settings?hsLang=en#organization-settings)
    - [Users & Funds](https://support.rundit.com/account-settings?hsLang=en#users-funds)
    - [Currency Settings](https://support.rundit.com/account-settings?hsLang=en#currency-settings)
    - [Subscriptions](https://support.rundit.com/account-settings?hsLang=en#subscriptions)
    - [Security](https://support.rundit.com/account-settings?hsLang=en#security)
- [Functionalities](https://support.rundit.com/functionalities?hsLang=en#main-content)

    - [Portfolio monitoring](https://support.rundit.com/functionalities?hsLang=en#portfolio-monitoring)
    - [Investment data](https://support.rundit.com/functionalities?hsLang=en#investment-data)
    - [Investments Overview Dashboards](https://support.rundit.com/functionalities?hsLang=en#investments-overview-dashboards)
    - [Export data](https://support.rundit.com/functionalities?hsLang=en#export-data)
    - [Company profile](https://support.rundit.com/functionalities?hsLang=en#company-profile)
    - [Comments](https://support.rundit.com/functionalities?hsLang=en#comments)
    - [Company reports](https://support.rundit.com/functionalities?hsLang=en#company-reports)
    - [Portfolio activity](https://support.rundit.com/functionalities?hsLang=en#portfolio-activity)
    - [Global fund and currency selector](https://support.rundit.com/functionalities?hsLang=en#global-fund-and-currency-selector)
    - [Capital allocation](https://support.rundit.com/functionalities?hsLang=en#capital-allocation)
    - [Company custom ID](https://support.rundit.com/functionalities?hsLang=en#company-custom-id)
    - [Industry](https://support.rundit.com/functionalities?hsLang=en#industry)
    - [Labels](https://support.rundit.com/functionalities?hsLang=en#labels)
    - [Currency Settings](https://support.rundit.com/functionalities?hsLang=en#currency-settings)
    - [Interactive Fund Report](https://support.rundit.com/functionalities?hsLang=en#interactive-fund-report)
    - [Fund Management](https://support.rundit.com/functionalities?hsLang=en#fund-management)
    - [AI Toolbelt](https://support.rundit.com/functionalities?hsLang=en#ai-toolbelt)
    - [Dashboards](https://support.rundit.com/functionalities?hsLang=en#dashboards)
- [Rundit for Portfolio Companies - Get started](https://support.rundit.com/rundit-for-portfolio-companies-get-started?hsLang=en#main-content)

    - [Investor reports](https://support.rundit.com/rundit-for-portfolio-companies-get-started?hsLang=en#investor-reports)
    - [Getting started](https://support.rundit.com/rundit-for-portfolio-companies-get-started?hsLang=en#getting-started)
    - [Investor groups](https://support.rundit.com/rundit-for-portfolio-companies-get-started?hsLang=en#investor-groups)
    - [Metrics](https://support.rundit.com/rundit-for-portfolio-companies-get-started?hsLang=en#metrics)
    - [File storage and sharing](https://support.rundit.com/rundit-for-portfolio-companies-get-started?hsLang=en#file-storage-and-sharing)
- [Troubleshooting](https://support.rundit.com/troubleshooting?hsLang=en#main-content)

    - [Google Sheet integration](https://support.rundit.com/troubleshooting?hsLang=en#google-sheet-integration)
    - [Email issues](https://support.rundit.com/troubleshooting?hsLang=en#email-issues)
    - [Metrics](https://support.rundit.com/troubleshooting?hsLang=en#metrics)
    - [Reporting reminder](https://support.rundit.com/troubleshooting?hsLang=en#reporting-reminder)
    - [Navigation](https://support.rundit.com/troubleshooting?hsLang=en#navigation)
    - [Interactive LP report](https://support.rundit.com/troubleshooting?hsLang=en#interactive-lp-report)
    - [Investments](https://support.rundit.com/troubleshooting?hsLang=en#investments)
- [FAQs](https://support.rundit.com/faqs?hsLang=en#main-content)

    - [Investors](https://support.rundit.com/faqs?hsLang=en#investors)
    - [Portfolio Companies](https://support.rundit.com/faqs?hsLang=en#portfolio-companies)

- [Support Center Homepage](https://support.rundit.com/)

[![Chill listening crop-3](https://support.rundit.com/hs-fs/hubfs/rundit_logo.png?width=69&height=24&name=rundit_logo.png "Chill listening crop-3")](https://rundit.com/)

Support Center

<https://www.facebook.com/runditsoftware/> <https://twitter.com/RunditOfficial> <https://www.linkedin.com/company/rundit/> <https://www.instagram.com/rundit_official/>

Copyright © 2026, Rundit