Results 1 to 7 of 7
  1. #1


    Member Since
    Feb 13, 2010
    Posts
    6
    Can I export iCal dates to a spreadsheet?
    Hi there switched to Mac from PC around 2 months ago and was instantly hooked. I love it. (MacBook Pro 13" - Snow Leopard)

    I want to use iCal and at the end of the year export appointments in iCal to a spreadsheet. I have got Numbers and Open Office apps to export to if possible.

    I used to use Outlook and Excel to do this on my PC but am trying not to go down the Microsoft route as I love the simplicity of the Apple apps.

    Cheers

  2. #2

    louishen's Avatar
    Member Since
    Oct 22, 2007
    Location
    London
    Posts
    8,968
    Specs:
    Mac Mini Core i7 2012 | White 2009 MacBook 2 Ghz | 733 Mhz G4 Quicksilver
    I think Officetime can do that - can extract data from your Ical calendar anyway

    Intuitive Time Tracking Software for Mac and Windows.
    Member of the Month September 2008 & August 2012 | Found advice useful? use the rep system

  3. #3


    Member Since
    Feb 13, 2010
    Posts
    6
    Hi louishen thanks for your suggestion. All are helpful if even to rule out.
    I had a look at Office Time which has a lot of features but I think I need a simpler solution otherwise I will need to go down the Microsoft route.

    I have heard Microsoft Office 2010 is coming out at some point this year which will contain Outlook (rather than Entourage) although I use the Windows version and find the whole application very busy. I would like to go down the simpler interface route of iCal if possible which also has better integration. If I cant find a solution I will have to get Office and suffer in silence. This may also affect having to possibly move away from Address Book as well.

  4. #4

    toMACsh's Avatar
    Member Since
    Jul 30, 2009
    Location
    Wisconsin
    Posts
    6,187
    Specs:
    Mac Mini (Late 2014) 2.6GHz Intel Core i5 Memory: 8GB 1600MHz DDR3
    You can use the Search function in iCal to generate a list of Events. Then you can Copy those, and Paste them into a spreadsheet. I tried it. It works, after a fashion. The key will be having sufficient Search terms to find the Events you want to "export".

  5. #5


    Member Since
    Feb 13, 2010
    Posts
    6
    Hi toMACsh thanks for that. I tried it and as you say it did work after a fashion although the data that comes out on the spreadsheet is placed vertically rather than say a date being the first field and then subsequent data being placed horizontally in separate cells across the page.

    Saying that its the closest Ive got so far.

    I am a musician and want to have my gig dates in iCal together with venue, fee received and agents name. At the end of the year I want to transfer all this data to a spreadsheet so I can create my books from them. So that's a simple 4 column spreadsheet is all that is needed. If I could export from iCal in csv format, or other, then what I want would be possible straight away.

    Maybe I should have explained that first?

    I have since tried widening my search to other software solutions and have initially found Bento which seems to come up a lot. If this is the solution I would be happy to buy this app but I don't want to get more complicated if I can solve it with a simple export in the correct format.

  6. #6

    toMACsh's Avatar
    Member Since
    Jul 30, 2009
    Location
    Wisconsin
    Posts
    6,187
    Specs:
    Mac Mini (Late 2014) 2.6GHz Intel Core i5 Memory: 8GB 1600MHz DDR3
    Yeah, I knew the copy and paste method would not render the format you probably were looking for. Bento is of course a database application, and you'll have to set it up independently from iCal. The problem is iCal's inability to export in an appropriate format, as you know. Unless someone else has found a way...

    Good luck!

  7. #7


    Member Since
    Feb 13, 2010
    Posts
    6
    Thanks for your help toMACsh much appreciated!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. iCal stops showing dates
    By iMACGuru in forum OS X - Apps and Games
    Replies: 3
    Last Post: 03-01-2015, 06:33 PM
  2. Trouble editing dates for To Do items in iCal
    By OneSycamore in forum OS X - Apps and Games
    Replies: 0
    Last Post: 08-06-2011, 05:20 PM
  3. Changing dates in iCal
    By Wenfuli in forum OS X - Apps and Games
    Replies: 9
    Last Post: 12-09-2010, 01:25 PM
  4. iCal Question...Crossing out past dates???
    By piercenkc in forum OS X - Apps and Games
    Replies: 1
    Last Post: 02-18-2010, 12:52 PM
  5. Spreadsheet which will do dates before 1900
    By patricci in forum OS X - Apps and Games
    Replies: 11
    Last Post: 12-05-2007, 10:08 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •