Skip to main content
Bharat Surveyभारत सर्वे
वॉर रूम में बड़ी स्क्रीन पर विधानसभा का नक्शा और दीवार पर बूथ-वार चार्ट
Services · Election data

Electoral roll PDFs turned into clean, checked spreadsheets for one constituency at a time

If your campaign office needs the voter list in Excel for an assembly or parliamentary constituency, Bharat Survey prepares it from the electoral roll PDFs that the Election Commission and state Chief Electoral Officers publish. We read every part with OCR, check the row count against the roll's own summary, and deliver a row-level spreadsheet plus booth-wise and village-wise analysis: age and gender, first-time voters, family groups and print-ready voter slips. Scope, turnaround and price are agreed on a call before any work starts.

  • Only the fields printed on the published roll
  • Every part reconciled with its printed elector totals
  • Booth-wise and village-wise summaries in the same file
  • Delivered after a scoping call, never as an instant download
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
A strongB fairC weakD very weakNo report today
Constituency 172 · Survey round 2Updated 12s ago · sample
3,000
Target homes
2,184
Visits
1,962
Completed
1,871
Accepted
Daily accepted surveysLast 12 days
Location evidence
Survey #BS-0412
  • In areaInside approx. boundary
  • Accuracy±12 m
  • Time09:42 · fresh fix
  • Mock GPSNot detected
  • Interview length11 min
Added to accepted count
Voter list in ExcelPart-wise OCRRow counts reconciledAge–gender by boothFirst-time votersFamily groupingPrinted voter slipsVillage-wise summary
Start with the source

Every column in our file traces back to something printed on the roll. If the roll does not print it, we do not supply it.

Voter list in Excel: fields compared with the published electoral roll, September 2026
FieldPrinted on the published rollIn the Excel we deliver
Assembly constituency, part number and polling station
Section number and name (street, mohalla or village)
Serial number within the part
EPIC (elector photo identity card) number
Elector's name
Relation type and relative's name
House number
Age and gender
PhotographIn some roll formats
Date of birth
Mobile number
Caste or religion

Roll layouts differ slightly between states and revisions. We confirm the exact columns for your state on the scoping call.

How the file is made

Rolls on CEO websites are published part by part as image PDFs, so text cannot simply be copied out. Reading them is the easy half; proving the read is complete is the work.

  1. 01

    Collect the current roll, part by part

    We download every part of the constituency from the official CEO website and note the revision the roll belongs to, such as the final roll after a summary or special revision. That date is printed on the cover of your file.
    Day 1
    Collect the current roll, part by part
  2. 02

    OCR in the roll's language

    Each page is read in the script it was printed in, Hindi, Marathi, English or another state language, and split into one row per elector with the part, section and serial number attached.
    Extraction
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    A strongB fairC weakD very weakNo report today
  3. 03

    Page and serial checks

    Serial numbers in a part must run without gaps or repeats. Any break points to a missed box or a misread page, and that page goes back for a second read and a manual look.
    QA pass 1
    Location evidence
    Survey #BS-0412
    • In areaInside approx. boundary
    • Accuracy±12 m
    • Time09:42 · fresh fix
    • Mock GPSNot detected
    • Interview length11 min
    Added to accepted count
  4. 04

    Reconcile with the roll's own totals

    Each part carries a printed summary of electors by gender. Our row count for every booth is matched against it, and any part that does not tally is listed in a QA sheet rather than hidden.
    QA pass 2
    Constituency 172 · Survey round 2Updated 12s ago · sample
    3,000
    Target homes
    2,184
    Visits
    1,962
    Completed
    1,871
    Accepted
    Daily accepted surveysLast 12 days
  5. 05

    Build summaries and hand over

    Booth-wise and village-wise tables, age–gender breakdowns and family groups are computed from the checked rows, and the workbook is delivered with a short method note.
    Delivery
    Build summaries and hand over

Our view

Deliverables

The row-level sheet is the raw material. Most campaigns get more use from the summaries built on top of it.

Sheet 1

Row-level voter list per assembly constituency

One workbook per assembly constituency, one row per elector, with part, section and serial number so any row can be found again on the printed roll. Hindi or regional-language names stay in their original script.

  • One row per elector
  • Original-script names
  • Traceable to part and serial
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
A strongB fairC weakD very weakNo report today
Sheet 2

Booth-wise and village-wise summaries

Electors per booth and per section, rolled up to village or ward where the section names allow it. This is the table most offices print for booth in-charges.

  • Booth totals by gender
  • Village and ward roll-up
  • Sections mapped to booths
Constituency 172 · Survey round 2Updated 12s ago · sample
3,000
Target homes
2,184
Visits
1,962
Completed
1,871
Accepted
Daily accepted surveysLast 12 days
Sheet 3

Age–gender pyramid per booth

Electors in age bands (18–19, 20–29, up to 80 and above) split by gender for every booth, with a small chart per booth. It shows at a glance where young or elderly electors are concentrated.

  • Ten-year age bands
  • Chart per booth
  • Constituency comparison
Constituency 172 · Survey round 2Updated 12s ago · sample
3,000
Target homes
2,184
Visits
1,962
Completed
1,871
Accepted
Daily accepted surveysLast 12 days
Quality
Accepted1871
In review64
Outside area19
Weak signal8
Top issues · by panchayat
Water62%
Roads48%
Power31%
Drains24%
Sheet 4

First-time voters count

Electors aged 18 or 19 on the roll, counted by booth and village. Age on the roll is used as a stand-in for first-time voters, so a few older new registrants will not appear in this count.

  • Counted per booth
  • Age 18–19 on the roll
  • Limit stated in the note
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
A strongB fairC weakD very weakNo report today
Sheet 5

Family grouping from relation fields

Electors who share a house number and are linked through the relative's-name field are grouped into likely households, with a family ID and size. It is an estimate built from printed fields, and the note says so.

  • Household ID and size
  • Built from house no. and relation
  • Flagged as estimated
Location evidence
Survey #BS-0412
  • In areaInside approx. boundary
  • Accuracy±12 m
  • Time09:42 · fresh fix
  • Mock GPSNot detected
  • Interview length11 min
Added to accepted count
Print

Printable voter slips grouped by booth or village

Print-ready PDF slips with the elector's name, part and serial number and polling station, sorted by booth and section so they can be handed out street by street. Layout follows the Election Commission's instructions for the election in question.

  • Sorted by booth and section
  • Print-ready PDF
  • Layout checked against current instructions
Printable voter slips grouped by booth or village
Social composition

Many campaigns ask what a booth looks like socially. On request we add a surname frequency table per booth: the most common surnames and how many electors carry each. It is a count of words printed on a public roll and nothing more. We do not label any elector with a caste, religion or community, and we do not add such a column to the row-level sheet.

Surnames are a weak signal. The same surname is used by different communities in different regions, many electors use no surname at all, and women's surnames on the roll may reflect either the parental or the marital family. Treat the table as a rough description of a booth, never as a fact about a person.

The legal line

Section 123(3) of the Representation of the People Act, 1951 makes an appeal to vote on the ground of religion, race, caste, community or language a corrupt practice. Aggregate description of an area is one thing; messaging built on it is another. If your plan moves from the first to the second, stop and take legal advice.

What the surname table is

  • Counts per booth, not per person
  • Only surnames printed on the roll
  • No caste or religion column
  • Optional, on request only
Before you order

The roll is published for electoral purposes. How you use a copy is your responsibility, and the rules deserve a proper reading before the file reaches workers' phones.

Decide the purpose

  • Which election and which constituency?
  • Who in the team needs row-level data?
  • Would booth summaries be enough for most people?
  • When will copies be deleted after the poll?

Check the rules

  • Representation of the People Acts, 1950 and 1951
  • Current ECI instructions on rolls and slips
  • Model Code of Conduct for the election period
  • Digital Personal Data Protection Act, 2023

Control the copies

  • Share the Excel with named people only
  • Avoid forwarding files on group chats
  • Keep a list of who received what
  • Take legal advice for your specific use
With the app

The data service and the booth management app are separate. The summaries travel into the app; the row-level list stays with your office.

Booth summaries load into the booth master

The booth-wise sheet is formatted to match the booth master upload in the Bharat Survey app: part number, booth name, building and electors by gender. One upload and every booth on the war room board carries correct counts.

  • Matches the booth master CSV
  • Counts by gender per booth
  • No manual retyping
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
A strongB fairC weakD very weakNo report today

Page ranges for panna pramukhs

Page numbers from the roll help you assign each panna pramukh a page range for their booth. The app records the range as a role; it does not load names from the roll.

  • Page range per worker
  • Role recorded in the app
  • No voter rows in the app
Leader view · read-only
Constituency 172
9
Shifts on
212
Accepted today
7
Open alerts
64
In review
High · outside area 14.2 km
#BS-0398 · 11:02 · sample
Updated 12s ago

Plan surveys where the electors are

Age–gender and village totals help decide where survey interviews should go, so a door-to-door sample reflects the booth instead of whichever street was nearest.

  • Sample in proportion
  • Village totals as a guide
  • Verified interviews in the app
Constituency 172 · Survey round 2Updated 12s ago · sample
3,000
Target homes
2,184
Visits
1,962
Completed
1,871
Accepted
Daily accepted surveysLast 12 days

Not the right fit if

  • Mobile numbers matched to electors
  • Caste or religion tagging of named electors
  • Dates of birth or any field not printed on the roll
  • Instant downloads or online checkout
  • Rolls from unofficial or leaked sources

A good fit if

  • A checked Excel copy of the current published roll
  • Booth-wise and village-wise planning tables
  • Age–gender and first-time voter counts per booth
  • Printed slips sorted for booth teams
FAQ

Straight answers to the questions people ask most about this topic.

Where does your voter list data come from?

Only from the electoral roll PDFs published by the Election Commission of India and the state Chief Electoral Officer's website for your constituency. We note the revision and publication date on the file. We do not use lists from other campaigns, data brokers or unofficial sources, and we do not merge in outside data.

Does the Excel include mobile numbers or caste?

No. The file holds only what the published roll prints: part, section, serial number, EPIC number, name, relation and relative's name, house number, age and gender. Mobile numbers, dates of birth, caste and religion are not on the roll, and we do not add them from any other source.

How accurate is OCR on roll PDFs?

Reading is rarely perfect on the first pass, especially for faint scans or mixed scripts. That is why every part is checked for serial gaps and matched against the elector totals printed in the roll. Parts that still do not tally are listed in the QA sheet so you know exactly where to look.

How long does a constituency take and what does it cost?

Both depend on the number of parts, the roll's language and which analyses you want. We agree scope on a short call and send a written quotation with the delivery date. There is no fixed price list and no online checkout.

Is it legal to use a voter list in Excel for campaigning?

Rolls are published for electoral purposes, and parties and candidates use them in campaigns. What is lawful depends on how you use the data, the election period and current Election Commission instructions. You are responsible for your use, and we recommend taking legal advice before sharing the file widely.

Can the full voter list be loaded into the Bharat Survey app?

No. The app works with your booth list: booth-wise counts, committees, page ranges and surveys. Booth summaries from this service load straight into the booth master, while the row-level list stays in your office's Excel file.

शाम के समय कस्बे का हवाई दृश्य
India Nationwide, Hindi-first

Tell us the state, constituency and what your team will use the file for. We will confirm the roll revision, the analyses that fit, the delivery date and a quotation.