Import a formula into a calculated metric definition
Directly import any formula that is stored in Microsoft Excel spreadsheets into a calculated metric definition. This import helps in quickly building your formula for performing calculations.
Before you begin
Role required: system admin
About this task
Sometimes, you might have a formula saved in a spreadsheet that you want to include into a calculated metric definition for use in formula building. In these instances, the formula import functionality proves beneficial. It's crucial to verify that the spreadsheet includes the following columns with precisely the same column names.
- Name
- Frequency
- Formula
- Calculation level
- Domain area
Procedure
-
Navigate to All > System Import Sets > Administration > Data Sources.
-
Select Metric definition data source.
-
Select the Manage attachment icon and upload the file that contains the formula.
-
Select the Load All Records related link.
-
Select Run Transform.
-
Select Transform.
Result
The calculated metric definition becomes available with the formula in the list of all the metric definitions.
Parent Topic:Formula building in a calculated metric definition
--- title: Import a formula into a calculated metric definition description: Directly import any formula that is stored in Microsoft Excel spreadsheets into a calculated metric definition. This import helps in quickly building your formula for performing calculations. locale: en-US canonical_url: https://www.servicenow.com/docs/r/environmental-social-governance/import-a-formula-into-a-cmd.html release: brazil topic_type: task last_updated: "2026-09-10" reading_time_minutes: 1 breadcrumb: [Formula building in a calculated metric definition, Configuring GRC: Metrics, GRC: Metrics, Operational Sustainability Management \(formerly Environmental, Social, and Governance\)] --- # Import a formula into a calculated metric definition Directly import any formula that is stored in Microsoft Excel spreadsheets into a calculated metric definition. This import helps in quickly building your formula for performing calculations. ## Before you begin Role required: system admin ## About this task Sometimes, you might have a formula saved in a spreadsheet that you want to include into a calculated metric definition for use in formula building. In these instances, the formula import functionality proves beneficial. It's crucial to verify that the spreadsheet includes the following columns with precisely the same column names. - Name - Frequency - Formula - Calculation level - Domain area ## Procedure 1. Navigate to **All** > **System Import Sets** > **Administration** > **Data Sources**. 2. Select Metric definition data source. 3. Select the Manage attachment icon and upload the file that contains the formula. 4. Select the **Load All Records** related link. 5. Select **Run Transform**. 6. Select **Transform**. ## Result The calculated metric definition becomes available with the formula in the list of all the metric definitions. **Parent Topic:**[Formula building in a calculated metric definition](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/brazil/markdown/environmental-social-governance/formula-building-at-metric-definition-and-entity-level.md)
| title | Import a formula into a calculated metric definition |
| description | Directly import any formula that is stored in Microsoft Excel spreadsheets into a calculated metric definition. This import helps in quickly building your formula for performing calculations. |
| locale | en-US |
| canonical_url | https://www.servicenow.com/docs/r/environmental-social-governance/import-a-formula-into-a-cmd.html |
| release | brazil |
| topic_type | task |
| last_updated | 2026-09-10 |
| reading_time_minutes | 1 |
| breadcrumb | Formula building in a calculated metric definition{"Configuring GRC":"Metrics"}{"GRC":"Metrics"}Operational Sustainability Management \(formerly EnvironmentalSocialand Governance\) |