{"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\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\/","title":{"rendered":"[:sr]Prevla\u010denje-u\u010ditavanje-importovanje iz TXT u Excel [:en]Drag-load-import from TXT to Excel[:]"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_87_1 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\">[:sr]Sadr\u017eaj[:en] 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\/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\/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\/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\/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\/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\/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\/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\/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\/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\/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\/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\/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\/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\/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[:sr]Prevla\u010denje-u\u010ditavanje-importovanje podataka iz datoteka formata TXT u Excel mo\u017ee se obaviti na dva na\u010dina. Upotrebom <strong>Open<\/strong> (izabrati tip datoteke TXT) i upotrebom <strong>PowerQuery<\/strong> funkcionalnosti koja je ugra\u0111ena u verzijama 2019-2021-365.\u00a0 U prethodnim verzijama 2010, 2013 i 2016 ova funkcionalnost je bila opciona i dodatno se instalirala na postoje\u0107u instalaciju Excel-a.<\/p>\n<p><em>U\u00a0<a href=\"https:\/\/kalkulacija.com\/wordpress\/istorijat-dodavanja-formula-u-excelu\/\">verzijama<\/a>: <strong>2003, 2007, 2010, 2013, 2016, 2019, 2021, 365, za<span class=\"appliesToItem\">\u00a0Mac<\/span>\u00a0i za\u00a0<span class=\"appliesToItem\">web<\/span><\/strong><\/em><\/p>\n<figure style=\"width: 1143px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt01.png\" alt=\"Izgled TXT datoteke \" width=\"1143\" height=\"278\" \/><figcaption class=\"wp-caption-text\">Izgled TXT datoteke<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Prevlacenje_upotrebom_OPEN\"><\/span>Prevla\u010denje upotrebom OPEN<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Veli\u010dina TXT datoteke je odre\u0111ena operativnim sistemom i za FAT16B mo\u017ee biti 2GB, za FAT32 &#8211; 4GB, HFS &#8211; 2GB, itd. \u0160to omogu\u0107ava da snimite tabelu od 10 kolona (svaka kolona po 10 bajtova) i skoro 20 miliona redova, naravno ako imate program koji mo\u017ee generisati ili Notepad koji mo\u017ee ispisati toliku datoteku.<\/p>\n<p>Tu svakako nismo zaboravili ni delimiter (oznaka za razdvajanje kolona) koja mo\u017ee biti: Tabulator (znak TAB &#8211; ASCII kod karaktera 009) , ta\u010dka-zarez, zarez, razmak, ili korisni\u010dki definisan znak. Isto tako ne zaboravimo da je u excelu maksimalno dozvoljena tabela od \u00a01.048.576 redova i 16.384 kolone.<\/p>\n<p>To je ujedno i ograni\u010denje za ovu vrstu u\u010ditavanja podataka za daljnju obradu.<\/p>\n<p>Zna\u010di da sve obrade vi\u0161e od milion redova radimo upotrebom PowerQuery i PowerPivot funkcionalnostima.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Carobnjak_za_prevlacenje_podataka\"><\/span>\u010carobnjak za prevla\u010denje podataka<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Mo\u017eete da otvorite tekstualnu datoteku koju ste kreirali u drugom programu kao Excel radnu svesku pomo\u0107u komande <strong>Open. <\/strong>Otvaranje tekstualne datoteke u Excel-u ne menja format datoteke \u2014 ovo mo\u017eete videti u naslovnoj traci Excel-a, gde ime datoteke zadr\u017eava ekstenziju tekstualne datoteke.<\/p>\n<ul>\n<li>Idite na\u00a0<strong>File<\/strong>&gt;\u00a0<strong>Open<\/strong>\u00a0i potra\u017eite lokaciju koja sadr\u017ei tekstualnu datoteku.<br \/>\nIzaberite\u00a0<strong>TXT datoteku <\/strong>na padaju\u0107oj listi tipa datoteke u\u00a0dijalogu\u00a0<strong>Open.<\/strong><\/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>Nakon klika na <strong>Open<\/strong> dugme pokrenu\u0107e se \u010darobnjak za pomo\u0107 u tri koraka.<\/li>\n<\/ul>\n<p><strong>Prvi korak<\/strong><\/p>\n<ul>\n<li>Od vas o\u010dekuje da odredite da li \u0107ete za razdvajanje vrednosti po kolonama koristiti posebni znak za razdvajanje (delimiter) kolona ili \u0107ete brojem znakova odrediti \u0161irinu za sve redove.<\/li>\n<li>\u010carobnjak preporu\u010duje kodni raspored teksta (UTF-8) kao i mogu\u0107nost \u0161tikliranja da li je u prvom redu zaglavlje tabele (My data has headers.)<\/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\" alt=\"\" width=\"592\" height=\"454\" 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\" sizes=\"auto, (max-width: 592px) 100vw, 592px\" \/><\/p>\n<ul>\n<li>Kada zavr\u0161ite izbor opcija kliknite dalje (<strong>Next&gt;)<\/strong>.<\/li>\n<\/ul>\n<p><strong>Drugi korak<\/strong><\/p>\n<ul>\n<li>Tra\u017ei da odredite znak za razdvajanje kao \u0161to je Tabulator (<strong>Tab<\/strong>), ta\u010dkazarez\/polukolona (<strong>Semicolon<\/strong>), zarez (<strong>Comma<\/strong>), razmak (<strong>Space<\/strong>) ili neki drugi znak koji sami odredite (<strong>Other<\/strong>).<\/li>\n<li>U slu\u010daju da imate uzastopne znakove razdvajanja, npr, duplirani, triplirani, \u0161tiklirajte i samostalni kvadrat za tretiranje uzastope znakove razdvajanja kao jedan (<strong>Treat consecutive delimiters as one<\/strong>).<\/li>\n<li>I na kraju odredite navodnike za tekstove (<strong>Text qualifier<\/strong>).<\/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\" alt=\"\" width=\"593\" height=\"455\" 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\" sizes=\"auto, (max-width: 593px) 100vw, 593px\" \/><\/p>\n<ul>\n<li>Kada zavr\u0161ite izbor opcija kliknite dalje (<strong>Next&gt;)<\/strong>.<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Treci_korak\"><\/span><strong>Tre\u0107i korak<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>Od vas se sada o\u010dekuje da za svaku kolonu iz TXT datoteke odredite tip podataka.<\/li>\n<li>Podrazumevana vrednost je Op\u0161ti format (<strong>General<\/strong>), mo\u017ee biti i tekst, (<strong>Text<\/strong>), datum (<strong>Date<\/strong>) odre\u0111ene pravopisne forme (<strong>DMY<\/strong>, dan, mesec i godina), ili da neku kolonu jednostavno i ne prevu\u010dete-importujete (<strong>Do not import column (skip)<\/strong>).<\/li>\n<li>Ovde jednostavno mo\u017eete sve ostaviti u postoje\u0107em op\u0161tom formatu.<\/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\" alt=\"\" width=\"596\" height=\"459\" 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\" sizes=\"auto, (max-width: 596px) 100vw, 596px\" \/><\/p>\n<ul>\n<li>Kada zavr\u0161ite izbor opcija kliknite zavr\u0161etak\u00a0(<strong>Finish<\/strong>).<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Prevlacenje_upotrebom_PowerQuery\"><\/span>Prevla\u010denje upotrebom PowerQuery<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>U slu\u010daju da radimo sa vi\u0161e od milion redova u tabeli (snimljenih u TXT formatu) jedini na\u010din da to obavimo u Excel-u je upotreba PowerQuery funkcionalnosti. PowerQuery je dodatak u verzijama 2010 do 2016 i mora se naknadno instalirati, a u verziji 2019, 2021 i 365 on je nezaobilazna funkcija na tab-u <strong>Data.<\/strong><\/p>\n<p>Kada otvorite tab <strong>Data<\/strong> prvi alat na traci vam je <strong>Get Data<\/strong>. U prvoj opciji <strong>From File<\/strong> odaberite <strong>From Text\/CSV<\/strong>, kao na slede\u0107oj slici.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt02.png\" \/><\/p>\n<p>U dijalogu za izbor datoteke (Files) odaberite folder i datoteku TXT formata koju \u017eelite da u\u010ditate. Nakon informativnog prozora za konekciju na datoteku otvara se sadr\u017eaj kao na slede\u0107oj slici:<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt03.png\" \/><\/p>\n<p>Kada u\u010ditavamo podatke iz TXT formata i neznamo koji znak razdvaja podatke po kolonama, pametnije je da svaki red u\u010ditamo u jednu kolonu, a samu obradu tj. transformaciju obavimo u PowerQuery-ju. Jednostavno tako \u0161to \u0107emo za Delimiter (srednja kolona) odabrazi znak za koji znamo da ne postoji u TXT datoteci. U konkretnom slu\u010daju je to <strong>Colon<\/strong>.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt04.png\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"PowerQuery_Editor\"><\/span><strong>PowerQuery Editor<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Neophodna transformacija podataka iz TXT datoteke obavi\u0107e se klikom na<strong> Transform Data<\/strong>, koji poziva <strong>PowerQuery Editor<\/strong>.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt05.png\" \/><\/p>\n<p>Da bi tu jednu kolonu razdvojili na vi\u0161e kolona upotrebi\u0107emo alate na tabu <strong>Add Column<\/strong>. Prvi alat <strong>Column From Examples-From Selection <\/strong>kao na slede\u0107oj slici omogu\u0107ava nam jednostavan na\u010din formiranja nove kolone navo\u0111enjem primera.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt06.png\" \/><\/p>\n<p>Primer odvajanja broja ra\u010duna uplatioca- se mo\u017ee videti na slede\u0107oj slici. Naj\u010de\u0161\u0107e jedan primer nije dovoljan, tako da je potrebno i u onom redu gde nudi druga\u010dije re\u0161enje korisnik ispravi sadr\u017eaj kao u ovom primeru u 9. redu.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt07.png\" \/><\/p>\n<p>Tako isto mo\u017eemo iz tekstualnog formata datuma izdvojiti datum i kasnije ga transformisati u ispravni datumski format, \u0161to \u0107emo videti u slede\u0107im koracima.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt08.png\" \/><\/p>\n<p>Isto tako ako \u017eelimo izdvojiti tekst u posebnu kolonu navo\u0111enjem delove teksta izme\u0111u dva znaka za razdvajanje izabra\u0111emo opciju <strong>Text Between Delimiters <\/strong>u <strong>Extract<\/strong> meniju istog taba.<\/p>\n<p><img decoding=\"async\" style=\"font-size: 1.0625rem;\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt09.png\" \/><\/p>\n<p><strong>Extract<\/strong> opcija je na istoj traci sa alatima.<\/p>\n<p><img decoding=\"async\" style=\"font-size: 1.0625rem;\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt11.png\" \/><\/p>\n<p>Sama veli\u010dina delimitera nije ograni\u010dena, i mo\u017ee biti bilo koji niz koji mi defini\u0161emo u dijalogu na slede\u0107oj slici.<\/p>\n<p><img decoding=\"async\" style=\"font-size: 1.0625rem;\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt12.png\" \/><\/p>\n<p>Takav intuitivni postupak mo\u017eemo ponavljati koliko god nam je potrebno, na osnovu sadr\u017eaja u jednoj ili vi\u0161e selektovanih kolona.<\/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=\"Razdvajanje_brojeva_i_znakova_po_kolonama\"><\/span>Razdvajanje brojeva i znakova po kolonama<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>U slu\u010daju da \u017eelimo razdvojiti sve brojeve i tekstove u posebne kolone mo\u017eemo upotrebiti opciju <strong>Split Column &#8211; By Digit to Non-Digit<\/strong> kao \u0161to je prikazano na slede\u0107oj slici.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt14.png\" \/><\/p>\n<p>Kako izgleda rezultat tog razdvajanja mo\u017eemo videti odmah po kliku na akciju.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt15.png\" \/><\/p>\n<p>Svakako da sada imamo i problem spajanja celih brojeva iz jedne kolone sa decimalama u drugoj koloni upotrebom alata <strong>Merge Column<\/strong> u delu alata <strong>Text Column<\/strong>.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt16.png\" \/><\/p>\n<p>Obratite pa\u017enju na po\u010detak svake kolone postoji statisti\u010dki pregled podataka u koloni, da li su svi podaci validirani, ima li gre\u0161aka i praznih \u0107elija. Pored tih podataka postoji histogram unikatnih vrednosti i broja ponavljanja u celoj koloni.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt17.png\" \/><\/p>\n<p>Kada \u017eelimo transformisati datume zapisane iz tekstualnog formata u datumski format, prvo iskoristimo sada ve\u0107 poznatu transformaciju na osnovu na\u0161eg uzorka.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt18.png\" \/><\/p>\n<p>Potom na po\u010detku zaglavlja kolone imamo simbol tipa podataka sa padaju\u0107im izborom.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt20.png\" \/><\/p>\n<p>Jednostavno izaberite <strong>Date<\/strong> za definisanje datumskog polja tj. kolone.<\/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=\"Zatvaranje_PowerQuery_Editora_i_prevlacenje_podataka\"><\/span>Zatvaranje <strong>PowerQuery Editora i prevla\u010denje podataka<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Kada smo kona\u010dno izvr\u0161ili sve potrebne transformacije i uklonili nepotrebne kolone mo\u017eemo zatvoriti <strong>PowerQuery Editor<\/strong> u tabu <strong>Home<\/strong>. Klikom na <strong>Close &amp; Load<\/strong> gde imamo dve mogu\u0107nosti.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt22.png\" \/><\/p>\n<p>Prva mogu\u0107nost <strong>Close &amp; Load<\/strong>\u00a0 zatvara editor i prevla\u010di podatke u tabelu Excel radnog prostora \u0161to je naj\u010de\u0161\u0107i slu\u010daj.<br \/>\nDruga mogu\u0107nost <strong>Close &amp; Load To<\/strong> nam pored zatvaranja editora nudi da prevu\u010demo podatke u tabelu Excel radni prostor, direktno\u00a0 u Pivot tabelu, Pivot dijagram i samo da uspostavi konekciju sa podacima sa eventualnim dodavanjem u Data model za daljnju obradu u PowerPivot dodatnoj funkcionalnosti.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/txt23.png\" \/><\/p>\n<p>Izborom podrazumevanog izbora <strong>Table<\/strong> dobijamo kona\u010dni slede\u0107i oblik u Excel-u.<\/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\" alt=\"\" width=\"926\" height=\"523\" 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\" sizes=\"auto, (max-width: 926px) 100vw, 926px\" \/>[:en]<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 class=\"ez-toc-section\" id=\"PowerQuery_Editor-2\"><\/span><span id=\"PowerQuery_Editor\" class=\"ez-toc-section\"><\/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;[:sr] Ocenite [:en]Rate this [:]post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (2 votes)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;[:sr]Prevla\u010denje-u\u010ditavanje-importovanje iz TXT u Excel [:en]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>\n","protected":false},"excerpt":{"rendered":"<p>[:sr]Prevla\u010denje-u\u010ditavanje-importovanje podataka iz datoteka formata TXT u Excel mo\u017ee se obaviti na dva na\u010dina. Upotrebom Open (izabrati tip datoteke TXT)<\/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 v28.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=\"Kalkulacija u osnovi svega!\" \/>\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\":\"[:sr]Prevla\u010denje-u\u010ditavanje-importovanje iz TXT u Excel [:en]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\":[\"PowerQuery\"],\"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\":\"Kalkulacija u osnovi svega!\",\"description\":\"Samo napred! Unapredite svoje ve\u0161tine obrade podataka!\",\"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":"Kalkulacija u osnovi svega!","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":"[:sr]Prevla\u010denje-u\u010ditavanje-importovanje iz TXT u Excel [:en]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":["PowerQuery"],"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":"Kalkulacija u osnovi svega!","description":"Samo napred! Unapredite svoje ve\u0161tine obrade podataka!","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\/wp-json\/wp\/v2\/posts\/3447","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/comments?post=3447"}],"version-history":[{"count":51,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/3447\/revisions"}],"predecessor-version":[{"id":3554,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/3447\/revisions\/3554"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/media\/3443"}],"wp:attachment":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/media?parent=3447"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/categories?post=3447"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/tags?post=3447"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}