{"id":3447,"date":"2022-11-10T18:14:43","date_gmt":"2022-11-10T17:14:43","guid":{"rendered":"https:\/\/kalkulacija.com\/wordpress\/?p=3447"},"modified":"2022-11-10T18:19:49","modified_gmt":"2022-11-10T17:19:49","slug":"prevlacenje-ucitavanje-importovanje-iz-txt-u-excel","status":"publish","type":"post","link":"https:\/\/kalkulacija.com\/wordpress\/en\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\/","title":{"rendered":"Drag-load-import from TXT to Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_83 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #0d590e;color:#0d590e\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #0d590e;color:#0d590e\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\/#Prevlacenje_upotrebom_OPEN\" >Prevla\u010denje upotrebom OPEN<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\/#Carobnjak_za_prevlacenje_podataka\" >\u010carobnjak za prevla\u010denje podataka<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\/#Treci_korak\" >Tre\u0107i korak<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\/#Prevlacenje_upotrebom_PowerQuery\" >Prevla\u010denje upotrebom PowerQuery<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\/#PowerQuery_Editor\" >PowerQuery Editor<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\/#Razdvajanje_brojeva_i_znakova_po_kolonama\" >Razdvajanje brojeva i znakova po kolonama<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\/#Zatvaranje_PowerQuery_Editora_i_prevlacenje_podataka\" >Zatvaranje PowerQuery Editora i prevla\u010denje podataka<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\/#Drag_using_OPEN\" >Drag using OPEN<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\/#Drag_data_wizard\" >Drag data wizard<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\/#The_third_step\" >The third step<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\/#Drag_using_PowerQuery\" >Drag using PowerQuery<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\/#PowerQuery_Editor-2\" >PowerQuery Editor<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\/#Separation_of_numbers_and_characters_by_columns\" >Separation of numbers and characters by columns<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\/#Closing_PowerQuery_Editor_and_dragging_data\" >Closing\u00a0PowerQuery Editor and dragging data<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<span>Dragging-loading-importing data from TXT format files to Excel can be done in two ways.\u00a0Using\u00a0<\/span><strong><span>Open<\/span><\/strong><span>\u00a0(select TXT file type) and using the\u00a0<\/span><strong><span>PowerQuery<\/span><\/strong><span>\u00a0functionality built into versions 2019-2021-365.\u00a0In previous versions 2010, 2013, and 2016, this functionality was optional and was additionally installed on top of an existing Excel installation.<\/span><\/p>\n<p><em><span>In\u00a0\u00a0<\/span><a href=\"https:\/\/kalkulacija.com\/wordpress\/istorijat-dodavanja-formula-u-excelu\/\"><span>versions<\/span><\/a><span>\u00a0:\u00a0<\/span><strong><span>2003, 2007, 2010, 2013, 2016, 2019, 2021, 365, for\u00a0<\/span><span class=\"appliesToItem\"><span>\u00a0Mac<\/span><\/span><span>\u00a0\u00a0and for\u00a0\u00a0<\/span><span class=\"appliesToItem\"><span>the web<\/span><\/span><\/strong><\/em><\/p>\n<figure class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt01.png\" alt=\"TXT file layout\" width=\"1143\" height=\"278\" \/><figcaption class=\"wp-caption-text\"><span>TXT file layout<\/span><\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Drag_using_OPEN\"><\/span><span id=\"Prevlacenje_upotrebom_OPEN\" class=\"ez-toc-section\"><\/span><span>Drag using OPEN<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span>The size of the TXT file is determined by the operating system and can be 2GB for FAT16B, 4GB for FAT32, 2GB for HFS, etc.\u00a0Which allows you to record a table of 10 columns (each column of 10 bytes) and almost 20 million rows, of course if you have a program that can generate or Notepad that can print such a file.<\/span><\/p>\n<p><span>We certainly didn&#8217;t forget the delimiter, which can be: Tab (TAB character &#8211; ASCII character code 009), semicolon, comma, space, or user-defined character.\u00a0Also, let&#8217;s not forget that the maximum allowed table in Excel is 1,048,576 rows and 16,384 columns.<\/span><\/p>\n<p><span>This is also a limitation for this type of data upload for further processing.<\/span><\/p>\n<p><span>It means that we do all the processing of more than a million rows using PowerQuery and PowerPivot functionalities.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Drag_data_wizard\"><\/span><span id=\"Carobnjak_za_prevlacenje_podataka\" class=\"ez-toc-section\"><\/span><span>Drag data wizard<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span>You can open a text file that you created in another program as an Excel workbook using the\u00a0<\/span><strong><span>Open command.\u00a0<\/span><\/strong><span>Opening a text file in Excel does not change the file format \u2014 you can see this in the Excel title bar, where the file name retains the text file extension.<\/span><\/p>\n<ul>\n<li><span>Go to\u00a0\u00a0<\/span><strong><span>File<\/span><\/strong><span>\u00a0&gt;\u00a0\u00a0<\/span><strong><span>Open<\/span><\/strong><span>\u00a0\u00a0and browse to the location that contains the text file.<\/span><br \/>\n<span>Select\u00a0\u00a0<\/span><strong><span>a TXT file from the File Type drop-down list in the\u00a0<\/span><\/strong><span><strong>Open<\/strong>\u00a0dialog\u00a0 .<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3520 \" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt001-1.png\" alt=\"\" width=\"692\" height=\"580\" \/><\/p>\n<ul>\n<li><span>After clicking the\u00a0<\/span><strong><span>Open<\/span><\/strong><span>\u00a0button, a three-step help wizard will be launched.<\/span><\/li>\n<\/ul>\n<p><strong><span>The first step<\/span><\/strong><\/p>\n<ul>\n<li><span>It expects you to determine whether you will use a special column delimiter to separate the values \u200b\u200bby column, or whether you will use the number of characters to determine the width for all rows.<\/span><\/li>\n<li><span>The wizard recommends the code layout of the text (UTF-8) as well as the option to check if the table header is in the first row (My data has headers.)<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3510 size-full\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt002.png\" sizes=\"auto, (max-width: 592px) 100vw, 592px\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt002.png 592w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt002-300x230.png 300w\" alt=\"\" width=\"592\" height=\"454\" \/><\/p>\n<ul>\n<li><span>When you have finished selecting options, click\u00a0<\/span><strong><span>Next&gt;<\/span><\/strong><span>\u00a0.<\/span><\/li>\n<\/ul>\n<p><strong><span>Second step<\/span><\/strong><\/p>\n<ul>\n<li><span>It asks you to specify a separator character such as Tab (\u00a0<\/span><strong><span>Tab<\/span><\/strong><span>\u00a0), Semicolon (\u00a0<\/span><strong><span>Semicolon<\/span><\/strong><span>\u00a0), Comma (\u00a0<\/span><strong><span>Comma<\/span><\/strong><span>\u00a0), Space (\u00a0<\/span><strong><span>Space<\/span><\/strong><span>\u00a0) or some other character you specify (\u00a0<\/span><strong><span>Other<\/span><\/strong><span>\u00a0).<\/span><\/li>\n<li><span>In case you have consecutive delimiters, for example, duplicated, tripled, check the independent box to treat consecutive delimiters as one (\u00a0<\/span><strong><span>Treat consecutive delimiters as one<\/span><\/strong><span>\u00a0).<\/span><\/li>\n<li><span>And finally set the quotation marks for texts (\u00a0<\/span><strong><span>Text qualifier<\/span><\/strong><span>\u00a0).<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3511 size-full\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt003.png\" sizes=\"auto, (max-width: 593px) 100vw, 593px\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt003.png 593w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt003-300x230.png 300w\" alt=\"\" width=\"593\" height=\"455\" \/><\/p>\n<ul>\n<li><span>When you have finished selecting options, click\u00a0<\/span><strong><span>Next&gt;<\/span><\/strong><span>\u00a0.<\/span><\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"The_third_step\"><\/span><span id=\"Treci_korak\" class=\"ez-toc-section\"><\/span><strong><span>The third step<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li><span>You are now expected to specify a data type for each column from the TXT file.<\/span><\/li>\n<li><span>The default value is General format (\u00a0<\/span><strong><span>General<\/span><\/strong><span>\u00a0), it can also be text\u00a0<\/span><strong><span>,<\/span><\/strong><span>\u00a0date (\u00a0<\/span><strong><span>Date<\/span><\/strong><span>\u00a0) in a certain orthographic form (\u00a0<\/span><strong><span>DMY<\/span><\/strong><span>\u00a0, day, month and year), or simply do not drag and import a column (\u00a0<\/span><strong><span>Do not import column (skip)<\/span><\/strong><span>\u00a0).<\/span><\/li>\n<li><span>Here you can simply leave everything in the existing general format.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3512 size-full\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt004.png\" sizes=\"auto, (max-width: 596px) 100vw, 596px\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt004.png 596w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt004-300x231.png 300w\" alt=\"\" width=\"596\" height=\"459\" \/><\/p>\n<ul>\n<li><span>When you have finished selecting the options, click\u00a0<\/span><strong><span>Finish<\/span><\/strong><span>\u00a0.<\/span><\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Drag_using_PowerQuery\"><\/span><span id=\"Prevlacenje_upotrebom_PowerQuery\" class=\"ez-toc-section\"><\/span><span>Drag using PowerQuery<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span>In case we work with more than a million rows in the table (saved in TXT format), the only way to do it in Excel is to use the PowerQuery functionality.\u00a0PowerQuery is an add-on in versions 2010 to 2016 and must be installed afterwards, and in versions 2019, 2021 and 365 it is an indispensable function on the\u00a0<\/span><strong><span>Data tab.<\/span><\/strong><\/p>\n<p><strong><span>When you open the Data<\/span><\/strong><span>\u00a0tab\u00a0, the first tool on the ribbon is\u00a0<\/span><strong><span>Get Data<\/span><\/strong><span>\u00a0.\u00a0<\/span><strong><span>In the first From File<\/span><\/strong><span>\u00a0option ,\u00a0select\u00a0<\/span><strong><span>From Text\/CSV<\/span><\/strong><span>\u00a0, as in the following image.<\/span><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt02.png\" \/><\/p>\n<p><span>In the file selection dialog (Files), select the folder and the TXT file you want to upload.\u00a0After the information window for connecting to the file, the content opens as in the following image:<\/span><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt03.png\" \/><\/p>\n<p><span>When we load data from TXT format and we do not know which character separates the data by column, it is smarter to load each row into one column, and perform the processing itself, i.e. the transformation, in PowerQuery.\u00a0Simply by choosing for the Delimiter (middle column) a character that we know does not exist in the TXT file.\u00a0In the specific case it is\u00a0<\/span><strong><span>Colon<\/span><\/strong><span>\u00a0.<\/span><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt04.png\" \/><\/p>\n<h3><span id=\"PowerQuery_Editor\" class=\"ez-toc-section\"><\/span><span class=\"ez-toc-section\" id=\"PowerQuery_Editor\"><\/span><strong>PowerQuery Editor<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span>The necessary transformation of the data from the TXT file will be done by clicking on\u00a0<\/span><strong><span>Transform Data<\/span><\/strong><span>\u00a0, which calls\u00a0<\/span><strong><span>the PowerQuery Editor<\/span><\/strong><span>\u00a0.<\/span><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt05.png\" \/><\/p>\n<p><span>In order to separate that one column into several columns, we will use the tools on the\u00a0<\/span><strong><span>Add Column<\/span><\/strong><span>\u00a0tab .\u00a0The first tool\u00a0<\/span><strong><span>Column From Examples-From Selection<\/span><\/strong><span>\u00a0as in the following picture allows us a simple way of forming a new column by specifying an example.<\/span><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt06.png\" \/><\/p>\n<p><span>An example of separating the payer&#8217;s account number can be seen in the following picture.\u00a0Most often, one example is not enough, so it is necessary for the user to correct the content in the line where he offers a different solution, as in this example in the 9th line.<\/span><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt07.png\" \/><\/p>\n<p><span>We can also extract the date from the text date format and later transform it into the correct date format, which we will see in the next steps.<\/span><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt08.png\" \/><\/p>\n<p><span>Likewise, if we want to extract text into a separate column by specifying parts of the text between two delimiters, select the option\u00a0<\/span><strong><span>Text Between Delimiters<\/span><\/strong><span>\u00a0in the\u00a0<\/span><strong><span>Extract<\/span><\/strong><span>\u00a0menu of the same tab.<\/span><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt09.png\" \/><\/p>\n<p><strong><span>The Extract<\/span><\/strong><span>\u00a0option is on the same toolbar.<\/span><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt11.png\" \/><\/p>\n<p><span>The size of the delimiter itself is not limited, and it can be any string that we define in the dialog in the following image.<\/span><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt12.png\" \/><\/p>\n<p><span>We can repeat such an intuitive procedure as often as we need, based on the content in one or more selected columns.<\/span><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt10.png\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Separation_of_numbers_and_characters_by_columns\"><\/span><span id=\"Razdvajanje_brojeva_i_znakova_po_kolonama\" class=\"ez-toc-section\"><\/span><span>Separation of numbers and characters by columns<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span>In case we want to separate all numbers and texts into separate columns, we can use the option\u00a0<\/span><strong><span>Split Column \u2013 By Digit to Non-Digit<\/span><\/strong><span>\u00a0as shown in the following image.<\/span><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt14.png\" \/><\/p>\n<p><span>We can see what the result of that separation looks like immediately after clicking on the action.<\/span><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt15.png\" \/><\/p>\n<p><span>Of course, now we have the problem of merging whole numbers from one column with decimals in another column using the\u00a0<\/span><strong><span>Merge Column tool in the\u00a0<\/span><\/strong><strong><span>Text Column<\/span><\/strong><span>\u00a0tool section\u00a0.<\/span><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt16.png\" \/><\/p>\n<p><span>Pay attention to the beginning of each column, there is a statistical overview of the data in the column, whether all the data is validated, whether there are errors and empty cells.\u00a0In addition to these data, there is a histogram of unique values \u200b\u200band the number of repetitions in the entire column.<\/span><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt17.png\" \/><\/p>\n<p><span>When we want to transform dates written from text format to date format, we first use the already known transformation based on our sample.<\/span><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt18.png\" \/><\/p>\n<p><span>Then at the beginning of the column header we have a data type symbol with a dropdown.<\/span><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt20.png\" \/><\/p>\n<p><span>Simply select\u00a0<\/span><strong><span>Date<\/span><\/strong><span>\u00a0to define a date field ie.\u00a0columns.<\/span><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt21.png\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Closing_PowerQuery_Editor_and_dragging_data\"><\/span><span id=\"Zatvaranje_PowerQuery_Editora_i_prevlacenje_podataka\" class=\"ez-toc-section\"><\/span><span>Closing\u00a0<\/span><strong><span>PowerQuery Editor and dragging data<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span>When we have finally performed all the necessary transformations and removed unnecessary columns, we can close\u00a0<\/span><strong><span>the PowerQuery Editor in the\u00a0<\/span><\/strong><strong><span>Home<\/span><\/strong><span>\u00a0tab\u00a0.\u00a0By clicking on\u00a0<\/span><strong><span>Close &amp; Load<\/span><\/strong><span>\u00a0where we have two options.<\/span><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt22.png\" \/><\/p>\n<p><span>The first option,\u00a0<\/span><strong><span>Close &amp; Load,<\/span><\/strong><span>\u00a0\u00a0 closes the editor and drags the data into the Excel workspace table, which is the most common case.<\/span><br \/>\n<span>Another possibility\u00a0<\/span><strong><span>Close &amp; Load This<\/span><\/strong><span>\u00a0, in addition to closing the editor, offers us to drag the data into the Excel workspace table, directly into the Pivot table, Pivot diagram and only to establish a connection with the data with eventual addition to the Data model for further processing in PowerPivot additional functionality.<\/span><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt23.png\" \/><\/p>\n<p><span>By choosing the default option\u00a0<\/span><strong><span>Table<\/span><\/strong><span>\u00a0, we get the final following form in Excel.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3472 size-full\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt24.png\" sizes=\"auto, (max-width: 926px) 100vw, 926px\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt24.png 926w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt24-300x169.png 300w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt24-768x434.png 768w\" alt=\"\" width=\"926\" height=\"523\" \/>\n\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-right kksr-valign-bottom\"\n    data-payload='{&quot;align&quot;:&quot;right&quot;,&quot;id&quot;:&quot;3447&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;bottom&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;2&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (2 votes)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;Drag-load-import from TXT to Excel&quot;,&quot;width&quot;:&quot;142.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 142.5px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            5\/5 - (2 votes)    <\/div>\n    <\/div>","protected":false},"excerpt":{"rendered":"<p>Dragging-loading-importing data from TXT format files to Excel can be done in two ways.\u00a0Using\u00a0Open\u00a0(select TXT file type) and using the\u00a0PowerQuery\u00a0functionality<\/p>\n","protected":false},"author":1,"featured_media":3443,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[69],"tags":[],"class_list":["post-3447","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-powerquery-2"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Prevla\u010denje-u\u010ditavanje-importovanje iz TXT u Excel<\/title>\n<meta name=\"description\" content=\"Prevla\u010denje-u\u010ditavanje-importovanje podataka formata TXT mo\u017ee se obaviti upotrebom Open i upotrebom PowerQuery funkcionalnosti.\u00a0\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kalkulacija.com\/wordpress\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Prevla\u010denje-u\u010ditavanje-importovanje iz TXT u Excel\" \/>\n<meta property=\"og:description\" content=\"Prevla\u010denje-u\u010ditavanje-importovanje podataka formata TXT mo\u017ee se obaviti upotrebom Open i upotrebom PowerQuery funkcionalnosti.\u00a0\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kalkulacija.com\/wordpress\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Calculation in essence of everything!\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-10T17:14:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-10T17:19:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt01.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1143\" \/>\n\t<meta property=\"og:image:height\" content=\"278\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"12 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"headline\":\"Drag-load-import from TXT to Excel\",\"datePublished\":\"2022-11-10T17:14:43+00:00\",\"dateModified\":\"2022-11-10T17:19:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\\\/\"},\"wordCount\":2464,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2022\\\/11\\\/txt01.png\",\"articleSection\":[\"\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\\\/\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\\\/\",\"name\":\"Prevla\u010denje-u\u010ditavanje-importovanje iz TXT u Excel\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2022\\\/11\\\/txt01.png\",\"datePublished\":\"2022-11-10T17:14:43+00:00\",\"dateModified\":\"2022-11-10T17:19:49+00:00\",\"description\":\"Prevla\u010denje-u\u010ditavanje-importovanje podataka formata TXT mo\u017ee se obaviti upotrebom Open i upotrebom PowerQuery funkcionalnosti.\u00a0\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2022\\\/11\\\/txt01.png\",\"contentUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2022\\\/11\\\/txt01.png\",\"width\":1143,\"height\":278,\"caption\":\"TXT datoteka dnevnog izvoda\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Prevla\u010denje-u\u010ditavanje-importovanje iz TXT u Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\",\"name\":\"Calculation in essence of everything!\",\"description\":\"Go ahead! Improve your data processing skills!\",\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"contentUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"width\":128,\"height\":128,\"caption\":\"admin\"},\"logo\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Prevla\u010denje-u\u010ditavanje-importovanje iz TXT u Excel","description":"Prevla\u010denje-u\u010ditavanje-importovanje podataka formata TXT mo\u017ee se obaviti upotrebom Open i upotrebom PowerQuery funkcionalnosti.\u00a0","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/kalkulacija.com\/wordpress\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\/","og_locale":"en_US","og_type":"article","og_title":"Prevla\u010denje-u\u010ditavanje-importovanje iz TXT u Excel","og_description":"Prevla\u010denje-u\u010ditavanje-importovanje podataka formata TXT mo\u017ee se obaviti upotrebom Open i upotrebom PowerQuery funkcionalnosti.\u00a0","og_url":"https:\/\/kalkulacija.com\/wordpress\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\/","og_site_name":"Calculation in essence of everything!","article_published_time":"2022-11-10T17:14:43+00:00","article_modified_time":"2022-11-10T17:19:49+00:00","og_image":[{"width":1143,"height":278,"url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt01.png","type":"image\/png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"12 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kalkulacija.com\/wordpress\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\/#article","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\/"},"author":{"name":"admin","@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"headline":"Drag-load-import from TXT to Excel","datePublished":"2022-11-10T17:14:43+00:00","dateModified":"2022-11-10T17:19:49+00:00","mainEntityOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\/"},"wordCount":2464,"commentCount":0,"publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt01.png","articleSection":[""],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kalkulacija.com\/wordpress\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kalkulacija.com\/wordpress\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\/","url":"https:\/\/kalkulacija.com\/wordpress\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\/","name":"Prevla\u010denje-u\u010ditavanje-importovanje iz TXT u Excel","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\/#primaryimage"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt01.png","datePublished":"2022-11-10T17:14:43+00:00","dateModified":"2022-11-10T17:19:49+00:00","description":"Prevla\u010denje-u\u010ditavanje-importovanje podataka formata TXT mo\u017ee se obaviti upotrebom Open i upotrebom PowerQuery funkcionalnosti.\u00a0","breadcrumb":{"@id":"https:\/\/kalkulacija.com\/wordpress\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kalkulacija.com\/wordpress\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kalkulacija.com\/wordpress\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\/#primaryimage","url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt01.png","contentUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt01.png","width":1143,"height":278,"caption":"TXT datoteka dnevnog izvoda"},{"@type":"BreadcrumbList","@id":"https:\/\/kalkulacija.com\/wordpress\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kalkulacija.com\/wordpress\/"},{"@type":"ListItem","position":2,"name":"Prevla\u010denje-u\u010ditavanje-importovanje iz TXT u Excel"}]},{"@type":"WebSite","@id":"https:\/\/kalkulacija.com\/wordpress\/#website","url":"https:\/\/kalkulacija.com\/wordpress\/","name":"Calculation in essence of everything!","description":"Go ahead! Improve your data processing skills!","publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kalkulacija.com\/wordpress\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","contentUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","width":128,"height":128,"caption":"admin"},"logo":{"@id":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png"}}]}},"_links":{"self":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts\/3447","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/comments?post=3447"}],"version-history":[{"count":51,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts\/3447\/revisions"}],"predecessor-version":[{"id":3554,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts\/3447\/revisions\/3554"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/media\/3443"}],"wp:attachment":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/media?parent=3447"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/categories?post=3447"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/tags?post=3447"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}