Note: The other languages of the website are Google-translated. Back to English
Mewngofnodi  \/ 
x
or
x
Cofrestru  \/ 
x

or

Sut i allforio calendr o Outlook i daenlen Excel?

Ffordd i chi rannu'ch calendr Outlook ag eraill yw allforio'ch calendr Outlook ac yna ei fewnforio i ffolder calendr Outlook pobl eraill. Ond mae cwestiwn sut i allforio. Bydd y tiwtorialau canlynol yn rhoi gwybod i chi sut i allforio'ch calendr Outlook i daenlen Excel.


Allforio calendr o Outlook i daenlen Excel heb nodwedd Allforio

Bydd y dull cyntaf yn cyflwyno hawdd i allforio pob eitem galendr yn gyflym o daenlen Outlook i Excel heb y nodwedd Mewnforio ac Allforio. Gwnewch fel a ganlyn:

1. Symudwch y ffolder Calendr, a dewiswch y calendr y byddwch chi'n ei allforio i Excel.

2. Newid yr olygfa galendr gyda chlicio Gweld > Newid Golwg > rhestr. Gweler y screenshot:

3. Dewiswch yr holl eitemau calendr neu rai lluosog y byddwch chi'n eu hallforio i Excel.
Nodyn: Cynnal y Ctrl allwedd, gallwch ddewis nifer o eitemau nad ydynt yn gyfagos gyda chlicio pob eitem fesul un; dal y Symud allwedd, gallwch ddewis nifer o eitemau cyfagos gyda chlicio'r un cyntaf a'r un olaf.

4. Cliciwch ar y dde ar yr eitemau a ddewiswyd, a dewiswch y copi o'r ddewislen clicio ar y dde.

5. Creu llyfr gwaith newydd, cliciwch ar y dde ar gell wag a dewiswch y Cadwch Testun yn Unig (T) botwm yn y ddewislen clicio ar y dde. Gweler y screenshot:

6. Cadw a chau'r llyfr gwaith newydd.

Felly ar gyfer yr eitemau calendr a ddewiswyd, mae eitemau'n cael eu hallforio i lyfr gwaith newydd yn barod.

Un clic i arbed / allforio sawl e-bost i ffeiliau testun / PDF / HTML / CSV mewn swmp yn Outlook

Fel rheol gallwn allforio / cadw neges e-bost fel ffeil testun gyda'r nodwedd Save As yn Outlook. Ond, ar gyfer arbed batsh / allforio sawl e-bost i ffeiliau testun unigol, mae'n rhaid i chi drin pob neges â llaw fesul un. Yn cymryd llawer o amser! Tedious! Nawr, Kutools ar gyfer Outlook's Arbed Swp gall nodwedd eich helpu i arbed nifer o negeseuon e-bost yn gyflym i ffeiliau testun unigol, ffeiliau PDF, ffeiliau HTML, ac ati! Cliciwch am dreial 60 diwrnod am ddim heb gyfyngiad!
swp ad ac eithrio fel 9.50

Allforio calendr o Outlook i daenlen Excel

1. Mynd i ffeil > Agor ac Allforio> Mewnforio / Allforio. Gweler y screenshot:

2. Yn y Dewin Mewnforio ac Allforio agoriadol, Dan Dewiswch weithred i'w pherfformio, dewiswch Allforio i ffeil, ac yna cliciwch nesaf i barhau.

3. . In Yn Allforio i Ffeil deialog, dewiswch Gwerthoedd Gwahanu Comma, ac yna cliciwch nesaf. Gweler y screenshot:

Nodyn: Os ydych chi'n defnyddio Outlook 2010 neu fersiynau cynharach, dewiswch y Microsoft Excel 97-2003 opsiwn yn uniongyrchol.

4. Nawr, o dan Dewiswch ffolder i allforio ohono, dewiswch calendr o Ffeil Data Outlook, ac yna cliciwch nesaf.

5. Pan fydd y Allforio i Ffeil deialog yn dangos i fyny, cliciwch Pori ... botwm i ddewis cyrchfan y ffeil.

6. Porwch a dewiswch y gyrchfan lle gellir cadw'r ffeil. Enwch y ffeil ac yn olaf cliciwch OK i gau'r ymgom.

7. Pan fydd yn troi at y blaenorol Allforio i Ffeil deialog, cliciwch nesaf i barhau.

8. Nawr un arall Allforio i Ffeil dialog popping up, cliciwch Gorffen i allforio eich calendr Outlook. Gweler y screenshot:

9. Yn y blwch deialog Set Date Range, nodwch yr ystod dyddiad y byddwch yn allforio calendr ynddo, a chliciwch ar y OK botwm.

Nodyn: Os ydych chi'n defnyddio Outlook 2010 neu fersiynau cynharach, a'ch bod chi'n dewis y Microsoft Excel 97-2003 opsiwn yng Ngham 3, mae'r calendr wedi'i allforio fel llyfr gwaith Excel yn barod. Os ydych chi'n defnyddio Outlook 2013 neu fersiynau uwch, mae'r calendr wedi'i allforio fel ffeil CSV, ac ewch ymlaen gyda'r cam islaw.

10. Nawr rydym wedi allforio'r calendr penodedig fel ffeil CSV. Agorwch y ffeil CSV gyda Microsoft Excel, ac yna arbedwch y ffeil fel llyfr gwaith.


Demo: allforio calendr Outlook i Excel


Tip: Yn y Fideo hwn, Kutools tab yn cael ei ychwanegu gan Kutools ar gyfer Rhagolwg. Os oes ei angen arnoch, cliciwch yma <http://sizeofwales.org.uk/donate/> i gael treial am ddim 60 diwrnod heb gyfyngiad!


Kutools for Outlook - Yn Dod â 100 o Nodweddion Uwch i'w Rhagweld, a Gwneud Gwaith yn Haws Osgach!

  • Auto CC / BCC yn ôl rheolau wrth anfon e-bost; Auto Ymlaen E-byst Lluosog yn ôl arfer; Ymateb Auto heb weinydd cyfnewid, a nodweddion mwy awtomatig ...
  • Rhybudd BCC - dangoswch neges pan geisiwch ateb popeth os yw'ch cyfeiriad post yn rhestr BCC; Atgoffwch Wrth Ymlyniadau ar Goll, a mwy o nodweddion atgoffa ...
  • Ymateb (Pawb) Gyda'r Holl Atodiadau yn y sgwrs bost; Ateb Llawer o E-byst mewn eiliadau; Auto Ychwanegu Cyfarchiad wrth ateb; Ychwanegu Dyddiad i'r pwnc ...
  • Offer Ymlyniad: Rheoli Pob Atodiad ym mhob Post, Auto Detach, Cywasgu Pawb, Ail-enwi Pawb, Arbed Pawb ... Adroddiad Cyflym, Cyfrif Postiau Dethol...
  • E-byst Sothach Pwerus yn ôl arfer; Tynnwch y Post a Chysylltiadau Dyblyg... Yn eich galluogi i wneud yn ddoethach, yn gyflymach ac yn well yn Outlook.
tab kutools rhagweld kutools tab 1180x121
kutools rhagweld rhagolygon kutools ynghyd â thab 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?