Outlook Calendar to Excel Automation

[jhowl777]

Hello! I’m looking to find a way to automate on a regular basis (daily, weekly, etc) my outlook calendar appointments to a .csv file so I can then import that to my excel log book. Does anyone know a way to do this automatically?

 

[FormR]

Hi, have you tried importing it directly using a menu path similar to "Data" > "Get Data" > "From other sources" > "From Microsoft exchange"

 

[jhowl777]

Hi, have you tried importing it directly using a menu path similar to "Data" > "Get Data" > "From other sources" > "From Microsoft exchange"

Hi! Yes I have. I’m going to look again but last time I looked I didn’t have that option. I’m using Microsoft 365 on my Mac and couldn’t find that feature.

 

[FormR]

on my Mac

Ah, very possibly not an option then. Have you tried the "Open & Export" options from Outlook itself? Google has lots of hits with instructions.

 

[jhowl777]

Yes, I can export my calendar to a csv file, but I want to automate it so that its done weekly.