{"id":7282,"date":"2026-01-14T14:54:59","date_gmt":"2026-01-14T21:54:59","guid":{"rendered":"https:\/\/support.spatialkey.com\/?p=7282"},"modified":"2026-01-23T15:17:31","modified_gmt":"2026-01-23T22:17:31","slug":"foreign-language-characters","status":"publish","type":"post","link":"https:\/\/support.spatialkey.com\/foreign-language-characters\/","title":{"rendered":"Foreign Language Characters"},"content":{"rendered":"<p>SpatialKey supports a wide range of languages and characters in datasets uploaded as CSV files. In most cases if the data looks right on your computer before uploading, it will appear correctly in SpatialKey. However, this doesn&#8217;t always produce perfect results. There are some manual steps you can take to ensure the best support for the full range of characters in your data.<\/p>\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/support.spatialkey.com\/wp-content\/uploads\/2026\/01\/JapaneseChars.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1032\" height=\"664\" src=\"https:\/\/support.spatialkey.com\/wp-content\/uploads\/2026\/01\/JapaneseChars.png\" alt=\"Example dashboard with Japanese characters\" class=\"wp-image-8409\" srcset=\"https:\/\/support.spatialkey.com\/wp-content\/uploads\/2026\/01\/JapaneseChars.png 1032w, https:\/\/support.spatialkey.com\/wp-content\/uploads\/2026\/01\/JapaneseChars-300x193.png 300w, https:\/\/support.spatialkey.com\/wp-content\/uploads\/2026\/01\/JapaneseChars-1024x659.png 1024w, https:\/\/support.spatialkey.com\/wp-content\/uploads\/2026\/01\/JapaneseChars-768x494.png 768w, https:\/\/support.spatialkey.com\/wp-content\/uploads\/2026\/01\/JapaneseChars-60x39.png 60w\" sizes=\"auto, (max-width: 1032px) 100vw, 1032px\" \/><\/a><figcaption class=\"wp-element-caption\"><em>Example with Japanese characters<\/em><\/figcaption><\/figure>\n<\/p>\n<h2 class=\"wp-block-heading has-medium-font-size\"><strong>What bad data will look like<\/strong><\/h2>\n<p>If you are working with a dataset in SpatialKey and see data that either shows a square icon or question marks (Windows) or a diamond with a question mark (Mac) then there was a problem with the CSV upload. These errors can often be fixed by saving the CSV file with a specific character encoding.<\/p>\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/support.spatialkey.com\/wp-content\/uploads\/2026\/01\/UnrecognizedChars.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1032\" height=\"546\" src=\"https:\/\/support.spatialkey.com\/wp-content\/uploads\/2026\/01\/UnrecognizedChars.png\" alt=\"Example dashboard with invalid characters\" class=\"wp-image-8410\" srcset=\"https:\/\/support.spatialkey.com\/wp-content\/uploads\/2026\/01\/UnrecognizedChars.png 1032w, https:\/\/support.spatialkey.com\/wp-content\/uploads\/2026\/01\/UnrecognizedChars-300x159.png 300w, https:\/\/support.spatialkey.com\/wp-content\/uploads\/2026\/01\/UnrecognizedChars-1024x542.png 1024w, https:\/\/support.spatialkey.com\/wp-content\/uploads\/2026\/01\/UnrecognizedChars-768x406.png 768w, https:\/\/support.spatialkey.com\/wp-content\/uploads\/2026\/01\/UnrecognizedChars-60x32.png 60w\" sizes=\"auto, (max-width: 1032px) 100vw, 1032px\" \/><\/a><figcaption class=\"wp-element-caption\"><em>Example with invalid characters<\/em><\/figcaption><\/figure>\n<\/p>\n<h2 class=\"wp-block-heading has-medium-font-size\"><a name=\"windows\"><\/a><strong>Encoding needed if using Windows XP\/7\/8<\/strong><\/h2>\n<p>You can use Notepad, which comes as a core application with Windows, to save the proper format.<\/p>\n<ul class=\"wp-block-list\">\n<li>Open your CSV file with Notepad<\/li>\n<li>Choose File &gt; Save As&#8230;<\/li>\n<li>Change the Encoding dropdown to &#8220;Unicode big endian&#8221;<\/li>\n<\/ul>\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/support.spatialkey.com\/wp-content\/uploads\/2026\/01\/Windows.png\"><img loading=\"lazy\" decoding=\"async\" width=\"458\" height=\"197\" src=\"https:\/\/support.spatialkey.com\/wp-content\/uploads\/2026\/01\/Windows.png\" alt=\"windows_utf_16\" class=\"wp-image-8412\" srcset=\"https:\/\/support.spatialkey.com\/wp-content\/uploads\/2026\/01\/Windows.png 458w, https:\/\/support.spatialkey.com\/wp-content\/uploads\/2026\/01\/Windows-300x129.png 300w, https:\/\/support.spatialkey.com\/wp-content\/uploads\/2026\/01\/Windows-60x26.png 60w\" sizes=\"auto, (max-width: 458px) 100vw, 458px\" \/><\/a><\/figure>\n<\/p>\n<h2 class=\"wp-block-heading has-medium-font-size\"><a name=\"mac\"><\/a><strong>Encoding needed if using Mac OSX<\/strong><\/h2>\n<p>Unfortunately, the built-in text editor with OSX does not properly save UTF-16 in the way SpatialKey requires. However, there is a free third party application called <a href=\"http:\/\/www.barebones.com\/products\/textwrangler\/download.html\">TextWrangler<\/a> that does.<\/p>\n<ul class=\"wp-block-list\">\n<li>Download and install <a href=\"http:\/\/www.barebones.com\/products\/textwrangler\/download.html\">TextWrangler<\/a> if you don&#8217;t already have it<\/li>\n<li>Open your CSV file with TextWrangler<\/li>\n<li>Choose File &gt; Save As&#8230;<\/li>\n<li>Change the Encoding dropdown to &#8220;Unicode (UTF-16)&#8221;<\/li>\n<\/ul>\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/support.spatialkey.com\/wp-content\/uploads\/2026\/01\/Mac-OSX.png\"><img loading=\"lazy\" decoding=\"async\" width=\"458\" height=\"257\" src=\"https:\/\/support.spatialkey.com\/wp-content\/uploads\/2026\/01\/Mac-OSX.png\" alt=\"textwrangler_utf_16\" class=\"wp-image-8413\" srcset=\"https:\/\/support.spatialkey.com\/wp-content\/uploads\/2026\/01\/Mac-OSX.png 458w, https:\/\/support.spatialkey.com\/wp-content\/uploads\/2026\/01\/Mac-OSX-300x168.png 300w, https:\/\/support.spatialkey.com\/wp-content\/uploads\/2026\/01\/Mac-OSX-60x34.png 60w\" sizes=\"auto, (max-width: 458px) 100vw, 458px\" \/><\/a><\/figure>\n<\/p>\n<h2 class=\"wp-block-heading has-medium-font-size\"><strong>Technical Details<\/strong><\/h2>\n<p>SpatialKey typically expects UTF-8 encoded CSV files. However, we can&#8217;t support all characters that you may have in your data in this format. We also support UTF-16 in these cases, in particular big endian-encoded UTF-16 with the byte marker offset (BOM). The details about this <a href=\"http:\/\/en.wikipedia.org\/wiki\/Byte_order_mark#UTF-16\">particular encoding on Wikipedia<\/a> provide a good summary.<\/p>\n<h2 class=\"wp-block-heading has-medium-font-size\"><strong>Having Trouble Converting XLS to CSV?<\/strong><\/h2>\n<p>Excel isn&#8217;t the most helpful when converting your xls file to a csv format. You may notice that your special characters were adjusted to &#8220;___&#8221; or &#8220;????&#8221;. To avoid this, you can use a free third-party software called <a href=\"https:\/\/www.openoffice.org\/download\/index.html\">OpenOffice<\/a>. Open your xls file in OpenOffice and save it as &#8220;Text CSV (.csv)&#8221;.<\/p>\n<p>After doing this, you&#8217;ll be asked to select your encoding. You can select &#8220;Unicode&#8221; (in OpenOffice &#8220;unicode&#8221; represents Big-Endian encoded UTF-16).<\/p>\n<p>That&#8217;s it, you are all set to import your file into SpatialKey!<\/p>\n<div id=\"daexthefu-container\"\n\t\t\t\tclass=\"daexthefu-container daexthefu-layout-side-by-side daexthefu-alignment-left\"\n\t\t\t\tdata-post-id=\"7282\"><\/p>\n<div class=\"daexthefu-feedback\">\n<div class=\"daexthefu-text\">\n<h3 class=\"daexthefu-title\">Was this helpful?<\/h3>\n<\/p><\/div>\n<div class=\"daexthefu-buttons-container\">\n<div class=\"daexthefu-buttons\">\n<div class=\"daexthefu-yes daexthefu-button daexthefu-button-type-text\" data-value=\"1\">\n<div class=\"daexthefu-button-text\">Yes<\/div>\n<\/p><\/div>\n<div class=\"daexthefu-no daexthefu-button daexthefu-button-type-text\" data-value=\"0\">\n<div class=\"daexthefu-button-text\">No<\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<div class=\"daexthefu-comment\">\n<div class=\"daexthefu-comment-top-container\">\n\t\t\t\t\t\t<label id=\"daexthefu-comment-label\" class=\"daexthefu-comment-label\"><\/label><\/p>\n<div class=\"daexthefu-comment-character-counter-container\">\n<div id=\"daexthefu-comment-character-counter-number\"\n\t\t\t\t\t\t\t\t\tclass=\"daexthefu-comment-character-counter-number\"><\/div>\n<div class=\"daexthefu-comment-character-counter-text\"><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<p>\t\t\t\t\t<textarea id=\"daexthefu-comment-textarea\" class=\"daexthefu-comment-textarea\"\n\t\t\t\t\t\t\t\tplaceholder=\"Type your message\"\n\t\t\t\t\t\t\t\tmaxlength=\"\n\t\t\t\t\t\t\t\t400\t\t\t\t\t\t\t\t\t\"><\/textarea><\/p>\n<div class=\"daexthefu-comment-buttons-container\">\n\t\t\t\t\t\t<button class=\"daexthefu-comment-submit daexthefu-button\">Submit<\/button><br \/>\n\t\t\t\t\t\t<button class=\"daexthefu-comment-cancel daexthefu-button\">Cancel<\/button>\n\t\t\t\t\t<\/div>\n<\/p><\/div>\n<div class=\"daexthefu-successful-submission-text\">Thanks for your feedback!<\/div>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"<p>SpatialKey supports a wide range of languages and characters in datasets uploaded as CSV files. In most cases if the data looks right on your computer before uploading, it will appear correctly in SpatialKey. However, this doesn&#8217;t always produce perfect results. There are some manual steps you can take to ensure the best support for [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_helpful_status":1,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[1],"tags":[69],"class_list":["post-7282","post","type-post","status-publish","format-standard","hentry","category-miscellaneous","tag-unlisted"],"_links":{"self":[{"href":"https:\/\/support.spatialkey.com\/wp-json\/wp\/v2\/posts\/7282","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.spatialkey.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/support.spatialkey.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/support.spatialkey.com\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/support.spatialkey.com\/wp-json\/wp\/v2\/comments?post=7282"}],"version-history":[{"count":6,"href":"https:\/\/support.spatialkey.com\/wp-json\/wp\/v2\/posts\/7282\/revisions"}],"predecessor-version":[{"id":8414,"href":"https:\/\/support.spatialkey.com\/wp-json\/wp\/v2\/posts\/7282\/revisions\/8414"}],"wp:attachment":[{"href":"https:\/\/support.spatialkey.com\/wp-json\/wp\/v2\/media?parent=7282"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.spatialkey.com\/wp-json\/wp\/v2\/categories?post=7282"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.spatialkey.com\/wp-json\/wp\/v2\/tags?post=7282"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}