Make Your Own Set of Flashcards

Google Sheets

Step 1: Modify the Google Sheet Template

  • Make a copy of this template. (You'll need to sign-in with your Google account.)
  • Edit the Side1 and Side2 text. Enter as many terms as you want.
    • Choose from red, orange, yellow, green, blue, purple, pink, brown, and gray for card and text colors. Leave color options blank for black text on white cards.
  • Name your set of flashcards by changing the name of the worksheet (at the bottom).
  • Do not edit any cell with a blue background.

Step 2: Publish Your Spreadsheet

  • Go to File, Share, Publish to web, then click Publish.

Step 3: Get Your Link

  • Click on the Get the Link Here tab of the template (at the bottom).
  • Click on the link to view your Flippity flashcards.

Step 4: Bookmark and Share

  • Bookmark the page to find it again quickly.
  • Share the link with anyone you want to view your flashcards.

Frequently Asked Questions

How do I make changes to my cards?

  • Make sure Automatically republish when changes are made is checked, then go ahead and make changes to your Google Spreadsheet.
  • Your changes will automatically be reflected in the Flippity Flashcards, no need to get a new link.
    • Changes may take up to 5 minutes to appear in your link.

What if I want to delete my flashcards?

  • Simply click Stop publishing under File, Publish to the Web…
  • Or delete your spreadsheet altogether.

How do I get the audio to work?

  • Select the appropriate spoken language in cells A2 and B2 on the template.
    • Audio works best using Google Chrome and Safari on iOS (iPhones and iPads). Voices and pronunciation may vary.
    • Non-English languages may not work properly unless you're using Google Chrome on a desktop, laptop, Chromebook, or Android device.

How do I get pictures on the cards?

  • Just paste the URL (address) of a picture you find on the web in the appropriate cell.
    • URLs must end in ".gif", ".png", ".jpg", ".jpeg", or ".webp".
    • You cannot use Google Drive to store your images.
    • You can use Google Drawings. Use the "Publish to the web…" link.
    • Images are automatically resized to 220 pixels high.
    • Smaller images load quicker.

How do I embed YouTube videos?

Can I use EquatIO to add math equations to my flashcards?

  • Yes, but after you insert your equation images into the spreadsheet, you'll need to make a few changes:
    • E.g. change =IMAGE("") to
    • Tip: Once you have inserted all your EquatIO equations, use Find/Replace to remove all instances of
      =IMAGE(" and ")
    • EquatIO Flashcards Demo
    • EquatIO Flashcards Demo Template

Can I use Desmos graphs in my flashcards?

Can I embed my own audio recordings?

  • Yes, by using
    • Record or upload your audio and click "Save."
    • Copy the link you see under "Sharing options" and paste it in the appropriate cell.
      • (The link should look like this:
    • (Vocaroo recordings expire after a few months.)

Can I modify the text on my cards in any way?

  • You may include basic HTML tags (but incorrect coding may cause problems).
  • (W3schools has many great tutorials on HTML, including how to make links.)

Is there a way to print out my flashcards?

  • You can print out a list of your flashcard terms, but It's nearly impossible to generate a double-sided document that properly matches up the terms front to back.