Count a preferential ballot election

Each voter ranks the choices: 1 for first choice, 2 for second, and so on. This page finds the winner and the full ranking with Ranked Pairs, and gives you a spreadsheet with the complete results.

1

Download the sample spreadsheet

Save SampleElection.xlsx, then rename it to the name of your election (keep the .xlsx at the end).

2

Enter the ballots

Open your spreadsheet and enter the preferential ballots for your election that you have collected yourself, following the instructions in the spreadsheet.

3

Count the votes

Drag your spreadsheet here, or

Your spreadsheet stays on your computer. Nothing is uploaded to our servers, so you have complete privacy. The votes are counted by your own web browser (using code anyone can inspect) which determines the winner of the election with an accompanying spreadsheet explaining every detail.

4

Save the results

The winner and the ranking appear below, with a link to the complete results spreadsheet.