Blooket CSV import and Blooket spreadsheet import template, filled from a video lesson

Why is my Blooket CSV not importing?

It is almost always one of four things. The Correct Answer(s) column holds a letter or the answer text instead of a number from 1 to 4. A colored cell in the template was edited, deleted or shifted, often by pasting a whole sheet over it. The file was uploaded as .xlsx instead of being downloaded as .csv. Or a question has a fifth answer in a column Blooket does not read.

The fix is the same order every time. Start from a fresh copy of the template, paste only into the white cells from row 3 down, make every Correct Answer(s) cell a number, keep time limits at or under 300 seconds, and download as Comma Separated Values.

If the upload still fails, try three rows. If three rows import, the problem is a specific row, usually a stray comma inside a cell that a different program saved without quotes. If three rows fail, the problem is the file or the browser, not your questions.

What is the Blooket spreadsheet import template format?

Row 1 is a Blooket title row and row 2 holds eight headers: Question #, Question Text, Answer 1, Answer 2, Answer 3 (Optional), Answer 4 (Optional), Time Limit (sec) with a maximum of 300 seconds, and Correct Answer(s), where you include only the answer number.

Each row after that is one question. Blooket's own example shows the format: What's 3 + 3? with 3 and 6 as the answers, a 15 second time limit and 2 in Correct Answer(s), because the right answer sits in Answer 2. Two correct answers are written as 1,4.

Column J is the one most guides miss. Type typing there and the row imports as a typing answer question, with the answers you entered treated as is exactly matches.

Can you make a Blooket from a YouTube video?

Not inside Blooket. The Set Creator offers typed questions, CSV and Spreadsheet Import, Quizlet Import and, for Plus subscribers, the Question Bank, and none of those reads a video link. Khanmigo, the AI generator Blooket points to, writes from a topic you describe, so you get questions about the subject rather than about what the lesson said.

That is the gap VidQuiz fills. Paste the public YouTube link and it reads the video, then drafts multiple choice questions with four options and the correct one marked, a one line explanation and a timestamp showing the moment each question came from. For a recording that is not on YouTube, paste its transcript instead.

The draft exports as CSV with the options already in four columns, which is the shape of Blooket's Answer 1 to Answer 4.

How many answers can a Blooket question have?

Two to four. Blooket's question types article says each multiple choice question needs two to four answer options with at least one marked correct, and you may mark more than one. The template has exactly four answer columns, so a question with more choices has to be trimmed before it is imported.

A VidQuiz question normally has four options, which fits exactly. True or false questions fit too: Blooket's own advice is True in Answer 1, False in Answer 2, the last two left blank, and Random Order unchecked in the editor so True always sits on the left.

Can I import Quizlet into Blooket?

Yes. Choose Quizlet Import on the Set Creator or Set Edit page, export the Quizlet set as text with a tab between term and definition and a new line between rows, and paste the text into Blooket. The Quizlet set has to be in your own Quizlet library, and a set built with Quizlet Plus features may not copy unless you also have Quizlet Plus.

What comes across is term and definition pairs. A flashcard is not a four answer question, so you still write the wrong answers yourself, which is the slow part of building a good review game in the first place.

How do I turn a video lesson into a Blooket set?

Paste the lesson's YouTube link into VidQuiz, or paste the transcript if the recording lives in your LMS, on Vimeo or on a school drive. Review the questions, edit anything you would phrase differently, and export the CSV.

Open a fresh copy of Blooket's template. Copy the Question column into Question Text and Option A to Option D into Answer 1 to Answer 4, starting on row 3. Paste the Correct Option letters into a spare column on the right, say L, then in H3 enter =CODE(UPPER(L3))-64 and fill it down. A becomes 1, B becomes 2, and so on. Copy column H, paste it back as values, delete column L, and type a time limit into column G.

True or false rows carry no letter, so type 1 or 2 by hand. Move short answer rows to typing questions: answer text in Answer 1, typing in column J. Download as .csv, upload it through CSV Import, and host the set.