QR Code decoder in Google Sheets

A QR Code decoder implemented in Google Sheets: Google Sheet link.

Each step of the decoding process is computed with Google Sheet formulas. Changing the modules of the input QR Code will automatically update intermediate steps and final output message:

More "drastic" input changes are supported too, such as changing the encoding mode modules:

This also comes with a tool to convert an image of a QR Code into a binary matrix that can be pasted into the Google Sheet:

Generating a Google Sheet

Go to the template Google Sheet, find the appropriate sheet for the QR Code version, and right-click > Copy to.

Alternatively, generate from source:

1. Go to this page and upload a QR Code.
2. Click "Copy contents to clipboard" and paste into a Google Sheet at cell A1.
3. Go to Extensions > Apps Script, and paste in the contents of appsscript.js.
4. Click "Run".
5. Currently adding Checkbox data validation for integers in Apps Script doesn't work correctly. Manually go to Data > Data Validation, click the Checkbox rule, and change the "Checked" and "Unchecked" values to 1 and 0 respectively.

Development

Run npm run dev and go to http://localhost:1234.

Before committing a change, run npm run build and include the changes to the docs directory.