THIS POST MAY CONTAIN AFFILIATE LINKS. PLEASE READ OUR DISCLOSURE  FOR MORE INFO.

how-to-easily-create-your-semester-schedule-in-google-calendarStudents often say that it is difficult to stay on track with their schedule. Similarly, procrastination is a common issue as well.  We have addressed the main approaches to overcoming procrastination in our previous post.

In the beginning of a semester, every student receives a syllabus for each class he or she takes. As the semester progresses, students try to make time for studying, or at least not to let the due dates slip through their fingers.

The pile of tasks on the to-do list is growing exponentially, and by the time the midterms come the stress level is on high and it’s not clear anymore whether we are swimming or drowning in that pile.

How do we get to the point of being overwhelmed? Remember the familiar problem with “not enough time” or “waiting until the last minute?” There are many more reasons for not completing the semester successfully.

The solution is obvious. You need time! Well, let’s get it.

In this video, I will show you how to import a list of events into  Google Calendar from a simple Excel spreadsheet.

Some of you may prefer to keep all study-related information separate from the rest of your life. Then, you need to read our guide on how to organize your calendar in My Study Life. It is a separate online planner for everything related to studying. Because it doesn’t sync with Google Calendar, your school-related events won’t mix with everything else if that’s what you want.

1. Create a New Calendar for the Current Semester

  • Open Google calendar.
  • In the top right corner, you can see the “Create”, “Mini Calendar”, and “My Calendars” buttons.
  • Let’s create a new calendar. Click on drop down button and select “Create New calendar”.

  • Type in the calendar name and its description.

When you are creating your calendar for the semester, allocate time for all your lectures, assignments, and study time. Often, assignments and homeworks get on our to-do list without time allocation. They show up there only as a reminder that the assignment is due, say, at 11:59pm on Sunday.

It creates a skewed image of the total required study time. Adding estimated study time on your calendar will help you plan other activities better. You will be able to see the entire schedule in front of you and make better time-management decisions. As a result, you will feel more relaxed knowing that you are on top of it.

Here is another trick that you may find helpful. You don’t have to follow the schedule exactly. Once a time slot is created, it’s easy to move it from one time to another. You can be flexible within the structure of the calendar.

Also, I recommend creating a separate calendar for each semester because it’s easy to delete just that one calendar after the semester is over and start a new one.

2. Prepare an Excel Template Using Your Syllabi

Google has a specific format for an Excel file with the event we would like to add to a Google calendar. In short, the file must be saved in Excel as a comma-separated values (.csv) format and must contain specific columns.

Let’s take a look at my template.

  • Column A is called “Subject”, and it contains the names of every event I want to add. I added various events here to provide variety.
  • Columns B and C are called “Start Date” and “Start Time”.
  • Columns D and E are “End Date” and “End Time”.

When event’s ‘Start Date’ and ‘End Date’ are the same (the event occurs on the same day), leave column D empty.

  • Column F is called “All Day Event”. It can take values of TRUE or FASLE. Therefore, enter TRUE only for all-day events.
  • Columns G and H are “Description” and “Location”. They add additional details for the event.
  • Column I is called “Private”, and it can take values of TRUE or FALSE as well. I set my calendar to public. Therefore, all values in my column ‘Private’ are set to FALSE.

Do not delete any columns. Each column is important to properly import these data into Google Calendar.

When you are done, save the document as a comma-separated values document (.csv).

3. Import the Created Template with Multiple Events

  • Hover your mouse over the drop-down menu next to “My Calendar”.
  • Select “Settings”.
  • In the new window, scroll down, and click on “Import Calendar”.
  • In the new pop-up window, you will see an option to choose the file that contains all events. That is our template. After selecting the file, you can choose the calendar from the drop-down menu of available calendars. All events will be imported into the calendar you choose.

  • Click on “Import”.
  • A new window will pop up with the confirmation stating the number of imported events. We got 37 events.

  • Close the notification window and return to the calendar.

Overview

Let’s look at the events in our calendar using different viewing options located in the top right corner.

  • Month view. It is really convenient to rearrange the tasks in this view. Based on other activities, just dragging and dropping an event is much easier than creating a new one.
  • Agenda view. It shows events as a list. It is convenient to check whether there are important events soon, expand all events for a quick edit, and collapse all events back. Click on “Today” in the top left corner to come back to the original date. Agenda view can be helpful because it is easy to print out upcoming events. Hover your mouse over the “More” button in the top right corner to select “Print” or “Refresh” options.

Conclusion

Now you know how to create a new calendar and import a list of events from an Excel spreadsheet. As you can see, it saves tons of time on manually entering events that are similar into Google calendar. Of course, it doesn’t mean you can’t add more events later, but most of the work is done when you prepared an Excel spreadsheet.

Download our Excel template and please subscribe to our newsletter. We send out useful college-related information.

Thank you for reading!