Excel Analyser
Drop your cleaned bahi Excel. Get an instant audit: rows, groups, villages, castes, gotras, year-range, gender split — under one roof.
Software · AI · Products
We build the
We build the
systems
genealogists trust
when accuracy is
non-negotiable.
Vansh reads a cleaned bahi/pahi Excel, infers parent · spouse · sibling links from free-text relations, lets you tune the graph in a relationship builder, exports a strict GEDCOM 5.5.1 file, and renders a standards-grade hierarchical family tree for every Group ID — with full per-node provenance.
Datiya · Disavar · Bohara · Mahate · Dangi · Brahmin · Thakur · Asthi Visarjan · Manoj Sharma · 1890 · 1919 · 1982
Datiya · Disavar · Bohara · Mahate · Dangi · Brahmin · Thakur · Asthi Visarjan · Manoj Sharma · 1890 · 1919 · 1982
Five surfaces.
One workflow.
Relationship Builder
Every X's Father / Son / Wife string is parsed, classified, and rendered as an editable edge. Toggle, retype, re-anchor — without touching the spreadsheet.
GEDCOM 5.5.1 Export
Single-group .ged or one combined file for all groups. Conforms to LINEAGE-LINKED — ready for Gramps, Family Historian, Ancestry, MyHeritage.
Standard Tree View
Generation-banded, spouse-paired, children-from-midpoint — the chart genealogists actually expect. No circles, no spaghetti.
Per-node Insights
Tap any person: full bahi provenance (folio, image no.), ritual context, gotra, kul-devta, Tirth Purohit, residence — in one slide-over.
PNG · JSON · GEDCOM
Snapshot a tree, export the inferred graph, save the GEDCOM — share a single page or the whole archive in one click.
The pipeline.
- Step 01Read
Excel → typed dataframe
- Step 02Parse
"X's Father" → (subject, relation_type)
- Step 03Classify
parent · spouse · sibling · in-law
- Step 04Build
per-Group directed graph
- Step 05Tune
relationship builder UI
- Step 06Render
generation-banded family chart
- Step 07Export
GEDCOM · PNG · JSON
Built for the Bahi.
Source
The cleaned Output1_cleaned.xlsx — 469 individuals across 81 family groups, drawn from the Datiya / Disavar bahis kept by Tirth Purohits.
Each row
Bahi · Folio · Group ID · Individual ID · Name · Gender · Relation · Level · Village · District · Caste · Gotra · Ritual · Year · Image No.
What's hard
Relations are free-text in mixed English/Hindi; the "subject" of X's Father is implicit; mojibake apostrophes; missing surnames. Vansh handles all of that.
Ready to map the lineage?
The bundled bahi is auto-loaded. Upload a different cleaned file at any time.