Skip to content
Help for campaign teams

Voter list format: the columns we read

Campaign teams can upload their own voter lists — booth lists, survey sheets, contacts collected in the field, or exports of the Election Commission's elector database — into the voter table of a campaign. This page lists the columns that are recognised. Headings can be in English or Hindi, in any order, and the heading row may sit below a title row.

Files

  • Excel (.xlsx, .xls), OpenDocument (.ods) or CSV, up to 25 MB and 20,000 rows per file.
  • In a workbook, the sheet whose headings match best is read; an instructions sheet is skipped.
  • For CSV, use “CSV UTF-8” when saving from Excel so Hindi text survives.
  • Each row needs an EPIC number or a name. Rows with neither are skipped and listed before you import.

Columns

ColumnNeeded?Also recognised asNotes
Part NoRecommendedPart, Part No., PART_NO, Booth No, भाग संख्याPolling-station part number. A file holding several parts imports into each part.
Serial NoRecommendedSl. No., Sr, S.No, SLNOINPART, क्रम संख्या, क्रमांकSerial of the voter within the part. Without one, new rows continue after the part's last serial.
EPIC NoEPIC or nameEPIC, Voter ID, EPIC_NO, ID Card No, एपिकSpaces and dashes are removed and letters capitalised.
NameEPIC or nameName, Elector's Name, Voter Name, First Name + Last Name, FM_NAME_EN + LASTNAME_EN, नामSplit first and last names are joined.
Name (Hindi)OptionalName (Hindi), FM_NAME_V1 + LASTNAME_V1, नाम हिंदीAs printed on the roll, in Devanagari.
AgeOptionalAge, उम्र, आयु — or Date of Birth, DOB, जन्मतिथि18–120. A date of birth is turned into an age. Devanagari digits (४२) work.
GenderOptionalGender, Sex, लिंगMale / Female / Other, M / F / O, पुरुष / महिला / अन्य.
Relation TypeOptionalRelation Type, RLN_TYPE, संबंधFather / Husband or Wife / Mother / Other, F / H / M / O, पिता / पति / माता.
Relative's NameOptionalFather's/Husband's Name, Father Name, RLN_FM_NM_EN + RLN_L_NM_EN, पिता/पति का नाम
House NoOptionalHouse No., C_HOUSE_NO, Address, मकान संख्या
Village / LocalityOptionalVillage, Mohalla, Ward, SECTION_NAME, गांव, मोहल्लाThe roll's section name works as the locality.
MobileOptionalMobile, Mobile No., Phone, MOBILE_NO, मोबाइल10-digit Indian mobile, with or without +91 or 0. Anything else is left empty.
CommentOptional · privateComment, Notes, Remarks, टिप्पणीYour own note on the voter. Only your campaign sees it — never other leaders, never the shared roll.
Any other columnOptional · privateAny heading not listed aboveKept as up to 12 private fields per voter (e.g. Contacted by, Needs transport). Columns about caste, religion or community are not imported.

Before anything is saved, the upload screen shows how each of your columns was read and lets you change it — so a sheet with unusual headings can still be imported.

How rows are merged

  • A row whose EPIC is already in the campaign updates that voter, wherever the voter is.
  • Otherwise a row whose part and serial are already taken updates the voter at that serial.
  • An upload only fills in what is empty. It never overwrites a name, age, phone or village already on a voter.
  • The same EPIC twice in one file, or a serial whose existing voter has a different EPIC, is skipped and reported.
  • Re-uploading a corrected file is safe: nothing is duplicated.

Phone numbers and consent

Electoral rolls never carry phone numbers. Add a mobile only when the voter has given it to your team. Saved contacts can be messaged; the first message each person receives carries their own unsubscribe link, and one tap withdraws consent for every channel. A voter who says no is recorded as a refusal and blocked everywhere. Phone numbers you upload stay inside your campaign; the constituency roll the platform publishes to leader accounts has no phone numbers.

Electoral roll PDFs

Do not upload the Election Commission's roll PDFs here. They are read by the platform's own roll pipeline and appear, part by part, in the Constituency Roll tab of your campaign. Every leader account can open and import any seat whose roll has been parsed.

Questions? See the FAQ or write to info@democracyindia.com.