Required fields checker: find blank required cells by original line

Required fields checker: find blank required cells by original line: purpose and instructions

Paste simple TSV with headers, preview it locally, and choose required columns. Check up to 500 data rows and 20 columns for missing text. Reports contain original line numbers, missing column names, and counts, with no cell values. Data accuracy and consent to contact are not verified.

How to use

Paste simple TSV, confirm the first line contains column names and every line has the same column count, then review the preview. The 500-row limit excludes the header.
Select at least one required column and run the check. Original line numbers match the pasted text: headers are line 1 and the first data row is line 2.
Review the checked row count, affected row count, missing cell count, and missing column names for each line, then copy the report. Editing data or selections requires a new check.

Frequently asked questions

What counts as missing? Will 0, false, or leading zeros change?: Only empty or whitespace-only cells count as missing. 0, false, and 00123 remain filled text; formulas and HTML-like content also display as text. Only selected columns are checked. No passing or copyable report is produced without data rows and a selected required column.
How are blank lines, final newlines, and duplicate headers handled?: One final newline adds no row. Actual blank lines retain their original line numbers and count toward the limit. Every line must match the header width; a bare blank line in a multi-column table blocks the whole table. Blank or identical trimmed headers, inconsistent widths, and exceeded limits cannot produce a passing report.
Can it parse quoted TSV, embedded newlines, or connect to spreadsheets?: No. This version separates columns by tabs and rows by newlines. Quotes are literal text. Quoted TSV, embedded tabs or newlines, and merged cells are unsupported. It does not connect to spreadsheets, fill values, or delete rows. Confirm the source is simple TSV; not every unsupported format can be detected automatically.
Will the list be uploaded, saved, or included in the copied report?: Input and results stay in page memory. They are not uploaded or written to URLs, persistent storage, or logs. Clearing, leaving the tool, and reloading erase them. Reports contain only rules, selected column names, original line numbers, missing column names, and counts, never cell values. Headers do enter reports, so confirm the first line has no private information before copying.

Related tools

Group availability intersection finder — Merge each person's same-day availability and find shared intervals plus possible start ranges that fit the meeting length.
Serial Number Gap Checker — Check one number per line against a fixed-width range to find gaps, duplicates, out-of-range entries and format errors.
Inventory reconciliation — Check the book and actual quantity according to the product number, and list the shortages, surpluses and items to be reviewed.
Booking conflict checker — Check overlapping time periods for appointments with the same resource and on the same day, and retain the original sequence numbers for manual coordination.
Time zone meeting planner — Use Taipei time to compare with Tokyo, London and Los Angeles to check the complete date and daylight saving time.
Working days and deadlines — Calculate the interval days or delivery date according to the selected work rules.
Amount and date conversion — The amount, Republic of China and AD dates in Chinese capital letters, copy them as you like.
URL QR code generator — Check the complete public URL, generate a black and white QR Code in the browser and download the PNG.
List sorting and deduplication — Organize multi-line lists, items or codes and remove blank lines and duplicate items.
Double list comparison — Check the scheduled and actual lists, listing items that are only in A, both parties, and only in B.
Text version differences — Compare the two versions of the notice or process text line by line, and list the identical, new and deleted content.
Batch file name planner — Paste the file name, arrange the prefix, serial number and file extension, and take away the complete comparison table.
Meeting agenda schedule — Fill in the start time and topic minutes, and list the start and end time of each item and the complete agenda.
Random grouper — Paste the list of participants, specify the number of groups, and arrange random groups with a balanced number of people.
Countdown to work and meetings — Set a period of time, start, pause and continue the countdown, and clearly grasp the time.
Duty roster — Arrange the rotation according to the date, week and personnel order, and check the complete arrangement and the number of times per person.
StarShare cross-device file transfer — Transfer files, text and links between mobile phones and computers without installation or login.