data-quality-sweep SKILL.md skillA

data-quality-sweep from kesslernity/awesome-copilot-office-skills is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add kesslernity/awesome-copilot-office-skills/data-quality-sweep@git:20261024.9aa8eaa

Pins git:20261024.9aa8eaa in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
kesslernity/awesome-copilot-office-skills
Path
skills/data-quality-sweep/SKILL.md
Versions recorded
2
Latest version
git:20261024.9aa8eaa, committed Oct 24, 2026
First version recorded
Oct 24, 2026
Size
5,334 bytes
Repository stars
8
License
CC-BY-SA-4.0

Sweeps a data range in the open workbook for conditions that break reporting: mixed types in a column, numbers and dates stored as text, duplicates on the apparent key, inconsistent category spellings, out of range values, blanks that are meaningful, and inconsistent date formats. Corrects nothing. Use when the user asks to check data quality, find problems in a dataset, or audit a table before analysis.

Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.

What the file says

# Data quality sweep

## Purpose

Report what is wrong with a table before anybody builds on it. The skill profiles each column, names the conditions that will distort a pivot, a chart or a total, and quantifies how much of the data each one affects. It corrects nothing, because the fix for a blank depends on what the blank means and only the owner knows that.

## When to use

- The user asks to check data quality, profile a dataset or audit a table before analysis.
- A pivot, chart or total has produced a result that looks wrong and the data is suspected.
- Do not use to clean the data. If the host offers a data-cleaning skill or tool, use that for fixes. This one reports and quantifies, and it stops there.

## Inputs

1. The open workbook (required), and the range or table to sweep.
2. Expected schema (optional): column names with their intended type and any valid value list. If supplied, check against it.
3. Key columns (optional): the columns that should identify a row uniquely.

## Procedure

1. Establish the range: header row, first and last data row, and column count. State what was taken as the header.
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add kesslernity/awesome-copilot-office-skills/data-quality-sweep@sha256:66ba1bec58927728

The line at the top of this page pins the label git:20261024.9aa8eaa, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_z74ekgvhhriqzkof.svg)](https://markdownregistry.com/a/art_z74ekgvhhriqzkof)

3 badge image fetches in 30 days. What the badge shows.

Versions

The registry has recorded 2 versions of this file, all committed on Oct 24, 2026.

versioncommittedcommitsizeaudit
git:20261024.9aa8eaa latest2026-10-24 9aa8eaa 5,334 BA view · diff
git:20261024.a411dc22026-10-24 a411dc2 5,307 BA view

Audit of the latest version

A  17 of 17 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (5334 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No curl or wget piped into a shell
  • pass: No recursive delete of root, home or parent
  • pass: No instruction to read or print local credentials
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

kesslernity/awesome-copilot-office-skills · 8 stars · license CC-BY-SA-4.0 · pushed 2026-10-25 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_z74ekgvhhriqzkof
GET https://markdownregistry.com/api/v1/resolve?ref=kesslernity/awesome-copilot-office-skills/data-quality-sweep
GET https://markdownregistry.com/api/v1/blob/66ba1bec58927728022517f5f0acdff4b6f3c62f2fa7b2e9881bfad3cf7c35c3

Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.

More from kesslernity/awesome-copilot-office-skills

accessibility-pass SKILL.md skill
kesslernity/awesome-copilot-office-skills · skills/accessibility-pass/SKILL.md · Reviews the open presentation for accessibility issues (missing or duplicate slide titles, missing alt text, reading…
git:20261024.a411dc2 · audit A · 8 stars
action-title-rewrite SKILL.md skill
kesslernity/awesome-copilot-office-skills · skills/action-title-rewrite/SKILL.md · Reviews every slide title in the open presentation and proposes action titles that state each slide's message as a full…
git:20261024.a411dc2 · audit A · 8 stars
ai-writing-tells-check SKILL.md skill
kesslernity/awesome-copilot-office-skills · skills/ai-writing-tells-check/SKILL.md · Finds the patterns that make slide text read as machine-written (filler openers, inflated verbs, groups of three, em…
git:20261025.7203ae2 · audit A · 8 stars
appendix-split SKILL.md skill
kesslernity/awesome-copilot-office-skills · skills/appendix-split/SKILL.md · Separates the deck that gets presented from the detail that answers questions, by proposing which slides move to an…
git:20261024.9aa8eaa · audit A · 8 stars
assumptions-register SKILL.md skill
kesslernity/awesome-copilot-office-skills · skills/assumptions-register/SKILL.md · Finds every hardcoded input in the open workbook, separates genuine assumptions from calculated cells, and builds a…
git:20261024.a411dc2 · audit A · 8 stars
brand-rules-check SKILL.md skill
kesslernity/awesome-copilot-office-skills · skills/brand-rules-check/SKILL.md · Checks every slide of the open presentation against written brand rules (colours with hex codes, fonts, logo use…
git:20261024.9aa8eaa · audit A · 8 stars
chart-intent-check SKILL.md skill
kesslernity/awesome-copilot-office-skills · skills/chart-intent-check/SKILL.md · Checks every chart in the open workbook against what its title and labels claim: truncated or inverted axes…
git:20261024.a411dc2 · audit A · 8 stars
decision-slide SKILL.md skill
kesslernity/awesome-copilot-office-skills · skills/decision-slide/SKILL.md · Builds one decision slide that sets out the question, the options, the criteria, a comparison, the recommended option…
git:20261024.a411dc2 · audit A · 8 stars
deck-consistency-sweep SKILL.md skill
kesslernity/awesome-copilot-office-skills · skills/deck-consistency-sweep/SKILL.md · Sweeps the open presentation for the inconsistencies a reader notices and an author stops seeing: a term used two ways…
git:20261024.a411dc2 · audit A · 8 stars
deck-message-review SKILL.md skill
kesslernity/awesome-copilot-office-skills · skills/deck-message-review/SKILL.md · Reads a whole deck and reports whether it carries one message, whether the slides support it in order, and whether it…
git:20261025.7203ae2 · audit A · 8 stars
deck-trim-proposal SKILL.md skill
kesslernity/awesome-copilot-office-skills · skills/deck-trim-proposal/SKILL.md · Proposes which slides to cut, merge or move to an appendix so a deck fits its slot and its argument, using repetition…
git:20261024.9aa8eaa · audit A · 8 stars
executive-summary-slide SKILL.md skill
kesslernity/awesome-copilot-office-skills · skills/executive-summary-slide/SKILL.md · Reads the whole open presentation and drafts one executive summary slide of three to five points, each traced to the…
git:20261024.a411dc2 · audit A · 8 stars

Every file in kesslernity/awesome-copilot-office-skills

Browse by kind, by grade A, or by owner.