{"id":4480,"date":"2026-05-12T13:19:16","date_gmt":"2026-05-12T11:19:16","guid":{"rendered":"https:\/\/guides.heyloyalty.com\/help\/create-an-import-file-in-csv-utf-8-format\/"},"modified":"2026-05-12T13:28:46","modified_gmt":"2026-05-12T11:28:46","slug":"create-an-import-file-in-csv-utf-8-format","status":"publish","type":"ht_kb","link":"https:\/\/guides.heyloyalty.com\/en\/help\/create-an-import-file-in-csv-utf-8-format\/","title":{"rendered":"Create an import file in CSV UTF-8 format"},"content":{"rendered":"<div class=\"wp-block-post-date__modified-date wp-block-post-date\"><time datetime=\"2026-05-12T13:28:46+02:00\">12. May 2026<\/time><\/div>\n<p>In this guide you will learn how to save an Excel file as a CSV UTF-8 file for import into Heyloyalty.<br\/>The correct file format ensures that special characters such as \u00e6, \u00f8 and \u00e5 are displayed correctly after import.<\/p>\n\n<h2 class=\"wp-block-heading\">Step 1 &#8211; Save the file as CSV UTF-8<\/h2>\n\n<p>Start by opening <strong>Excel.<\/strong> Go to the <strong>Data <\/strong>tab and find the <strong>Get data <\/strong>option <strong>. <\/strong>Here you select <strong>From file<\/strong>:<\/p>\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6a046ef33b156&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6a046ef33b156\" class=\"wp-block-image size-large wp-lightbox-container\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"504\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Indsaet-fil-i-excel-1024x504.png\" alt=\"\" class=\"wp-image-4461\" style=\"box-shadow:var(--wp--preset--shadow--natural)\" srcset=\"https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Indsaet-fil-i-excel-1024x504.png 1024w, https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Indsaet-fil-i-excel-300x148.png 300w, https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Indsaet-fil-i-excel-768x378.png 768w, https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Indsaet-fil-i-excel-50x25.png 50w, https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Indsaet-fil-i-excel-1536x756.png 1536w, https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Indsaet-fil-i-excel-60x30.png 60w, https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Indsaet-fil-i-excel-100x49.png 100w, https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Indsaet-fil-i-excel.png 1954w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\taria-label=\"Enlarge\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.imageButtonRight\"\n\t\t\tdata-wp-style--top=\"state.imageButtonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewBox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n<p>Here you will see a modal showing how to insert the data into <strong>Excel<\/strong>. If it looks correct, press <strong>Load<\/strong> at the bottom of the modal.   <\/p>\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-info\"><strong>Note:<\/strong> If special characters appear incorrectly after import, the file is probably not saved as UTF-8.<\/p>\n\n<p>Then save the file as a <strong>CSV UFT-8<\/strong>. The image below shows how to do this: <\/p>\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6a046ef33bd30&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6a046ef33bd30\" class=\"wp-block-image size-large wp-lightbox-container\"><img decoding=\"async\" width=\"1024\" height=\"504\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Gem-filen-1024x504.png\" alt=\"\" class=\"wp-image-4463\" style=\"box-shadow:var(--wp--preset--shadow--natural)\" srcset=\"https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Gem-filen-1024x504.png 1024w, https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Gem-filen-300x148.png 300w, https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Gem-filen-768x378.png 768w, https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Gem-filen-50x25.png 50w, https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Gem-filen-1536x756.png 1536w, https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Gem-filen-60x30.png 60w, https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Gem-filen-100x49.png 100w, https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Gem-filen.png 1954w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\taria-label=\"Enlarge\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.imageButtonRight\"\n\t\t\tdata-wp-style--top=\"state.imageButtonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewBox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n<p><\/p>\n\n<h2 class=\"wp-block-heading\">Step 2- Check file format<\/h2>\n\n<p>We find that Excel can save it as a file format Heyloyalty cannot handle, so to make sure the file format is correct, open the file in a note program.  <\/p>\n\n<ul class=\"wp-block-list\">\n<li>Notepad (Windows)<\/li>\n\n\n\n<li>TextEdit (Mac)<\/li>\n<\/ul>\n\n<p>If you can&#8217;t see the file, you can select <strong>All files<\/strong> here. Finally, select <strong>Open.<\/strong><\/p>\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6a046ef33c18c&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6a046ef33c18c\" class=\"wp-block-image size-large wp-lightbox-container\"><img decoding=\"async\" width=\"1024\" height=\"504\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Find-alle-filer-1-1024x504.png\" alt=\"\" class=\"wp-image-4466\" style=\"box-shadow:var(--wp--preset--shadow--natural)\" srcset=\"https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Find-alle-filer-1-1024x504.png 1024w, https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Find-alle-filer-1-300x148.png 300w, https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Find-alle-filer-1-768x378.png 768w, https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Find-alle-filer-1-50x25.png 50w, https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Find-alle-filer-1-1536x756.png 1536w, https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Find-alle-filer-1-60x30.png 60w, https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Find-alle-filer-1-100x49.png 100w, https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Find-alle-filer-1.png 1954w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\taria-label=\"Enlarge\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.imageButtonRight\"\n\t\t\tdata-wp-style--top=\"state.imageButtonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewBox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n<p>Once you have opened the file, check if the file is a UFT-8 file. You can see in the image where you check it: <\/p>\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6a046ef33c457&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6a046ef33c457\" class=\"wp-block-image size-large wp-lightbox-container\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"530\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Tjek-filformat-1024x530.png\" alt=\"\" class=\"wp-image-4467\" style=\"box-shadow:var(--wp--preset--shadow--natural)\" srcset=\"https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Tjek-filformat-1024x530.png 1024w, https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Tjek-filformat-300x155.png 300w, https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Tjek-filformat-768x398.png 768w, https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Tjek-filformat-50x26.png 50w, https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Tjek-filformat-1536x796.png 1536w, https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Tjek-filformat-60x31.png 60w, https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Tjek-filformat-100x52.png 100w, https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Tjek-filformat.png 1954w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\taria-label=\"Enlarge\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.imageButtonRight\"\n\t\t\tdata-wp-style--top=\"state.imageButtonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewBox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n<p>If it just says UFT-8, you don&#8217;t need to change the file and you can simply upload it to Heyloyalty.  <\/p>\n\n<p>If it says otherwise, follow the next instructions. <br\/><br\/>You need to <strong>save the file as<\/strong>:<\/p>\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6a046ef33c70d&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6a046ef33c70d\" class=\"wp-block-image size-large wp-lightbox-container\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"530\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Gem-filen-som-1024x530.png\" alt=\"\" class=\"wp-image-4468\" style=\"box-shadow:var(--wp--preset--shadow--natural)\" srcset=\"https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Gem-filen-som-1024x530.png 1024w, https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Gem-filen-som-300x155.png 300w, https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Gem-filen-som-768x398.png 768w, https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Gem-filen-som-50x26.png 50w, https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Gem-filen-som-1536x796.png 1536w, https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Gem-filen-som-60x31.png 60w, https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Gem-filen-som-100x52.png 100w, https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Gem-filen-som.png 1954w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\taria-label=\"Enlarge\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.imageButtonRight\"\n\t\t\tdata-wp-style--top=\"state.imageButtonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewBox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n<p>When you save the file as, select the options below:<\/p>\n\n<ul class=\"wp-block-list\">\n<li><strong>File name:<\/strong> You give the file a name and after the name you put <strong>.csv.<\/strong> For example, it could look like this: <strong>test.csv<\/strong> <\/li>\n\n\n\n<li><strong>File type: <\/strong>All files<\/li>\n\n\n\n<li><strong>Coding: <\/strong>UFT-8<\/li>\n<\/ul>\n\n<p>Finally, press <strong>Save<\/strong>.<\/p>\n\n<p>Settings will look like this:<\/p>\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6a046ef33ca5d&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6a046ef33ca5d\" class=\"wp-block-image size-large wp-lightbox-container\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"530\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Indstillinger-for-gem-som-1024x530.png\" alt=\"\" class=\"wp-image-4469\" style=\"box-shadow:var(--wp--preset--shadow--natural)\" srcset=\"https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Indstillinger-for-gem-som-1024x530.png 1024w, https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Indstillinger-for-gem-som-300x155.png 300w, https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Indstillinger-for-gem-som-768x398.png 768w, https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Indstillinger-for-gem-som-50x26.png 50w, https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Indstillinger-for-gem-som-1536x796.png 1536w, https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Indstillinger-for-gem-som-60x31.png 60w, https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Indstillinger-for-gem-som-100x52.png 100w, https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/05\/Indstillinger-for-gem-som.png 1954w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\taria-label=\"Enlarge\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.imageButtonRight\"\n\t\t\tdata-wp-style--top=\"state.imageButtonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewBox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n<p>Once you have saved the file with the correct settings, you are ready to import your contacts. You can read here how to<a href=\"https:\/\/guides.heyloyalty.com\/en\/help\/importing-and-exporting-contacts\/#importer-kontakter\"> import contacts.<\/a>  <\/p>\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n\n<div class=\"wp-block-group is-layout-constrained wp-block-group-is-layout-constrained\"><form role=\"search\" method=\"get\" action=\"https:\/\/guides.heyloyalty.com\/en\/\" class=\"wp-block-search__button-outside wp-block-search__text-button wp-block-search\"    ><label class=\"wp-block-search__label\" for=\"wp-block-search__input-1\" >Fandt du ikke hvad du ledte efter?<\/label><div class=\"wp-block-search__inside-wrapper\" ><input class=\"wp-block-search__input\" id=\"wp-block-search__input-1\" placeholder=\"S\u00f8g p\u00e5 emner, funktioner eller sider\" value=\"\" type=\"search\" name=\"s\" required \/><button aria-label=\"S\u00f8g\" class=\"wp-block-search__button wp-element-button\" type=\"submit\" >S\u00f8g<\/button><\/div><\/form>\n\n\n<div class=\"wp-block-group is-nowrap is-layout-flex wp-container-core-group-is-layout-6c531013 wp-block-group-is-layout-flex\">\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"208\" height=\"118\" src=\"https:\/\/heyloyalty.com\/support\/wp-content\/uploads\/sites\/2\/2026\/01\/HL-Logo.png\" alt=\"\" class=\"wp-image-85\" style=\"width:108px;height:auto\" srcset=\"https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/01\/HL-Logo.png 208w, https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/01\/HL-Logo-50x28.png 50w, https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/01\/HL-Logo-60x34.png 60w, https:\/\/guides.heyloyalty.com\/wp-content\/uploads\/sites\/2\/2026\/01\/HL-Logo-100x57.png 100w\" sizes=\"(max-width: 208px) 100vw, 208px\" \/><\/figure>\n\n\n\n<p><br>Hvis du mangler information eller hj\u00e6lp, som du ikke finder her p\u00e5 guide sitet, er du altid velkommen til at kontakte vores support! <br><a href=\"mailto:support@ubivox.com\">support@heyloyalty.com<\/a> \/ tlf. 87 300 399<\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>In this guide you will learn how to save an Excel file as a CSV UTF-8 file for import into Heyloyalty.The correct file format ensures that special characters such as \u00e6, \u00f8 and \u00e5 are displayed correctly after import. Step 1 &#8211; Save the file as CSV UTF-8 Start by&#8230;<\/p>\n","protected":false},"author":7,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[53,66,80],"ht-kb-tag":[],"class_list":["post-4480","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-kontakter-og-lister","ht_kb_category-lists-and-contacts","ht_kb_category-troubleshooting-and-faq"],"_links":{"self":[{"href":"https:\/\/guides.heyloyalty.com\/en\/wp-json\/wp\/v2\/ht-kb\/4480","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/guides.heyloyalty.com\/en\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/guides.heyloyalty.com\/en\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/guides.heyloyalty.com\/en\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/guides.heyloyalty.com\/en\/wp-json\/wp\/v2\/comments?post=4480"}],"version-history":[{"count":1,"href":"https:\/\/guides.heyloyalty.com\/en\/wp-json\/wp\/v2\/ht-kb\/4480\/revisions"}],"predecessor-version":[{"id":4482,"href":"https:\/\/guides.heyloyalty.com\/en\/wp-json\/wp\/v2\/ht-kb\/4480\/revisions\/4482"}],"wp:attachment":[{"href":"https:\/\/guides.heyloyalty.com\/en\/wp-json\/wp\/v2\/media?parent=4480"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/guides.heyloyalty.com\/en\/wp-json\/wp\/v2\/ht-kb-category?post=4480"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/guides.heyloyalty.com\/en\/wp-json\/wp\/v2\/ht-kb-tag?post=4480"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}