Skip to content
Need to learn or teach remotely? Check out our new resources to help you work, learn or teach from anywhere.

1. Introduction to Organize College Applications in Google Sheets

Playback Speed:

Whether you’re about to start applying to colleges, universities, or vocational schools, or you just want to begin exploring information about them, it’s important to take the time to set yourself up for success.

No matter which schools you’re applying to, they all have their own application requirements and deadlines.

In this lesson, you will use Google Sheets to track application materials for the schools you hope to attend.

Tracking your applications in a spreadsheet will help you organize the application process and successfully meet deadlines.

Your spreadsheet can include things like: The list of schools you are interested in, The list of all the application materials required for each school, Important dates in the application process, And anything else you would like to track.

This lesson uses Google Sheets, but you could apply these skills and concepts in any spreadsheet application or even on a piece of paper.

As you complete this project in Google Sheets, you will: Create and title a new spreadsheet, Create a header row with the information you want to track, Type and format text, Format cells, columns, and rows, And use data validation to create dropdown menus.

To work on this lesson, sign in to your Google account.

Open a new tab in your browser, and navigate to

If you are not signed in, do so now.

If you do not have a Google account, pause the video and create one now.

To begin, open Google Drive.

Create a new spreadsheet and rename it.

Then, move on to the next video to begin setting up your spreadsheet.

Now, it’s your turn: Create a new spreadsheet in Google Sheets, And rename it.


  1. Create a new spreadsheet in Google Sheets.
  2. Rename it.