The Spark Between

Thoughts, Projects, Happenings, Ideas
  • Home
  • About
  • SmartBox
  • LiveTrip
  • Calendar
  • Photos

HowTo: Merge Google Calendars Together

Colin M | March 4, 2008 | 2:11 am

Here’s a quick How-To on merging two Google Calendars together, since Googling with the obvious phrases did not get me very useful results.

The Problem: Merge Two (or more) Google Calendars Into One

Let’s suppose that you, like me, have more than one calendar in your Google Calendar, and decide at some point that you want to condense those into one. I was struggling to find a single click solution for this, and then just to find any solution, for quite a while. Then I stumbled on the “Import” feature, and realized that it actually solves all my problems. Here’s how it works.

The Solution: Import one Calendar into the other

Once you see how to do it, it’s a quick task to merge two calendars together. In fact, you can even use this to merge a Google calendar from one account into another.

  1. Log in to your Google Calendar account, and click on the drop-down menu next to your Source calendar. Pick “Calendar Settings” from the list:
    Calendar Settings
  2. Now, scroll down to the bottom and find the Private ICAL address link. Right click on this link and save the file to your Desktop (or other handy temporary location):
    Private ICAL Link
  3. Next, return to your calendar and click on the “Add” dropdown menu at the top of your calendar list, then click Import Calendar:
    Import Calendar
  4. Select the file you just saved from your Source calendar, and choose the Destination calendar you want to import into:
    Import Form
    Then click Import, and you will soon be greeted with the cheery success message:
    Successful Import
  5. And that’s it! Here’s a before-and-after of me combining two calendars to show that it works. (Take a look at Tues, February 12, for example.):
    BeforeAfter
Categories
Howto
Comments rss
Comments rss
Trackback
Trackback

« Enjoying Free Books Thaw »

92 Responses to “HowTo: Merge Google Calendars Together”

Newer Comments »
  1. Paddy says:
    March 5, 2008 at 5:23 am

    Good job!

  2. Michelle Murrain says:
    March 10, 2008 at 12:27 pm

    Thanks for this – it’s great. It saved my life!!!

  3. twelvesteppp says:
    March 15, 2008 at 12:46 pm

    Wonderful — thank you!

  4. Jumalakarhu says:
    April 14, 2008 at 8:42 am

    Hi,

    Great to know about the import function. Still if you want the two to be displayed as separate calendars use the this description
    http://blog.larskjensen.dk/2006/12/18/google-calendar-publishing-multiple-calendars/

  5. SteveH says:
    April 30, 2008 at 10:42 am

    Thanks for this. It saved me a load of work!

  6. PDonaghy says:
    May 7, 2008 at 7:51 am

    Thanks for this excellent little tutorial. It works a treat!! Just what I was looking for :-)
    Also discovered that you can embed several calendars into the one view without having to merge them. This embedding method also retains the original colours of each calendar!!

  7. Ben says:
    May 10, 2008 at 3:34 pm

    Thanks for posting this — exactly what I needed.

  8. Brian says:
    May 14, 2008 at 5:44 pm

    it won’t work for me. what are you saving the ical link as on the desktop in step 2

  9. Colin M says:
    May 15, 2008 at 9:38 pm

    @Brian:
    Save the calendar as an ical calendar file (.ics extension). you can choose any file name that you like, but you will need to remember it and be able to locate it again for step 4.

    If that’s still confusing/not working, try this: right click on the ICAL link, and select “Save As…”. (you may see “Save Link As” or “Save Target As”, those are good too). When the file chooser appears, press the “Up Folder” icon (A folder with an arrow going left and up on it, located near the top of the file chooser window) many times until you reach your Desktop. Now, enter a name, such as “calendar1.ics”. Then follow the steps until Step 4. When you click on “Browse…”, repeat the same procedure: click the “Up Folder” icon many times to reach your desktop, and then select the file you just created, “calendar1.ics”.

  10. Daniel Williams says:
    May 27, 2008 at 10:58 pm

    Thank you, this was very helpful. If only it were so easy to merge gmail accounts!

  11. Colin M says:
    May 28, 2008 at 1:17 am

    @Daniel:
    I suggest using IMAP to merge gmail accounts. (And thanks, by the way, for reading and posting!)

    If you’re looking to do what I think you are looking to do: copy all mail from an old_account into a new_account, then here is what I would recommend, based on what has worked well for me.

    Enable IMAP access to both accounts by logging in, then clicking on Settings->”Forwarding and POP/IMAP”->”Enable IMAP”. Then click [Save Changes] and wait for some time so that Google can enable the IMAP service. (This took about 15 minutes for me… YMMV)

    Now, add both accounts as IMAP accounts to a local mail program, such as Mozilla Thunderbird. The settings you will need are, in brief:

    User: username@gmail.com
    IMAP server: imap.gmail.com
    Port: 993
    Use SSL.

    Once you have added both accounts to your local mail program, simply drag the messages you want to migrate from the old_account to the new_account, in the appropriate folders. This will take some time, as all the messages will be first downloaded to your PC, then uploaded again, but is well worth the wait, because everything (dates, sent addresses, etc) is preserved correctly.

    A few notes:

    You can automatically label all messages that you are transferring in this way by creating a new folder in the new_account’s IMAP section, and dragging the messages to that instead of the Inbox. The name you give the folder will appear as a label back in GMail.

    You can find the “Sent” folder under the special IMAP folder: [Gmail]/Sent Mail

    Good luck! And let me know if any of this is unclearly written; I will try to better explain.

  12. Michael Ubben » Blog Archive » calendars galore says:
    May 28, 2008 at 9:18 pm

    [...] get gsync and synchronise your Google calendar with your Outlook calendar. (found it via here) This and this post [...]

  13. JC says:
    May 30, 2008 at 5:12 am

    Discovered this while searching: merge google calendars

    This is a great tip. Nicely written and nicely done. Thankyou for taking the time to share.

    Cheers,
    JC

  14. SueCr says:
    June 6, 2008 at 10:39 am

    I need to put my tasks into my calendar. Is there any way to do this?

  15. Guy Gur Ari says:
    July 4, 2008 at 7:08 am

    Thanks you so much! Exactly what I needed.

  16. Dawn says:
    July 28, 2008 at 11:47 am

    THANKS SO MUCH!!! I was using the unregistered version of Rainlendar (which I LOVE) to have a calendar on my desktop. Now Calgoo calendar is FREE! But, it only lets you sync 1 calendar with Outlook. And I have to sync Google with Outlook in order for my smartphone to get the info. (Yes, I *COULD* go online and see the Google Calendar with my smartphone, but I want the items in my Today screen)
    Thank you again for the instructions…..IMPORT……how obvious is that?????? Obviously not very, because I (and many others) had to do a search and end up here to find out how!!!

  17. CW says:
    August 3, 2008 at 5:08 pm

    Thanks so much! Just what I was looking for!

  18. Gman says:
    September 2, 2008 at 8:42 am

    Thank you so much, it’s what i am search for

  19. DJB says:
    September 23, 2008 at 9:29 pm

    As many have said, found this while search “merge google calendar” Thanks for clear answer and taking the time, was very helpful – (also, love the header photo – very zen).

  20. bretek says:
    October 1, 2008 at 10:01 am

    Great job!!! And great blog too…this post is very helpful…

  21. Tobias says:
    October 5, 2008 at 4:17 pm

    Thank you – a great help!

  22. Franck Depierre says:
    October 21, 2008 at 3:07 pm

    Great job. Thank you very much.

  23. Rajtastic says:
    November 10, 2008 at 5:17 pm

    Great – I found this searching for ‘merge google calendars’ too.

    One question though – will I need to keep on doing this to keep it up to date?

    Cheers,

    Raj

  24. Colin M says:
    November 10, 2008 at 5:26 pm

    @Raj:

    Yes, if you are making changes to the source calendar(s), you will need to keep doing this if you want your destination calendar to remain updated. Exporting & Importing the calendar(s) like this is a “one-time” synchronization: you copy a snapshot of all the events on the source calendar into the destination calendar one time only.

    If you want to see many calendars in one “view”, you can always add each calendar to your Google Calendar page, but unfortunately I do not personally know of any way to merge them into a single calendar with live synchronization at this point.

    Thanks for reading!
    -Colin

  25. PJ says:
    November 13, 2008 at 6:39 am

    Hi,
    Ive just followed the instructions but at the end of the process I get thefollowing error message…

    Please help? :(

  26. PJ says:
    November 13, 2008 at 6:40 am

    (Block quote doesnt seem to work! ;-)

    error message was…

    Processed 47 events.

    Successfully imported 22 events.

    Failed to import events: Could not upload your events because you do not have sufficient access on the target calendar..

  27. Ryan says:
    November 24, 2008 at 6:17 pm

    Will they be merged on an ongoing basis this way, or is this solution just backward looking?

  28. Justin says:
    December 1, 2008 at 12:54 am

    So helpful! Thanks; if only they made it easier to naturally know how to do it all yourself.

  29. Brian says:
    January 1, 2009 at 6:21 pm

    Thanks for the tip.

  30. LM says:
    January 15, 2009 at 5:31 am

    Thanks a lot, very helpful!

  31. Swaroop says:
    January 20, 2009 at 9:20 am

    Thanks for your help man

  32. ray says:
    January 24, 2009 at 6:24 pm

    It works but it does not remove duplicates. eg. Merging two or more holiday calendars. Common holidays such as Christmas, New Year’s Day, Easter, etc. will not merge together to leave one.

  33. Mike says:
    February 13, 2009 at 6:47 am

    Thank you!

  34. melissa says:
    February 18, 2009 at 3:24 am

    thanks! super helpful!!!!

  35. ak_ranger says:
    April 13, 2009 at 10:35 pm

    If you get an error like this:

    Could not upload your events because you do not have sufficient access on the target calendar..

    The problem is being caused by your primary calendar already having items in it. You must first wipe out your primary calendar before adding the *.ics file.

    1) Save a backup copy of your primary calendar as an *.ics file using the process described here.
    NOTE: Be sure you right-click on the Private iCal link. If you try to save the public file, all you’ll get is a hypertext link.

    2) Go to “Settings : Calendars” and delete your primary calendar. A pop-up box will appear warning you that you are about to delete everything in your primary calendar…that’s fine. Your calendar isn’t going anywhere, you’re just deleting its contents.

    3) Import your new calendar using the process described in the above blog post, adding the *.ics file to your primary calendar

    Worked for me … 145 events successful, and no jibberjabber about not having enough access.

    Good luck!

  36. Johnny says:
    May 17, 2009 at 12:38 am

    So many thanks for your time on this!

    Very much appreciated!

  37. bruno says:
    May 23, 2009 at 9:42 am

    [Colin says: These directions should not be necessary in ordinary circumstances, but if you do run into this case, give them a try and let us know if they worked for you!]

    it seems you cannot merge a calendar into a non-empty main calendar (your 1st one, the one you cannot delete)
    BUT you can merge any calendar into any (non-empty) secondary calendar AND/OR merge a calendar into your EMPTY main calendar.

    So, you got it ?
    What you have to do is:

    1/ export calendars
    2/ delete all events in main calendar
    3/ create a new “test” calendar
    4/ import calendar 1 into “test”
    5/ import calendar 2 (3, 4, 5, …) into “test” (merging)
    6/ export calendars
    7/ import “test” into main calendar
    8/ delete “test”

    That’s all folks !

    Wish Google guys work on that issue !

  38. Colin M says:
    May 23, 2009 at 11:38 am

    @bruno – After seeing your comment, I tested these directions again this morning to be sure they still worked. Other than the Add button moving to the bottom of the list instead of on top, everything is still the same. You should not have to delete events from the destination calendar before importing. If you find that this is isn’t working, I would check the sharing permissions on your main calendar.

  39. Libby says:
    June 16, 2009 at 3:54 pm

    This worked like a charm! Thanks!

  40. Yvette says:
    July 8, 2009 at 10:00 pm

    Hi
    I just did this
    But I lost my colours – which was the main reason I made up separate calendars – any reason why?

  41. Deeyan says:
    August 25, 2009 at 8:32 pm

    Thanks so much! The only directions I’ve ever found and perfect!
    BTW, if you do this with a public calendar, such as Religious Holidays, then you can edit to remove any unwanted ones or rename, etc.

  42. Katie K says:
    August 30, 2009 at 12:40 pm

    Thanks so much, thats perfect!!! just what i was looking for!

  43. Touvania says:
    September 14, 2009 at 7:37 am

    AWESOME! WONDERFUL! Saved $ to use free calendar! THANK YOU!! – webmaster

  44. Sharon says:
    September 16, 2009 at 3:16 pm

    Yay! My calendar agony is over! Thank you! Thank You!

  45. Josh says:
    September 16, 2009 at 8:57 pm

    Thanks–a huge help!!

  46. Abhay says:
    September 24, 2009 at 3:17 pm

    Very nice, thanks for the idea.

  47. Merging Google Calendars and feeling silly later « The Rest of My Life… says:
    September 25, 2009 at 10:46 pm

    [...] http://www.mccambridge.org/blog/2008/03/howto-merge-google-calendars-together/ [...]

  48. Shelly says:
    September 29, 2009 at 12:39 pm

    Wow! This is incredible. Thanks for taking away a HUGE headache!

  49. Wethersfield says:
    October 1, 2009 at 10:00 am

    Thank you!

  50. Joe says:
    October 2, 2009 at 2:06 am

    What I have tried to do is set up notifications for my “Contacts Birthdays” Calendar…. however I do not have a private link to subscribe to it in the other calendar. Got any advice? I desperately need notifications for my Birthdays, that is the main thing I need to remember!

Newer Comments »

Leave a Reply

Click here to cancel reply.

Calendar

September 2010
S M T W T F S
« Jun «-»  
 1234
567891011
12131415161718
19202122232425
2627282930  

Random Quote

Archie looked over at Acuna, whose face was a dangerous shade of blank. He decided to make it even simpler.

-The Android's Dream
John Scalzi

Blogroll

  • Angela
  • Ashley
  • Jared
  • Jeni
  • Jon
  • Paul
  • Scott

Archives

Meta

  • Log in
  • Entries RSS
  • Comments RSS
  • WordPress.org
rss Comments rss valid xhtml 1.1 design by jide powered by Wordpress get firefox