The Microsoft Excel Unicode UTF-8 Gotcha<\/p>\n
Pretty unbelievable, but true, is that (since Office 2003?) Microsoft Excel cannot properly handle Unicode UTF-8 Import and Export to look after your accented and other special characters used on your website. (Try exporting \u00b5 ≥ or ≤ or just a \u00b0 Degree sign!)<\/p>\n
You can<\/em> get Excel to import UTF-8 Menu > Data > From Text > CSV file > Import dialogue: [options] UTF-8<\/p>\n But it will screw up on your carriage return\/line feeds, and the data will be (literally) all over the place. Duh!<\/p>\n The only option I have found that worked was to use LibreOffice Calc (and not ApacheOffice Calc, where IFERROR() doesn\u2019t seem to work).<\/p>\n Using that for Unicode UTF-8 Imports and Exports worked absolutely fine, and your Website will look like it should\u2026<\/p>\n","protected":false},"excerpt":{"rendered":" The Microsoft Excel Unicode UTF-8 Gotcha Pretty unbelievable, but true, is that (since Office 2003?) Microsoft Excel cannot […]<\/p>\n","protected":false},"author":1,"featured_media":1937,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-1935","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-design"],"_links":{"self":[{"href":"https:\/\/ind-tech.com\/index.php?rest_route=\/wp\/v2\/posts\/1935","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ind-tech.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ind-tech.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ind-tech.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ind-tech.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1935"}],"version-history":[{"count":3,"href":"https:\/\/ind-tech.com\/index.php?rest_route=\/wp\/v2\/posts\/1935\/revisions"}],"predecessor-version":[{"id":1939,"href":"https:\/\/ind-tech.com\/index.php?rest_route=\/wp\/v2\/posts\/1935\/revisions\/1939"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ind-tech.com\/index.php?rest_route=\/wp\/v2\/media\/1937"}],"wp:attachment":[{"href":"https:\/\/ind-tech.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1935"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ind-tech.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1935"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ind-tech.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1935"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}