Data Lineage for CSV and Excel Files: A Practical Guide
Most spreadsheet work leaves no trail. Here is how to keep one for CSV and Excel files without a catalog or a pipeline.
Short answer: data lineage is the record of where a file came from and what was done to it. For CSV and Excel files, Data Utility builds that record for you as you work: each tool you run adds a step, and the Data Lineage page draws the steps as a graph. It all happens in your browser.
What is data lineage for a spreadsheet?
Data lineage answers three questions about a file: where did the data come from, what changed along the way, and what is the result? For a spreadsheet that means the original export, every clean-up, join or mask you applied, and the file you finally sent to someone.
Why CSV and Excel files need lineage
- They are copied, renamed and emailed, so the name alone says little. A file called final_v3_REAL.xlsx tells nobody what was done.
- Clean-up is manual and easy to forget: trimming spaces, removing duplicates, fixing dates, hiding a column.
- Reviewers and auditors ask how a number or a column was produced, weeks later.
How to track the lineage of a CSV or Excel file
- Open the file in a Data Utility tool such as Data Transformation, Data Masking or the Format Converter.
- Run your step and download the result, or click Save. The step is recorded with its settings, the input file and the output row count.
- Use the saved file in the next tool from Recent files. The chain keeps growing as the file moves from tool to tool.
- Open Data Lineage to see the graph. Click a step to see what was done and which columns were kept, changed, added, renamed or dropped.
Follow one column through the steps
Pick a column in Follow a column and the graph highlights the steps that touched it. This is the quickest way to answer a question like "was the email column masked before I shared the file?".
Keep the lineage with the file
Use Result + lineage to download your file together with an HTML report and a JSON copy. The JSON includes the file's SHA-256 fingerprint, so a recipient can check that the copy they hold is the same file. You can also save the graph as a PNG or SVG for a slide or a document.
What it does not capture
- Only steps done in Data Utility are recorded. Edits you make in Excel itself are not.
- The history is kept in your browser on your device. Clearing browser data removes it, so download the report for anything you need to keep.
- It records which steps ran, not which person ran them.
Related tool pages
- 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: 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: 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: 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: 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: 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
How to use the Data Lineage: step by step
- Run your CSV or Excel file through a Data Utility tool.
- Download the result or click Save.
- Open Data Lineage and click a step or follow a column.
- Download the result with its lineage report.
When to use the Data Lineage
- Document a spreadsheet clean-up for a reviewer
- Show how a CSV export became the file you sent
- Keep a record of masking before sharing data
- Explain a number in a report to an auditor
Example
Input: customers.csv → Data Masking → Format Converter
Output: customers.json + LINEAGE.html (input → transformations → result)
Frequently asked questions
What is data lineage for a CSV file?
It is the record of where the file came from, the steps that changed it and the result. Data Utility records these steps as you use its tools.
Do I need to install anything?
No. It runs in your browser and nothing is uploaded.
Does it track edits I make in Excel?
No. It only records steps done in Data Utility tools.
Can I prove a copy is the same file?
The downloadable lineage JSON includes a SHA-256 fingerprint of the result, which a recipient can compare with their own copy.
Is it free?
Yes. It is free and needs no account.
Tip: Download the report for any lineage you must keep. Browser history is not backed up anywhere.