Export OKRs from Viva Goals and Teams: what to do now
Viva Goals, including its Teams app, closed on 31 December 2025, so you can no longer export from it. Find the Excel, CSV or JSON export your admin took before then, or rebuild one from PowerPoint decks and reports, clean it into one row per objective, key result and initiative, and import that sheet into your next tool.
Milestra team · 26 October 2026 · 6 min read
What changed when Viva Goals closed
Microsoft announced in December 2024 that Viva Goals would be retired. Users kept access to the service and their data until 31 December 2025, or until their licence expired if that came first. After that date Viva Goals, and the Viva Goals app inside Microsoft Teams, stopped working.
Before the shutdown Microsoft pointed customers to three ways of getting data out:
- Excel and PowerPoint exports from the Viva Goals interface, for lists of OKRs and for presentation views.
- An admin data export from the Export tab of the admin dashboard, added in mid-2025, which produced CSV or JSON files for the whole organisation.
- The Microsoft Graph API, where an export job could produce a file from an Explorer view. It needed admin consent and a specific permission.
So the question today is not how to export from Viva Goals, because that is no longer possible. It is where your export is, and what to do with it.
Step 1: Find the export you already have
Most organisations that ran OKRs in Viva Goals took at least one export, often without telling everyone. Check, in this order:
- Your Microsoft 365 administrator or IT team. The admin export and any API export would have been run by them. Ask for the files and the date they were taken.
- The OKR programme owner. Whoever ran quarterly planning often kept an Excel export at the end of each quarter.
- SharePoint, OneDrive and Teams channels where leadership or planning meetings were held. Search for files with "Viva Goals", "OKR" or "Goals export" in the name.
- Board packs and quarterly review decks. PowerPoint exports are often attached to meeting invites or saved alongside minutes.
Keep the original files untouched in one folder. They are your record of the old system and, for some organisations, part of the audit trail.
Step 2: If there is no export, rebuild the current set
If nothing turns up, do not try to recreate years of history. Rebuild only what you need to keep working:
- This period's objectives and key results, from the last PowerPoint deck, board report or planning document.
- The latest value of each key result, from the last check-in or report.
- Owners, by name or email.
Most teams can rebuild a quarter's OKRs for one department in an hour. History you cannot recover is better recorded as a short note ("Q1–Q3 2025 results reported in board packs") than guessed.
Step 3: Clean the export into one standard sheet
Viva Goals exports, and most OKR tool exports, use one row per item, with a column saying whether the row is an objective, key result or initiative. That shape is easy to import anywhere once it is tidy. Aim for these columns:
| Column | What goes in it | Example |
|---|---|---|
| Type | Objective, Key result or Initiative | Key result |
| Title | The wording of the item | Raise monthly donors from 400 to 600 |
| Parent | The title of the objective it belongs to | Grow sustainable income |
| Owner | Email address, or full name | a.mensah@example.org |
| Start | The starting value for key results | 400 |
| Current | The latest value | 470 |
| Target | The target value | 600 |
| Due date | When the item is due | 2026-12-31 |
Then tidy the content:
- Remove closed periods you do not need in the new tool. Archive them in the original file instead.
- Use email addresses for owners where you can. Names are spelled differently in different exports; emails match people reliably.
- Check every key result has a number. Some key results may have been tracked as milestones or as a percentage complete rather than a metric. Decide on a start and target value, or turn the item into an initiative.
- Make parent titles match exactly. A key result whose parent is "Grow sustainable income " (with a trailing space) will not attach to "Grow sustainable income".
- Save as CSV if your next tool does not accept Excel files, or copy the rows and paste them.
Step 4: Choose where your OKRs live next
There are three sensible options, depending on how many people update OKRs and who reads the results.
| Option | Works well when | Watch out for |
|---|---|---|
| Keep them in Excel or Google Sheets | One team, a handful of objectives, one person updating | Versions multiply, no reminders, reports built by hand |
| Another OKR tool | Several teams update weekly and leadership wants roll-ups | Check it can import your sheet without retyping |
| A results tool linked to reporting | You also report to a board or funders | Make sure indicators, evidence and reports come from the same numbers |
Whatever you choose, test it with the cleaned sheet before you commit: import one department, run one weekly check-in, and produce one report. If any step needs a workaround, you will find out in a week rather than a quarter.
Milestra imports this sheet directly: rows with a Type column are grouped automatically, key results keep their start, current and target values, initiatives become action steps, and owners are matched by email or name. The Viva Goals alternative page shows how each part maps.
Step 5: Restart the weekly rhythm straight away
The biggest risk in any OKR migration is not lost data. It is the six weeks after the move when nobody updates anything. To avoid it:
- Announce one date when the new tool becomes the place OKRs live, and stop updating the old copies.
- Run the first check-in in the same week. Each owner updates their key results and rates confidence. See how to run weekly check-ins.
- Review the first month's data at the next leadership or programme meeting, so people see the numbers being used.
Common mistakes
- Waiting for a perfect history. You need this quarter's OKRs to keep working, not every past check-in.
- Importing everything at once. Start with one department, fix the sheet, then import the rest.
- Matching owners by name. "Akosua Mensah" and "A. Mensah" are two people to an import tool. Use emails.
- Dropping the Teams habit without a replacement. If people were reminded to update OKRs inside Teams, set up email, Slack or calendar reminders in the new tool before the first check-in.
Frequently asked questions
Can I still export my OKRs from Viva Goals or Microsoft Teams?
No. Viva Goals and its Teams app stopped working on 31 December 2025, or earlier for organisations whose licence expired first. Ask your Microsoft 365 administrator whether an Excel, CSV, JSON or API export was taken before then.
What format were Viva Goals exports in?
Users could export to Excel and PowerPoint, and administrators could export the whole organisation's data as CSV or JSON from the admin dashboard. The Microsoft Graph API also offered export jobs for Explorer views.
Can Microsoft recover our Viva Goals data now?
Microsoft has not published a recovery route after the retirement date. Your Microsoft account team or administrator is the right contact to ask; in the meantime, rebuild the current period's OKRs from decks and reports so work does not stop.
What columns does an OKR import file need?
At minimum: Type, Title, Parent and Owner. For key results add Start, Current and Target so progress carries over, and a due date if you track one. One row per objective, key result or initiative is the most widely accepted shape.
Is Excel good enough to replace Viva Goals?
For one team with a few objectives, yes. Once several teams update weekly and leadership wants roll-ups or board reports, a shared tool saves time. See how to track OKRs in Excel for a workable spreadsheet setup.
Sources and further reading
- Viva Goals retirement FAQ · Microsoft Learn
- Create goalsExportJob (Microsoft Graph API) · Microsoft Learn
Try Milestra for free
Put this guide into practice in 10 minutes
- Goals, key results and indicators in one place
- Two-minute weekly check-ins with reminders
- Donor and board reports from live numbers
- Free for up to 5 people · 50% off for nonprofits