{"id":59031,"date":"2021-07-13T17:15:43","date_gmt":"2021-07-13T16:15:43","guid":{"rendered":"https:\/\/hlrnet.com\/technoblog\/?p=59031"},"modified":"2021-07-13T17:15:43","modified_gmt":"2021-07-13T16:15:43","slug":"outlook-kalender-analyseren-met-excel","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/outlook-kalender-analyseren-met-excel\/","title":{"rendered":"Outlook kalender analyseren met Excel"},"content":{"rendered":"<p>V. Kan ik mijn Outlook kalender op een of andere manier in Excel krijgen? De organisatie waar ik voor werk zet ons werkschema in een Outlook kalender, maar ik wil kunnen controleren op dubbels en op aantallen.<\/p>\n<p>A. Ja hoor &#8211; met Power Query.<\/p>\n<ul>\n<li>Gegevens, Gegevens ophalen, Van andere bronnen, Uit Microsoft Exchange<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-59033\" src=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2021\/07\/Screenshot-2021-07-13-18.05.08.png\" alt=\"\" width=\"1920\" height=\"1080\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2021\/07\/Screenshot-2021-07-13-18.05.08.png 1920w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2021\/07\/Screenshot-2021-07-13-18.05.08-300x169.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2021\/07\/Screenshot-2021-07-13-18.05.08-1024x576.png 1024w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2021\/07\/Screenshot-2021-07-13-18.05.08-768x432.png 768w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2021\/07\/Screenshot-2021-07-13-18.05.08-1536x864.png 1536w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/li>\n<li>Geef je login<\/li>\n<li>Kies Calendar &#8211; en mogelijk daarin de subrubriek waarin die werkafspraken vermeld worden<\/li>\n<\/ul>\n<p>Meer informatie nodig? Kijk bv. eens naar<\/p>\n<ul>\n<li><a href=\"https:\/\/www.youtube.com\/watch?v=apBglZR9W60\">How to Import Emails From OUTLOOK to EXCEL &amp; why you want to do that! &#8211; YouTube<\/a><\/li>\n<li><a href=\"https:\/\/www.xelplus.com\/import-outlook-to-excel-with-power-query\/\">Import Outlook to Excel with Power Query &#8211; Xelplus &#8211; Leila Gharani<\/a><\/li>\n<\/ul>\n<p>Overigens: Google calendar kan je niet (zo maar in \u00e9\u00e9n stap) exporteren naar een rekenblad. Wat wel kan, is Google calendar exporteren naar ICS en die ICS inlezen in een Google spreadsheet met <a href=\"https:\/\/gsuite.google.com\/marketplace\/app\/calendar_to_sheet\/398869950567?_ga=2.39490403.1111185635.1626171628-484370856.1626171628\" rel=\"nofollow\">Calendar to Sheet<\/a>. <a href=\"https:\/\/blog.coupler.io\/export-google-calendar-to-google-sheets\/\">Coupler.io<\/a> legt een en ander mooi uit.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>V. Kan ik mijn Outlook kalender op een of andere manier in Excel krijgen? De organisatie waar ik voor werk zet ons werkschema in een Outlook kalender, maar ik wil kunnen controleren op dubbels en op aantallen. A. Ja hoor &#8211; met Power Query. Gegevens, Gegevens ophalen, Van andere bronnen,<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":128,"footnotes":""},"categories":[104,54,79,10,414,56,340,160],"tags":[],"class_list":["post-59031","post","type-post","status-publish","format-standard","hentry","category-business","category-excel","category-odisee","category-office","category-office-365","category-outlook","category-samenwerken-2","category-tabellen"],"publishpress_future_action":{"enabled":false,"date":"2026-05-03 16:49:34","action":"delete","newStatus":"draft","terms":[],"taxonomy":"category","extraData":[]},"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"_links":{"self":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/59031","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/comments?post=59031"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/59031\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=59031"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=59031"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=59031"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}