Allowed Values Column Checker: check choices by original line

Allowed Values Column Checker: check choices by original line: purpose and instructions

Paste a simple TSV with headers, select one column and enter allowed values to check each row and copy a location report.

How to use

Paste a TSV with headers and select one column.
Enter one allowed value per line, run the check and review original line numbers.

Frequently asked questions

Does an empty cell count as a match?: Zero-character cells are counted separately; whitespace-only values are compared exactly. The copied report excludes values and headers.

Related tools

Shift time worksheet — Calculate working time from start, finish and break minutes, including overnight shifts.
Duplicate table row checker — Find exactly matching TSV rows and retain their original line numbers.
Payment reconciliation worksheet — Match expected and received entries by unique reference and flag discrepancies.
Table transpose — Swap rows and columns in a TSV or CSV table while preserving cell text.
Booklet page order — Plan front and back page numbers for a single folded booklet, including padded blank pages.
Table column masking — Replace selected TSV data columns with fixed text while preserving headers and unselected cells.
Date and time interval — Find the days, hours, minutes and total minutes between two full date-times.
Sequential label generator — Generate labels with a start number, count, increment, zero padding, prefix and suffix.
Box grid capacity — Compare six item orientations and their uniform grid capacities inside a rectangular box.
Task dependency order — Order tasks into dependency stages and check for cycles using task IDs and prerequisites.
Document Date Inventory — Sort recorded dates to help check source documents; this does not determine validity.
Item quantity aggregator — Paste simple TSV to sum matching items and units and trace source lines.
Required fields checker — Paste simple TSV with headers, choose required columns, and copy a report of blank fields by original line.
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.
Equal Reservation Slots Generator — Generate empty slots in a single-day window with a fixed duration and gap.
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.
Double list comparison — Check the scheduled and actual lists, listing items that are only in A, both parties, and only in B.
Batch file name planner — Paste the file name, arrange the prefix, serial number and file extension, and take away the complete comparison table.
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.