To ensure the file is uploaded correctly, some criteria must be followed:
-
File format: use the template downloadable from the platform, which is in .xlsx format;
-
Column headers: do not modify or delete the column headers (neither the content nor the formatting);
-
Data type for each column, in particular:
-
Email: there must be no spaces or invalid characters (such as commas, semicolons, etc.);
-
Username: must be complete, with no spaces or special characters, and must be unique (no duplicate usernames allowed);
-
Mobile number (if OTP is required): must include the international country code (e.g., +1 or others) for all mobile numbers; ensure the formatting is correct;
-
-
No empty rows: check that there are no blank rows in the spreadsheet;
-
The "info" column, being optional, should not be deleted if left empty — simply leave it blank;
-
No special formatting: do not use colors, borders, or special cell formatting.
For further details, we recommend reading the article Adding voters to an event or a ballot.