How to see who changed a Confluence spreadsheet and restore an earlier version

By Jake Marsh · Updated

To see who changed a spreadsheet on a Confluence page and go back to an earlier state, click History in the Sheetkeep spreadsheet's toolbar. Every save is listed with the person who made it and when. Click one to preview it, then Restore this version. The restore becomes a new version, so it can be undone too, and the rest of the page stays as it is.

Why not use page history?

Confluence keeps versions of the whole page. Restoring one brings back every paragraph, heading and table on the page as they were then, so fixing one bad edit to a table also throws away any text written since. It also only records a new version when someone publishes the page.

A Sheetkeep spreadsheet has a history of its own, separate from the page. It gets a new version each time someone stops typing for about a second, and restoring one changes only the spreadsheet.

Steps

  1. Open the page with the spreadsheet. You don't need to click Edit.
  2. Click History in the spreadsheet's toolbar. The panel lists saves newest first, each marked Saved, Merged, Restored, Imported or Copied, with a name and time.
  3. Click a version to preview it in the panel.
  4. Click Restore this version. The spreadsheet shows "Restored, now version N".
  5. Changed your mind? Open History again and restore the version just before the restore.

Only people who can edit the page see Restore this version. Anyone who can view the page can open History and click Download as XLSX on any version.

Name the versions that matter

Under the preview, type a name such as "Signed off" or "Q3 final" and click Save name. Named versions are kept forever, however old they get, which makes them a record of what was agreed at a point in time.

How long versions are kept

AgeWhat's kept
Last 30 daysEvery version
30 days to a yearThe last version of each hour
Older than a yearThe last version of each day
AlwaysNamed versions, the first version, every restore and import, and the version each restore replaced

When two people saved close together

If someone else saved after you opened the page, your save is merged with theirs and listed as Merged. Changes to different cells are both kept. When you both changed the same cell, Sheetkeep shows a table with your value and theirs, with Keep all of mine and a button to keep all of theirs, and saves nothing until you click Save my choices. Both saves are in History either way.

What it costs

Sheetkeep is $13.80 a month for up to 10 users, or $138 a year, then $1.38 per user a month from 11 users, with lower rates for larger sites. Atlassian bills it, with a 30-day free trial. Plans, limits and the install link are on the Sheetkeep page.

Sheetkeep: Spreadsheets for Confluence

Spreadsheets on Confluence pages that keep every version: formulas, sheets, Excel import and export, and one-click restore. From $13.80 a month for up to 10 users.


Questions

Can I see exactly which cells changed between two versions?

Not as a highlighted diff. Preview the two versions in History, or download both as XLSX and compare them in Excel.

Can someone who only views the page restore a version?

No. Viewers can open History, preview versions and download them. Restoring and naming need permission to edit the page.

Does restoring a version change the page text?

No. It replaces the spreadsheet's contents only. Text, images and other macros on the page stay as they are.

What if the browser closed before my last edit saved?

Unsaved edits are kept in that browser. Reopen the page there and click Restore them on the yellow bar.

What if the whole page was deleted?

The spreadsheet and its history stay. A space admin can find it under Space settings > Sheetkeep spreadsheets, marked recoverable, and download it or copy it into a new spreadsheet.


More Sheetkeep guides


More Confluence guides