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
- Open the campaign and go to the Items tab. In Review Offline, click Download Sheet.
- 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.
- 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).
- 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).
- 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.
- 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).
Related
- Launch a certification campaign
- Navigate the audit trail β find
CERT_WORKSHEET_DOWNLOADEDandCERT_WORKSHEET_APPLIEDentries
Β© AtmanID Β· Privacy