{"id":197,"date":"2021-03-17T20:48:25","date_gmt":"2021-03-17T19:48:25","guid":{"rendered":"https:\/\/absklep.pl\/podstawy-jak-zaimportowac-kontakty-ksiazke-adresowa-z-pliku-csv-do-outlooka-2016-2019\/"},"modified":"2024-08-02T13:12:51","modified_gmt":"2024-08-02T11:12:51","slug":"podstawy-jak-zaimportowac-kontakty-ksiazke-adresowa-z-pliku-csv-do-outlooka-2016-2019","status":"publish","type":"post","link":"https:\/\/absklep.pl\/?p=197","title":{"rendered":"Podstawy: Jak zaimportowa\u0107 kontakty (ksi\u0105\u017ck\u0119 adresow\u0105) z pliku .csv do Outlooka 2016\/2019 ?"},"content":{"rendered":"<p>Jak zaimportowa\u0107 kontakty z pliku csv do programu pocztowego Outlook 2016\/2019 ?<\/p>\n<p>Do tej operacji b\u0119dziemy potrzebowali arkusza kalkulacyjnego z nasz\u0105 baz\u0105 kontakt\u00f3w.<br \/>Mo\u017cemy go \u0142atwo przygotowa\u0107 w Excelu lub w dowolnym darmowym arkuszu kalkulacyjnym np. z pakietu OpenOffice.<br \/>Ja przygotowa\u0142em arkusz z 2 kolumnami: <strong>adres e-mail<\/strong>, <strong>nazwa<\/strong>.<br \/>(Bardzo wa\u017cne s\u0105 nazwy kolumn, to nam upro\u015bci p\u00f3\u017aniejszy import &#8211; mapowanie p\u00f3l.)<br \/><img decoding=\"async\" class=\" size-full wp-image-187\" src=\"https:\/\/absklep.pl\/wp-content\/uploads\/2021\/03\/01bemaile_do_importu-78d.jpg\" width=\"400\" height=\"480\" alt=\"01emaile do importu\" \/><br \/>Nast\u0119pnie tak przygotowany arkusz Excela zapisujemy jako typ: <strong>CSV (rozdzielony przecinkami)<\/strong>.<br \/>Niestety, Excel w wersji polskiej, domy\u015blnie jako separatora u\u017cywa \u015brednika, a nie przecinka.<br \/>A my potrzebujemy pliku CSV rozdzielonego przecinkami.<br \/>Mo\u017cna sobie poradzi\u0107 u\u017cywaj\u0105c do zapisu CSV z przecinkami pakiet Open Office.<br \/>Innym sposobem jest u\u017cycie zwyk\u0142ego windowsowego <strong>Notatnika<\/strong>.<br \/>Otwieramy zapisany plik csv w Notatniku.<br \/>Nast\u0119pnie zmieniamy (Ctr+H) <strong>\u015brednik<\/strong>&nbsp;<strong>na<\/strong> <strong>przecinek<\/strong> i klikamy &#8222;<strong>Zmie\u0144 wszystko<\/strong>&#8222;.<\/p>\n<p><img decoding=\"async\" class=\" size-full wp-image-188\" src=\"https:\/\/absklep.pl\/wp-content\/uploads\/2021\/03\/emaile_zmiana_separatora2-b3c.jpg\" width=\"500\" height=\"413\" alt=\"emaile zmiana separatora\" \/><br \/>Zapisujemy plik w formacie csv i mamy wreszcie CSV z separatorami &#8211; przecinkami.<br \/>Je\u015bli otworzymy plik w Excelu:<\/p>\n<p><img decoding=\"async\" class=\" size-full wp-image-189\" src=\"https:\/\/absklep.pl\/wp-content\/uploads\/2021\/03\/emiale_przecinek2-5ee.jpg\" width=\"400\" height=\"540\" alt=\"emiale przecinek\" \/><br \/><strong>Teraz mo\u017cemy przyst\u0105pi\u0107 do w\u0142a\u015bciwego procesu importu kontakt\u00f3w w programie Outlook 2016\/2019<\/strong>.<br \/>Klikamy Plik &gt; Otw\u00f3rz i eksportuj &gt; Importuj\/eksportuj<br \/><img decoding=\"async\" class=\" size-full wp-image-190\" src=\"https:\/\/absklep.pl\/wp-content\/uploads\/2021\/03\/02import_eksport_red-849.jpg\" width=\"500\" height=\"579\" alt=\"02import eksport red\" srcset=\"https:\/\/absklep.pl\/wp-content\/uploads\/2021\/03\/02import_eksport_red-849.jpg 906w, https:\/\/absklep.pl\/wp-content\/uploads\/2021\/03\/02import_eksport_red-849-259x300.jpg 259w, https:\/\/absklep.pl\/wp-content\/uploads\/2021\/03\/02import_eksport_red-849-884x1024.jpg 884w, https:\/\/absklep.pl\/wp-content\/uploads\/2021\/03\/02import_eksport_red-849-768x890.jpg 768w\" sizes=\"(max-width: 500px) 100vw, 500px\" \/><br \/>Nast\u0119pnie w kreatorze importu i eksportu wybieramy &#8222;<strong>Import z innego programu lub pliku<\/strong>&#8222;.<\/p>\n<p><img decoding=\"async\" class=\" size-full wp-image-191\" src=\"https:\/\/absklep.pl\/wp-content\/uploads\/2021\/03\/03import_z_pliku-506.jpg\" width=\"600\" height=\"415\" alt=\"03import z pliku\" srcset=\"https:\/\/absklep.pl\/wp-content\/uploads\/2021\/03\/03import_z_pliku-506.jpg 806w, https:\/\/absklep.pl\/wp-content\/uploads\/2021\/03\/03import_z_pliku-506-300x208.jpg 300w, https:\/\/absklep.pl\/wp-content\/uploads\/2021\/03\/03import_z_pliku-506-768x532.jpg 768w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/p>\n<p>Teraz wybieramy typ importowanego pliku &#8222;<strong>Warto\u015bci oddzielone przecinkami<\/strong>&#8222;<\/p>\n<p><img decoding=\"async\" class=\" size-full wp-image-192\" src=\"https:\/\/absklep.pl\/wp-content\/uploads\/2021\/03\/04wart_oddziel_przecnik-c5e.jpg\" width=\"600\" height=\"415\" alt=\"04wart oddziel przecnik\" srcset=\"https:\/\/absklep.pl\/wp-content\/uploads\/2021\/03\/04wart_oddziel_przecnik-c5e.jpg 806w, https:\/\/absklep.pl\/wp-content\/uploads\/2021\/03\/04wart_oddziel_przecnik-c5e-300x208.jpg 300w, https:\/\/absklep.pl\/wp-content\/uploads\/2021\/03\/04wart_oddziel_przecnik-c5e-768x532.jpg 768w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/p>\n<p>I w ko\u0144cu wybieramy folder docelowy importowanego pliku, czyli <strong>Kontakty<\/strong>.<\/p>\n<p><img decoding=\"async\" class=\" size-full wp-image-193\" src=\"https:\/\/absklep.pl\/wp-content\/uploads\/2021\/03\/05folder_docelowy-32b.jpg\" width=\"600\" height=\"415\" alt=\"05folder docelowy\" srcset=\"https:\/\/absklep.pl\/wp-content\/uploads\/2021\/03\/05folder_docelowy-32b.jpg 806w, https:\/\/absklep.pl\/wp-content\/uploads\/2021\/03\/05folder_docelowy-32b-300x208.jpg 300w, https:\/\/absklep.pl\/wp-content\/uploads\/2021\/03\/05folder_docelowy-32b-768x532.jpg 768w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/p>\n<p>Teraz poka\u017ce nam si\u0119 okno z mapowanie p\u00f3l. Klikamy &#8222;<strong>Mapuj pola niestandardowe<\/strong>&#8222;.<br \/>W naszym przypadku <strong>s\u0105 to dwa pola: nazwa i adres e-mail.<\/strong><\/p>\n<p><img decoding=\"async\" class=\" size-full wp-image-194\" src=\"https:\/\/absklep.pl\/wp-content\/uploads\/2021\/03\/mapuj_pola_niestandardowe-158.jpg\" width=\"600\" height=\"415\" alt=\"mapuj pola niestandardowe\" srcset=\"https:\/\/absklep.pl\/wp-content\/uploads\/2021\/03\/mapuj_pola_niestandardowe-158.jpg 806w, https:\/\/absklep.pl\/wp-content\/uploads\/2021\/03\/mapuj_pola_niestandardowe-158-300x208.jpg 300w, https:\/\/absklep.pl\/wp-content\/uploads\/2021\/03\/mapuj_pola_niestandardowe-158-768x532.jpg 768w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><img decoding=\"async\" class=\" size-full wp-image-195\" src=\"https:\/\/absklep.pl\/wp-content\/uploads\/2021\/03\/mapowanie_niestandardowe-c44.jpg\" width=\"600\" height=\"472\" alt=\"mapowanie niestandardowe\" srcset=\"https:\/\/absklep.pl\/wp-content\/uploads\/2021\/03\/mapowanie_niestandardowe-c44.jpg 810w, https:\/\/absklep.pl\/wp-content\/uploads\/2021\/03\/mapowanie_niestandardowe-c44-300x236.jpg 300w, https:\/\/absklep.pl\/wp-content\/uploads\/2021\/03\/mapowanie_niestandardowe-c44-768x604.jpg 768w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/p>\n<p>Po zako\u0144czeniu pracy kreatora importu otrzymujemy <strong>zaimportowane kontakty.<\/strong><\/p>\n<p><img decoding=\"async\" class=\" size-full wp-image-196\" src=\"https:\/\/absklep.pl\/wp-content\/uploads\/2021\/03\/zaimportowane_kontakty-3b1.jpg\" width=\"600\" height=\"569\" alt=\"zaimportowane kontakty\" srcset=\"https:\/\/absklep.pl\/wp-content\/uploads\/2021\/03\/zaimportowane_kontakty-3b1.jpg 864w, https:\/\/absklep.pl\/wp-content\/uploads\/2021\/03\/zaimportowane_kontakty-3b1-300x284.jpg 300w, https:\/\/absklep.pl\/wp-content\/uploads\/2021\/03\/zaimportowane_kontakty-3b1-768x728.jpg 768w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/p>\n<p>A tu jest pokazane na filmiku jak wykona\u0107 powy\u017csze czynno\u015bci:<\/p>\n<p><iframe width=\"560\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/L6YHVqhB6Ts\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p>Tu mo\u017cna kupi\u0107 Pakiet Ofiice 2019 i Offcie 365:<\/p>\n<p><script class=\"moneteasy-widget-112363\" src=\"https:\/\/widgets.moneteasy.pl\/widget\/112363,23182\" type=\"text\/javascript\"><\/script><br \/>\n<script class=\"moneteasy-widget-112364\" src=\"https:\/\/widgets.moneteasy.pl\/widget\/112364,23183\" type=\"text\/javascript\"><\/script><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Jak zaimportowa\u0107 kontakty z pliku csv do programu pocztowego Outlook 2016\/2019 ? Do tej operacji b\u0119dziemy potrzebowali arkusza kalkulacyjnego z nasz\u0105 baz\u0105 kontakt\u00f3w.Mo\u017cemy go \u0142atwo przygotowa\u0107 w Excelu lub w dowolnym darmowym arkuszu kalkulacyjnym np. z pakietu OpenOffice.Ja przygotowa\u0142em arkusz z 2 kolumnami: adres e-mail, nazwa.(Bardzo wa\u017cne s\u0105 nazwy kolumn, to nam upro\u015bci p\u00f3\u017aniejszy import [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":187,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ocean_post_layout":"","ocean_both_sidebars_style":"","ocean_both_sidebars_content_width":0,"ocean_both_sidebars_sidebars_width":0,"ocean_sidebar":"","ocean_second_sidebar":"","ocean_disable_margins":"enable","ocean_add_body_class":"","ocean_shortcode_before_top_bar":"","ocean_shortcode_after_top_bar":"","ocean_shortcode_before_header":"","ocean_shortcode_after_header":"","ocean_has_shortcode":"","ocean_shortcode_after_title":"","ocean_shortcode_before_footer_widgets":"","ocean_shortcode_after_footer_widgets":"","ocean_shortcode_before_footer_bottom":"","ocean_shortcode_after_footer_bottom":"","ocean_display_top_bar":"default","ocean_display_header":"default","ocean_header_style":"","ocean_center_header_left_menu":"","ocean_custom_header_template":"","ocean_custom_logo":0,"ocean_custom_retina_logo":0,"ocean_custom_logo_max_width":0,"ocean_custom_logo_tablet_max_width":0,"ocean_custom_logo_mobile_max_width":0,"ocean_custom_logo_max_height":0,"ocean_custom_logo_tablet_max_height":0,"ocean_custom_logo_mobile_max_height":0,"ocean_header_custom_menu":"","ocean_menu_typo_font_family":"","ocean_menu_typo_font_subset":"","ocean_menu_typo_font_size":0,"ocean_menu_typo_font_size_tablet":0,"ocean_menu_typo_font_size_mobile":0,"ocean_menu_typo_font_size_unit":"px","ocean_menu_typo_font_weight":"","ocean_menu_typo_font_weight_tablet":"","ocean_menu_typo_font_weight_mobile":"","ocean_menu_typo_transform":"","ocean_menu_typo_transform_tablet":"","ocean_menu_typo_transform_mobile":"","ocean_menu_typo_line_height":0,"ocean_menu_typo_line_height_tablet":0,"ocean_menu_typo_line_height_mobile":0,"ocean_menu_typo_line_height_unit":"","ocean_menu_typo_spacing":0,"ocean_menu_typo_spacing_tablet":0,"ocean_menu_typo_spacing_mobile":0,"ocean_menu_typo_spacing_unit":"","ocean_menu_link_color":"","ocean_menu_link_color_hover":"","ocean_menu_link_color_active":"","ocean_menu_link_background":"","ocean_menu_link_hover_background":"","ocean_menu_link_active_background":"","ocean_menu_social_links_bg":"","ocean_menu_social_hover_links_bg":"","ocean_menu_social_links_color":"","ocean_menu_social_hover_links_color":"","ocean_disable_title":"default","ocean_disable_heading":"default","ocean_post_title":"","ocean_post_subheading":"","ocean_post_title_style":"","ocean_post_title_background_color":"","ocean_post_title_background":0,"ocean_post_title_bg_image_position":"","ocean_post_title_bg_image_attachment":"","ocean_post_title_bg_image_repeat":"","ocean_post_title_bg_image_size":"","ocean_post_title_height":0,"ocean_post_title_bg_overlay":0.5,"ocean_post_title_bg_overlay_color":"","ocean_disable_breadcrumbs":"default","ocean_breadcrumbs_color":"","ocean_breadcrumbs_separator_color":"","ocean_breadcrumbs_links_color":"","ocean_breadcrumbs_links_hover_color":"","ocean_display_footer_widgets":"default","ocean_display_footer_bottom":"default","ocean_custom_footer_template":"","ocean_post_oembed":"","ocean_post_self_hosted_media":"","ocean_post_video_embed":"","ocean_link_format":"","ocean_link_format_target":"self","ocean_quote_format":"","ocean_quote_format_link":"post","ocean_gallery_link_images":"on","ocean_gallery_id":[],"footnotes":""},"categories":[6],"tags":[],"class_list":["post-197","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office","entry","has-media"],"_links":{"self":[{"href":"https:\/\/absklep.pl\/index.php?rest_route=\/wp\/v2\/posts\/197","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/absklep.pl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/absklep.pl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/absklep.pl\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/absklep.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=197"}],"version-history":[{"count":1,"href":"https:\/\/absklep.pl\/index.php?rest_route=\/wp\/v2\/posts\/197\/revisions"}],"predecessor-version":[{"id":563,"href":"https:\/\/absklep.pl\/index.php?rest_route=\/wp\/v2\/posts\/197\/revisions\/563"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/absklep.pl\/index.php?rest_route=\/wp\/v2\/media\/187"}],"wp:attachment":[{"href":"https:\/\/absklep.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=197"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/absklep.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=197"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/absklep.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=197"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}