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.
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.
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:

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.
The scorecard structure can be created manually or generated with AI from the existing files.
How to Do It with AI
- Open any scorecard in BSC Designer.
- Switch to the AI tab.
- Explain what structure needs to be created—for example, business-unit scorecards, functional scorecards, or the objective hierarchy.
- 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 Import the Data with AI
- Open the scorecard where the data should be imported.
- Switch to the AI tab.
- Open the predefined Import data from Excel prompt.
- Copy and paste the strategy or KPI data that needs to be imported.
- 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.
Structure and Measurement Logic
Examples where the source contains technical identifiers, KPI measurement logic, or elements that need to be separated during migration.
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.
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 Element | Migration Approach |
|---|---|
| Excel formulas | Excel 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. |
| Macros | Review the business process behind the macro and determine whether it is still required. |
| Conditional formatting | Recreate 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.

BSC Designer is strategy execution and performance management software that connects objectives, KPIs, initiatives and risks across teams. It supports the Balanced Scorecard and other management frameworks, helping organizations move from spreadsheets to a connected strategy architecture. Our strategy implementation system provides a practical methodology, while strategy execution capability building helps teams develop the skills and practices needed for execution.
