How to Import Your Voters List

How to Import Your Voters List

Learn how to validate and prepare your voter list for import into your community in Ballot Bliss. This process ensures your data is accurate, error-free, and ready for a smooth election setup. Prefer to watch instead? View our interactive step-by-step tutorial here.


Step 1: Log into Your Community

Once you receive your login details in the welcome message, log into your Ballot Bliss community and navigate to Settings and select Voter XLS Import Validator.


Step 2: Enter Your Community Name

On the XLS Validator page, type in the name of your community in the Provide Community Name field.

Step 3: Upload Your Voter List

Click Upload File to upload your prepared voter list in XLS format, then click Continue to upload the file into the validator.

Step 4: Choose Your Header Row

Select the header row in your spreadsheet, then click Continue.

Step 5: Map Your Columns

Map each column in your spreadsheet to the corresponding voter information fields (e.g., First Name, Last Name, Email, etc.).

  • If your name column is split (first name and last name in different columns), select Split Columns.

If your name column is combined, select Same Column.

For User Type, you can either map the column from your spreadsheet or select from preset options: Owners, Managers, Tenants, or Other.

If your address is stored in:

  • One column: choose Single Column and map it to “Full Address.”

  • Multiple columns: choose Split Columns and map each part (street, building, unit, etc.) individually.

Don’t forget to scroll to the bottom and map your Ownership Percentage column.

Once everything is mapped, click Continue.

Step 6: Validate Your Data

Ballot Bliss will now scan your voter list for:

  • Missing information

  • Invalid email addresses

  • Duplicate contacts

This ensures your data is accurate and ready for import.

In this example, there are some rows with errors in the uploaded voter list.
Click Show All Errors to display only the rows with issues, making them easier to fix.


Step 7: Fix Errors

Click on any red error message to view the reason for the error. Then click the pencil icon to edit it directly on-screen.


After entering the correct information, click the green check mark to save it.

Once fixed, the row will automatically disappear from the error view.


Step 8: Download for Offline Editing (Optional)

If you prefer to fix errors later, click Download to export your voter list as an XLS file.
The downloaded sheet includes each row and the reason for the error. Before downloading, make sure to uncheck “Show All Errors” so your entire list - not just the error rows - is included.


Step 9: Confirm Addresses

After correcting all the errors, Click Continue to move on to the next step.


Next, confirm that your voter addresses are correct before proceeding.
In this example, all voters are located on Mask Ave, which is why only one street name is shown.
After verifying, click Continue.


Step 10: Download Your Validated List

Once your voter list has been validated, click Download XLS to get your error-free voter list. Send the downloaded list to the Ballot Bliss team for prompt import into your community.

You’re Done!

Your voter list is now fully validated and ready for your next election.

Prefer to watch instead?
View our interactive step-by-step tutorial here.



    • Related Articles

    • How to Format Your Voter List for Import (Step-by-Step Video Guide)

      Before sending your voter list to Ballot Bliss Setup Team, it’s important to make sure your data is structured in the format our system accepts. A correctly formatted Excel file helps avoid import errors, reduces back-and-forth, and ensures your ...
    • Ballot List Page

      The Ballot List page provides a centralized location to view all your created ballots. From here, you can manage settings, make edits, monitor participation, and access ballot results. 1. Selecting a Community Use the Community dropdown at the top of ...
    • Getting Started With Ballot Bliss

      Use this page to quickly access any Ballot Bliss interactive tutorial. Each walkthrough includes a short description of what you’ll learn and a direct link to launch the tutorial. Getting Familiar with Ballot Bliss Title Description Link Getting ...
    • Frequently Asked Questions For Voters

      1. How do I cast my vote? You’ll receive an email with a secure link to your ballot. Click the link, enter the access code in the email, review the options, and select your choice. Once you're ready, click Submit Vote. You’ll see a confirmation ...
    • How Residents/Voters Can Cast Their Vote

      Casting your vote is a quick and secure process. Follow these simple steps to ensure your voice is heard: 1. Locate The Voting Email Head to your email inbox and find the voting invitation from your organization. It will be sent from the official ...