Export of Calendar to Excel

[Pooja]

Hi Team,

We are using a Team calendar for confluence.

We want to export some of the calendars to excel formate,

Is it possible to export the calendar to Excel?

[Andrey Khaneev [StiltSoft] · Accepted solution]

Hi Pooja,

Here is a post on how to get Team Calendar in the table form, make it possible to filter, aggregate, visualize and export to CSV.

[Agrawal_ Ashutosh _Noida_]

Not found any script. If URL can be provided then that will help a lot employees

[Ivan Nikolov]

Hi Pooja,

Searching for the same answer today, I managed to do this via 1st - importing the Confluence calendar into Outlook and 2nd - exporting it from Outlook in .csv format (you can then save as .xlsx).

These are the steps to follow as it worked for me;

1. Choose to the right of the Confluence calendar and choose Export to iCalendar
2. Save the .ics file to your computer
3. Open Outlook desktop application and choose File > Open & Export > Import / Export
4. Choose Import an iCalendar (.ics) or vCalendar file (.vcs)
5. Locate and select the .ics file you saved and follow the prompts to import it.
6. Go to Outlook desktop application
7. Go to File > Open & Export >Import/Export > Export to a file > Comma Separated Values > click Next > Choose your calendar from section 'Calendar' in 'Select folder to export from:'
   Click Next to save in a preferred name and location
8. Click Finish
9. Select date range for the downloaded calendar and click 'OK'
10. Enjoy!