Spreadsheets and data

Free Missing Data Report Generator.

Missingness by field and affected records.

Measure completeness in the table you are reviewing and identify the fields that need follow-up before analysis.

Chrome extension + account required.
25 free automation tasks/month across tools. Browser-provider limits apply.

WHAT TO HAVE READY

Table and required fields.

YOUR STARTING POINT

A task you can make yours.

Copy it here. Paste it into WebAct when you are ready.

This page prepares your prompt. The task runs in WebAct.

01

Make the task yours.

Review the prompt above. Add your goal and any requirements that matter.

02

Bring it to WebAct.

Open WebAct, paste the task and provide your source material. Start in Chat for a draft or explanation; use Task when you want an approved browser action or file.

03

Check the useful part.

Check formulas, code and calculations against known inputs in the appropriate runtime. Review actions before execution and keep the original data available.

A PRACTICAL GUIDE

How to use the Missing Data Report Generator.

Missingness has several forms: blank, null, placeholder and unavailable. Define which values count as missing before summarizing coverage.

Make the workflow fit your task.

Define missing values separately for each field, including empty strings, nulls and agreed placeholders. Count missing records and show percentages with denominators. Break down affected groups when useful, without assuming that missingness means zero or a negative answer.

What you provide
Table and required fields.
What you get
Missingness by field and affected records.

See the input and the result.

Illustrative input and output · a teaching example, not a live WebAct run

Example input

Email values are blank, unknown and alex@example.com; unknown counts as missing.

Completed example

Two of three records have missing email information under the stated rule.
Download this example

Load this input into the prompt, then copy it to WebAct to try the task. Your result may differ from the illustration.

Decisions and troubleshooting.

Should zero count as missing in a coverage report?

Only when the field definition explicitly uses zero as a missing-value code. Otherwise it may be a valid observation.

Why is the missing percentage unexpectedly low?

Check whitespace-only strings and placeholder spellings. Also confirm whether the denominator includes filtered or excluded records.

Try it with your own source.

Replace the example with your material in the task prompt. Keep the requirements you need, then copy the task into WebAct.

Customize and copy the task ↑
BEFORE YOU BEGIN

Using WebAct.

The prompt and example are available here. Run your task in the WebAct Chrome extension.

Is this tool free?

You can copy and edit the prompt here for free. To use it with WebAct, install the Chrome extension, create and verify your account, and connect an available browser ChatGPT session. The Free plan includes 25 user-started automation tasks per calendar month, shared across tools. Ordinary browser Chat is separate; provider limits apply.

Learn about shared context in our privacy policy and choosing Chat or Task.

FROM A PROMPT TO YOUR OWN WORK

Bring the task to your page.

Install WebAct, add your source material and make the result yours.

Install WebAct