This importer is used during deployment and ongoing updates in partnership with your Customer Success Manager or Data Solutions Lead. You complete the template; the Standard Metrics team imports it.
The template can be found here or at the bottom of this page as a downloadable Excel file.
See a short tutorial here:
The four sheets
The importer is organized into four sheets, each for a different purpose:
Holdings — add new investments.
Financings — add round-level information (with or without holdings attached).
Transactions — record sales, conversions, and warrant exercises.
Overrides — set Fair Value, Ownership, and Post-Money Valuation.
The template is attached to this article. Please reach out to your Customer Success Manager if you need a fresh copy.
Holdings sheet
The Holdings sheet is where you add new investments to the platform in bulk. Each row is one investment.
Supported investment types
Equity
Convertibles
Warrants
Crypto
Crypto Warrants
Crypto Convertibles
Required vs. optional fields
Always required
Field | Notes |
Company Name | Must match exactly with the company name displayed in the Standard Metrics platform |
Financing Round Name |
|
Close Date |
|
Fund |
|
Investment Amount | The check size written to the portfolio company, not the cost allocated to the investment |
Required based on investment type
Shares Purchased — Equity, Warrants, Crypto, Crypto Warrants
Exercise Price and Due Date — Warrants and Crypto Warrants
Issue Date — Convertibles, Warrants, and all Crypto types (defaults to Close Date if left blank)
Crypto Token Short Code — any Crypto type
Holding ID is optional and only used to mark existing rows on a re-import — leave blank for new investments. The Standard Metrics team will populate it.
Optional fields
There are many optional fields you can fill in for extra detail. Several have sensible defaults if left blank:
Field | Default if blank |
Price Per Share | Investment Amount ÷ Shares Purchased |
Type of Purchase | Primary |
Type of Shares | Preferred |
Share Class Stage | Financing Round Name |
Convertible Type | Convertible Note |
Issue Date | Close Date |
Investment Type | Empty (creates an empty financing shell) |
If you provide a value, the importer uses what you provided.
Additional optional fields include: Pre-Money Valuation, Round Size, Co-Investors, and Liquidation Preference columns.
Currency and FX rates
Each of the following fields has its own Currency and FX Rate column you can fill in. All currency defaults to USD unless otherwise specified.
Investment Amount
Price Per Share
Exercise Price
Pre-Money Valuation
Round Size
Valuation Cap
Co-Investors formatting
Separate co-investor names with a semicolon and a space — for example, Fund A; Fund B.
Liquidation preferences
Liquidation preferences are optional, but if you fill in any of the three main fields below, you need to fill in all three:
Liquidation Preference Multiple — any positive number
Liquidation Preference Participation — Non-Participating, Fully Participating, or Capped Participating
Liquidation Preference Seniority — Tiered Seniority, or Pari Passu With All Existing Preferred
Capped Participating Multiple — only needed when Participation is set to Capped Participating
Financings sheet
The Financings sheet is for round-level information on its own, with or without holdings attached. Use it when you want to record that a round happened (with its pre-money, round size, co-investors, and liquidation prefs) even if your fund didn't participate.
If you did own part of the round and the same round appears on both Holdings and Financings, the shared values must match.
Financing type: Traditional or Crypto
Required: Company Name, Financing Round Name, Close Date, Financing Type
Optional: Pre-Money Valuation, Round Size, Fully Diluted Shares, Co-Investors, the Currency and FX Rate columns, and the Liquidation Preference columns
Updating values on an existing financing round
You can use the Financings tab to update a few things on a round that's already in the platform. To match an existing round, the row must have the same Company Name, Financing Round Name, and Close Date as the one in the platform.
What you can update this way
Liquidation Preference Multiple, Participation, Seniority, and Capped Participating Multiple — re-uploading replaces the existing values.
Co-Investors — new names you add to the row get attached to the round. Removing a name from the sheet does not remove it from the round; use the UI for that.
What you cannot update this way
Pre-Money Valuation
Round Size
Fully Diluted Shares
These are only set the first time a round is created. To change one of them on an existing round, edit it in the UI. Re-uploading a row with a different value will not change it.
Transactions sheet
The Transactions sheet supports bulk imports of three transaction types:
Sales — partial or full
Conversions — Note or SAFE converting to Equity
Warrant Exercises
Each transaction is one row.
Required fields
Always required
Company Name
Event (Sale, Conversion, or Exercise)
Date
Holding ID — so we know which holding the transaction applies to
Required depending on the event
Event | Additional required fields |
Sale | Proceeds, Number of Shares |
Exercise | Number of Shares, Converted to Share Class (the share class the warrant exercises into) |
Conversion | Converted to Share Class. Number of Shares is optional. |
Order of operations
Since a Holding ID is required for a transaction, holdings must already exist on the platform before a transaction can be applied to them. The recommended sequence is:
Upload holdings.
Download a fresh export to get the new Holding IDs.
Add transactions to the Transactions sheet (referencing the Holding IDs).
Upload the transactions.
Overrides sheet
Fair Value, Ownership, and Post-Money Valuation can be added in bulk using the Overrides sheet.
Fund-level vs. company-level
Fair Value and Ownership are recorded at the fund level. If you enter a company-level value, the importer creates a $0 valuation across the funds that invested in the company.
Post-Money Valuation is company-level only. Leave the Fund column blank.
Post-Money and Ownership Overrides are tied to a date, not a round, once imported.
Columns
Company Name, Override, Date, Value, Fund (optional for Post-Money), Currency (optional), FX Rate (optional).
Currency and FX Rate apply to Fair Value and Post-Money Valuation. Ownership is a percentage, so currency is ignored.
FAQ
What types of investments can I import?
Equity, Warrants, Convertibles, Crypto, Crypto Warrants, and Crypto Convertibles.
What types of transactions are supported?
Stock sales, convertible conversions, and warrant exercises.
What types of transactions are not supported?
Exit events and public market purchases are not currently supported through the importer. These must be entered in the platform UI.
What date formats does the importer accept?
A few common formats are accepted, so you don't need to reformat exports. All of the following work: 2024-10-28, 10/28/2024, October 28, 2024. Times are accepted and ignored.
What happens if I re-import a file I just exported?
Existing rows are skipped — the importer uses the Holding ID to recognize them. You can safely export, add a few new rows, and re-upload the whole sheet without creating duplicates.
Can I update existing data through the importer?
Mostly, no. Most fields are only set the first time a holding or round is created, and re-importing will not change them.
The exception is on the Financings tab: for a round that already exists, you can update Liquidation Preference Multiple, Participation, Seniority, Capped Participating Multiple, and add Co-Investors. See the "Updating values on an existing financing round" section above.
Who uploads the completed template?
Send the completed template to your Customer Success Manager or Data Solutions Lead. The Standard Metrics team handles the import and confirms the data with you.
Need further assistance? Feel free to reach out to support@standardmetrics.io.