{"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":"Prevla\u010denje-u\u010ditavanje-importovanje iz TXT u 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\">Sadr\u017eaj<\/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>\nPrevla\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\" \/>\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;Ocenite post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (2 votes)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;Prevla\u010denje-u\u010ditavanje-importovanje iz TXT u 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>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 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=\"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\":\"Prevla\u010denje-u\u010ditavanje-importovanje iz TXT u 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\":\"sr-SR\",\"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\":\"sr-SR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"sr-SR\",\"@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\":\"sr-SR\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"sr-SR\",\"@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":"Prevla\u010denje-u\u010ditavanje-importovanje iz TXT u 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":"sr-SR","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":"sr-SR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kalkulacija.com\/wordpress\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\/"]}]},{"@type":"ImageObject","inLanguage":"sr-SR","@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":"sr-SR"},{"@type":["Person","Organization"],"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4","name":"admin","image":{"@type":"ImageObject","inLanguage":"sr-SR","@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}]}}