Import excel data into Team Calendar

[Michael Jones]

I have about 3 months of roster data in an excel spreadsheet and I would like to add it to a new Team Calendar. Is there any way to avoid entering each shift/name combination by hand? I was hoping that there would be some way to import the data from excel.

[FernandoA · Accepted solution]

Turns out that it's not possible to import data from a xls file yet.

Team Calendars only allows importing data from a .ics format.

For further reference please see: Subscribing to Other Calendars From Confluence

Hope this clarifies.

Cheers!

[Michael Jones]

Thank you for the prompt response.

[SimonS]

It is possible to convert an XLS file into a .ics file:

http://www.ehow.com/how_7434892_convert-csv-file-ics.html