EDITABLE WORKBOOK + COMPLETE GUIDE

Website content audit workbook
for public-service teams.

Turn a content inventory into a clear review and upkeep plan. Download the editable workbook, use the blank sheets for your own records and follow the worked example below.

No sign-in or email required. No macros, uploads or automatic publishing.

MAKE THE REVIEW ACTIONABLE

Know what exists,
who owns it and what needs attention.

An audit is useful when it leads to a specific next action. This workbook helps a public-service team inventory pages, documents, forms and events, check service facts against authoritative sources, and assign the work that follows. It suits a focused upkeep review or the content planning before a website redesign.

Start with important resident tasks: finding hours, preparing an application, understanding a fee, locating a meeting or reaching the right service. Include the documents and forms those pages depend on. A tidy page can still lead to an outdated attachment, so review the whole path.

Content audit

A blank inventory with stable IDs, responsible departments, user tasks, decisions, action owners and future checks.

Fact checks

A separate record for each claim, its authoritative source, the reviewer and every place affected by a correction.

Guide and example

Instructions, a field dictionary and a clearly fictional Cedar Bay example. Working sheets stay blank for your own records.

A PRACTICAL REVIEW PROCESS

From inventory to an owned change.

  1. Define the scope. Choose departments, service paths or content types. Record the exact URL or reference and a unique Content ID for each item. Include public documents, forms and event information; avoid putting sensitive resident records in the inventory.
  2. Describe the user task. Say what someone needs to understand or do. Note unclear instructions, broken links, missing effective dates and inaccessible formats as specific findings. Assign a content owner and reviewer.
  3. Verify the facts. Give each check a unique Fact ID and matching Content ID. Compare the claim with the responsible department’s source. Record the version or known source date, checker, check date and affected locations. “Cannot confirm” is useful information; it is not a verified result.
  4. Choose and authorize the next action. Keep, update, merge or send content for removal review. Record a merge destination, action owner and due date. A proposed removal remains subject to your organization’s records retention rules and authorized review.
  5. Record the result and next check. Move work through review, record evidence before marking Done, and set a next review date. A new policy, hours memo, form, service owner or source version can trigger an earlier check.

Use an evidence reference that your team can actually find: a controlled review record, approval reference, corrected live URL or documented comparison. This template records the review; it does not certify accessibility or replace specialist testing.

FICTIONAL WORKED EXAMPLE

A small change can affect several channels.

Cedar Bay is fictional. This example is not a client project or a record of completed work.

Content ID CB-W001 refers to /library. The page says Saturday opening is 9 AM. A fictional Hours Memo v2 says 10 AM from January 9, 2027. The reviewer records the upcoming change on December 15, 2026 and checks both the website and a social draft.

Decision and deadline
Update; due December 18, 2026
Recorded status
Awaiting review
Verification evidence
Blank: completion is unknown
Next review
January 8, 2027

Confirm the effective date and approve wording for the future change. Do not describe 10 AM as current hours before January 9. Keep the website and social draft consistent, then record the review and live-change evidence.

The workbook includes this example on Guide and example, away from the blank inventory. Its source date is left blank because the example supplies a version and service effective date, not a memo publication date.

READ THE FLAGS IN CONTEXT

Unknown information stays visible.

Calculated review flags identify duplicate or unmatched IDs, missing owners, overdue actions, unresolved fact checks, missing evidence for Done, and a removal review without an authorization reference. A blank row produces no status. The workbook does not invent a quality score or treat an empty cell as success.

Use the dropdowns for decisions, priority and workflow status. Enter real dates, rather than strings that only look like dates. Keep the calculated columns intact and increase row heights for longer notes. Each working sheet has 200 prepared rows, filters and frozen headers. For a larger inventory, update all linked formula ranges, validation and filters before extending the prepared area.

Open the file in an Excel-compatible application with automatic calculation enabled. If you import it into another application, check dates, dropdowns and formulas before relying on the flags. Keep your internal workbook in your organization’s approved storage; it stays in your control and is not uploaded to Civicfield Systems.

EVERY FIELD HAS A PURPOSE

Workbook field dictionary.

Open a sheet’s dictionary to see what to enter. Blank means unknown; use a source version and/or a known source date.

Content audit: field dictionary
Content ID
Unique stable ID; link every fact check to this ID.
URL / reference
Exact page URL, document path, form or event reference.
Title
Current content title.
Type
Choose the kind of content.
Department
Responsible department or team.
User task
What the visitor needs to understand or do.
Content owner
Named role or person responsible for keeping the content accurate.
Reviewer
Person or role reviewing this content.
Review date
Date of this review.
Findings
Specific observed issues; distinguish facts from suggestions.
Priority
Team-selected urgency, not an automatic quality score.
Decision
Removal remains subject to retention rules and approval.
Merge destination
Destination ID or URL when proposing a merge.
Action owner
Person or role assigned the next change.
Due date
Agreed action deadline.
Status
Recorded workflow state; Done requires verification evidence.
Authorization reference
Approval/retention reference for a removal review or other controlled change.
Verification evidence
Reference to review or live-change evidence; required for Done.
Next review date
Planned future factual/content check.
Change trigger
Events that require earlier review, such as hours, policy or source changes.
Fact checks: field dictionary
Fact ID
Unique fact-check record ID.
Content ID
Must match a Content ID on Content audit.
Claim
Exact factual statement being checked.
Authoritative source
Reference to the responsible source, not a search-result summary.
Source version
Version or edition; use this and/or a known source date.
Source date
Known date of the source; leave unknown dates blank.
Checker
Person or role that verified the claim.
Check date
When the source was checked.
Outcome
Record mismatch or uncertainty without treating it as verified.
Affected locations
Every website, document or channel draft needing the same correction.
Correction / follow-up
Required correction, escalation or recheck.

Calculated columns

Review flags list recorded gaps. Verified content ID links a complete, matching-source fact check to its content item. A match requires a unique fact ID, an unambiguous linked content ID, claim, source/version or source date, checker/date and affected locations. These formulas support your review; they do not authorize changes.

TRY A SMALL MIGRATION MAP

Find the gaps before pages move.

Record an old URL, proposed destination, owner role, content decision and review date. Check for duplicates, shared destinations and missing decisions before your team agrees on a migration plan.

Your notes stay in this tab. No crawl, upload, saving or automatic changes. Reload clears them. Use public paths and role names; keep personal records, credentials and confidential details out. Flags identify recorded gaps, not verified content or approved redirects.

Actual migration checker result detail showing duplicate URLs, shared destinations and a missing owner in fictional sample notes.
Owned migration checker result detail with fictional notes. Flags describe recorded gaps and require human review.

Blank visitor notes. No example loaded.

Only used to flag recorded review dates later than this date. It does not establish when a page was last verified.

Loading checker…

Run checks to review your notes. Up to 50 rows, 500 characters per field. Paths, query strings and case are preserved for matching; URL fragments are ignored and flagged.

    Several old URLs may intentionally lead to one destination. Review a shared destination before treating it as a collision. Removal is always a proposal for authorized retention and archival review. CSV cells are quoted and formula starters are neutralized; review the exported file in your spreadsheet application.

    COMMON QUESTIONS

    Before you start.

    Can we use it before a website migration?

    Yes. Inventory important pages and documents, agree on owners and decisions, and carry the useful IDs into migration planning. Add redirects, permissions and acceptance checks to your project scope separately.

    Does “Review for removal” mean we should delete the page?

    No. It records a proposal for authorized review. Confirm retention, archival, public-records and approval requirements with the responsible people before a removal action. Preserve an authorization reference.

    Does the workbook check the website automatically?

    No. Your reviewers supply the findings and evidence. The formulas identify recorded gaps and linked records; they do not crawl pages or verify external sources.

    Do we need to share the completed workbook?

    No. Download and edit it within your own approved storage. There is no email gate or upload form. You can discuss the scope of a review by email without sending confidential material.

    REFERENCE GUIDANCE

    Useful places to continue.

    Georgia’s Content Tools (opens in a new tab) provides resources for planning and managing web content, including an inventory template. Iowa’s Auditing Content guide (opens in a new tab) explains practical review fields, responsibilities and ways to prioritize an audit.

    This Civicfield workbook is an original template informed by those general practices. It is not an official state template or an endorsement. Map the operational work behind a service page with the service request workflow workbook. Pair the inventory with the public-service content calendar when a factual change also affects email or social drafts.

    Choose review triggers before assigning a calendar date.

    Content conditionTrigger or priorityReview evidence
    Time-sensitive actionBefore the deadline or occurrence and on a source changeFull date, timezone, availability and current next action.
    Consequential service ruleOn policy change and a justified planned checkAuthorized fact owner and approved revision.
    Frequently changing detailsOn operating change and a capacity-based intervalHours, location, contact and linked destination checked.
    Stable explanationPlanned review based on use and consequenceSource still supports the answer; owner remains assigned.
    Historic recordAgency-approved records and access processStatus, provenance and access route, without unauthorized alteration.

    Record why the next check is due and who will perform it. Unknown ownership is itself an action, not a reason to assign a distant date. The table is a proposed prioritization model, not a statutory retention or review schedule.

    Use the existing owner, source-check, action and review fields in the workbook. Document the risk rationale in the appropriate notes; no new automated scheduling is implied. A check completed with no change should record the actual source inspected. Do not advance a public “updated” date merely because a row was touched.

    Connect the priority to content governance and the source-verification worksheet.

    CONTENT REVIEW & UPKEEP

    Bring the content.
    Let’s plan the upkeep.

    Discuss a focused content review, named ownership or ongoing upkeep. Share your public website and the service paths you want to improve. Keep confidential records and credentials out of the project notes.

    Check contact availability

    Project inquiries are currently unavailable.