Skip to content

Review access offline with a spreadsheet

Some reviewers have hundreds of items to review, or need to work away from the app. If your organisation has turned on offline review sheets, you can download your open items in a campaign as a spreadsheet, decide there, and upload it. Every decision goes through the same rules as a decision made in the app.

For administrators: turn it on

Open Platform Config β†’ Governance Settings, choose the Certifications tab and, in Offline Review Sheets, tick Let reviewers decide in a spreadsheet, then save. It is off until you do.

The controls in Reviewer Accountability Controls apply to uploaded decisions exactly as they do online:

  • Justification policy β€” rows that need a justification and do not have one are not applied.
  • Block self-certification β€” a reviewer’s own access cannot be certified from a sheet either.
  • Bulk certification guardrail β€” with Require a justification note, every Certify row needs one; with Forbid bulk certification, a sheet may certify one item only.

Every download and every applied upload is recorded in the audit trail; a preview changes nothing and is not recorded. The uploaded file itself is never stored.

For reviewers: review offline

  1. Open the campaign and go to the Items tab. In Review Offline, click Download Sheet.
  2. Open the file in your spreadsheet program. Each row is one item, with the person, the access, its risk, how many of their peers have it, when it was last used and when it was granted.
  3. In the Decision column, write Certify, Revoke or Escalate β€” or leave it blank to decide later. Add a Justification where your organisation requires one (Revoke usually does).
  4. Save the file as CSV UTF-8 β€” in Excel: File β†’ Save As β†’ CSV UTF-8; in Numbers: File β†’ Export To β†’ CSV (Numbers’ Save keeps a separate Numbers copy and leaves the downloaded file unchanged β€” upload the exported one).
  5. Back in Review Offline, click Upload Decisions. You see what would happen β€” how many items will be certified, revoked and escalated, how many you left blank, and every row that will not be applied, with the reason. Nothing has changed yet.
  6. Click Apply Decisions.

You can upload the same sheet again at any time β€” items already decided are simply skipped. Rows left blank stay open for you to decide online or in a later sheet.

Rows that are not applied

You see What to do
Not from your sheet for this campaign Use the sheet you downloaded yourself, for this campaign. Sheets cannot be shared.
More than 30 days old Download a fresh sheet β€” the risk and usage details in an old one may have changed.
Already decided, reassigned, moved to another stage, or the campaign has closed Nothing to do β€” the item is no longer yours to decide.
Decision must be Certify, Revoke, Escalate, or blank Fix the spelling in the Decision column.
Your organisation requires a justification Add a justification in that row.
The same item appears on more than one row Keep one row for the item and delete the others.
You cannot certify your own access Ask the campaign owner to reassign the item.
Your organisation allows certifying one item at a time Certify these items in the app.

If the upload is refused

  • β€œThe file is not UTF-8 text” β€” save it again as CSV UTF-8, not plain CSV.
  • β€œNo decisions found” β€” every Decision cell in the uploaded file is blank. Usually the edits were saved somewhere else: in Numbers, export with File β†’ Export To β†’ CSV and upload that file.
  • β€œThis is not a review sheet” β€” the row token or Decision column was removed. Download a fresh sheet.
  • β€œThe file is larger than 2 MB” β€” delete the context columns you do not need (keep the row token, Decision and Justification columns).

Β© AtmanID Β· Privacy