Note: The other languages of the website are Google-translated. Back to English
登入  \/ 
x
or
x
註冊  \/ 
x

or

如何將日曆從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文件等! 點擊免費試用60天,不受限制!
廣告批次另存為9.50

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

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

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

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

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

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

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

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

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

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

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

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

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


演示:將Outlook日曆導出到Excel


小技巧: : 在這個視頻裡, Kutools 選項卡添加者 Kutools for Outlook。 如果需要,請單擊 ,請點擊這裡。 免費試用60天!


Kutools for Outlook-為Outlook帶來100個高級功能,並使工作更加輕鬆!

  • 自動CC / BCC 根據規則發送電子郵件; 自動前進 自定義多封電子郵件; 自動回复 沒有交換服務器,還有更多自動功能...
  • BCC警告 -當您嘗試全部答复時顯示消息 如果您的郵件地址在“密件抄送”列表中; 缺少附件時提醒,還有更多提醒功能...
  • 在郵件對話中回复(全部)帶有所有附件; 回复許多電子郵件 片刻之間; 自動添加問候語 回复時將日期添加到主題中...
  • 附件工具:管理所有郵件中的所有附件, 自動分離, 全部壓縮,重命名全部,保存全部...快速報告, 計算選定的郵件...
  • 強大的垃圾郵件 習俗 刪除重複的郵件和聯繫人... 使您能夠在Outlook中做得更聰明,更快和更好。
拍攝kutools前景kutools選項卡1180x121
拍攝kutools前景kutools加標籤1180x121
 
Say something here...
symbols left.
You are guest
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    kelly001 · 3 years ago
    @Del Hi Del,
    One calendar is a folder in Outlook. Outlook supports to export one folder at a time.
  • To post as a guest, your comment is unpublished.
    Del · 3 years ago
    Can I export all my team member's calendar at same time?
  • To post as a guest, your comment is unpublished.
    · 3 years ago
    @Philyn 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.
  • To post as a guest, your comment is unpublished.
    Philyn · 3 years ago
    @Raf 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.
  • To post as a guest, your comment is unpublished.
    · 3 years ago
    @lallement 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!
  • To post as a guest, your comment is unpublished.
    lallement · 3 years ago
    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.
  • To post as a guest, your comment is unpublished.
    andy · 3 years ago
    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
  • To post as a guest, your comment is unpublished.
    ibrahim · 4 years ago
    how to export calendar to excel with command line
  • To post as a guest, your comment is unpublished.
    Raf · 4 years ago
    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?
  • To post as a guest, your comment is unpublished.
    Jill · 5 years ago
    @Kyle 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!
  • To post as a guest, your comment is unpublished.
    Kyle · 5 years ago
    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?
  • To post as a guest, your comment is unpublished.
    weenadelic · 6 years ago
    @Carma [quote name="Carma"]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.[/quote]

    A csv file will open in excel fine. Then you can save it as whatever you like from there.
  • To post as a guest, your comment is unpublished.
    Carma · 6 years ago
    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.
  • To post as a guest, your comment is unpublished.
    Opie · 6 years ago
    How can you export shared calendars?
  • To post as a guest, your comment is unpublished.
    Bebbs · 6 years ago
    I think you would have to save it as a CSV which you can then open in Excel and save as xls.
  • To post as a guest, your comment is unpublished.
    DH · 6 years ago
    How would you export the calendar into Excel if the feature has been taken out of Outlook 2013? Any Ideas?
  • To post as a guest, your comment is unpublished.
    Jesse · 6 years ago
    Support to export to .xls is no longer supported in Outlook 2013
  • To post as a guest, your comment is unpublished.
    nj · 6 years ago
    Great! but i'm having trouble exporting to excel... it only gives me the option of csv or pst... any suggestions?