How to Go from ChatGPT to Gimkit (or anything that uses a CSV)

How to take questions you generate in ChatGPT to Gimkit.

What if you could create multiple choice questions inside ChatGPT and then export into Gimkit? Quizizz? Other apps? Why yes you can! In this post, I will demonstrate how I helped our science teacher create some questions in ChatGPT. Then, how we exported them and pulled them into Gimkit! 

This can work for any tool that is CSV. To keep it simple, I'm using Google sheets but you can use Excel. Also note that I'm on a Mac but I'll include PC instructions.

Table of Contents

Step 1: Determine the type of CSV format that your tool needs.

So, first we created a ten question multiple choice with an answer key. But then, Jessica, our middle school science teacher, asked this question, “Can I take this into Gimkit?”

And I realized that ChatGPT does do CSV exports.

So, I went to Gimkit to determine the format it needed for the CSV Input.  Quizizz is a separate format, so I'll do that one separately.

The import from spreadsheet option allows importing the csv into Gimkit. You'll need this.

The import from spreadsheet option allows importing the csv into Gimkit. You'll need this.

So, first I went into Gimkit and downloaded and opened their template into Google Sheets by opening it and clicking “New Kit” –> Import from Spreadsheet and then I downloaded the spreadsheet. 

Gimkit import spreadsheet
Gimkit import spreadsheet that I found just by looking at their sample import templates inside Gimkit.

Step 2: Generate Questions Relating to Your Topic

In my experience, it is easier to get good questions if you have already been “talking” to ChatGPT about your topic.  I would make sure that it understands what you're teaching, the objectives and such. In this case, Jessica and I had been generating ideas, and project ideas, and had a multi-prompt “conversation” about her lessons around this topic. 

Don't for one second think that ChatGPT is doing the work of teaching. As I've said multiple times, human intelligence can be multiplied by ChatGPT. However, when you do not have knowledge of a topic, you do not know how to prompt for that work. 

So, after we found the questions we wanted, we used this prompt. If you are prompting without conversation, you'll have to have much more information than this. (I'll do a separate post for science teachers on another day!)

Notice that the format is the names of the columns.

I want to give a quick quiz about the four space disasters that is 10 multiple choice questions with four answers. I want a CSV output in this format: Question, Correct Answer, Incorrect Answer 1, Incorrect Answer 2, Incorrect Answer 3 but do not include the number in the question.

CSV output with questions that I'll insert into Gimkit
CSV output with questions that I'll insert into Gimkit

Step 3: Save the CSV onto your computer as a CSV File.

So, when you copy the CSV code, then it needs a place to go.

I opened text edit on my Mac. (Tip: You have to go into preferences and tell it to open in plain text.)  On a PC I would use the free Notepad++.

Then, I just go in and paste. Then, I click File and save and save it as gimkit-space.csv. You can name it anything but it must, I mean MUST, end in csv.

 

I used TextEdit on my Mac, but had to go into Preferences and set it to "plain text" before I opened a new document to paste in the CSV code.
I used TextEdit on my Mac, but had to go into Preferences and set it to "plain text" before I opened a new document to paste in the CSV code.

Then, after I saved it, it ended in CSV and I saved it on my computer.

Step 4: Go Back to Your Google Sheet and Import the CSV

File --> Import inside Google Sheets

File –> Import inside Google Sheets

Now, all you have to do is go back to the Google Sheet and go to File –> Import.

When you import it, import it as a NEW SHEET inside the Google Sheet Template. It is OK, this is the best way to do it!

Now import the CSV into a New Sheet
Now import the CSV into a New Sheet inside the Google Sheet.

Step 5: Copy the Questions and Answers from the New Sheet into the Template Sheet

This is important. Make sure the import sheet headings look exactly as the template that was downloaded. This way it will import properly. In this example you can see my second sheet. I'm just copying the questions and answers as I've highlighted.

Now, I'm copying from the second sheet onto the original first sheet in the template.
Now, I'm copying from the second sheet onto the original first sheet in the template.

Now I will paste into the first sheet.

I pasted the items into the first spreadsheet.

Step 7: Check and Edit Your Data

Now, we had already checked our questions and answers before we had created the CSV but I have to emphasize this.

ALWAYS CHECK THE QUESTIONS AND ANSWERS.

ChatGPT is a Large Language Model. It studies humans. Humans make mistakes. ChatGPT can make mistakes too. In this case you just have to check the question and the first column which is the correct answer. 

Just fix the mistake by typing in the spreadsheet, and when you're happy, go to the next step.

Step 8: Delete the Second Spreadsheet

Truthfully, you probably don't HAVE to do this. However, I just wanted to keep it simple and understandable.

click the up arrow and delete the second spreadsheet.
click the up arrow and delete the second spreadsheet.

Step 8: File and Download as a CSV

File download as a CSV.
File download as a CSV.

Step 9. Upload your CSV into Gimkit

Import from Spreadsheet and then upload the file in Gimkit. Then, you're done!

Import the CSV file into Gimkit
Import the CSV file into Gimkit

Viola!

Newly Created File
Newly Created File

Never miss an episode

Get the 10-minute Teacher Show delivered to your inbox.

Powered by ConvertKit
Facebook
Twitter
LinkedIn
Pinterest
Picture of Vicki Davis

Vicki Davis

Vicki Davis is a full-time classroom teacher and IT Director in Georgia, USA. She is Mom of three, wife of one, and loves talking about the wise, transformational use of technology for teaching and doing good in the world. She hosts the 10 Minute Teacher Podcast which interviews teachers around the world about remarkable classroom practices to inspire and help teachers. Vicki focuses on what unites us -- a quest for truly remarkable life-changing teaching and learning. The goal of her work is to provide actionable, encouraging, relevant ideas for teachers that are grounded in the truth and shared with love. Vicki has been teaching since 2002 and blogging since 2005. Vicki has spoken around the world to inspire and help teachers reach their students. She is passionate about helping every child find purpose, passion, and meaning in life with a lifelong commitment to the joy and responsibility of learning. If you talk to Vicki for very long, she will encourage you to "Relate to Educate" or "innovate like a turtle" or to be "a remarkable teacher." She loves to talk to teachers who love their students and are trying to do their best. Twitter is her favorite place to share and she loves to make homemade sourdough bread and cinnamon rolls and enjoys running half marathons with her sisters. You can usually find her laughing with her students or digging into a book.

All Posts »

1 comment

Sharing Diigo Links and Resources (weekly) | Another EducatorAl Blog April 23, 2023 - 7:58 pm

[…] How to Go from ChatGPT to Gimkit (or anything that uses a CSV) […]

Reply

Leave a Reply

[script_20]

This site uses Akismet to reduce spam. Learn how your comment data is processed.

The Cool Cat Teacher Blog
Vicki Davis writes The Cool Cat Teacher Blog for classroom teachers everywhere
-
00:00
00:00
Update Required Flash plugin
-
00:00
00:00