Mass delete for Google Calendar events.

  • Idea
  • Updated 1 year ago
I'd love mass delete functionality in Google Calendar search results. The use case is this: I imported a repeating event from iCal, Google Calendar imported it as 100's of individual events, instead of 1 repeating event. Now I have to manually delete each event one-at-a-time. It'd be great if I could search for an event within my Calendar, then use checkboxes, along with a Select All functionality, to delete all of these events. Thanks for listening!!
Photo of Sally

Sally

  • 1 Post
  • 0 Likes
  • hopeful!

Posted 7 years ago

  • 115
Photo of MTOakeyM

MTOakey

  • 1 Post
  • 0 Likes
I too would like some kind of functionallity to do a global delete of all events so I can start new. In Thunderbird, just show "ALL Future Events", select all, and DEL. It should be that easy in Google also. And Thunderbird also, when importing a ".ics" calendar file, will reject all duplicates. That should also be the way of the Goog.
Photo of

  • 1 Post
  • 2 Likes
Deleting all events before a specified date would be a good feature.
Google calendar sync also should be able to exclude based upon date criteria. When I synced to Outlook I had hundreds of long past events from up to four years ago show up in gcal, and had to manually delete them. As I also sync gcal with Nokia N800 mcal, I want some criteria available to keep my mobile calendar trim.
Photo of

  • 1 Post
  • 1 Like
I would like that too. I had some event repeated 200+ times because of GCalDaemon, and now I have to delete it one by one manually... :/
Photo of

  • 1 Post
  • 2 Likes
I have found a solution to this. It is not very pretty but it does work and does make things quicker.

If you use google sync to sync to your outlook calendar then you can download your google calendar, do a search in outlook to find the events you want to remove and then they will be displayed as a list. You can then select all and press delete. Much quicker...hope that helps.

Jacob
Photo of TuxT

Tux

  • 1 Post
  • 3 Likes
Unless I am a complete idiot, I think I have found a way to delete multiple(all) events in the gCal. Stumbled on it I must say out of frustration.

So if you go to the settings tab under "My calendars" on the far right you will see "Delete" ....well click it!

This will delete all of the events without deleting the calendar or the settings you have configured. NICE!!!!

Once complete, you can just re-import your calendar that you have exported from outlook, etc.

Not ideal, but works none the less.
Do I get a cookie or something for finding this.
Photo of jaxnoodleJ

jaxnoodle

  • 1 Post
  • 0 Likes
Dear Tux, thank you for the tip which may work for Outlook,but my Blackberry and Google Sync are not picking up the deleted calender and changes made to my contacts. Merged all my duplicate contacts too from 3,000 to about 700. My line of work requires me to rely on phone and this issue has made my Blackberry a useless phone device because it is always processing the duplicates. My whole morning just want to the trash trying to figure out way to remedy this problem.
Photo of Steph Beach

Steph Beach

  • 3 Posts
  • 0 Likes
Yup Tux, you are a CI. There does not appear to be any way to delete multiple entries in GCal.
Photo of Spot Lajalf

Spot Lajalf

  • 3 Posts
  • 0 Likes
This worked great for me... and look at the great reviews on the page.
http://ryanvision.com/?page_id=123
Photo of animartis

animartis

  • 1 Post
  • 2 Likes
One word of advice. This only works on your Primary calendar. If you try to use the delete button on another calendar it WILL delete it.
Photo of ValterV

Valter

  • 1 Post
  • 0 Likes
I trying deleting in my outlook and changing the Google sync to 1-way from Outlook to Google Calendar. Didnt help. To have the ability to delete all events in the google calender itself, either if it will require confirmation is the best option.
thx.
Photo of

  • 2 Posts
  • 5 Likes
Google calendar really needs a multiple delete. When you search by a date range, the results page of your search would be a good please to do this maybe by clicking a checkbox by each entry much like you do with messages in GMail. Google has this functionality all ready. Just port it over to Calendar.
This functionality is really basic. Please consider this.
Photo of cfc2000

cfc2000

  • 7 Posts
  • 2 Likes
Follow Tux's advice if your My calendar in Google is the primary one. Delete the lot, but make sure Google calendar sync is not running a 2 way sync or you'll lose the lot, Outllook and Google. Then use ODIR on Outllook calendar folder, then re-instate Google calendar sync 2 way. Important: make sure you haven't got the google calendar sync program running on any other computers you may use while you are cleaning up one computer. Of course backup your pst file before you do any of this!
Photo of WhaleCancerW

WhaleCancer

  • 1 Post
  • 1 Like
You should be able to select multiple events to switch their calenders, delete them, or anything else. Why this hasn't been done baffles me. It is my only complaint of Google Calender.
Photo of notesandtones

notesandtones

  • 3 Posts
  • 3 Likes
GCalToolkit (http://www.gcaltoolkit.com) can do exactly this - although it's probably too late for Sally or partymola... you can delete between a range of dates, delete all events based on text filter, delete all duplicates, search and replace text in multiple events etc. It's really powerful though so be careful! The free version does all this 6 months into the past and future and the full version works on your entire calendar.

Photo of nevillejyoungN

nevillejyoung

  • 1 Post
  • 0 Likes
Oh BLISS this is fantastic, thank you. It's silly that you can't do this as part of the main calendar functionality, but wonderful that you can do it with this nice software. It's easily worth the money I paid to sort out the mess I inadvertently made while converting to my Google calendar. Thanks again!
Photo of Jeremy Davis

Jeremy Davis

  • 4 Posts
  • 0 Likes
This is cool, but really Google should allow you to do this in GCal itself. IMO you should not need a third party app to delete multiple events!
Photo of Kichigai

Kichigai

  • 2 Posts
  • 1 Like
Only problem with this is that it's Windows-only. That leaves the rest of us on Mac OS X, a handful of BSD distros, a dozen flavors of UNIX, a thousand different Linuxes, BeOS, Haiku, and other platforms out in the cold.
Photo of notesandtones

notesandtones

  • 3 Posts
  • 3 Likes
Hi Kichigai, there's also a browser based version - you'll find in under "Online Tool" on the website. It doesn't do the same fancy search/replace or text editing... but it will delete duplicates or undo failed syncs and imports in a few clicks. Nothing to install, no security concerns if you don't like typing your Google password into Windows software, and it's actually faster than the Windows tool as all data passes directly between Google and my server. Let me know what you think :-)
Photo of pingnakP

pingnak

  • 4 Posts
  • 5 Likes
The fact that there is a THIRD PARTY commercial tool to do this says Google is not just resting on their laurels, they're soundly sleeping.
Photo of pingnakP

pingnak

  • 4 Posts
  • 5 Likes
However, since I had a calendar program that syncs to google calendar (iCal), I ran it and was able to search+delete. So there's a FREE workaround for OSX users, anyway. There is probably some FREE PC and certainly free Linux stuff to do the same.
Photo of lf.groups

lf.groups

  • 1 Post
  • 5 Likes
Well, I think Google ́s people not even read this forum...
How come an idea this important rests for a full year without any solution? And, come on, it ́s not as we were asking them some astronomical difficult calculation or a feature nobody heard of before. It ́s just a functionality ALL calendar applications have, except, o ́course, Google Calendar.
Photo of kabat.michalK

kabat.michal

  • 4 Posts
  • 3 Likes
Free and working solution is to use Mozilla Thunderbird + Lightning addon + Provider for Google Calendar plugin. You can add all your calendars to Thunderbird and then you can copy/edit/move/delete multiple items and all the changes are applied automatically on-the-fly.
Photo of Jeremy Davis

Jeremy Davis

  • 4 Posts
  • 0 Likes
Excellent work on figuring this out! I'll be doing this very soon!
Photo of erik.oxaalE

erik.oxaal

  • 1 Post
  • 0 Likes
I never used Thunderbird before, but this was an excellent tip!
Photo of Willykc

Willykc

  • 2 Posts
  • 0 Likes
PERFECT SOLUTION!!! Quick and easy...exactly what I needed to be able to do a Calendar filter and delete mass events! Thanks so much.
Photo of Ken Koh Tokyo

Ken Koh Tokyo

  • 1 Post
  • 1 Like
this is the free way to do it:

1. download google calendar outlook sync onto 32bit OS (64bit OS sync doesnt work).
2. do one way sync from google to outlook, then stop sync after this is done
3. in tools menu in outlook, go to find-->advanced find and search for your duplicate events
4. select multiple duplicates using shift left mouse
5. delete events
6. sync back to google using outlook-->google one way

the above should get rid of all the duplicates
Photo of Jeremy Davis

Jeremy Davis

  • 4 Posts
  • 0 Likes
Thanks for sharing Ken and I'm sure for some users will be greatful. Bottom line though is that this is NOT "the free way to do it"! For the free way to do it see the post above by kabat.michal (using Thunderbird). Your way relies on Outlook which is not free (you need to have a copy of MS Office - which is certainly not free!)
Photo of NicojN

Nicoj

  • 14 Posts
  • 4 Likes
The problem remains for people in corporate environments. I want to export my Outlook calendar to Google. Currently, I export data from Outlook into a CSV file, which I can then import into Google Calendar. But if I repeat the process I either have duplicate values or I have to delete and re-create the whole calendar. Any links to the public version are broken.
As I'm in a corporate environment, I cannot download or install software, so your approach doesn't work. Deleting all event from a google calendar would solve the issue. Maybe the new google apps script will be able to achieve this.
Photo of kabat.michalK

kabat.michal

  • 4 Posts
  • 3 Likes
Nicoj, I would like to help you, but I need to ask you few questions:
1) Do you connect to your corporate calendar through Microsoft Exchange server?
2) Do you own and use any Android/Windows Mobile device to sync your calendar?
Photo of Jeremy Davis

Jeremy Davis

  • 4 Posts
  • 0 Likes
Hey Nicoj, Another idea probably worth a go (a bit of a pain but perhaps better than nothing) would be to use kabat.michal's idea above (using Thunderbird) but if you can't install software, try it with Thunderbird Portable: http://portableapps.com/apps/internet...
Photo of kabat.michalK

kabat.michal

  • 4 Posts
  • 3 Likes
Jeremy, the thing I am worried about is that I suppose Nicoj would need to keep the Outlook and Google calendar sync'ed, as he's experiencing problems when exporting Outlook calendar into CSV MORE THAN ONCE.
Photo of NicojN

Nicoj

  • 14 Posts
  • 4 Likes
Kabat, thanks for this, only just saw it. I connect through Ms Exchange, and I don't sync with any mobiles-or anything really. Plus, there isn't a stable password, but one that changes every two minutes. I guess Thunderbird Portable could work, but I would be breaking the rules...
Anyway, I did find a way using Google Apps Script. See below.
Photo of cfc2000

cfc2000

  • 7 Posts
  • 2 Likes
It is true that Outlook is not free, but I have to have it for work, and it comes with the whole suite, so it should be classed as effectively free if you already have Outlook. This is the method I have been using, together with ODIR, since this problem with google calendar began. ODIR allows you to find duplicate contacts as well, but that's another ball game. ODIR is free
http://www.vaita.com/ODIR.asp

Cfc
Photo of pingnakP

pingnak

  • 4 Posts
  • 5 Likes
'Effectively free' for pirates, versus actually free for everyone, with absolutely no strings attached. Just because you already paid for it (or pirated it from the office) doesn't make it free. Especially when you start receiving 'new' Office documents that you can't open, because other people have 'upgraded' to a newer version of Micro$uck Orifice and sent you files written in the freshly and arbitrarily incompatible 'new' file format, and there's no way to talk the dimwits through exporting an 'old' version of M$ Orifice docs, and now you have to consider 'upgrading', too.

But hey, I'm sure Micro$uck is 'all better now', fully reformed under Steve 'devil lepers devil lepers devil lepers devil lepers' Ballmer into a corporation that upholds international data and protocol standards and doesn't rape their customers for fun and profit like the 20 years or so of my experience with them and their products before I switched to open source software across the board. Of course, IE8 seemed to be the only browser that choked on a bunch of Flash sites and games that ran fine for years, so I'd say that's a big 'no'.
Photo of cfc2000

cfc2000

  • 7 Posts
  • 2 Likes
Dear Pingnak
My copies of Office are legitimate and paid for under the Microsoft home Office scheme (remarkably good value). Anybody who tries to use Microsoft products downloaded from pirate websites is in for a disappointing time, quite apart from the morality of it. And as for your point about not being able to open other versions of documents etc if you have the wrong version of Office eg 2010, 2007 docs not opening in 2003, 2002 - Microsoft offer a compatibility pack which is totally free to download, but only if your copy of Office is legitimate. If you are a student or a home office worker employed by an organisation that subscribes to Microsoft's scheme, then Office is good value. Otherwise use OpenOffice or another open source product to accomplish the same thing.
Photo of kabat.michalK

kabat.michal

  • 4 Posts
  • 3 Likes
Please, let's try to stick to the topic.
Photo of cfc2000

cfc2000

  • 7 Posts
  • 2 Likes
i thought I was well on topic until there was an inference that i was using pirated software!
Photo of pingnakP

pingnak

  • 4 Posts
  • 5 Likes
No inference that you're using 'pirated' software. Just software that COSTS MONEY (and LOTS of it: $280 for Outlook with M$ Orifice 2010), and is therefore not a realistic solution to the problem at hand for many people, working around a BUG in a FREE web-based calendar service.

As for downloading 'warez', most North American M$ Orifice pirates sneak media and a software key home from work, or otherwise piggyback someone else's license, with a wink and a nod. Internationally, most others buy a disc with a crack edited in from a street vendor. The last 'legitimate' copy of Office I ever owned was Office 2000 Professional, that I paid $800 for, and they only provided 'compatibility' packs for NEWER versions of office to export older files at that time. Not for older versions of Office to open or write newer files. OpenOffice worked well enough, so I switched, gave my 'legal' version of M$ Office to someone else, and never looked back. Try to talk some secretary whose 'computer skills' are limited to typing, and has no 'Administrator' permissions through downloading and installing such a patch over the phone, when she emails you a file that won't open.

M$ is evil. People who buy from M$ are suckers who are allergic to money. And I DO mean that. Free Open Source Software rocks.
Photo of cfc2000

cfc2000

  • 7 Posts
  • 2 Likes
I take your point. But to be fair, microsoft has been getting better! And the software from the Home office program only cost me 25 dollars (admittedly the organisation paid on top of that). Student licences are about 50 dollars here in UK, which is not too bad. the full retail is a total rip-off, agreed. Anyway, we've been told, this is off topic....
Photo of NicojN

Nicoj

  • 14 Posts
  • 4 Likes
Right, slightly arduous to set up, but once it's set up, it's a piece of cake to use. It doesn't use Outlook or any other software. Also, I'm not sure how well it deals with recurrent events, but it should be (relatively) easy to amend.

1. Open Google Calendar settings for the calendar you want to delete (Settings > Calendar Settings > Calendars > CalendarToDelete)

2. Copy the Caldendar ID (scroll down, in section Calendar Address it will say Calendar ID. It looks something like this: xxxxxxxxxxxxxx@group.calendar.google.com. Select the whole thing and press Ctrl+C)

1. Open Google Docs. (http://docs.google.com)

2. Create a new spreadsheet (Create New > New Spreadsheet)

3. Save that spreadsheet (click on the "Unsaved Spreadsheet" at the top). In Internet Explorer you may have to allow scripted windows first.

3. Open the script editor (Tools > Scripts > Script editor...)

4. Name and save the script. (click the save button and name your script. I called mine DeleteAllEvents)

5. Adjust the time zone of the script (A bit annoying, but this seems to be some bug. File > Properties) If you don't do this the script may leave out one or two events at either end of the selected dates.

4. Paste the following script


function onOpen() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var menuEntries = [ {name: "Delete all events from calendar", functionName: "DeleteEvents"}];
ss.addMenu("Calendar", menuEntries);
}

function DeleteEvents() {
var startdate = new Date("January 1, 2010 GMT");
var enddate = new Date("December 31, 2011 GMT");
var count = 0;

var calendarID = "xxxxxxxxxxxxxxxxxxxxx@group.calendar.google.com";

var cal=CalendarApp.getCalendarById(calendarID);
var events = cal.getEvents(startdate, enddate);

// if (Browser.msgBox("Do you want to delete all events in the selected calendar?",
// Browser.Buttons.OK_CANCEL)=="ok") {
for (i in events) {
events[i].deleteEvent();
count++;
}
Browser.msgBox(count+" events deleted, between "+startdate+" and "+enddate)
// } else {
// Browser.msgBox("Aborted. Nothing was deleted.")
// }
}



5. Insert your calendar ID in the line that starts with var calendarID. Make sure there are "" around the inserted ID. (in Internet Explorer you have to type the two quotes first, then paste (Ctrl+V) the ID betweeen. Don't ask.)

6. Adjust the start and end date variables.

7. Save.

8. Run. (Run > DeleteEvents) It takes a while.

Note: The script will NOT ask you for confirmation. This is because of a known bug in Google Script. You can try it out by deleting the // in front of all the lines, but unless Google has fixed their bug, you will get the following error: "If-Match or If-None-Match header or entry etag attribute required." It should, I guess, work eventually, but doesn't at the moment. So be careful.

Next time you want to delete all events (from the same calendar), open the spreadsheet, and you will see a new entry on the top menu: Calendar (might take a bit to appear). Click and then Delete All Events from Calendar. Done.
Photo of NicojN

Nicoj

  • 14 Posts
  • 4 Likes
Please note that I've just discovered a rather important flaw in this approach. If you delete all events from the calendar (which works) and you want to add an Outlook-exported calendar, Google Calendar will not import those events it had previously imported (even though they have been deleted). I have no idea how to reset this, other than deleting the whole calendar. Back to square 1, it seems... Maybe import also via script?
Photo of briancluneB

brianclune

  • 3 Posts
  • 2 Likes
awesome that this is the ridiculous levels of reach around that you need to do to accomplish a task that a 15 year old programmer could handle in 5 minutes
Photo of briancluneB

brianclune

  • 3 Posts
  • 2 Likes
awesome that this is the ridiculous levels of reach around that you need to do to accomplish a task that a 15 year old programmer could handle in 5 minutes
Photo of JBLsMomJ

JBLsMom

  • 1 Post
  • 0 Likes
To address the flaw reported above, try this: you will need to use a text editor (notepad) to rename the UID: field to UID:1 in your saved calendar file and re-save it as a calendar file (not a text file). Just select your old file and add the word edited. Google will not re-import the file otherwise.
Photo of TexT

Tex

  • 1 Post
  • 0 Likes
This look very promissing. Is it possible to delete entries based on title as opposed to date range?

Many thanks
Photo of NicojN

Nicoj

  • 14 Posts
  • 4 Likes
It should be possible. I don't have time to check the details, but look into replacing the "events[i].deleteEvent();" with an if statement.

It should look something like this:
If (events[i].title="title of events to be deleted") {events[i].deleteEvent();count++;}

Hope it works out. Google for Google Apps Script for more explanations.

Oh, and you will need to include a date range because the Scripting language doesn't allow you to capture the whole calendar (afaik).
Photo of MCM

MC

  • 1 Post
  • 0 Likes
I think if you change the : LAST-MODIFIED:20110105T172656 and import it again it'll work :)

Moreover commented area with confirmation work .
Photo of NicojN

Nicoj

  • 14 Posts
  • 4 Likes
Ah! Thanks for that. :)
Photo of NicojN

Nicoj

  • 14 Posts
  • 4 Likes
Ah! Thanks for that. :)
Photo of notesandtones

notesandtones

  • 3 Posts
  • 3 Likes
Maybe too late for NicoJ, but for users in Office environments such as yourself I've released a simplified version of GCalToolkit that runs in most browsers as a web based application with nothing to install. It doesn't do the mass text edits etc, but it will mass delete duplicates (strict or relaxed) or delete events based on text content. It's free for small calendars (<500 events).
Photo of NicojN

Nicoj

  • 14 Posts
  • 4 Likes
Thanks, that is still useful. :)
Photo of briancluneB

brianclune

  • 3 Posts
  • 2 Likes
sadly the best way I have found is to sync my cal with another program and edit it there. fuck google for missing the boat on this for TWO FUCKING YEARS! it's so basic.

guess they are too busy rolling in piles of money from adsense.adwords to care about real users.

Hey sergei! Hand me a stack of them 'non-evil' 100's to wipe my ass.
Photo of cfc2000

cfc2000

  • 7 Posts
  • 2 Likes
Totally agree. And I hate that whatever word you use in googlemail in socalled private communication results in a pile of junk mail. EG my friend is in Thailand at the moment and he has bought a scooter and we discussed this - but I don't really want loads of junk mail and popups urging me to buy a scooter. I have another friend in Bulgaria and equally I don't want to be hassled by Bulgarian properties. We know that often google is the only game in town, but really they abuse their position.
Photo of Kichigai

Kichigai

  • 2 Posts
  • 1 Like
A semi-solution is to use Thunderbird and the Lightning Add-On to access Google Calendar via CalDAV. Thunderbird has a mass delete option, allowing you to do searches, select multiple items, and delete them. Unfortunately, there is no automated solution here, and since Lightning has to deal with each entry individually, the sync process can take some time if you've got a lot of entries to delete.

Thunderbird and Lighting are available on Windows, Mac OS X and Linux under the Mozilla Public License, Gnu General Public License (GPL), and Gnu Lesser Public License (LGPL), making it free and legal to redistribute under many (but not all) circumstances.