Importing Calendar From Microsoft Outlook To Mozilla Lightning - gHacks Tech News

Importing Calendar From Microsoft Outlook To Mozilla Lightning

A question came up today if it was possible to export a Calendar from Microsoft Outlook and import it to Mozilla Lightning. Mozilla Lightning can be integrated in the email client Thunderbird. There are basically two ways to import the Microsoft Outlook Calendar into Mozilla Lightning.

The manual way would be to export the Calendar files from Microsoft Outlook as comma separated values (csv) and import them to Mozilla Lightning. To do that open Microsoft Outlook and select File > Import and Export from the top menu.

The Import and Export Wizard will show up offering choices to import data into Microsoft Outlook and export data into files as well. Pick the Export To A File entry from the selection.

import export outlook

The Export To A File menu shows up which offers to export data into various file types. Select the Comma Separated Values (Windows) entry from the available choices.

export outlook calendar

After making that selection it is time to select the data that should be exported. Pick the Calendar entry from the available data sources.

calendar export outlook

Select a file name for the calendar export, pick the data range that you want to export and save it to the computer's hard drive. Now that the exported data is available it is time to import it into Mozilla Lightning.

Make sure that the Mozilla Lightning extension for the email client Thunderbird has already been installed. Start Mozilla Thunderbird afterwards and click on the Calendar button in the lower left corner of the application's window. It is possible to use the shortcut [CTRL 3] to go to the calendar as well.

import calendar

Lightning supports Calendar imports from csv and ics files. Pick the csv filter in the file browser and navigate to the hard drive folder that contains the Microsoft Outlook Calendar export. A click on that file will load the calendar in Mozilla Lightning and make the calendar available there.

The Open Source tool Outpost provides an elegant alternative. It has not been updated in the last years but is still able to export Outlook data. It can be used to export Outlook Calendar data in an ics file which can then be imported into Mozilla Lightning or any other application that supports the format.

Advertisement

We need your help

Advertising revenue is falling fast across the Internet, and independently-run sites like Ghacks are hit hardest by it. The advertising model in its current form is coming to an end, and we have to find other ways to continue operating this site.

We are committed to keeping our content free and independent, which means no paywalls, no sponsored posts, no annoying ad formats or subscription fees.

If you like our content, and would like to help, please consider making a contribution:


Previous Post: «
Next Post: »

Comments

  1. Giljorak said on October 26, 2008 at 1:53 pm
    Reply

    How about a completely automated option? It allows for bi-directional syncing.

    “Provider For Google Calendar” in Thunderbird:
    https://addons.mozilla.org/en-US/thunderbird/addon/4631

    and

    “Google Calendar Sync” with Outlook:
    http://www.google.com/support/calendar/bin/answer.py?answer=98563&topic=13948

    I provided the wrong link for the Thunderbird add-on in my previous submission.

  2. Rick said on October 27, 2008 at 8:41 pm
    Reply

    Using Google Calendar as a go-between like that is great, except it doesn’t support task lists. I use tasks far more than the calendar.

    Can anyone suggest an automated way to automatically bi-directionally sync tasks between Outlook and Lightning?

  3. Ron said on September 6, 2009 at 6:17 am
    Reply

    Thanks for the article- I really like the step-by-step instructions- but this doesn’t work for me at all. I’ve tried importing a .csv file manually, and it doesn’t show at all. If hanyone has any tips for me, I’m using Vista, Thunderbird 2.0.0.23, and Lightning 0.9.

    1. Alex said on October 27, 2009 at 11:53 am
      Reply

      Try to use FreeMiCal. For me worked great.

  4. Mark said on October 8, 2009 at 9:38 pm
    Reply

    The cvs transfer method worked great! Thanks so much.

  5. Si D said on January 4, 2010 at 2:14 am
    Reply

    Method didn#t work for me either. Export seemed to go ok but import has an exclamation mark and no appointments show up. Sadly, easy tho freemical looks, it fails for me 3/4 of the way through.

    This seemingly simple process is becoming a complete pain in the arse.

  6. Stiletto said on April 26, 2011 at 10:02 pm
    Reply

    FreeMiCal works great for me on Windows XP SP3, Office 2007 SP2, and Thunderbird 3.1.9. I’m impressed that it still works, it hasn’t had a new version released since 2007. I haven’t tested repeating events thoroughly though (I know that is always problematic), and the user’s calendar on which I tested it was not that complicated.

    http://sourceforge.net/projects/freemical/

  7. Rahul said on June 17, 2011 at 2:42 pm
    Reply

    Thank you for this post!

  8. John said on February 27, 2012 at 7:48 am
    Reply

    I have been using Broderbun Calendar Creator Plus and was able to export to CSV. Odds are slim that their output format (order and type of varaibles, possible header, etc) matches that from Outlook. Can you provide a description of the field order, data types and headers that Lightening is expecting to find on import?

  9. Mutos said on December 6, 2014 at 9:50 am
    Reply

    Hello all,

    I’m currently trying to achieve just that : salvaging my calendar from Outlook (2003 SP2) and importing it into Lightning (Ubuntu 14.10, Thunderbird 31.3.0, Lightning 3.3.1).

    The method described above works, but not as is. Two little tricks I’ve found on the Internet seem necessary:
    – Set “English (US)” regional parameters on Windows prior to exporting the Outlook calendar. I’m French, and that caused the Import to stall or seemingly finish but do nothing. It seems only en-us format is supported for date and time.
    – Not use “Comma Separated Values (Windows)” but rather “Comma Separated Values (DOS)”. It also seems to be able to handle non-english accentuated characters like “é” and “è” in French.

    I’ve just done this and succeeded importing one full year of calendar (528kB CSV). However, when I tried to pass the full calendar (6.5MB CSV), it failed. So if it fails, just split your calendar export to make it pass. For now I don’t know whether there is a size limit or it’s just a matter of error probability growing with the size of the calendar export…

    Before succeeding, I tried many other paths, installed many extensions, but to no avail. Only this method worked for me so far.

    Hope it could be useful, I’ve googled a lot and it seems very difficult to find accurate and reliable information on this migration path.

  10. Space Junk said on April 1, 2016 at 10:38 pm
    Reply

    Hi
    Why don’t we in office outlook 2010 simply click file | save calendar option, this saves the calendar in ics format
    Also click the “more options …” button to
    Set a specific date range rather than the default today date and
    Set the full details option as opposed to the availability only,

    Then in Lightning click the open | calendar file option?
    This seems to be simple and work

    Regards, Space Junk

Leave a Reply

Check the box to consent to your data being stored in line with the guidelines set out in our privacy policy

Please note that your comment may not appear immediately after you post it.