I am trying to find the dates all public holiday for the year 2012, for several countries. There are many public holiday calendars for different countries shared at the Google Calendar (see here).

After I subscribed these calenders, can I export these subscribed calenders to another format such as CSV, Excel or text format?

1 Answer 1


You can import it as an XML into Microsoft Excel. To do so:

  • Go to your calendar setting.
  • Click on the calendar in question; the calendar settings will show up.
  • On the right hand side click on XML. Google Calendar will provide you with a link.
  • Open Excel and click on open file.
  • Copy and paste the provided link into the File Name field and click open.
  • Follow the instructions given by Microsoft Excel.

Now you will have to format it in a usable way.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.