+ Reply to Thread
Results 1 to 6 of 6

Exporting excel sheet to Calendar

  1. #1
    Forum Contributor
    Join Date
    12-02-2008
    Location
    India
    Posts
    118

    Exporting excel sheet to Calendar

    Hey all!
    First of all i'm not even sure if i should be asking this here or somewhere else so apologies if it doesnt belong here.

    I have a a matrix table with Rows (A1:A65) and column (B1:F1) as headers containing events and the dates filling up the matrix.
    So suppose A10 has "#1015"
    and D1 has "Tax"
    then D10 has the due date of Tax payment of #1015

    How can i export this table to google calenders to let it remind me of all the coming due dates?

    All of these events/dates need to be recurring every year.

    Want it to be specifically for google calender because i need to be able to forward those reminders to concerned people to take care of it.
    I only know google lets us import csv files of icalender but i dont have the format or the structure of the csv file...

    Can i be helped or do i need to get some more info?

    Thanks And Regards
    Mohit
    Last edited by mohitspamz; 11-15-2009 at 03:28 AM.

  2. #2
    Valued Forum Contributor JeanRage's Avatar
    Join Date
    03-02-2009
    Location
    Nice, France
    MS-Off Ver
    Excel 2003
    Posts
    705

    Re: Exporting excel sheet to Calender

    Excel allows you to save your data as a comma separated value file ...

    HTH

  3. #3
    Forum Contributor
    Join Date
    12-02-2008
    Location
    India
    Posts
    118

    Re: Exporting excel sheet to Calender

    Hey!
    Thanks for the reply...

    However, i dont know how the csv file is to be structured so that google calender can identify 5*64=320 different events and set these events on those specific dates and then make these events recurring every year?

    Regards
    Mohit

  4. #4
    Forum Contributor
    Join Date
    12-02-2008
    Location
    India
    Posts
    118

    Re: Exporting excel sheet to Calender

    Hey!
    Sorry for the bump, but i'm still kinda looking for some push..

    Regards
    Mohit

  5. #5
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Exporting excel sheet to Calender

    i dont know how the csv file is to be structured so that google calender can identify 5*64=320 different events ...
    well... this looks more like a Google calendar question, really.

    After spending about 30 second on Google with the keywords "google calendar import from csv" I found

    http://www.google.com/support/calend...py?topic=15286

    hth

  6. #6
    Forum Contributor
    Join Date
    12-02-2008
    Location
    India
    Posts
    118

    Re: Exporting excel sheet to Calendar

    Hey thanks for that link!
    I'd been to that page before and somehow i missed the link to csv structure page (About CSV files) and posted the same question on google calender help forum too...

    Stupid of me!

    Regards
    Mohit

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1