---
title: Import Data 
description: Users can manually enter scorecard data, but if you have data in a CSV file, you can import all data at once.
---

[Skip to content](https://support.clearimpact.com/en/2023-import-data#main-content)

English

Show submenu for translations

[Contact Support](https://support.clearimpact.com/en/kb-tickets/new?hsLang=en)

[![Clear-Impact-Logo-Wide-Tagline-RGB.png\]](https://support.clearimpact.com/hs-fs/hubfs/images/Clear-Impact-Logo-Wide-Tagline-RGB.png?height=40&name=Clear-Impact-Logo-Wide-Tagline-RGB.png)](https://support.clearimpact.com/?hsLang=en)

Open main navigation

Close main navigation

- English
  
  Show submenu for translations
- [Contact Support](https://support.clearimpact.com/en/kb-tickets/new)
- [Help Desk](https://support.clearimpact.com/en/kb-tickets/new)

[Help Desk](https://support.clearimpact.com/en/kb-tickets/new?hsLang=en)

 Hi, how can we help you?

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

1. [Help Center](https://support.clearimpact.com/en?hsLang=en)
2. [Scorecard Documentation](https://support.clearimpact.com/en/scorecard-documentation?hsLang=en)
3. [Site-Level Settings](https://support.clearimpact.com/en/scorecard-documentation?hsLang=en#site-level-settings)

# Import Data

*For users with instance administrator permission.*

Users can [manually enter scorecard data](https://support.clearimpact.com/en/2023-entering-data-values-and-target-values-for-a-measure?hsLang=en), but if you have data in a CSV file, you can import all data at once.

 

To import a data spreadsheet, click the **Administration** icon and choose **Import / Import Data**.

 **![](https://support.clearimpact.com/hs-fs/hubfs/Screenshot%202025-11-07%20at%204-13-46%E2%80%AFPM-png.png?width=519&height=276&name=Screenshot%202025-11-07%20at%204-13-46%E2%80%AFPM-png.png)**

 

**Read the instructions on this page carefully.** While importing it’s possible to update or overwrite existing data, **which cannot be undone**. 

The import format must include specific columns and headers. We recommend first downloading the sample file to use as a template. 

![](https://support.clearimpact.com/hs-fs/hubfs/Screenshot%202025-11-07%20at%204-14-06%E2%80%AFPM-png.png?width=570&height=140&name=Screenshot%202025-11-07%20at%204-14-06%E2%80%AFPM-png.png)

 

The five import columns include **id**, **actual\_value\_date**, **target\_value**, **actual\_value**, and **comment**.  

![](https://support.clearimpact.com/hs-fs/hubfs/Screenshot%202025-11-07%20at%204-14-24%E2%80%AFPM-png.png?width=604&height=122&name=Screenshot%202025-11-07%20at%204-14-24%E2%80%AFPM-png.png)

 

Once downloaded, fill in the file with your data.

- **id (required):** The ID of the measure into which the values will be imported. This ID is the series of numbers at the end of the URL of the page when [viewing a measure](https://support.clearimpact.com/en/2023-viewing-or-editing-a-measure?hsLang=en).  
  ![](https://support.clearimpact.com/hs-fs/hubfs/Screenshot%202025-11-07%20at%204-14-45%E2%80%AFPM-png.png?width=1098&height=586&name=Screenshot%202025-11-07%20at%204-14-45%E2%80%AFPM-png.png)
- **actual\_value\_date (required):** Format must be MM/DD/YYYY. To specify a time period, use a date anytime within that period. For example, if the measure takes monthly data, and you have a value for April 2021, you can use any date within that month, such as 04/15/2021.
- **target\_value (optional), actual\_value (required):** Numerical values up to six decimals. Do not include symbols such as % or $. If the value is a percent, use the percent number, not the decimal. For example, 90% should be entered as 90.
- **comment (optional):** Enter up to 255 characters; comments over 255 characters will be truncated.

For each row in the import file, a new measure value will be added in Scorecard. If there is already measure data for a time period for which there is also data in the import file, the imported value will overwrite the existing value. To preserve existing measure data, leave the data field empty in the import file.

Be sure to include the header row, with the exact spelling used in the template. Save the file in CSV format.

Then use **Choose File** to find the file, and once uploaded, click **Run Import**.

![](https://support.clearimpact.com/hs-fs/hubfs/Screenshot%202025-11-07%20at%204-15-17%E2%80%AFPM-png.png?width=625&height=248&name=Screenshot%202025-11-07%20at%204-15-17%E2%80%AFPM-png.png)

 

- [Scorecard Documentation](https://support.clearimpact.com/en/scorecard-documentation?hsLang=en#main-content)

    - [Getting Started](https://support.clearimpact.com/en/scorecard-documentation?hsLang=en#getting-started)
    - [Scorecards](https://support.clearimpact.com/en/scorecard-documentation?hsLang=en#scorecards)
    - [Scorecard Objects](https://support.clearimpact.com/en/scorecard-documentation?hsLang=en#scorecard-objects)
    - [Entering Scorecard Data and Notes](https://support.clearimpact.com/en/scorecard-documentation?hsLang=en#entering-scorecard-data-and-notes)
    - [Viewing or Editing Scorecard Objects and Data](https://support.clearimpact.com/en/scorecard-documentation?hsLang=en#viewing-or-editing-scorecard-objects-and-data)
    - [Actions](https://support.clearimpact.com/en/scorecard-documentation?hsLang=en#actions)
    - [Reports](https://support.clearimpact.com/en/scorecard-documentation?hsLang=en#reports)
    - [Tools](https://support.clearimpact.com/en/scorecard-documentation?hsLang=en#tools)
    - [Site-Level Settings](https://support.clearimpact.com/en/scorecard-documentation?hsLang=en#site-level-settings)
    - [API](https://support.clearimpact.com/en/scorecard-documentation?hsLang=en#api)
    - [Upgrade Notes](https://support.clearimpact.com/en/scorecard-documentation?hsLang=en#upgrade-notes)
    - [FAQ (Scorecard)](https://support.clearimpact.com/en/scorecard-documentation?hsLang=en#faq-scorecard)
- [Scorecard Video Tutorials](https://support.clearimpact.com/en/scorecard-video-tutorials?hsLang=en#main-content)

    - [Upgrade Videos](https://support.clearimpact.com/en/scorecard-video-tutorials?hsLang=en#upgrade-videos)
    - [Training Videos](https://support.clearimpact.com/en/scorecard-video-tutorials?hsLang=en#training-videos)
    - [Customer Success Stories](https://support.clearimpact.com/en/scorecard-video-tutorials?hsLang=en#customer-success-stories)
- [Compyle Documentation](https://support.clearimpact.com/en/compyle-documentation?hsLang=en#main-content)

    - [Compyle Overview](https://support.clearimpact.com/en/compyle-documentation?hsLang=en#compyle-overview)
    - [Participants, Households, and Organizations](https://support.clearimpact.com/en/compyle-documentation?hsLang=en#participants-households-and-organizations)
    - [Data Collection](https://support.clearimpact.com/en/compyle-documentation?hsLang=en#data-collection)
    - [Analytics](https://support.clearimpact.com/en/compyle-documentation?hsLang=en#analytics)
    - [Administration](https://support.clearimpact.com/en/compyle-documentation?hsLang=en#administration)
    - [Administration - Forms and Fields](https://support.clearimpact.com/en/compyle-documentation?hsLang=en#administration-forms-and-fields)
    - [Scorecard Feeds](https://support.clearimpact.com/en/compyle-documentation?hsLang=en#scorecard-feeds)
    - [Compyle Release Notes](https://support.clearimpact.com/en/compyle-documentation?hsLang=en#compyle-release-notes)
    - [FAQ (Compyle)](https://support.clearimpact.com/en/compyle-documentation?hsLang=en#faq-compyle)
    - [Referral Network (Compyle-to-Compyle Referrals)](https://support.clearimpact.com/en/compyle-documentation?hsLang=en#referral-network-compyle-to-compyle-referrals)
- [Compyle Video Tutorials](https://support.clearimpact.com/en/compyle-video-tutorials?hsLang=en#main-content)

    - [Compyle Overview Videos](https://support.clearimpact.com/en/compyle-video-tutorials?hsLang=en#compyle-overview-videos)
    - [Upgrade Webinars](https://support.clearimpact.com/en/compyle-video-tutorials?hsLang=en#upgrade-webinars)
- [Control Documentation](https://support.clearimpact.com/en/control-documentation?hsLang=en#main-content)

    - [Control Overview](https://support.clearimpact.com/en/control-documentation?hsLang=en#control-overview)
    - [Control for Users](https://support.clearimpact.com/en/control-documentation?hsLang=en#control-for-users)
    - [Control for Administrators](https://support.clearimpact.com/en/control-documentation?hsLang=en#control-for-administrators)
    - [Control FAQ](https://support.clearimpact.com/en/control-documentation?hsLang=en#control-faq)
    - [Clear Impact Suite Overview](https://support.clearimpact.com/en/control-documentation?hsLang=en#clear-impact-suite-overview)
    - [Suite Release Notes](https://support.clearimpact.com/en/control-documentation?hsLang=en#suite-release-notes)
- [Showcase Documentation](https://support.clearimpact.com/en/showcase-documentation?hsLang=en)
- [Unlimited Suite Documentation](https://support.clearimpact.com/en/unlimited-suite-documentation?hsLang=en#main-content)

    - [Suite Implementation Materials](https://support.clearimpact.com/en/unlimited-suite-documentation?hsLang=en#suite-implementation-materials)
    - [Managing Partner/Child Sites](https://support.clearimpact.com/en/unlimited-suite-documentation?hsLang=en#managing-partner-child-sites)
    - [Rolling Up Data Across the Unlimited Suite Network](https://support.clearimpact.com/en/unlimited-suite-documentation?hsLang=en#rolling-up-data-across-the-unlimited-suite-network)
- [Clear Impact Live Training](https://support.clearimpact.com/en/clear-impact-live-training?hsLang=en#main-content)

    - [Free and Customized Training](https://support.clearimpact.com/en/clear-impact-live-training?hsLang=en#free-and-customized-training)
    - [Software Courses](https://support.clearimpact.com/en/clear-impact-live-training?hsLang=en#software-courses)
- [Collaborate with Clear Impact](https://support.clearimpact.com/en/collaborate-with-clear-impact?hsLang=en#main-content)

    - [Coming Attractions & Sneak Peeks](https://support.clearimpact.com/en/collaborate-with-clear-impact?hsLang=en#coming-attractions-sneak-peeks)
    - [Resources & Results](https://support.clearimpact.com/en/collaborate-with-clear-impact?hsLang=en#resources-results)

[![Logo\_ClearImpact\_White](https://support.clearimpact.com/hs-fs/hubfs/Logo_ClearImpact_White.png?width=341&height=80&name=Logo_ClearImpact_White.png "Logo_ClearImpact_White")](http://www.clearimpact.com)

Clear Impact Help Center | support@clearimpact.com

<https://www.linkedin.com/company/clear-impact-llc/posts/?feedView=all> <https://clearimpact.com/resources/turning-curves-podcast/> <https://clearimpact.com/social-sector-hero/>

Copyright © 2025, Clear Impact, Inc. LLC.