Open Flashcards

Turn your Google Sheets into online flashcards

Public flashcards – no login needed!

What is this?

Open Flashcards is a free tool that allows you to generate and view sets of flashcards, one of the most effective tools for improving your memory. Flashcards are very flexible and can be used for a range of purposes including improving your vocabulary in a new language, learning times tables, memorizing an important speech through prompts, or just about any other purpose you can think of.

How does it work?

Open Flashcards works by making use of your existing Google Sheets. Taking the information from the Sheets that you import, a set of flashcards will automatically be generated. As the application does not store the information in any sheet, any updates to your sheet will automatically be reflected when you view the card on Open Flashcards.

Within the application you also have a range of options for managing and interacting with your Sheets. Any Sheets that you currently have access to in your Google Drive will be available for viewing in the application. Furthermore, the permissions set in your Drive will also be reflected here. If you have shared a Sheet with someone, they will also be able to view the Sheet when they log into Open Flashcards. Correspondingly, you will also be able to view all files others have shared with you.

Finally, you also have the option to share your Sheet publicly. This will update the permissions in Google Drive so that anyone with the correct link can view the file, and so that anyone who logs into Open Flashcards will be able to view (but not alter) your Sheet to create flashcards.

Getting Started

To get started, firstly use the button at the top of the page to login with your Google account. Once logged in, there are several options available:

  • Import an existing Google Sheet from your Google Drive. The Sheet only needs to have two columns (one with the values for the front of the cards, one for the backs). Don't worry if the Sheet has more than two columns, you will have the option to select which columns are used and how.
  • View one of the public Google Sheets shared by other users. Keep an eye out for new features coming soon that will allow you to rate and comment on public sets.
  • Create a new Google Sheet through this application (coming soon).