Windows 10: Export events from windows calendar

I have added some events to the "Calendar" app in Windows 10 and I would like to access these on my mobile device iOS. Google calendar, iCloud, Outlook, it doesn't matter. I will use whatever works. I do not need it to sync with new events going forward I just want to extract the dates and times I have manually entered to the Windows Calendar so that I may get the reminders on my iPhone. I have added an iCloud account and Google account to the Calendar app but it doesn't do what I want. I can get events from these accounts into Windows Calendar but not the other way around. I have made the m

:)

 

Export All Administrative Events to Excel

To analyze events, from the Windows Event Viewer, there is a simple way to export all Administrative Events to Excel, with PowerShell.

Exporting all Administrative Events to Excel is a simple two Step process, as described here:

Step 1 - Create the Administrative Events View .xml file

1. Open Eventviewer (%windir%\system32\eventvwr.msc)
2. Navigate to: Event Viewer (Local) > Custom Views > Administrative Events
3. In the “Actions” pane select “Filter Current Custom View”.
4. Select the the XML tab.
5. Press Ctrl+A to select all the XML code of the Custom View.
6. Open a notepad, paste the selected code and save the file to your Desktop as AdmEvtView.xml

Step 2 - Create the csv file with the events

1. Download the ExportEvtCSV.zip file, which contains the script ExportEvtCSV.ps1 and unzip it, on your Desktop.
   It's not a fancy script, just basic PowerShell commands to create a csv file on the Desktop.
2. In Windows Search, type “ISE” (without the quotes) to open “Windows PowerShell ISE” and Run as administrator
   
3. To allow running the script, change the ExecutionPolicy, for this session. To do that, in the Console pane type:
   Code:
4. In the Windows PowerShell ISE, open and run the script: ExportEvtCSV.ps1
   The script will create a csv file with a name YYYYMMDD.HHMM.csv on the Desktop
5. When done, open the newly created .csv file, format the columns as needed and optionally save it as .xlsx, if you wish.

That’s it! You now have all the Administrative Events in Excel for filtering and further analysis.

Now to the more technical hard stuff... *Confused

There is a reason for running the script from within PowerShell ISE!

It would be great if everything was also working perfectly, when running the script from an elevated PowerShell too.

We can run it from an elevated PowerShell, which means that you just follow the Step 1, as above but for the Step 2 instead of the ISE you run the script from an elevated PowerShell.

The problem is that it will work only for anybody who has en-US format for the dates. Everyone else, who has another format (i.e. en-GB, fr-FR, el-GR etc.), the dates are not translated properly by Excel (although the script uses the –UseCulture switch) and remain as text in the en-US format.

I'm not sure if this a bug of the "export-csv" cmdlet, but although it runs the way it supposed to from within the ISE, from PowerShell there is a problem with the dates format.
As I haven’t found a way to overcome this obstacle, any suggestion from the PowerShell gurus of the forum (like my good friend Shawn @Brink, for instance), is welcome.

 

Windows 10 calendar sync problem

Hello,

Thank you for getting back to us with the results and we appreciate the time and effort you have put in to resolve the issue with us. Let me assist you further from here.

At this point, I suggest you to check if it helps to use the web version of the calendar to sync the existing calendar details.

Please follow the below steps.

Step 1: Export Google Calendar

• Click on the the gear button, then navigate to Settings > Calendars > Export calendars.
• It downloads as a zip, so copy the .ics file out.

Step 2: Import or subscribe to a calendar in Outlook.com

• Follow the instructions prescribed in the below Help Article.
  
  Ref:
  http://windows.microsoft.com/en-us/windows/outlook/calendar-import-vs-subscribe

Step3: Next, open your calendar app to check if you can see the events which were used in your Google calendar.

Kindly keep us posted on the status of the issue for us to be able to assist you further.

Thank you.

 

gmail calendar event is deleted by calendar app

Hi,

We appreciate your time and effort for getting back to us.

If your Google calendar can't be synced with the Windows Calendar app, then follow the below Microsoft article.

Windows help & learning

If the issue persists then, I suggest you to uninstall the apps which came inbuilt with Windows 10 using Windows PowerShell and reinstall using Windows Store. Follow the below steps.

• 
  Open the Start menu, type Windows PowerShell in
  the search bar.
  
• 
  Right click on the Windows PowerShell and select Run as administrator.
  
• 
  Enter the below command to reinstall the Mail and Calendar app.
  

get-appxpackage *microsoft.windowscommunicationsapps* | remove-appxpackage


After performing the above steps, install the Mail and Calendar app form the Windows Store.

If you need any further assistance let us know and we would be glad to assist you.