Move Your Existing Strategy and KPI System to BSC Designer

Your strategy may already exist in Excel spreadsheets or strategy documents such as Word files and PDFs. Use these existing materials to reproduce the scorecard structure, transfer the data and rationale, and continue working in BSC Designer without rebuilding everything from scratch.

When Strategy Outgrows Spreadsheets

Why change something that already works well? The short answer is complexity and scale. As the system grows, maintaining it across spreadsheets and documents adds more manual work:

  • A flat list of goals and KPIs no longer works, but hierarchies are difficult to maintain in spreadsheets.
  • Different versions of the same KPI file start circulating.
  • Historical values can be overwritten without control.
  • Owners send updates by email instead of updating their own KPIs.
  • Performance formulas break, and overall calculations become inconsistent.
Too Many KPIs in Excel? Turn a Flat KPI List into a Structured Strategy

We discuss the disadvantages of the ad hoc approach with Excel spreadsheets in the separate article.

The solution is to migrate the existing strategy to a specialized strategy execution system such as BSC Designer.

Migration Workflow

The migration can be organized into four steps. Each step deals with a different part of the existing system:

1. Prepare the Scorecard Structure

Define the scorecards and hierarchy that will contain the strategy. Create them manually or use AI to reproduce the structure from existing materials.

2. Prepare the Data Model

Use standard BSC Designer fields for common strategy elements and add custom fields only for organization-specific metadata.

3. Import the Strategy and KPI Data

Populate the prepared scorecards with objectives, KPIs, historical data, targets, initiatives, rationale, and other existing information.

4. Import Supporting Strategy Documents

Extract controls that need to become working scorecard elements, or keep the original documents attached as supporting material.

AI can significantly reduce the work required to reproduce an existing strategy and KPI structure.

200+ Objectives and KPIs Migrated with AI

In one implementation, a financial organization used AI-assisted import to create the initial structure for more than 200 objectives and KPIs in approximately 10–15 minutes, compared with an estimated full working day of manual preprocessing.

See the migration case study.

Step 1. Prepare the Scorecard Structure

In many organizations, strategy is spread across Excel spreadsheets, Word documents, PDFs, and other files maintained by different business units and functional teams:

Typical strategy, KPI, and performance management documents stored in spreadsheets and office files

First, define where the existing strategy will live.

A spreadsheet or part of a strategic plan focused on one business unit or functional area can become a separate scorecard. Related scorecards can then be connected within the overall strategy structure.

Strategy implementation in a business group with multiple companies and subsidiaries.

The scorecard structure can be created manually or generated with AI from the existing files.

Too Many Strategy Spreadsheets? Build a Scorecard Structure with AI

How to Do It with AI

  1. Open any scorecard in BSC Designer.
  2. Switch to the AI tab.
  3. Explain what structure needs to be created—for example, business-unit scorecards, functional scorecards, or the objective hierarchy.
  4. Review the proposed structure and apply it.

Step 2. Prepare the Data Model

Most strategy information already maps to the standard BSC Designer data model. Custom fields are needed only for information specific to your organization or methodology.

Already Available in the Standard Data Model

  • objectives and KPIs;
  • update intervals;
  • current and historical values with targets;
  • optimization direction (maximize / minimize);
  • project properties (start date, end date, budget);
  • initiatives and action plans;
  • owners;
  • comments and rationale.

Add Custom Fields When Needed

  • internal classification codes;
  • custom KPI attributes;
  • control or evidence classifications;
  • other metadata that should remain searchable or reportable.

See how to configure custom fields.

Once the required custom fields are prepared, AI can populate them while transferring the source material into the scorecard.

Step 3. Import the Strategy and KPI Data with AI

With the scorecard structure and any required custom fields in place, import the actual strategy and KPI content.

AI-assisted migration is the primary approach because real strategy files rarely look like clean import tables. AI can use headings, indentation, descriptions, dates, and surrounding context to map the existing strategy into BSC Designer.

Review the resulting scorecard before using it for ongoing reporting, especially where the source contains ambiguous KPI logic or inconsistent structure.

How to Turn an Excel Strategy File into a Real Scorecard with AI

How to Import the Data with AI

  1. Open the scorecard where the data should be imported.
  2. Switch to the AI tab.
  3. Open the predefined Import data from Excel prompt.
  4. Copy and paste the strategy or KPI data that needs to be imported.
  5. Review the proposed changes and apply them to the scorecard.

AI-Assisted Migration Examples

Time-Based KPI Logic

Examples where the imported strategy includes reporting logic that changes across periods rather than a single static KPI structure.

Actual vs. Planned Values Across Reporting Periods
Turn Excel Cost Tracking into an Automated 'Plan vs. Actual' Scorecard
KPI Sets That Change by Analysis Date
Managing an AI Initiative Portfolio Without Rebuilding the Spreadsheet Every Month
Moving KPI Comments from Excel to Strategy Execution Software
Moving KPI Comments from Excel to Strategy Execution Software

Structure and Measurement Logic

Examples where the source contains technical identifiers, KPI measurement logic, or elements that need to be separated during migration.

Preserving IDs During AI-Assisted Excel Migration
How to Preserve Objective IDs when Migrating Strategy from Excel to BSC Designer
Importing KPI Thresholds and Measurement Logic
How to Handle KPI Thresholds When Importing Strategy from Excel
Separating Outcome KPIs From Strategic Initiatives
From Excel to a Connected Scorecard: Separate Outcome KPIs from Strategic Initiatives

If AI-assisted migration cannot be used—for example, because internal policy restricts AI processing, or because the source is a very large and already structured data set—the standard Excel importer remains available. It supports column mapping, historical KPI values, recurring imports, and saved import profiles. See the Excel import guide.

Step 4. Import Supporting Strategy Documents

Supporting strategy documents can be handled in two ways, depending on whether their content needs to become part of the working scorecard.

Import Controls from the Document

Strategy, risk, governance, and quality documents may contain actual controls that should become part of the working scorecard.

AI can extract control descriptions from Word or PDF documents and place them into the corresponding structure.

The controls can then be connected to the objectives or risks they support and extended with ownership, evidence, and review logic. See the GRC controls example.

Keep the Document as Supporting Material

Some documents do not need to be converted into scorecard elements. They may provide background, evidence, policy context, methodology, or supporting detail.

Upload these documents to the relevant scorecard element so they remain available as supporting material without duplicating their full content inside the scorecard. See the guide to attaching supporting evidence.

How to Turn Vague Governance Requirements into Measurable Controls: AI Governance Example

What Does Not Transfer Directly

Some spreadsheet and document elements belong to the source format rather than to the strategy model and need to be recreated where still relevant.

Source ElementMigration Approach
Excel formulasExcel formulas are not imported directly. Typical KPI calculation logic is already supported natively in BSC Designer; configure the corresponding calculation principle and recreate only organization-specific logic.
MacrosReview the business process behind the macro and determine whether it is still required.
Conditional formattingRecreate the relevant performance states using KPI thresholds and status logic.

The focus of the migration is the strategy structure, KPI data, and management logic rather than recreating the original source visually.

Migration FAQ

Can I Import Historical KPI Values?

Yes. Historical KPI values can be transferred together with their dates and related measurement information so reporting can continue from the existing history rather than starting from the latest value.

Can I Import a Strategy from Word or PDF?

Yes. AI can use textual strategy material from Word or PDF documents to create or populate scorecard elements such as objectives, initiatives, risks, and controls. Documents that only provide supporting context can also remain attached to the relevant scorecard elements.

What Happens to Excel Formulas?

Excel formulas themselves are not imported. Typical KPI logic can normally be implemented using BSC Designer’s native calculation principles for performance, progress, aggregation, targets, and related calculations. Only organization-specific formulas need to be recreated separately. See the calculation principles.

Can We Migrate Without Using AI?

Yes. If AI use is restricted by internal policy, or the source is a large structured data set, use the standard Excel importer. Scorecards can also be configured manually.

Can We Preserve Our Existing Scorecard Structure?

Yes. Existing business-unit, functional, objective, and KPI hierarchies can be reproduced manually or interpreted with AI. When AI creates related scorecards as part of the structure, they are linked automatically. Additional cross-scorecard links can be added manually later where needed.

Can We Correct Import Errors?

AI can make errors. If you notice one, ask the AI assistant to make the required correction directly in the scorecard.

Can We Use the Same Import Process for Regular Updates?

Yes. The import process can be repeated as needed. For example, when additional data becomes available for a KPI, you can import the new data for that KPI with AI. For recurring data updates, consider automating the data connection instead.

Relevant Migration Case Studies

Existing Strategy and Balanced Scorecards

Examples of organizations that already had strategy, objectives, KPIs, or scorecards in spreadsheets and documents and moved them into BSC Designer without rebuilding the strategy from zero.

Implementing an Existing Balanced Scorecard
— Environmental and Disaster Reduction Consultancy

Connecting Operational KPI Scorecards
— East African Port Operator

AI-Assisted Migration

Examples where existing Excel-based objectives and KPIs were interpreted with AI to create the initial scorecard structure before ownership, measurement settings, and governance were added.

Importing Strategy and KPIs With AI
— Financial Organization

From Spreadsheet Monitoring to Connected Scorecards
— Southeast Asian Energy Company

Start with What You Already Have

After migration, you can extend your existing scorecards with strategy cascading, KPI governance, management reviews, and automated reporting. Explore all BSC Designer capabilities.

Want to see the platform in action? Watch a short Balanced Scorecard software demo.

Use one of two paths to move your existing strategy and KPI system into BSC Designer.

Set It Up Yourself

Bring your existing Excel spreadsheet or strategy document into BSC Designer and use AI to reproduce the scorecard structure, transfer the data, and preserve the relevant rationale.

Let Us Prepare the Pilot for You

Send us one representative spreadsheet or strategy document. We’ll recreate it in BSC Designer and prepare a working pilot using your existing structure and data.