# Data Lineage for Personal Data: Show a Column Was Masked

> Use data lineage to show which personal data columns were masked, converted or filtered before a file was shared. Free, in your browser, with no upload.

Page: https://datautility.in/blog/data-lineage-for-personal-data-masking-proof
This is the Markdown copy of the page. The tool itself runs in the browser: your files are processed on your own device and are not uploaded.

Published 2026-11-15 · Analyze & protect · data lineage gdpr, pii masking audit trail, prove data was masked, personal data lineage, data masking record, data lineage for audits, anonymization audit trail

Before you share a file, you may need to show what was done to the personal data in it. Lineage gives you that record.

Open the tool: [Data Lineage](https://datautility.in/data-lineage)

Short answer: when you mask a file in Data Utility, the step is recorded with the columns it handled and the settings used. Data Lineage then lets you follow a column such as email through every step, and download a report that shows the chain. It supports your own records. It is not legal advice and does not by itself make a file compliant.

## Why record what happened to personal data

Teams are often asked later: was the phone number removed, was the name hashed, which version went to the vendor? Without a record the honest answer is "I think so". A lineage turns that into something you can show.

## What the lineage shows

- The input file and where it came from.

- Each masking step and its settings, for example which columns were masked and how.

- The output file and its row count.

- Which columns were kept, changed, added or dropped at every step.

## The personal data check

On the latest file, Data Lineage lists columns whose names look personal, such as email, phone or name, and shows whether a masking step handled them. This is a guess from column names only. Values are never read, and a column with an unusual name may be missed. Treat it as a prompt to check, not a guarantee.

## How to document a masking step

- Open Data Masking and choose the columns and the method for each.

- Download the result or save it.

- Open Data Lineage, select the lineage and click the masking step to see what was done.

- Follow a column to confirm it was masked before any later step.

- Download Result + lineage to keep the report next to the file you share.

## Limits to keep in mind

- Only work done in Data Utility is recorded.

- Lineage records what was done. It does not tell you whether the masking is strong enough for your rules.

- History is stored in your browser. Download the report to keep it.

- No user accounts: it does not record who did the step.

## How to use the Data Lineage: step by step

1. Mask the file in Data Masking and save the result.
2. Open Data Lineage and select the lineage.
3. Follow a personal data column through the steps.
4. Download Result + lineage.

## When to use the Data Lineage

- Show which columns were masked before sharing
- Keep a record of anonymization for a review
- Check that a later step did not add personal data back
- Send a vendor a file with its masking history

## Example

Input:

```
customers.csv → Data Masking → Format Converter
```

Output:

```
customers.json + LINEAGE.html (input → transformations → result)
```

## Frequently asked questions

### Does data lineage make my file GDPR compliant?
No. It gives you a record of what was done to the file. Whether that meets your obligations is for you and your advisers to judge.

### Does it read the values in my file?
The personal data check looks at column names only, never at the values.

### Is my data uploaded?
No. Everything runs in your browser.

### Can I show a reviewer the steps?
Yes. Download Result + lineage for an HTML report, or save the graph as an image.

Tip: Check the personal data list yourself. It is based on column names only.

## Related tool pages

- [Data Lineage Version History](https://datautility.in/data-lineage-version-history): Keep a version history of your data lineage and compare any two versions: steps, settings, columns and row counts. Export a report. Free and private.
- [Free Data Lineage Tool](https://datautility.in/free-data-lineage-tool): A free data lineage tool for files: transform data, see input, transformations and result as a graph, and download a shareable HTML report. No signup.
- [Data Lineage Report as HTML](https://datautility.in/data-lineage-report-html): Download a data lineage report as one HTML page: a tree from the input file through every transformation to the result, with a SHA-256 checksum.
- [Share Your Data Together with Its Lineage](https://datautility.in/share-data-lineage-with-results): Send a result file and the proof of how it was made in one ZIP: your data, an HTML lineage report and a JSON copy. Free, made in your browser.
- [Data Audit Trail for CSV and Excel Files](https://datautility.in/data-audit-trail-for-csv): Keep an audit trail of what was done to a CSV or Excel file: conversions, cleaning, joins and masking, with the settings used. Free, in your browser.
- [Data Provenance Tool for Files](https://datautility.in/data-provenance-tool): Record where a data file came from and every transformation applied to it. See it as a graph and export an HTML provenance report. Free, no upload.

## Also try

- [Data lineage for GDPR and audits](https://datautility.in/data-lineage-for-gdpr)
- [Data Masking](https://datautility.in/data-masking)
- [Column-level lineage](https://datautility.in/column-level-data-lineage)

## More guides

- [Data Profiler: Check Data Quality Before You Use It](https://datautility.in/blog/data-profiler-check-data-quality)
- [Compare Two CSV or Excel Files: Find Added, Removed and Changed Rows](https://datautility.in/blog/compare-two-csv-files-find-differences)
- [Data Masking: Hide Emails, Phones and Names Before Sharing](https://datautility.in/blog/data-masking-hide-emails-phones-pii)
