New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
Switcher Hangout The place for switchers to discuss their new machines, and how to work with OS X. General support can be had here for newbie stuff, like "How do I restart my new iMac?" :)

Can I export iCal dates to a spreadsheet?


Post Reply New Thread Subscribe

 
Thread Tools
TheG

 
Member Since: Feb 13, 2010
Posts: 6
TheG is on a distinguished road

TheG is offline
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
QUOTE Thanks
louishen

 
louishen's Avatar
 
Member Since: Oct 22, 2007
Location: London
Posts: 8,940
louishen has a brilliant futurelouishen has a brilliant futurelouishen has a brilliant futurelouishen has a brilliant futurelouishen has a brilliant futurelouishen has a brilliant futurelouishen has a brilliant futurelouishen has a brilliant futurelouishen has a brilliant futurelouishen has a brilliant futurelouishen has a brilliant future
Mac Specs: Mac Mini Core i7 2012 | White 2009 MacBook 2 Ghz | 733 Mhz G4 Quicksilver

louishen is offline
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
QUOTE Thanks
TheG

 
Member Since: Feb 13, 2010
Posts: 6
TheG is on a distinguished road

TheG is offline
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.
QUOTE Thanks
toMACsh

 
toMACsh's Avatar
 
Member Since: Jul 30, 2009
Location: Wisconsin
Posts: 5,459
toMACsh is a glorious beacon of lighttoMACsh is a glorious beacon of lighttoMACsh is a glorious beacon of lighttoMACsh is a glorious beacon of lighttoMACsh is a glorious beacon of lighttoMACsh is a glorious beacon of light
Mac Specs: Mac Mini Core 2 Duo

toMACsh is offline
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".
QUOTE Thanks
TheG

 
Member Since: Feb 13, 2010
Posts: 6
TheG is on a distinguished road

TheG is offline
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.
QUOTE Thanks
toMACsh

 
toMACsh's Avatar
 
Member Since: Jul 30, 2009
Location: Wisconsin
Posts: 5,459
toMACsh is a glorious beacon of lighttoMACsh is a glorious beacon of lighttoMACsh is a glorious beacon of lighttoMACsh is a glorious beacon of lighttoMACsh is a glorious beacon of lighttoMACsh is a glorious beacon of light
Mac Specs: Mac Mini Core 2 Duo

toMACsh is offline
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!
QUOTE Thanks
TheG

 
Member Since: Feb 13, 2010
Posts: 6
TheG is on a distinguished road

TheG is offline
Thanks for your help toMACsh much appreciated!
QUOTE Thanks

Post Reply New Thread Subscribe


« iPassword | new vs refurb? »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
iCal gone wild! macmanlondon OS X - Apps and Games 1 07-25-2012 05:07 PM
Syncing iCal with Google Calendar and CalDAV froze my iCal g725s OS X - Apps and Games 1 01-02-2011 10:02 PM
iCal deleting entries for no reason macmanlondon OS X - Apps and Games 0 01-21-2009 11:27 AM
Spreadsheet which will do dates before 1900 patricci OS X - Apps and Games 11 12-05-2007 10:08 PM
Any way to export iCal or Address book to Entourage? Original Nerd OS X - Apps and Games 3 09-22-2007 08:33 PM

All times are GMT -4. The time now is 08:15 AM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?