Skip to Help Center content

Step-by-step guide

Import KPI data from CSV

Prepare, validate, and reconcile a KPI data import before reporting.

In this article
  1. Prepare the file
  2. Import and review
  3. Avoid duplicate history

Prepare the file

Use the CSV structure provided by the KPI import workflow. Keep one observation per indicator and period, preserve the expected column names, and save the file with a consistent character encoding.

  • Use stable KPI names or identifiers that match the company’s configured indicators.
  • Represent dates and periods consistently.
  • Do not mix currencies or units in the same indicator history.
  • Remove formulas, merged cells, explanatory rows, and subtotals before exporting CSV.

Import and review

Investor Relations → Indicators → Import from CSV

  1. Select the CSV and start validation.
  2. Review rejected rows, missing indicators, invalid values, and period conflicts.
  3. Correct the source file rather than guessing inside the import review.
  4. Confirm only after the accepted-row count and affected periods match your expectation.
  5. Open the affected KPI charts and reconcile several sample values with the source.

Avoid duplicate history

Before repeating an import, check whether the first operation completed. A corrected import should intentionally update the relevant periods, not create a second set of observations with slightly different labels.

Keep the source evidence

Retain the approved source file and the import date. If a published report used the data, reconcile corrections against the published snapshot before changing the current series.