---
title: Add values to companies' metric tables manually/ with Google Sheet integration
description: Learn how to add values to the company metrics table manually or using a Google Sheet integration
---
[Skip to content](https://support.rundit.com/add-values-to-the-company-metrics-table#main-content)
[Submit a ticket](https://support.rundit.com/kb-tickets/new?hsLang=en)
[](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. [Functionalities](https://support.rundit.com/functionalities?hsLang=en)
3. [Company profile](https://support.rundit.com/functionalities?hsLang=en#company-profile)
# Add values to companies' metric tables manually/ with Google Sheet integration
## Learn how to add values to the company metrics table manually or using a Google Sheet integration
#### **1. Add values manually**
- Navigate to the to the **metrics table** of a company. You can add values to the metric table manually simply by clicking a cell on the table and typing in a value.
#### **2. Add values by using Google Sheet Integration**
- For investors, Google Sheet Integration is available only with private companies (read more about **[Private vs. shared companies here](https://support.rundit.com/managed-vs.-claimed-companies?hsLang=en)**).
- If you invite the actual portfolio company members to claim the company profile, the Google Sheet integration access will then only be available for only the company members.
- Click the **“Import from Google Sheets**” button below the metrics table and continue with the guided steps:
- - Sign in with Google
- Select source (the correct spreadsheet in your drive)
- - ***If you can't find the spreadsheet you're looking for, please make sure the spreadsheet is in Google Sheet format. Rundit doesn't recognise .xlsx formatted spreadsheets❗***
- *If the spreadsheet is in xlsx format, **before** starting the integration setup in Rundit, open the Excel file in your drive -\> At the top, click File -\> Save as Google Sheets). *
- - - Choose a sheet from selected spreadsheet
- Select which time periods you want to import (monthly/ quarterly/ yearly values or all)
- Select the starting year of your sheet
- Select the date row number of the sheet
- Choose data source rows for your Rundit table metrics and click save
\- You don’t have to create a separate Excel Sheet for Rundit - you can choose any already filled Google Sheet that has a compatible structure
\- To sync multiple Google Sheets, you’ll have to do the integration setup separately for each separate sheet or file.
\- In order to sync your sheet, make sure your file is converted into a Google Sheet file (Rundit does not read regular Excel files).
- - Open an Excel file in your drive
- At the top, click file -\> Save as Google Sheets
**Please note:**
- Please don't insert abbreviations such as 1 K or 1 M.
- 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.
- If you’re not able to login to your drive in order to proceed with the sync, the issue is most likely due to third-party API access blockers set in your google admin, please check your settings. Also, make sure you're not using private/ incognito mode.
- Investor users can also add data to companies' metrics tables in bulk using the [Excel Add-in tool](https://support.rundit.com/how-to-use-rundit-excel-add-in?hsLang=en)—enabling uploads across multiple portfolio companies simultaneously—or leverage the AI-driven [email extractor](https://support.rundit.com/extracting-company-data-from-emails?hsLang=en) for automated data entry.
- [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/)
[](https://rundit.com/)
Support Center
Copyright © 2026, Rundit