keronbk.blogg.se

1. Google sheets login how to#
2. Google sheets login update#
3. Google sheets login code#
4. Google sheets login download#

This way, you’ll have a master list in case a student forgets his or her information. Once you’ve downloaded your CSV, you can add additional information to the spreadsheet, such as the name of the student who gets each login. Once you have this file, you can upload it to the service of your choosing.

Google sheets login download#

To download a Google Sheet as a CSV file, click File > Download as > Comma-separated values (.csv, current sheet). Once the script runs, you’ll see a list of fun, unique passwords that are easy for kids to type and remember.įor more details on using this add-on, including customizing the words used to create passwords, check out this post. The first time you use the add-on, you’ll need to authorize it to run. Next, open the “Password Generator” menu at the top of the screen next to the help menu and click “Create passwords”. First, highlight the cells you’d like to fill with passwords.

Google sheets login code#

In the template, I’ve included the code for an add-on to generate fun, kid-friendly passwords.

This technique also works in Microsoft Excel. Once you release the mouse, each cell you dragged over will automatically be filled with the base username and an incremented number. Click on the cell and then click and drag the square in the bottom right corner. In the cell you’d like to use for the first username, type the base username followed by a 1 (e.g. Google Sheets makes it easy to generate these sequential usernames. From my example, usernames for my students would be 2019MrKCoding1, 2019MrKCoding2, 2019MrKCoding3, etc. Once you have a base, add a sequential number to the end for each student to guarantee a unique username. For example, I might make my base username 2019MrKCoding.

Google sheets login update#

This way, I can use the same pattern in future years and just update the year. I also incorporate the current school year. This makes sure the usernames all follow the same pattern so it’s easy for me to identify my students.

I like to start with a username base by choosing some unique word or combination of words (such as your room number, your school’s mascot, the name of your class, etc.). In most cases, you’ll also need to make sure that your usernames are unique across the whole website/service. Generating usernamesįor online services where usernames will be listed publicly, make sure you don’t use students’ names, school ID numbers, or any other information that could identify them. It should NOT contain titles for the columns. With Scratch, the first row should be the first pair of username and password. For example, Scratch requires a two-column CSV where the first column contains the usernames and the second contains the passwords. The copy will include the add-on for generating passwords.Ĭheck with the service you’re using to see what information needs to be in which column. Make a copy of this Google Sheets template. Most spreadsheet apps and programs can export to the CSV format. CSV files only contain data without any formatting such as fonts or colors.

The information in a CSV is often represented as a spreadsheet (e.g. What’s a CSV?Ī Comma Separated Value (CSV) file is a way to store information.

Google sheets login how to#

In this tutorial, I’ll show you how to use my Google Sheets password generator add-on to quickly generate a CSV file with usernames and passwords. However, it requires that you have a list of usernames and passwords. This is much faster than creating accounts one at a time. Many online services, such as Scratch, allow you to upload a CSV file with students’ usernames and passwords to create accounts in bulk.