How to Create Random Name Selector, Seating Charts and Group Selectors from a Single Google Sheets with!

Posted on Updated on

Ever wanted to take your list of students and quickly pick a random name for activities, prizes or other reasons? Want to use that same spreadsheet o create seating charts, pair students in groups? Want to use a simple google spreadsheet of terms to create online flashcards and review games from the same spreadsheet?

  1. Go to, 
  2. Click on their template and then
  3. click the Make a Copy button on the next screen.
  4. In the first two columns fill in the names or terms and definitions but do not change the header row
  5. When done, click on the second spreadsheet at the bottom.
  6. Follow the instructions
  7. Go to File and Publish to the web
  8. Copy the link into the highlighted box on the second tabbed sheet
  9. A new link appears below
  10. Click that and watch the magic begin!

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s