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。在 导出到文件 对话框,请选择 逗号分隔值,然后单击 下一页。 看截图:

备注:如果您使用的是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.
    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.
      kelly001 · 3 years ago
      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.
    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.
      · 3 years ago
      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.
    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 · 3 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.
      Philyn · 3 years ago
      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
        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.
    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.
      Jill · 5 years ago
      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.
    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.
      weenadelic · 5 years ago
      [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.
    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?