How do I upload questions from a spreadsheet?
Creators can upload a CSV file with one question per row on My creator page. Save your Excel or Google Sheet as CSV first. One file makes one bank.
Uploading a spreadsheet is a creator tool. It is on My creator page, under Upload questions from a spreadsheet. Other teachers can use 📂 Import a bank instead. See Can I import questions from a PDF, Word file or worksheet?
Get the file ready
- One question per row. Up to 100 rows (a bank holds 100 questions), and up to 1 MB.
- Columns:
questionandanswer. You can also addchoice_atochoice_d, andimage_url. - The answer can be the right choice's text, or its letter.
- A picture must already be on the Game Room. Paste its link from My Question Banks. Links to other sites are refused.
- Save the sheet as CSV. In Excel: File, Save As, CSV. In Google Sheets: File, Download, Comma-separated values.
The page has a Download a template link with the right columns.
Upload it
- Choose your CSV file and type a title for the new bank. Pick a grade and subject.
- Tick These are my own questions, not copied from copyrighted material.
- Tick Also list this bank in the public library if you want to share it.
- Press Check the file to see any problems, then press Create the bank.
A bank plays as multiple choice when every row has at least 2 wrong answers. If some rows have fewer, it plays as typed answers.