{"id":12084,"date":"2018-10-20T01:31:30","date_gmt":"2018-10-19T23:31:30","guid":{"rendered":"http:\/\/blog.wenzlaff.de\/?p=12084"},"modified":"2021-12-07T11:19:14","modified_gmt":"2021-12-07T10:19:14","slug":"excel-csv-import-mit-falschen-umlauten-in-2-minuten-fixen","status":"publish","type":"post","link":"http:\/\/blog.wenzlaff.de\/?p=12084","title":{"rendered":"Excel CSV Import mit falschen Umlauten in 2 Minuten fixen"},"content":{"rendered":"<p>Manchmal \u00f6ffnet man mit Excel per doppelklick eine CSV Datei und hat pl\u00f6tzlich alle Umlaute defekt. Wie kann das korrigiert werden? Wie hier z.B.<\/p>\n<p><a href=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2018\/10\/Bildschirmfoto-2018-10-10-um-19.17.26.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2018\/10\/Bildschirmfoto-2018-10-10-um-19.17.26.png\" alt=\"\" width=\"781\" height=\"296\" class=\"aligncenter size-full wp-image-12091\" srcset=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2018\/10\/Bildschirmfoto-2018-10-10-um-19.17.26.png 781w, http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2018\/10\/Bildschirmfoto-2018-10-10-um-19.17.26-300x114.png 300w, http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2018\/10\/Bildschirmfoto-2018-10-10-um-19.17.26-768x291.png 768w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/a><\/p>\n<p>Das kann man fixen, in dem man Excel mit einer neuen Tabelle \u00f6ffnet: <!--more--><\/p>\n<figure id=\"attachment_12096\" aria-describedby=\"caption-attachment-12096\" style=\"width: 763px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2018\/10\/Bildschirmfoto-2018-10-10-um-19.17.55.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2018\/10\/Bildschirmfoto-2018-10-10-um-19.17.55.png\" alt=\"Excel CSV Import\" width=\"763\" height=\"313\" class=\"size-full wp-image-12096\" srcset=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2018\/10\/Bildschirmfoto-2018-10-10-um-19.17.55.png 763w, http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2018\/10\/Bildschirmfoto-2018-10-10-um-19.17.55-300x123.png 300w\" sizes=\"auto, (max-width: 706px) 89vw, (max-width: 767px) 82vw, 740px\" \/><\/a><figcaption id=\"caption-attachment-12096\" class=\"wp-caption-text\">Excel CSV Import<\/figcaption><\/figure>\n<p>und dann im Men\u00fc: <strong>Datei &#8211; Importieren<\/strong> klicken: <\/p>\n<p><a href=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2018\/10\/Bildschirmfoto-2018-10-10-um-19.18.29.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2018\/10\/Bildschirmfoto-2018-10-10-um-19.18.29.png\" alt=\"\" width=\"394\" height=\"485\" class=\"aligncenter size-full wp-image-12092\" srcset=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2018\/10\/Bildschirmfoto-2018-10-10-um-19.18.29.png 394w, http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2018\/10\/Bildschirmfoto-2018-10-10-um-19.18.29-244x300.png 244w\" sizes=\"auto, (max-width: 394px) 100vw, 394px\" \/><\/a><\/p>\n<p>wir w\u00e4hlen <strong>CSV-Datei<\/strong> &#8230;<\/p>\n<p><a href=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2018\/10\/Bildschirmfoto-2018-10-10-um-19.18.44.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2018\/10\/Bildschirmfoto-2018-10-10-um-19.18.44.png\" alt=\"\" width=\"460\" height=\"301\" class=\"aligncenter size-full wp-image-12094\" srcset=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2018\/10\/Bildschirmfoto-2018-10-10-um-19.18.44.png 460w, http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2018\/10\/Bildschirmfoto-2018-10-10-um-19.18.44-300x196.png 300w\" sizes=\"auto, (max-width: 460px) 100vw, 460px\" \/><\/a><\/p>\n<p>und dann, das ist der Schl\u00fcssel auf <strong>Dateiursprung Unicode UTF-8<\/strong> und<\/p>\n<p><a href=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2018\/10\/Bildschirmfoto-2018-10-10-um-19.19.32.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2018\/10\/Bildschirmfoto-2018-10-10-um-19.19.32.png\" alt=\"\" width=\"765\" height=\"442\" class=\"aligncenter size-full wp-image-12093\" srcset=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2018\/10\/Bildschirmfoto-2018-10-10-um-19.19.32.png 765w, http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2018\/10\/Bildschirmfoto-2018-10-10-um-19.19.32-300x173.png 300w\" sizes=\"auto, (max-width: 706px) 89vw, (max-width: 767px) 82vw, 740px\" \/><\/a><\/p>\n<p>alles ist ok<\/p>\n<p><a href=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2018\/10\/Bildschirmfoto-2018-10-10-um-19.19.59.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2018\/10\/Bildschirmfoto-2018-10-10-um-19.19.59.png\" alt=\"\" width=\"722\" height=\"59\" class=\"aligncenter size-full wp-image-12095\" srcset=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2018\/10\/Bildschirmfoto-2018-10-10-um-19.19.59.png 722w, http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2018\/10\/Bildschirmfoto-2018-10-10-um-19.19.59-300x25.png 300w\" sizes=\"auto, (max-width: 722px) 100vw, 722px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Manchmal \u00f6ffnet man mit Excel per doppelklick eine CSV Datei und hat pl\u00f6tzlich alle Umlaute defekt. Wie kann das korrigiert werden? Wie hier z.B. Das kann man fixen, in dem man Excel mit einer neuen Tabelle \u00f6ffnet:<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[220,2769,2533,3187],"tags":[1721,3435,2310,3434,3433,189,3432],"class_list":["post-12084","post","type-post","status-publish","format-standard","hentry","category-anleitung","category-excel","category-fix","category-office","tag-csv","tag-csv-umlaute","tag-excel","tag-excel-fix","tag-umlaut","tag-umlaute","tag-umlaute-utf-8"],"_links":{"self":[{"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=\/wp\/v2\/posts\/12084","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=12084"}],"version-history":[{"count":0,"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=\/wp\/v2\/posts\/12084\/revisions"}],"wp:attachment":[{"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=12084"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=12084"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=12084"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}