跳到主要內容

如何將日曆從Outlook導出到Excel電子表格?

與他人共享Outlook日曆的一種方法是導出Outlook日曆,然後將其導入到其他人的Outlook日曆文件夾中。 但是有一個關於如何導出它的問題。 以下教程將使您知道如何將Outlook日曆導出到Excel電子表格。


沒有導出功能,將日曆從Outlook導出到Excel電子表格

第一種方法將引入一種無需導入和導出功能即可輕鬆將所有日曆項從Outlook快速導出到Excel電子表格的功能。 請執行以下操作:

1。 移動“日曆”文件夾,然後選擇要導出到Excel的日曆。

2。 通過單擊更改日曆視圖 瀏覽 > 更改視圖 > 名單。 看截圖:

3。 選擇所有日曆項或將導出到Excel的多個日曆項。
注意: 持有 按Ctrl 鍵,您可以選擇多個不相鄰的項目,並逐個單擊每個項目; 舉行 轉移 鍵,可以通過單擊第一個和最後一個選擇多個相鄰的項目。

4。 右鍵單擊所選項目,然後選擇 複製 從右鍵單擊菜單中。

5。 創建一個新工作簿,右鍵單擊一個空白單元格,然後選擇 僅保留文字(T) 右鍵菜單中的按鈕。 看截圖:

6。 保存並關閉新工作簿。

因此,對於所選日曆項目,已經將其導出到新工作簿中。

一鍵式將多封電子郵件保存/導出到Outlook中的文本/ PDF / HTML / CSV文件中

通常,我們可以使用Outlook中的“另存為”功能將電子郵件導出/保存為文本文件。 但是,要批量保存/將多封電子郵件導出到單個文本文件中,則必須手動逐一處理每封郵件。 耗時的! 乏味! 現在,Kutools for Outlook的 批量保存 功能可以幫助您快速將多封電子郵件消息保存到單個文本文件,PDF文件,HTML文件等!


廣告批次另存為9.50

將日曆從Outlook導出到Excel電子表格

1。 去 文件 > 打開和導出>導入/導出。 看截圖:

2。 在打開的導入和導出嚮導中,在 選擇要執行的動作, 選擇 導出到文件,然後單擊 下一頁 以繼續。

3. 。 In在 導出到文件 對話框,請選擇 逗號分隔值,然後單擊 下一頁。 看截圖:

備註:如果您使用的是Outlook 2010或更早版本,請選擇 微軟 Excel 97-2003 直接選項。

4。 現在,在 選擇要從中導出的文件夾, 選擇 日曆 Outlook數據文件,然後單擊 下一頁.

5。 當 導出到文件 出現對話框,單擊 瀏覽... 按鈕選擇文件的目的地。

6。 瀏覽並選擇可以保存文件的目的地。 命名文件,最後單擊 OK 關閉對話框。

7。 當轉向上一個 導出到文件 對話框中單擊 下一頁 以繼續。

8。 現在另一個 導出到文件 彈出對話框,單擊 導出Outlook日曆。 看截圖:

9。 在“設置日期範圍”對話框中,請指定要在其中導出日曆的日期範圍,然後單擊 OK 按鈕。

備註:如果您使用的是Outlook 2010或更早版本,則選擇 微軟 Excel 97-2003 選項在步驟3中,該日曆已被導出為Excel工作簿。 如果您使用的是Outlook 2013或更高版本,則該日曆已導出為CSV文件,請繼續執行以下步驟。

10。 現在,我們已將指定的日曆導出為CSV文件。 請使用Microsoft Excel打開CSV文件,然後將文件另存為工作簿。


演示:將Outlook日曆導出到Excel


尖端: 在這個視頻裡, 庫工具 選項卡添加者 Kutools for Outlook。 如果需要,請單擊 這裡 免費試用60天!


最佳辦公生產力工具

Kutools for Outlook - 超過 100 種強大的功能可增強您的 Outlook

🤖 人工智慧郵件助手: 具備人工智慧魔力的即時專業電子郵件——一鍵天才回覆、完美語調、多語言掌握。輕鬆改變電子郵件! ……

📧 電子郵件自動化: 外出(適用於 POP 和 IMAP)  /  安排發送電子郵件  /  發送電子郵件時按規則自動抄送/密件副本  /  自動轉送(進階規則)   /  自動添加問候語   /  自動將多收件者電子郵件拆分為單獨的訊息 ...

📨 電子郵件管理: 輕鬆回憶電子郵件  /  按主題和其他人阻止詐騙電子郵件  /  刪除重複的電子郵件  /  進階搜索  /  合併資料夾 ...

📁 附件專業版批量保存  /  批量分離  /  批量壓縮  /  自動保存   /  自動分離  /  自動壓縮 ...

🌟 介面魔法: 😊更多又漂亮又酷的表情符號   /  使用選項卡式視圖提高 Outlook 工作效率  /  最小化 Outlook 而不是關閉 ...

👍 一鍵奇蹟: 使用傳入附件回覆全部  /   反網路釣魚電子郵件  /  🕘顯示寄件者的時區 ...

👩🏼‍🤝‍👩🏻 通訊錄和行事曆: 從選定的電子郵件中大量新增聯絡人  /  將聯絡人群組拆分為各組  /  刪除生日提醒 ...

超過 100特點 等待您的探索! 按此處了解更多。

閱讀更多       免費下載      購買
 

 

Comments (20)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
Is there a way the date fields can be exported or copied to Excel in NUMERIC form that can directly be used in a formula?
This comment was minimized by the moderator on the site
Can I export all my team member's calendar at same time?
This comment was minimized by the moderator on the site
Hi Del,
One calendar is a folder in Outlook. Outlook supports to export one folder at a time.
This comment was minimized by the moderator on the site
i am trying to export the comments i put in the appointment. what field is that? i take notes about future and past appointments and i would to export them in excel.
This comment was minimized by the moderator on the site
Hi Iallement,

I am afraid you can’t. You can show the Message field in the List view, and then copy all rows to a workbook, but it seems no field relevant to comments. If you get solution, would you like to post it here? Thanks!
This comment was minimized by the moderator on the site
Im trying to export shared calendars individually but it seems to only give me the one person calendar to export apart from own. I cant seem to get a list up of different names even though I have full sharing and editing rights on all calendars any suggestions
This comment was minimized by the moderator on the site
how to export calendar to excel with command line
This comment was minimized by the moderator on the site
in step 8 where you have 'map custom fields', I have my own 'user defined-fields in folder' I wish to export with the other fields, how do I get these fields in there?
This comment was minimized by the moderator on the site
Hi I have the same question, were there any reply for your question? I have my own user defined-fields which I wish to export with the other fields but I couldn't seem to get those exported.
This comment was minimized by the moderator on the site
Hi,


User Defined-fields can’t be mapped and
exported by Outlook’s Import/Export feature (the 2ed method I introduced in
this article).

If you need to export custom fields, you
can try the first method introduced in this article: add the custom filed in
the List view, and then copy all rows to Excel workbook.
This comment was minimized by the moderator on the site
So saved it as a .csv and got better results than what i was getting with other file formats. Problem is nothing is in order like it dhould be. Any suggestions?
This comment was minimized by the moderator on the site
I needed to export just one calendar but this method exported everything...so this is what I did - opened the calendar in the List view, Cnrl A (select all)->File Print->Printed in Adobe and then Save As-> Excell SPread Sheet...I know, lots of steps but I got what i needed and in a format i needed. Hope this helps!
This comment was minimized by the moderator on the site
After I click "export to a file" the only options it gives me is: Comma Separated Values or Outlook Data file(.pst) I need to save the calendar as an excel file and email it. Thank you for your help.
This comment was minimized by the moderator on the site
[quote]After I click "export to a file" the only options it gives me is: Comma Separated Values or Outlook Data file(.pst) I need to save the calendar as an excel file and email it. Thank you for your help.By Carma[/quote] A csv file will open in excel fine. Then you can save it as whatever you like from there.
This comment was minimized by the moderator on the site
How can you export shared calendars?
This comment was minimized by the moderator on the site
I think you would have to save it as a CSV which you can then open in Excel and save as xls.
This comment was minimized by the moderator on the site
i did not find a CSV export or save as option in doing this process
There are no comments posted here yet
Load More
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations