Outlook calendar to CSV — appointments out of a .pst
Export the appointments in an Outlook .pst or .ost file to a CSV table, or to the CSV Google Calendar imports.
About this conversion
Two kinds of CSV are wanted from an Outlook calendar: a table to read and count, and a file to move the calendar into Google. Both come from the same reading of the .pst. The table keeps a repeating meeting as one row with its rule in words; the Google version writes every occurrence as its own row, because Google's CSV import has no notion of repeats.
Just want to look inside it?
The same tool without converting anything: open the file and read it.
The same calendar, any way out
The file is read once and stays open, so the format is picked at the end: the same events can leave here as XLSX, CSV for Google Calendar, ICS or PDF. The same meeting found in an invitation, a reply and an export is recognised as one event, and its time is the same moment whichever way it was written — with a time zone, in UTC or as a whole day.
Questions
- Wouldn't .ics be better for moving to Google?
- Usually, yes — .ics keeps the repeats as repeats. It is in the Export menu too, and there is a PST to ICS page.