Opomba: Drugi jeziki spletnega mesta so prevedeni z Googlom. Nazaj na angleščino
Vpiši se  \/ 
x
or
x
Registracija  \/ 
x

or

Kako izvoziti koledar iz Outlooka v preglednico Excel?

Koledar v Outlooku lahko delite z drugimi tako, da izvozite koledar v Outlooku in ga nato uvozite v mapo koledarja Outlook. Obstaja pa vprašanje, kako ga izvoziti. Naslednje vadnice vam bodo povedale, kako izvozite koledar Outlooka v preglednico Excel.

Izvoz koledarja iz Outlookove preglednice v Excel brez funkcije Izvoz

Prva metoda bo uvedla enostaven hiter izvoz vseh elementov koledarja iz Outlookove preglednice v Excel brez funkcije Uvozi in izvozi. Naredite naslednje:

1. Premaknite mapo Koledar in izberite koledar, ki ga želite izvoziti v Excel.

2. Spremenite pogled koledarja s klikom Pogled > Spremeni pogled > Seznam. Oglejte si posnetek zaslona:

3. Izberite vse elemente koledarja ali več, ki jih boste izvozili v Excel.
Opomba: Drži Ctrl tipko, lahko izberete več sosednjih elementov s klikom vsakega elementa enega za drugim; držite Shift tipko, lahko izberete več sosednjih elementov s klikom prvega in zadnjega.

4. Z desno miškino tipko kliknite izbrane elemente in izberite Kopiraj v meniju z desnim klikom.

5. Ustvarite nov delovni zvezek, z desno miškino tipko kliknite prazno celico in izberite Ohrani samo besedilo (T) v meniju z desnim klikom. Oglejte si posnetek zaslona:

6. Shranite in zaprite nov delovni zvezek.

Torej se za izbrane elemente koledarja že izvozi v nov delovni zvezek.

Z enim klikom shranite / izvozite več e-poštnih sporočil v besedilo / PDF / HTML / CSV v razsutem stanju v Outlooku

Običajno lahko izvozimo / shranimo e-poštno sporočilo kot besedilno datoteko s funkcijo Shrani kot v Outlooku. Za paketno shranjevanje / izvoz več e-poštnih sporočil v posamezne besedilne datoteke morate vsako sporočilo ročno obdelati eno za drugim. Zamudno! Utrujen! Zdaj Kutools za Outlook Shrani paket funkcija vam lahko pomaga hitro shraniti več e-poštnih sporočil v posamezne besedilne datoteke, datoteke PDF, datoteke HTML itd.! Kliknite za 60-dnevno brezplačno preskusno različico brez omejitev!
paket oglasov shrani kot 9.50

Izvoz koledarja iz Outlookove preglednice v Excel

1. Pojdi do file > Odpri in izvozi> Uvozi / izvozi. Oglejte si posnetek zaslona:

2. V uvodnem čarovniku za uvoz in izvoz pod Izberite dejanje, ki ga želite izvestitako, da izberete Izvoz v datotekoIn nato Naslednji za nadaljevanje.

3. v Izvozi v datoteko pogovorno okno, izberite Vrednosti, ločene z vejicoIn nato Naslednji. Oglejte si posnetek zaslona:

Opombe: Če uporabljate Outlook 2010 ali starejše različice, izberite Microsoft Excel 97-2003 možnost neposredno.

4. Zdaj, pod Izberite mapo, iz katere želite izvozititako, da izberete Koledar iz Podatkovna datoteka OutlookIn nato Naslednji.

5. Ko Izvozi v datoteko pogovorno okno, ki se prikaže, kliknite Prebrskaj ... , da izberete cilj datoteke.

6. Prebrskajte in izberite cilj, kamor lahko datoteko shranite. Datoteko poimenujte in na koncu kliknite OK , da zaprete pogovorno okno.

7. Ko se obrne na prejšnje Izvozi v datoteko dialog, kliknite Naslednji za nadaljevanje.

8. Zdaj še eno Izvozi v datoteko pogovorno okno, ki se odpre, kliknite Konec za izvoz koledarja Outlook. Oglejte si posnetek zaslona:

9. V pogovornem oknu Nastavi časovno obdobje določite časovno obdobje, v katerem boste koledar izvozili, in kliknite na OK gumb.

Opombe: Če uporabljate Outlook 2010 ali starejše različice in izberete Microsoft Excel 97-2003 V 3. koraku je bil koledar že izvožen kot Excelov delovni zvezek. Če uporabljate Outlook 2013 ali novejšo različico, je bil koledar izvožen kot datoteka CSV in nadaljujte s spodnjim korakom.

10. Zdaj smo navedeni koledar izvozili kot datoteko CSV. Odprite datoteko CSV z Microsoft Excelom in jo shranite kot delovni zvezek.

Predstavitev: izvozite koledar Outlooka v Excel


Nasvet: V tem videu, Kutools zavihek doda Kutools za Outlook. Če jo potrebujete, kliknite tukaj imeti 60-dnevno brezplačno preskusno različico brez omejitev!

Kutools za Outlook - prinaša 100 naprednih funkcij v Outlook in olajša delo!

  • Samodejno CC / BCC po pravilih pri pošiljanju e-pošte; Samodejno posredovanje naprej Več e-poštnih sporočil po meri; Samodejni odgovor brez strežnika za izmenjavo in več samodejnih funkcij ...
  • Opozorilo pred BCC - prikaži sporočilo, ko poskušate odgovoriti vsem če je vaš poštni naslov na seznamu BCC; Opomni, ko manjkajo priloge, in več opomnikov ...
  • Odgovori (vsi) z vsemi prilogami v e-poštnem pogovoru; Odgovori na veliko e-poštnih sporočil v nekaj sekundah; Samodejno dodaj pozdrav ko odgovor; Dodaj datum v zadevo ...
  • Orodja za priloge: Upravljanje vseh prilog v vseh e-poštnih sporočilih, Samodejno loči, Stisni vse, Preimenuj vse, Shrani vse ... Hitro poročilo, Štejte izbrano pošto...
  • Zmogljiva neželena e-poštna sporočila po meri; Odstranite podvojene pošte in stike... Omogočajo vam pametnejše, hitrejše in boljše delovanje v Outlooku.
strelec kutools outlook kutools zavihek 1180x121
shot kutools outlook kutools plus tab 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?