1Define Spreadsheet Column Headers
Your Google Sheet must start with the following headers in row 1. Order matters:
Col AQuestion
Col BOption A
Col COption B
Col DOption C
Col EOption D
Col FCorrect Answer
Col GExplanation A
Col HExplanation B
Col IExplanation C
Col JExplanation D
💡 Pro Tip: Options C and D, as well as all explanation columns, are optional. If a question only has 2 options (True/False), leave Option C and Option D empty.
2Fill Content Rules
- Correct Answer: Must contain exactly A, B, C, or D. Case-insensitive.
- Option C & D: If left empty, the quiz card will dynamically display only A & B.
- Explanations: These will slide open on the quiz screen when a user clicks the matching option button, providing instant pedagogical feedback.
3Make the Sheet Public
Google Visualization API queries only work on spreadsheets visible to anyone with the link.
- Open your Google Sheet.
- Click the blue Share button in the top-right corner.
- Under General Access, change status from Restricted to "Anyone with the link".
- Set the role to Viewer.
- Copy the sheet URL from your browser address bar. It should look like:
https://docs.google.com/spreadsheets/d/1A2B3C4D5E.../edit?usp=sharing
4Worksheet Tabs & GID Parameter
Sync questions from specific worksheet tabs inside your spreadsheet.
Google Sheets identifies different sheets/tabs inside a single spreadsheet file using the gid parameter at the end of the URL (for example, ?gid=1847192).
- To import a specific worksheet tab, navigate to that sheet in your browser and copy the entire URL including the
gid=...segment. - If your sheet URL does not contain any
gidparameter, RxQuiz defaults to syncing the first tab (gid=0).