Table column masking: purpose and instructions
Replace selected TSV data columns with fixed text while preserving headers and unselected cells. Calculate locally and copy the result; inputs are not saved automatically.
How to use
The first row contains headers; data starts on the second row. Column numbers start at 1. Selected blank cells are also replaced. Personal data is not detected automatically: review headers and unselected columns before sharing. Maximum 200 rows, 200 columns and 10,000 cells. Enter your data, generate results, then check before copying. Frequently asked questions
Is data saved or uploaded? Inputs are processed in browser memory on this page and cleared on refresh or departure.
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 pasted TSV table, preserving spaces and empty cells.Booklet page order — Plan front and back page numbers for a single folded booklet, including padded blank pages.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.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.