Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member

Adding users

From: Google Apps for Educators

Video: Adding users

Now that we've verified our domain, the next step is to go And under format I'm going to go ahead and scroll all the I'm then going to click Upload and Continue.

Adding users

Now that we've verified our domain, the next step is to go ahead and add some users to our Google Apps For Education account. Now before I get started, I'd like to point out one difference between my Admin console and your Admin console. If you've just set up your Google apps for education account, then you'll notice right above all of these icons, you have another box that's open. This is where Google app is walking you through the setup process. The reason I'm choosing to not use the setup process versus just clicking on the actual icons, is once you're done with the setup, that box will disappear.

If you know how to go into each one of those areas individually, then you can always update or change those settings at any additional time. If you'er at the second step of your setup process which is to add users, you can go ahead and click on the Add Users Button at the top of your screen. If not, let's go and click on the Users icon on the left hand side of our Google admin console. Here we are at our Users homescreen. Here I can hover above any single user and I can see some basic information about them. Currently I have only one user in the system, and that is myself.

As I hover above it, I can see this is admin@orangevalleyschool.com and I can also see that from this screen, I can choose to reset passwords for each individual user. When it comes to adding new users, there's several ways to do this. Let's go and click on the Add More Users icon in the upper right hand corner. Here Google gives me several options for how I can add users. I can either add them manually where I'll type in an e-mail address for each individual user, add their first and last name and a password. Or I can add several users at once. If your'e using Google Apps for Education for your entire school, adding several users at once can save you a lot of time as opposed to hand keying each individual entry.

For this video we're going to talk about how to take an excel spreadsheet and quickly turn it into the required CSV file, so that we can add our entire staff in one click of the mouse. Let’s go ahead and click next to Add Several Users At Once and then click Continue. Here Google is telling us how we need to set up our spreadsheet in order to create the comma separated file that will work perfect for this single batch upload. As you can see the first column has to have e-mail addresses. The second and third column has to have the first and last name. And the fourth column needs to have the password. We're going to go ahead and format an Excel spreadsheet.

Learn how to save it as a CSV, so that we can quickly upload our entire staff. To do that, let's head over to Microsoft Excel. Here I have a file open called Email Lists, and it's in XLSX, or Microsoft Excel File. This is available in chapter one of the Exercise Folders. Inside of this Excel spreadsheet, I have some fake staff members that we're going to go ahead and upload for this particular Google Apps account. I started by importing their first and last names in the second and third column. What I have then done is taken the first initial, followed by the last name, to create an email address.

The email address is @orangevalleyschool.com, which is the same domain that I had verified inside of my Orange Valley School's account. I've also added a password which is standardized for every single user. This is school123. The reason I've taken this very systematic approach to creating the e-mail addresses, is once I've uploaded everyone. I can tell each individual staff member that their way to log in is to use their first initial, last name @orangevalleyschool.com, and that their initial password is school123. This way, I don't have to worry about meeting with each individual person to give them a unique password.

In addition to this, when I first upload the CSV file, each one of these users is going to be prompted to change that school123 password upon their first login. So if I allowed my staff to select a password and then built into the system, they would just be forced to change that password the first time they logged in. So I do recommend setting a standardized password initially. And once every single member's logged in, that will be changed which makes sure that they can't access each other's accounts. Now that I've verified that my XLSX file is properly formatted, let's go ahead and turn it into a CSV file.

I'm going to do that by clicking on File, selecting Save As. And under format I'm going to go ahead and scroll all the way down to Windows Comma Separated File or a CSV file. Now you'll notice in the Exercise Folders that there is currently a CSV file as well as an XLSX file. If you're doing this for your own school, I highly recommend only editing the Excel file not the CSV file. In fact you'll see once I click Save. And I'll choose to replace the current one that's there. Microsoft Excel is actually going to prompt me to tell me that the workbook contains limited features.

That's because there's a lot of limitations to the CSV file versus the Microsoft Excel file. So if you open up the CSV file and try to make changes, you may not have the same result as if you start with a Microsoft Excel file. Let's go and click Continue. At this point, we've already created our CSV file. All we have to do is head back to Google. We're going to go and scroll down, to choose the CSV file we created. I'm going to select the CSV file from the chapter 1 folder of the Exercise Files, and click Open. I'm then going to click Upload and Continue. So Google's gone through, and it's read our file, and it's now showing us the first five entries, so we can double-check to make sure everything looks good.

I see the email addresses are coming through on the left-hand side, first and last names look good, and the password's coming through as well. Let's go and click Confirm and Upload. At this point Google is taking our CSV file and it's automatically creating all of the users that we have in there. What I can do is use the Users dropdown menu, I'm going to click on Users again, and come back to my main Users homepage. Here I can see that all those users have been built into the system. If I hover on any individual user I can see that got the proper email address. I can also choose to reset their passwords. We've successfully, quickly added a giant list of users using the CSV file to our Google Apps for Education Account.

Show transcript

This video is part of

Image for Google Apps for Educators
Google Apps for Educators

36 video lessons · 4546 viewers

Aaron Quigley

Expand all | Collapse all
  1. 2m 47s
    1. Welcome
    2. Things to know before watching this course
      1m 30s
    3. Using the exercise files
  2. 18m 22s
    1. What is Google Apps for Education?
    2. Setting up Google Apps
      4m 27s
    3. Verifying your domain name
      2m 40s
    4. Adding users
      5m 30s
    5. Customizing Google Apps
      4m 51s
  3. 26m 11s
    1. Configuring Gmail
      7m 37s
    2. Gmail communication
      5m 5s
    3. Creating a school signature
      3m 56s
    4. Archiving school communication
      2m 0s
    5. Sending large attachments
      3m 5s
    6. Using common shortcuts
      4m 28s
  4. 16m 12s
    1. Collaborating with calendars
      4m 47s
    2. Adding office hours with repeating events
      4m 48s
    3. Creating event invitations
      3m 0s
    4. Managing alerts
      3m 37s
  5. 8m 8s
    1. Understanding Google Drive
      1m 44s
    2. Creating a lesson-planning workflow
      3m 21s
    3. Centralizing school documents
      3m 3s
  6. 13m 6s
    1. Understanding Google Docs
      2m 30s
    2. Collaborating with Google Docs
      3m 10s
    3. Surveying other teachers
      7m 26s
  7. 26m 2s
    1. Getting started with a collaborative planning website
      3m 6s
    2. Adding collaborators
      1m 39s
    3. Adding pages
      3m 55s
    4. Styling your website
      5m 14s
    5. Styling individual pages
      4m 49s
    6. Adding dynamic elements for user interactions
      3m 55s
    7. Publishing your website
      1m 55s
    8. Google Sites in the classroom
      1m 29s
  8. 8m 14s
    1. Adding educational apps
      3m 6s
    2. Using YouTube for education
      2m 27s
    3. Teaching with Google Scholar
      2m 41s
  9. 45s
    1. Next steps

Start learning today

Get unlimited access to all courses for just $25/month.

Become a member
Sometimes @lynda teaches me how to use a program and sometimes Lynda.com changes my life forever. @JosefShutter
@lynda lynda.com is an absolute life saver when it comes to learning todays software. Definitely recommend it! #higherlearning @Michael_Caraway
@lynda The best thing online! Your database of courses is great! To the mark and very helpful. Thanks! @ru22more
Got to create something yesterday I never thought I could do. #thanks @lynda @Ngventurella
I really do love @lynda as a learning platform. Never stop learning and developing, it’s probably our greatest gift as a species! @soundslikedavid
@lynda just subscribed to lynda.com all I can say its brilliant join now trust me @ButchSamurai
@lynda is an awesome resource. The membership is priceless if you take advantage of it. @diabetic_techie
One of the best decision I made this year. Buy a 1yr subscription to @lynda @cybercaptive
guys lynda.com (@lynda) is the best. So far I’ve learned Java, principles of OO programming, and now learning about MS project @lucasmitchell
Signed back up to @lynda dot com. I’ve missed it!! Proper geeking out right now! #timetolearn #geek @JayGodbold
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.

Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ .

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

Join now Already a member? Log in

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.

Mark all as unwatched Cancel


You have completed Google Apps for Educators.

Return to your organization's learning portal to continue training, or close this page.

Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member ?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferences from the dropdown menu.

Continue to classic layout Stay on new layout
Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Learn more, save more. Upgrade today!

Get our Annual Premium Membership at our best savings yet.

Upgrade to our Annual Premium Membership today and get even more value from your lynda.com subscription:

“In a way, I feel like you are rooting for me. Like you are really invested in my experience, and want me to get as much out of these courses as possible this is the best place to start on your journey to learning new material.”— Nadine H.

Thanks for signing up.

We’ll send you a confirmation email shortly.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.