Convert Google Calendar to Excel

UPDATE: Now we have a web version of Gcal2Excel! It can be found here. No installation, no hassle! It converts description and location data as well

I am not sure if someone other than me (and some of my fellows) needs this or not but last weekend I came up with a Google Calendar to Excel Converter!

Yeah, of course there was a need behind this small innovation. I have to log my working hours in Google calendar everyday and after every fortnight have to provide an excel sheet containing my working hours to the authorities. Not surprisingly, some of my colleagues also have to do the same thing. After every fortnight, we have to go through our Google Calendars (which we maintain regularly) and then have to write down all the working hours and task titles and then by summing them up we have to find out our total working hours for that time period. It’s really a pain and we needed something to do this work for us automatically.

I was badly in need of such application and hence during the last weekend I coded a Java application that writes down all Google Calendar events of a specified time period to an Excel file. It’s really a life saver and hopefully it’s gonna help my fellow coders to save their lives to.

Thanks to Google Data API, JExcel, Ostermillerutils (for encryption) and JCalendar libraries without them it would not be possible to make it in such a short time. I have uploaded the (undocumented!) code in googlecodes, here is the url of the svn repository (if you are interested). It may not help everyone out there but this code can be easily extended to a complete ‘Salary Automation System using Google Calendar’. You can also download the executable .jar file from here and this app runs only on JRE5.

UPDATE: Now we have a web version of Gcal2Excel! It can be found here. No installation, no hassle! It converts description and location data as well

About this entry

You’re currently reading “Convert Google Calendar to Excel,” an entry on anupom.toString( );

Published:: September 27, 2007 / 10:44 pm

Category:: Java, google api, life optimization, open source

Tags:

junal 9.28.07 / 8pm

Good job….hope it can also make our life easier in near future

Gavin Jones 1.5.08 / 1am

Brilliant, Many thanks

Tapos 2.19.08 / 4pm

great job. this has make my work easier.

Vincent Duckworth 3.8.08 / 2am

This is an outstanding app but I have a question. What calendar address do you put in…I have tried the xml, ical, and html calendar ids and none seem to work…thoughts?

Stefano 4.9.08 / 9pm

Where can I find the calendar id in the settings?

Eleanor 4.14.08 / 10pm

Thanks so much–this is fantastic! I’m hoping to start using Google Calendar to track my work hours, and being able to export to Excel is a vital piece of that puzzle.

In response to some of the other comments, the Calendar ID is in “Calendar Details” near the bottom. Next to “Calendar Address” there are the XML, ICAL, and HTML buttons, and then next to those, in regular text (not a button), there is a “Calendar ID”. It took me a couple tries to figure it out…

Akjon Bangladeshi 4.23.08 / 11pm

Cool. Thanks Bro. Keep it up.

Juppy 5.14.08 / 7pm

You’re a star! Fantastic I’m using this for something else altogether but the Gcal to Excel feature is just perfect. Many thanks. (Makes you wonder why Google didn’t…. ah well, I’m sure there’s a good reason!)

MM 5.22.08 / 12am

Exactly what I’m looking for!
But when I try to open the url, I am asked to provide my username and password. If I enter these (of my Gmail account) get a 404.

What do I do wrong?
Someone please help me out…contact me via email!

Thanks a lot.

My email address is attached

BR 6.23.08 / 3pm

Thanks a lot for your archive

Jonas 8.4.08 / 7pm

What a lifesaver. thanks so much for making this public, you just saved me a bunch of time. Big thanks from my side!

MM – must enter your username as in your gmail adress and then the calendar id by going to “manage calendars” –> calendar details –>and under “calendar address” it gives you the id for whichever calendar youve got selected.

PlU 8.17.08 / 7am

Thank you so much! I’ve been waiting this to be implement in GCAL for such a long time, but this will do! THANKS!!!!!

Jenine 9.9.08 / 10pm

This is really great. I know nothing about Java, so I wouldn’t know how to expand it. We’re looking to be able to also pull out the description information, and possibly attendee information. We do a lot of training sessions and have to track this information as well. Does anyone know how that might be added?

Anupom Syam 9.18.09 / 1am

Hi Jenine, you can now pull out the description information using the new web version of gcal2excel. you can find it here http://gcal2excel.syamantics.com/

L 9.30.08 / 12am

I had the same issue… Apparently, there is another free app called “WinCalendar” that can also do this along with converting outlook calendars… Yours, however, seems more simple to use (fill in a couple of fields and there it is)

Wolfgang 10.4.08 / 6pm

This doesn´t work, I enter my data, get no error message, but the generated Excel file is always 0 bytes. Any ideas?

Kage 10.9.08 / 8am

Dude!! You are the shizzle!!!

Sankho Mallik 10.11.08 / 9pm

Wow, this was EXACTLY what I needed. All the time I was wasting counting those hours up like a human!

Tobi 10.21.08 / 11pm

Same Problem as Wolfgang. XLS size is allways 0byte. Is there a solution? Thank you a lot!

Nikki 11.19.08 / 2am

I am trying to DL this as this is the exact applicaton I need however when I put in my email address as the username and the calendar ID as the password I get an error, I have tried all email address, calendar address, and password to gmail combinations. PLEASE HELP! Thanks!

Federico 12.7.08 / 5pm

Simply Great!

Rene 12.9.08 / 8pm

Absolutely brilliant. Just saved me a week’s worth of collecting this year’s hours. Is there a statue I can contribute to?

Thanks you so much.

Debbie 1.11.09 / 7am

I am having the same problem with logging in. I am very anxious to try this program, but cannot find my ID…please help!!!

Marijn Depraetere 1.19.09 / 10pm

For those looking for the google calendar ID:

- Find the Google Calendar you want to publish in the ‘Calendars’ tab (lower left of the Calendar homepage).
- Click the down-arrow next to it, and choose ’share this calendar’.
- Click ‘Share all information on this calendar with everyone’.
- Then click ‘calendar details’ and scroll down to ‘calendar address’.
- Copy the Calendar ID which is displayed here.

If you are using only the primary calendar (wich I recommend for sync-purposes) it schould be your primary emailadress: foo.bar@gmail.com or something

Good luck and thank you for this app!

Janet 1.31.09 / 8am

I had some things with this, though it’s the closest brilliance I’ve found to what I need.
1. It wouldn’t get info off my main calendar (the one that’s actually called redguitarpublicity@gmail.com) I had to create a new one to make it work.
2. I had to give it a huge date range to get something in the normal date range. That is, I had an event on Jan 29, but asking it for Jan 1-Jan30 didn’t work. I had to do Jan 1 to Feb 28 to see it at all
3. The deal-breaker–I need to know what the event name and description was in addition to the time and date.

Alas, I am swamped in database learning and can’t climb Java right now or my head will explode. If you have any advice or tweaks, this is still waaaaay better than anything Google has provided.

cheers!

peter 2.10.09 / 6am

brilliant!
exactly what i was looking for.
grazie mille.

shannon 3.4.09 / 10pm

I could really use this, but I am not sure how to open up and use the jar file, any tips?

bbhartley 3.6.09 / 7am

I’d love to be able to make a small change to filter out one type of appt. How do I access your source at Google Code Subversion Repository?

Thanks for doing this!

Anupom Syam 3.6.09 / 5pm

Thanks everyone.

if you want to download the sourcecode then please go to the following page -
http://code.google.com/p/gcal2excel/source/checkout
you will find instructions there on how to checkout the sourcecode using subversion.

Some of you are having trouble running the app itself.
to use this app,
1) first download the .rar file form here
http://gcal2excel.googlecode.com/files/Gcal2Excel.rar
2) extract the .rar file using winrar or some other utilities.
3) download the latest JRE (Java Runtime Environment) from this page http://java.sun.com/javase/downloads/index.jsp
4) now, you can just run this app by double clicking on the Gcal2Excel.jar (which can be found just inside the extracted directory Gcal2Excel).

Please ping me if you have any more query. I am planning to open up a separate site for this project. Please feel free to knock me if you are interested to support this project.

Thanks again!

Picasso 3.11.09 / 4pm

very clever

Greg 3.29.09 / 12am

Thank you! Thank you!!!!!!!!!!

Laurie 4.6.09 / 7am

thankyouThankYouTHANKYOU!!!!

Dave 4.8.09 / 4am

Hi, very nice job, I have a question as i need to import all calendar fields not only hours I would like to know if its possible making some changes in your useful utility.

Thanks in advance

Jay Van Vark 4.14.09 / 5am

This looks very cool, but I can’t get it to work — I would love to be using it!!

Doing it on a mac and the labels are squished on the left — I assume that is Calendar ID, — I have tried the name and the id, but neither work… I always get a quick error of “Error Occured: ‘(”

Any idea what I am doing wrong…?

Could you share your make file…? I would love to tweak things a bit… Thanks!

Popop 4.23.09 / 8pm

Great job ! I wish it could work foe me, but the Excel file is 0 byte…
Tried in Windows XP and Vista.

Sandy 5.15.09 / 12am

Got it to work. Very simple, thanks!

I found another app, called WINCalendar that has alot more options. I prefer the simplicity of GCal2 but Wincalendar has some nice formatting options.

It may be worth adding some formatting options to GCal2.

karlg 5.21.09 / 10pm

Thanks, this program is awesome, really thanks…

perrinel 6.13.09 / 10pm

thanks for this program but when i run it I’ve got an excel file empty (0 ko ) . There is no message error. ???
why ? I use google apps .

ff 6.17.09 / 4am

Thanks! I am eternally grateful for this program

CB 6.25.09 / 2pm

Nice job. Saves me hours a week, and makes the clients happy.
As with some others I am looking at extending this a bit (just starting JAVA so it could take a while) and there are a couple of items I would like to add.
1. Ability to use a proxy
2. Description field included
3. Date broken out seperately on the front (simpler to produce a graph)
4. Specify a file to add the data to.

looks like jxls.jar should handle 2,3,4 any tips on where to look for 1.

Well done

David Wynot 6.27.09 / 10pm

Hello

I try your gcal2excel which would be useful for me.
I am on MAC PPC and it seems work except the excel file is empty.
The ID, wordpass are exacts. No errors

Why ?
Can you show a screen picture of the excel file ?
Thank you
David

Anupom Syam 7.2.09 / 3am

hi david, i am not sure why it’s not working. i don’t have mac so can’t test. are you using google app? people complained that it does not work well with google apps. you can try your gmail account instead.

btw here’s another app that extracts the data from google calendars and creates execl files http://code.google.com/p/google-timesheet/ check if that works for you.

JohnM 7.29.09 / 7pm

Very clever tool. Simple to install and operate.

A bit cheeky of me but a few suggestions
1. I have multiple calendars to compile. Some kind of multi-calendar id feature would be useful – perhaps a tab per calendar or a separate column. Alternatively a drop down list that remembers all the entries.

2. Save to folder box.

David Wynot 7.30.09 / 4pm

Hi Anupom, it doesn’t work on PC too (not only Mac).
I used my gmail account (same as Calendar)
I used the Calendar ID.
I just tried another time on a PC and I have empty sheet which name is my gmail account Timesheet…
Something is wrong in my use cause others users seem happy.
About Google Timesheet, it doen’t match cause I need Google Apps
Thank for your help – David

lokers 8.6.09 / 1am

Amazing how many people work in the same way. I use my google calendar to track hours too and I was doing these calculations manually for a while. Thanks a lot for this useful software.

bert 8.9.09 / 2pm

thanks so much for making this tool, you’ve saved me a lot of time!

Yokhannan 9.2.09 / 3pm

Thanks dude!!

Anupom Syam 9.7.09 / 9pm

I have released a new version of Gcal2Excel a few days back. You can find it in this page http://code.google.com/p/gcal2excel/downloads/list

New features:
a) Description, Location fields (Thanks to Kevin Jordan)
b) Meaningful error messages

Installation:
1) Download gcal2excel.zip from the above mentioned URL
2) Extract the .zip file
3) Run gcal2excel.jar from dist/ directory

Please let me know if you find any issue with this new version or any other problem you are facing. And please keep throwing your ideas to me. I will implement them one by one.

Thanks for your support

Sasha 9.11.09 / 4am

Brilliant! I wish GCal implemented something like this natively though
Thanks again!

anupom 9.12.09 / 11am

UPDATE: Now we have a web version of Gcal2Excel! It can be found here. No installation, no hassle! It converts description and location data as well.

Try it out and please let me know if you find any bug or want some new feature.

Thanks for you support.

Jeroen 9.17.09 / 3am

Dude !! Finally someone with brains, go work for google

Really helped me out. Thnx man.

Anupom Syam 9.18.09 / 1am

thanks bro!

Anupom Syam 9.18.09 / 1am

if you need any extra feature please ping me here.

Phil 9.22.09 / 9am

Wow, what a great app. The jar works perfectly on Mac OS 10.5, just download and double click to run. We just switched to Google App’s and the office manager needs to total time from 15 users Google Calendars each month. Each user has 4 calendars.

Apparently, on a Mac, you can simply duplicate your great app 4 times for each users calendar (or 60 times in total in our case) and the specific calendar information will be retained in each copy of the app, though it would be nice if in one app you could have multiple calendar ID’s for the same User Name (in our case 4 ID’s) which outputs each calendar to the same excel spread sheet with subtotals for each calendar, then a grand total at the end.

Outside of that my only other request would be to have the app default to a 30 or 31 day window for the current month (instead of the current day), or perhaps a check box for default to current day, bi-weekly, or month since bi-weekly or month is how most people run their timesheets. Awesome app.

Anupom Syam 9.22.09 / 9pm

Hi Phil,

Thanks for your comment. I was really curious if this app works perfectly with google app and Mac OS.

I can understand your problem, doing this for 60 times must be a very hectic task. But I am not sure if this is a common problem for many users. Have you tried the online version of this app? You can find it here http://gcal2excel.syamantics.com/ What about adding this feature to the online version as I am currently trying to support the online version only? You know maintaining two different apps that do the same thing is troublesome. Let me know if this will be helpful.

I think defaulting the app to a monthly/weekly/bi-weekly and daily window is a very good idea. I will add this to the online version.

Thanks again.

Phil 9.23.09 / 9am

Anupom, thanks for the quick reply. I think the bosses prefer the the java app as oppose to the online version for control/security reasons though if you’re able to add the multiple calendar export to the online version I’m sure they’ll get over it. In truth, your other project:

http://code.google.com/p/google-timesheet/

Seam’s like it would be perfect, though there doesn’t appear to be an available download, is this functional and if so, how do I get a copy and run it?

Melissa 10.24.09 / 8am

I’m working with confidential information- if I use this app. will I be the only person who is able to see my info?

Jordi 10.25.09 / 4am

What a great app. But, is it a security risk?

I had been looking for a way to look at my calendar and compare it to what _actually_ gets done.

anupom 10.25.09 / 8pm

Guys, sorry for the late reply. I would like to assure you that there’s no security risk in the desktop version. Melissa, you will be the only person who is able to see your info.

See softpedia’s certificates-
http://www.softpedia.com/progClean/Gcal2Excel-Clean-139009.html
http://mac.softpedia.com/progClean/Gcal2Excel-Clean-65488.html

Also read downloadtube’s editor review-
http://www.downloadtube.com/Windows/Office-tools/Gcal2Excel-download.html

Please let me know if you have more queries.

Thanks

anupom.toString( );

Convert Google Calendar to Excel

UPDATE: Now we have a web version of Gcal2Excel! It can be found here. No installation, no hassle! It converts description and location data as well

UPDATE: Now we have a web version of Gcal2Excel! It can be found here. No installation, no hassle! It converts description and location data as well

About this entry

61 Comments

Have your say

Recent Comments

Recent Posts

Trippert !

Tags

Top Posts

Categories