{"id":2615,"date":"2014-02-12T11:06:04","date_gmt":"2014-02-12T10:06:04","guid":{"rendered":"https:\/\/www.itlektor.cz\/?p=2615"},"modified":"2020-09-04T09:43:06","modified_gmt":"2020-09-04T07:43:06","slug":"vychozi-kodovani-textoveho-souboru-pri-importu","status":"publish","type":"post","link":"https:\/\/www.itlektor.cz\/en\/vychozi-kodovani-textoveho-souboru-pri-importu\/","title":{"rendered":"Default text encoding typ for import"},"content":{"rendered":"

<\/p>\n

Maybe the article title does not say anything, but if you are often importing txt<\/em> or csv<\/em> files in Excel, this guide will help you set the default encoding type. Generally importing serve to convert the file from another application into spreadsheets in Excel. This guide will help you import text, you can find it on the Data<\/strong> tab > Get External Data<\/strong>> From text<\/strong>.<\/p>\n

\"Import<\/a>
Picture 1 – Import text<\/figcaption><\/figure>\n

File encoding determines whether the stored data will be properly displayed, especially true for special characters with hooks or commas – for Czechs therefore quite important issue.<\/p>\n

In picture\u00a01\u00a0we see the Text Import Wizard, the first step to set the encoding type, but the offered are not always the right one. So to not\u00a0have to change every time you import this type of coding on the right one (eg. UTF-8, Windows 1250, etc.), it is possible to set the default type, but unfortunately not through a simple menu, but intervention in the Windows registry. Do not worry, you can do it if you follow these instructions. If you are not comfortable with it, hand over this task to someone advanced.<\/p>\n

To change the default encoding in the registry do as follows:<\/p>\n

    \n
  1. Start the Registry Editor tool – REGEDIT, which is part of Windows. Just go to\u00a0Start > Run command\u00a0“regedit”.<\/strong><\/li>\n
  2. Here locate the entry:
    \nHKEY_CURRENT_USER>Software>Microsoft>Office>14.0>Excel>Options
    \n(number indicates the version you have – eg. version 2013 has the number 15.0).<\/li>\n
  3. Create a new value, right-click on the Options item on the left, set New> DWORD<\/strong> see Figure # 2.<\/li>\n
  4. In the right list of values add a new item, which named as DefaultCPG<\/strong>.<\/li>\n
  5. Then right-click it and select Modify<\/strong>.<\/li>\n
  6. The window opens setting values, where select Decimal<\/strong> and enter the encoding (the number of\u00a0type inText Import Wizard, see Fig. 1). For UTF-8 this number is 65001, see Fig.\u00a03.<\/li>\n
  7. Confirm the value by pressing the OK button and you are done.<\/li>\n<\/ol>\n