Browse documentation
HomeDocsCell Lineage
Audit & Errors

Tracing Data Integrity (Cell Lineage)

Track any cell in your final grid back to its exact origin — a spreadsheet coordinate or a highlighted PDF sentence.


Data migration must be fully auditable. Elvity’s Data Trace feature ensures you can track any cell in your final grid back to its origin across structured spreadsheets, unstructured PDFs, and relational cross-lookups.

7.1

Activating the Lineage Viewer & Visual DAG Graph

  1. 1Open your active project’s data grid.
  2. 2Hover your mouse over any cell in the table. An Eye (Branch) Icon will appear in the cell’s right corner.
  3. 3Click the Eye (Branch) Icon (or click the cell and select “View Trace”).
  4. 4The Data Trace panel slides open from the right, rendering an interactive visual DAG (Directed Acyclic Graph) displaying the step-by-step transformation tree for that specific value.
  5. 5Visual DAG Nodes: The graph connects raw input nodes (source file coordinate, sheet name, or PDF bounding box), intermediate transformation nodes (formatting, cleanups, formulas), and the final target schema cell output.
The Data Trace panel displaying interactive visual DAG graph and cell lineage.
The Data Trace panel reveals the full step-by-step transformation tree for any cell.
7.2

Auditing Structured Sources (CSV/Excel) & Coordinate Highlighting

If the cell came from a spreadsheet:

  1. 1Select the cell and view the Data Trace panel.
  2. 2Under Source Data, inspect the exact source filename, worksheet name, and row index where the value was originally located.
  3. 3Click the filename link to open the Source Preview dialog. The spreadsheet preview opens and scrolls automatically, highlighting the exact cell coordinate in yellow.
Spreadsheet Source Preview highlighting original cell coordinates.
Spreadsheet Source Preview automatically highlights the source cell coordinate.
7.3

Auditing Unstructured Sources (PDFs/Images) & Bounding Boxes

If the cell was extracted from a contract, invoice, or image:

  1. 1Select the cell and view the Data Trace panel.
  2. 2Under Source Data, inspect the source document name, confidence score, and the AI’s extraction rationale.
  3. 3Click the document link to launch the Document Preview dialog.
  4. 4The embedded PDF viewer automatically opens, scrolls to the exact page, and draws a luminous bounding box around the exact text, table cell, or signature coordinate from which the AI extracted the value.
Document Preview overlaying bounding boxes on extracted PDF text.
Document Preview overlays glowing bounding boxes on extracted PDF text and tables.
Bulletproof audit verification
Visual coordinate highlighting lets you perform instant audit verification without reading the entire source document manually.
7.4

Relational Lookups & Cross-Entity Lineage Nodes

When a field value is populated via relational reference lookups (e.g., mapping a customer ID to a canonical company profile), the lineage viewer renders a specialized Relational Lookup Node:

  1. 1Inspect the lookup node in the visual graph to verify the secondary dataset name and the exact join keys used.
  2. 2Click View Joined Entity to inspect the matched record in the reference source table.
7.5

Auditing Formulas, Calculations & Manual Overrides

If the cell value was produced by a mathematical calculation or edited directly by a human reviewer:

  1. 1Formula Expressions: Under Formula, click Show to view the underlying expression (e.g., Unit_Price * Quantity). Click Translate formula to let the AI explain the business logic in plain English.
  2. 2Manual Override Tracking: If a reviewer manually modified a cell in the grid or applied a comment suggestion, the lineage tree inserts a dedicated Manual Override Node capturing the previous value, the new value, the author, and timestamp.
Manual override trace showing user edit history and prior value.
Manual overrides and human edits are tracked as discrete lineage nodes.

Ready to put this into practice?

Spin up your first pipeline and watch Elvity map your data in minutes.