Vehicle Analytics

Year, month, RTO, class and maker-wise comparison

Data refreshed —

FILTERS

Total registrations —

Makers —

RTOs —

Vehicle classes —

Selected market share —

Selected years —

Maker comparison (year-wise)

Rows

Page 1 of 1

RTO comparison (maker-wise)

Detailed registration data

Rows

Page 1 of 1

Quick summary

Top makers, top RTOs, highest growth and data summary

Top 5 makers by market share

Top 5 RTOs by registrations

Highest growth

Data summary

Import Registration Data

Upload a Vahan maker_vehicleClass_All RTO_<Mon><YY>.xlsx (All India), maker_vehicleClass_GJ_All RTO_<Mon><YY>.xlsx or maker_vehicleClass_MH_All RTO_<Mon><YY>.xlsx (whole state - a state file saved as plain "All RTO" is recognised from its title too), maker_vehicleClass_GJ01_<Mon><YY>.xlsx (Gujarat RTO) or maker_vehicleClass_MH01_<Mon><YY>.xlsx (Maharashtra RTO) export. It is checked first and nothing is written until you confirm - see . New to this format? to see the exact shape expected. Dealership covers more than one RTO? instead - one sheet for several RTOs/months at once.

Checks run on every uploaded workbook
Check	What it catches	If it fails
Filename pattern	Anything not named like a Vahan monthly export	Blocked
Title cross-check	Filename's month/year disagreeing with the sheet's own printed date range - how 2024 data would end up filed as 2025. For a Gujarat/Maharashtra file, the RTO named in the filename is also checked against the RTO named in the sheet's own title row	Blocked
Header shape	First column isn't Maker, or last isn't Total	Blocked
Known vehicle classes	A column Vahan hasn't sent before	Blocked
Duplicate maker	The same maker listed twice in one sheet	Blocked
Newline in a name	A stray line break inside a maker name	Blocked
Class columns sum to Total	A row whose printed Total doesn't match its own class counts	Reported, not blocked - shown before you confirm
Single month, single year (single RTO)	Only the uploaded month/year is touched - for a Gujarat/Maharashtra file, only that one RTO too. Every other row in the table is left exactly as it was	—