Google and it's ever expanding list of products are part of the everyday lives of many people. Most of the people like me, who uses these products are using it because it makes our lives easier to manage. From personal emails to mass collaborations on Google Docs, Google's products is very much part how I manage my day to day work or schedule.
One of the most commonly used product for me is the Google Calendar(G Cal), most of my scheduling be it for work or personal reminders is done though G Cal either on the web or through my phone. As I study part time at Unisim, one of the things I use G Cal for is to keep track of all the schedule for school. From class timing to exams and assignment due dates, as useful as G Cal as it maybe when it comes to mass input of items is still very time consuming. However there is a way of shortening the input time, we can do that by importing CSV files into the calendar. This method does not save a lot of input time if there are not many items to add, however it does provide a very good overview on the data that you are keying in. So below is my guide on how to import CSV into G Cal.
One of the most commonly used product for me is the Google Calendar(G Cal), most of my scheduling be it for work or personal reminders is done though G Cal either on the web or through my phone. As I study part time at Unisim, one of the things I use G Cal for is to keep track of all the schedule for school. From class timing to exams and assignment due dates, as useful as G Cal as it maybe when it comes to mass input of items is still very time consuming. However there is a way of shortening the input time, we can do that by importing CSV files into the calendar. This method does not save a lot of input time if there are not many items to add, however it does provide a very good overview on the data that you are keying in. So below is my guide on how to import CSV into G Cal.
The Format
First things first, some of you might be wondering what in the world is CSV? CSV is the abbreviation of Comma Separated Values, CSV basically stores data from rows and columns as plain text separated by commas or some other special characters. This data can be interpreted easily by programs or applications. We can create CSV files by using MS Excel or a similar program like Google Sheets. This example is done using Google Sheets.
To start off you need to create a new sheet with specific column headers as the table below, the header has to be followed in the same order as well be typed in the exact same way as well, as G Cal is case sensitive when important CSV.
To start off you need to create a new sheet with specific column headers as the table below, the header has to be followed in the same order as well be typed in the exact same way as well, as G Cal is case sensitive when important CSV.
Editing the CSV/Table
Basically you can just start keying in the details to your events, you just need to know the format of the date and time, below is a screenshot of an example of how I upload my schedule to G Cal.
DID YOU KNOW?!
Maybe you do, but I came across this function on Google Sheets which I think its good for planning schedules or in this case good for repetitive schedule. For example if you have a weekly program(repeats every 7 days) what you do is type in the first date and for the 2nd row you can simply type in the formula
"=(Cell of first date) + 7" eg. "= B2+7" and Sheets automatically add in the 7 days then simply drag the cell down like you would in normal excel functions and voila you have all the dates you need which are nicely a week apart.
"=(Cell of first date) + 7" eg. "= B2+7" and Sheets automatically add in the 7 days then simply drag the cell down like you would in normal excel functions and voila you have all the dates you need which are nicely a week apart.
Exporting as a CSV File
Uploading to your Google Calendar
Last step, simply select the CSV file you have downloaded just now and select the calendar which it will be imported into.
And there you have it how to go from Excel to Google Calendar.