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 GGeneral Explanation
Col HExplanation A
Col IExplanation B
Col JExplanation C
Col KExplanation D
💡 Pro Tip: Options C and D, General Explanation, and all per-option explanation columns are optional. If a question only has 2 options (True/False), leave Option C, Option D, and any unused explanation columns 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: Two levels are available:
- General Explanation (Col G): Shown as a highlighted block below all options after answering — ideal for a single overarching rationale.
- Per-option Explanations (Cols H–K): Slide open on each individual option button, providing targeted feedback per choice.
3Make the Sheet Public
Syncing 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).