How Data Utility Data Lineage Differs From Other Lineage Tools
Most lineage tools learn from your systems. This one learns from the steps you take on a file, in your browser.
Short answer: many lineage tools connect to a warehouse, an orchestrator or a code project and read lineage from there. Data Utility works the other way. It records the steps you run on a file in its own tools, in your browser, with nothing to connect or install. That makes it a good fit for CSV and Excel work done by hand, and a poor fit for automatic lineage across a whole data platform.
Three common approaches
These are general descriptions, not claims about any one product.
- Catalog and governance platforms: they usually connect to databases, warehouses and BI tools and read metadata or query history to draw lineage across the organization.
- Pipeline-based lineage: orchestrators and jobs report what they read and wrote while they run.
- Model graphs: SQL-based projects can draw a graph of how their models depend on each other from the references in the code.
What those approaches do well
They work at scale, they capture lineage automatically as pipelines run, they cover many systems, and they usually come with access control, search and monitoring. If you run a data platform, you probably want one of them.
The gap they leave: work done on files
A lot of real data work never touches those systems. Someone downloads a CSV export, fixes it in a spreadsheet, masks a column, joins it to another file and emails the result. There is no pipeline to instrument and no warehouse to read from, so nothing records what was done. That is the gap Data Utility's lineage covers.
How Data Utility lineage works
- It records each step you run in its tools: the input file and where it came from, the step and its settings, and the output with its row count.
- It records the output columns, so it can show what happened to each one: kept, changed, added, renamed, moved or dropped. You can follow a single column through the graph.
- Everything stays in your browser. Nothing is uploaded and nothing is installed.
- You can download the result together with a lineage report: a ZIP with your file, an HTML report and a JSON copy that includes the file's SHA-256 fingerprint, so a recipient can check that a copy is the same file.
- You can save the graph as a PNG or SVG, and download the lineage of a result as a ZIP with an HTML report.
What is different, in short
- No setup: no connection, agent or code to add.
- Built for files: CSV, Excel, JSON and Parquet.
- Private by design: the history lives in your browser, not on a server.
- Portable proof: the lineage travels with the file as a report you can open anywhere.
What it does not do
- It only records steps done in Data Utility. Work done in other programs is not captured.
- The history is kept in your browser. If you clear browser data it is gone, so download the report or the exports for anything you need to keep.
- It does not monitor pipelines, run on a schedule or connect to databases.
- It has no team accounts or permissions, and it does not record which person did a step.
- Column links are worked out from column names and the settings the tools record. For SQL the new columns are read from the query text, which is a good guess but not a full SQL parser.
When to use something else
Use a platform-level tool when you need lineage across many systems, automatic capture from scheduled pipelines, shared access for a team, or monitoring. Use Data Utility when the work is a file in front of you and you need to see, explain or prove what was done to it. Start with the free data lineage tool, or read about column-level lineage.
Related tool pages
- Free Data Lineage Tool: Transform Data and Download the Lineage: Free online data lineage tool: see every step applied to a file as a graph, then download a lineage report with a checksum. Runs in your browser, no upload.
- 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.
Also try
How to use the Data Lineage tool: step by step
- Use the Data Utility tools on your file.
- Open Data Lineage and follow a column.
- Download the result with its lineage, or export the lineage as an image or data.
When to use the Data Lineage tool
- Explain a one-off clean-up to a reviewer
- Show an auditor what was done to an export
- Document a spreadsheet-based process
- Keep a record of a masking step before sharing a file
Example
Input: customers → Data Masking → customers_masked
Output: Click Data Masking to see each column and method
Frequently asked questions
How is Data Utility lineage different from a data catalog?
A catalog is an inventory of datasets across systems. Data Utility records the history of the files you change in its tools, in your browser, with no connection to your systems.
Does it need to connect to my database or warehouse?
No. It works on files and records the steps you run in its tools. It does not connect to databases.
Where is the lineage stored?
In your browser, on your device. Nothing is uploaded. Download the lineage report or the exports to keep a copy.
Can I use it with other lineage tools?
Data Utility does not feed other lineage tools. You can download the lineage as a ZIP with an HTML report and keep it with your other records.
Does it track work I do in Excel or other programs?
No. It only records steps done in Data Utility.
Is it free?
Yes. It is free, needs no account and runs in your browser.
When should I use a larger lineage platform instead?
When you need automatic lineage across many systems, scheduled pipelines, team access control or monitoring.
Tip: If you need to keep a lineage, download the report. The history in your browser is not backed up anywhere.