RCV123 - Ranked Choice Voting calculator for Google Classroom, Google Forms and Google Sheets.

Google Forms & Classroom

Google Forms and Classroom are great for collecting votes, but they don't calculate ranked choice results.

Collect votes using Google Forms or Classroom, then upload your Google Sheets data to get instant tabulated results with charts and round-by-round breakdowns.

Create your form → Collect votes → Upload to RCV123 → Get instant RCV results

Want to collect the votes a different way? Click here

Quick Steps:

Use Google Forms "multiple choice question grid" and Google Sheets to collect votes.
When voting is complete, format your Google Sheet as shown below.
Copy the link to your Google Sheets document and use the Paste Google Sheets link button to paste the link
Or, download the file in Excel format and use the Find Excel file on your computer button.
RCV123 will immediately calculate and display your ranked choice voting results. The ballot will appear in your Dashboard.

Note: You must reformat your Google Forms response sheet before uploading. See instructions below.

Here is a sample spreadsheet which is formatted correctly:Sample Spreadsheet on Google Sheets

Click the link to view the spreadsheet in a separate tab and see how the data should be formatted.

Sign in to upload voting data

Spreadsheet upload allows you to import votes you've already collected and get instant RCV results.

Create Account

Formatting Example for Microsoft Excel (.xlsx) or Google Sheets files.

Google Forms / Google Classroom Instructions

Part 1: Create Your Google Form

Create a Google Form.
Where it says “Untitled Form,” type in your election’s name. The lower part of the form will disappear while you type. Click on the body of the form to make the hidden sections re-appear.
Delete the phrase “Untitled Question” and leave that field blank.
The default Form type is “Multiple choice.” Change that to “Multiple choice grid.”
Put a candidate’s name in each row. RCV123 can handle up to 30 candidates and 20 ranks, and Google Sheets has thousands of rows for votes.
For ranks, label columns from “1” to the number of candidates you have (up to 20 ranks). (5 in this example.) Do not use any letters or phrases such as “3rd Choice” in the column labels.
You can choose to have fewer ranks/columns than candidates. That reduces the number of ranks your voters will have. If you have a large number of candidates, it may be simpler for voters to have fewer ranks.
Also, if you have more than 9 columns/ranks, voters will need to scroll the form to see columns 10 or higher.
We recommend that you do not enable “Require a response in each row.”
In the bottom right of the ballot set up area, you’ll see three dots arranged vertically. Click on the dots and select “Limit to one response per column.” This prevents a voter from giving the same candidate two different ranks.
Now go to “Settings” at the top of the page. Under “Responses,” turn on “Limit to one response / require sign in.” This limit is not necessary if you are only holding a demonstration or test vote.
When the voting is over, click on "Responses" at the top of the page. Turn off "Accepting responses" and then click "Link to Sheets" which is also near the top of the page.

Part 2: Reformat Your Google Sheets Response Data

This is the critical step! You cannot upload the raw Google Forms responses. You must reformat the data following these steps:

Choose "Make a copy" from the File menu to create a new spreadsheet that you can edit.
At the top of the sheet, click on the dropdown and select “Revert to unformatted data”
Set up the data in your Google Sheet exactly as shown above. You do not need to set any cell formats.
Delete the Timestamp column and insert three new columns on the left. Fill in column A as shown and enter the appropriate data in column B for your contest.
Leave column C blank. Columns D and beyond should already be filled in with the votes you gathered from the form.
Your spreadsheet should have no other data than the information listed above. Select everything (Command-A or Control-A) and choose “Clear formatting” from the Format menu.

Part 3: Upload to RCV123

Copy the URL of your reformatted Google Sheets document from your browser's address bar.
Click the Paste Google Sheets link button in the upload box above and paste your link. The uploader can only calculate one contest per Google Sheet.
When uploading is complete, this page will refresh to show results automatically. The links to the results will be available in your account dashboard.

Alternative: If you prefer, you can download your spreadsheet as Excel (.xlsx) from the File menu and use the Find Excel file on your computer button instead.