{"id":3524,"date":"2022-11-14T17:41:17","date_gmt":"2022-11-14T16:41:17","guid":{"rendered":"https:\/\/kalkulacija.com\/wordpress\/?p=3524"},"modified":"2022-11-15T13:09:49","modified_gmt":"2022-11-15T12:09:49","slug":"ucitavanje-prevlacenje-podataka-iz-csv-u-excel","status":"publish","type":"post","link":"https:\/\/kalkulacija.com\/wordpress\/ucitavanje-prevlacenje-podataka-iz-csv-u-excel\/","title":{"rendered":"[:sr]U\u010ditavanje\/prevla\u010denje podataka iz CSV u Excel [:en]LOADING\/DRAG DATA FROM CSV TO EXCEL[:]"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_89 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\/ucitavanje-prevlacenje-podataka-iz-csv-u-excel\/#Ucitavanje_CSV_datoteke_jednostavnom_OPEN_funkcijom\" >U\u010ditavanje CSV datoteke jednostavnom OPEN funkcijom<\/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\/ucitavanje-prevlacenje-podataka-iz-csv-u-excel\/#Upotreba_znaka_polukolona_u_CSV_datoteci\" >Upotreba znaka [ ; ] (polukolona) u CSV datoteci<\/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\/ucitavanje-prevlacenje-podataka-iz-csv-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-4\" href=\"https:\/\/kalkulacija.com\/wordpress\/ucitavanje-prevlacenje-podataka-iz-csv-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-5\" href=\"https:\/\/kalkulacija.com\/wordpress\/ucitavanje-prevlacenje-podataka-iz-csv-u-excel\/#Prevlacenje_upotrebom_PowerQuery\" >Prevla\u010denje upotrebom PowerQuery<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/kalkulacija.com\/wordpress\/ucitavanje-prevlacenje-podataka-iz-csv-u-excel\/#Loading_a_CSV_file_with_a_simple_OPEN_function\" >Loading a CSV file with a simple OPEN function<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/kalkulacija.com\/wordpress\/ucitavanje-prevlacenje-podataka-iz-csv-u-excel\/#Using_the_character_semi-column_in_the_CSV_file\" >Using the character [\u00a0;\u00a0] (semi-column) in the CSV file<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/kalkulacija.com\/wordpress\/ucitavanje-prevlacenje-podataka-iz-csv-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-9\" href=\"https:\/\/kalkulacija.com\/wordpress\/ucitavanje-prevlacenje-podataka-iz-csv-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-10\" href=\"https:\/\/kalkulacija.com\/wordpress\/ucitavanje-prevlacenje-podataka-iz-csv-u-excel\/#Drag_using_PowerQuery\" >Drag using PowerQuery<\/a><\/li><\/ul><\/nav><\/div>\n[:sr]U\u010ditavanje\/prevla\u010denje podataka iz CSV u Excel datoteku je isto kao i kod \u010darobnjaka za TXT format kada koristimo delimiter za razdvajanje kolona tabele. Takav posao mo\u017eemo obaviti na dva na\u010dina, prvi, kada mo\u017eemo upotrebiti <strong>Open<\/strong> (biramo tip datoteke CSV) postoji najmanje od verzije 2003 i drugi, kada koristimo <strong>PowerQuery<\/strong> koji postoji od verzije 2010 kao dodatna, a od 2016 kao podrazumevana funkcionalnost.<\/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 id=\"attachment_3557\" aria-describedby=\"caption-attachment-3557\" style=\"width: 594px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3557\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv01.png\" alt=\"Izgled CSV datoteke\" width=\"594\" height=\"226\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv01.png 594w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv01-300x114.png 300w\" sizes=\"auto, (max-width: 594px) 100vw, 594px\" \/><figcaption id=\"caption-attachment-3557\" class=\"wp-caption-text\">Izgled CSV datoteke<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Ucitavanje_CSV_datoteke_jednostavnom_OPEN_funkcijom\"><\/span>U\u010ditavanje CSV datoteke jednostavnom OPEN funkcijom<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>CSV (eng. Comma-Separated Values &#8211; vrednosti razdvojene zarezom) je u osnovi TXT format u kojem su vrednosti po kolonama razdvojene zarezom. To je ta\u010dno ako nam je u Windowsu postavljeno regionalno pode\u0161avanje sa engleskim pravopisom.<\/p>\n<div style=\"background-color: green; color: white; padding: 20px;\">\n<h3><span class=\"ez-toc-section\" id=\"Upotreba_znaka_polukolona_u_CSV_datoteci\"><\/span>Upotreba znaka [ <strong><span style=\"color: #ffffff;\">;<\/span> ] (polukolona) u CSV datoteci<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Kada u Windows-u postavimo regionalno pode\u0161avanje sa srpsko-hrvatskim pravopisom (i drugim varijacijama) znak za razdvajanje decimalnih brojeva je zarez (,) tada se zbog ispravnosti CSV formata za razdvajanje kolona umesto zareza [ <strong><span style=\"color: #ffffff;\">,<\/span> ]\u00a0<\/strong>koristi znak polukolona\u00a0[ <strong><span style=\"color: #ffffff;\">;<\/span> ]<\/strong><\/p>\n<\/div>\n<p>Prilikom izvo\u017eenja podataka ovi znaci \u0107e biti podrazumevani prema trenutnom pode\u0161avanju. Ako kojim slu\u010dajem nam treba privremena promena tih znakova neophodno je u tabu <strong>File<\/strong> izabrati <strong>Options<\/strong>, i u kartici <strong>Advanced<\/strong> de\u0161tiklirati opciju <strong>Use system separators<\/strong>, kada postaju dostupne \u0107elije za korisni\u010dko pode\u0161avanje.<\/p>\n<figure id=\"attachment_3566\" aria-describedby=\"caption-attachment-3566\" style=\"width: 843px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-3566 size-full\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv02-1.png\" alt=\"Pode\u0161avanje separatora\" width=\"843\" height=\"693\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv02-1.png 843w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv02-1-300x247.png 300w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv02-1-768x631.png 768w\" sizes=\"auto, (max-width: 843px) 100vw, 843px\" \/><figcaption id=\"caption-attachment-3566\" class=\"wp-caption-text\">Pode\u0161avanje separatora<\/figcaption><\/figure>\n<p>Veli\u010dina CSV 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>CSV datoteku <\/strong>na padaju\u0107oj listi tipa datoteke u\u00a0dijalogu\u00a0<strong>Open.<\/strong><\/li>\n<\/ul>\n<figure id=\"attachment_3568\" aria-describedby=\"caption-attachment-3568\" style=\"width: 643px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3568\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv03.png\" alt=\"Prevuceni podaci iz CSV\" width=\"643\" height=\"579\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv03.png 643w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv03-300x270.png 300w\" sizes=\"auto, (max-width: 643px) 100vw, 643px\" \/><figcaption id=\"caption-attachment-3568\" class=\"wp-caption-text\">Prevu\u010deni podaci iz CSV<\/figcaption><\/figure>\n<ul>\n<li>Prevu\u010deni podaci bi\u0107e kao na prethodnoj slici.<\/li>\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 sinonim je separator) 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<figure id=\"attachment_3568-2\" aria-describedby=\"caption-attachment-3568-2\" style=\"width: 643px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3568\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv05.png\" alt=\"Prevuceni podaci iz CSV\" width=\"643\" height=\"579\" \/><figcaption id=\"caption-attachment-3568-2\" class=\"wp-caption-text\">Prevu\u010deni podaci iz CSV<\/figcaption><\/figure>\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<figure id=\"attachment_3568-3\" aria-describedby=\"caption-attachment-3568-3\" style=\"width: 643px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3568\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv06.png\" alt=\"Prevuceni podaci iz CSV\" width=\"643\" height=\"579\" \/><figcaption id=\"caption-attachment-3568-3\" class=\"wp-caption-text\">Prevu\u010deni podaci iz CSV<\/figcaption><\/figure>\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 CSV 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<figure id=\"attachment_3568-4\" aria-describedby=\"caption-attachment-3568-4\" style=\"width: 643px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3568\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv07.png\" alt=\"Prevuceni podaci iz CSV\" width=\"643\" height=\"579\" \/><figcaption id=\"caption-attachment-3568-4\" class=\"wp-caption-text\">Prevu\u010deni podaci iz CSV<\/figcaption><\/figure>\n<ul>\n<li>Kada zavr\u0161ite izbor opcija kliknite zavr\u0161etak\u00a0(<strong>Finish<\/strong>).<\/li>\n<\/ul>\n<figure id=\"attachment_3568-5\" aria-describedby=\"caption-attachment-3568-5\" style=\"width: 643px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3568\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv08.png\" alt=\"Prevuceni podaci iz CSV\" width=\"643\" height=\"579\" \/><figcaption id=\"caption-attachment-3568-5\" class=\"wp-caption-text\">Prevu\u010deni podaci iz CSV<\/figcaption><\/figure>\n<ul>\n<li>Dobijeni sadr\u017eaj kao na prethodnoj slici mo\u017eete formatirati selekcijom svih kolona i dovo\u0111enjem mi\u0161a na liniju izme\u0111u kolona (crvena strelica) mo\u017eete dvostrukim klikom formatirati \u0161irine kolona kao na slede\u0107oj slici.<\/li>\n<\/ul>\n<figure id=\"attachment_3568-6\" aria-describedby=\"caption-attachment-3568-6\" style=\"width: 643px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3568\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv09.png\" alt=\"Prevuceni podaci iz CSV\" width=\"643\" height=\"579\" \/><figcaption id=\"caption-attachment-3568-6\" class=\"wp-caption-text\">Prevu\u010deni podaci iz CSV<\/figcaption><\/figure>\n<ul>\n<li>Sada jednostavno izaberite bilo koju \u0107eliju i pozivom pre\u010dice <strong>Ctrl+T<\/strong> kreirajte tabelu.<\/li>\n<\/ul>\n<figure id=\"attachment_3568-7\" aria-describedby=\"caption-attachment-3568-7\" style=\"width: 643px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3568\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv10.png\" alt=\"Prevuceni podaci iz CSV\" width=\"643\" height=\"579\" \/><figcaption id=\"caption-attachment-3568-7\" class=\"wp-caption-text\">Prevu\u010deni podaci iz CSV<\/figcaption><\/figure>\n<ul>\n<li>Ne diraju\u0107i ni jednu opciju izborom na OK, dobijate objekat tabelu o kojoj mo\u017eete vi\u0161e pro\u010ditati u tekstu <a href=\"https:\/\/kalkulacija.com\/wordpress\/kreirati-excel-tabele\/\"><strong>Kako kreirati Excel tabele<\/strong><\/a>.<\/li>\n<\/ul>\n<figure id=\"attachment_3568-8\" aria-describedby=\"caption-attachment-3568-8\" style=\"width: 643px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3568\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv11.png\" alt=\"Prevuceni podaci iz CSV\" width=\"643\" height=\"579\" \/><figcaption id=\"caption-attachment-3568-8\" class=\"wp-caption-text\">Prevu\u010deni podaci iz CSV<\/figcaption><\/figure>\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 CSV formatu) jedini na\u010din da to obavimo u Excel-u je upotreba <strong>PowerQuery<\/strong> 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<figure id=\"attachment_3568-9\" aria-describedby=\"caption-attachment-3568-9\" style=\"width: 643px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3568\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv12.png\" alt=\"Prevuceni podaci iz CSV\" width=\"643\" height=\"579\" \/><figcaption id=\"caption-attachment-3568-9\" class=\"wp-caption-text\">Prevu\u010deni podaci iz CSV<\/figcaption><\/figure>\n<p>U dijalogu za izbor datoteke (Files) odaberite folder i datoteku CSV formata koju \u017eelite da u\u010ditate. Nakon informativnog prozora za konekciju na datoteku otvara se sadr\u017eaj kao na slede\u0107oj slici:<\/p>\n<figure id=\"attachment_3568-10\" aria-describedby=\"caption-attachment-3568-10\" style=\"width: 643px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3568\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv13.png\" alt=\"Prevuceni podaci iz CSV\" width=\"643\" height=\"579\" \/><figcaption id=\"caption-attachment-3568-10\" class=\"wp-caption-text\">Prevuceni podaci iz CSV<\/figcaption><\/figure>\n<p>Kada u\u010ditavamo podatke iz CSV formata i ne znamo koji znak razdvaja podatke po kolonama, separator \u0107e biti prepoznat u koloni Delimiter kao na slede\u0107oj slici.<\/p>\n<figure id=\"attachment_3568-11\" aria-describedby=\"caption-attachment-3568-11\" style=\"width: 643px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3568\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv14.png\" alt=\"Prevuceni podaci iz CSV\" width=\"643\" height=\"579\" \/><figcaption id=\"caption-attachment-3568-11\" class=\"wp-caption-text\">Prevu\u010deni podaci iz CSV<\/figcaption><\/figure>\n<p>Sada je dovoljno klikom na<strong> Load<\/strong>, u\u010ditati podatke.<\/p>\n<p>Ako neko ipak \u017eeli da transformi\u0161e podatke pre u\u010ditavanja neka pozove <strong>PowerQuery Editor, <\/strong>\u010diju upotrebu smo detaljnije objasnili u prilogu <a href=\"https:\/\/kalkulacija.com\/wordpress\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\/\">Prevla\u010denje-u\u010ditavanje-importovanje iz TXT formata<\/a>.<\/p>\n<figure id=\"attachment_3568-12\" aria-describedby=\"caption-attachment-3568-12\" style=\"width: 643px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3568\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv15.png\" alt=\"Prevuceni podaci iz CSV\" width=\"643\" height=\"579\" \/><figcaption id=\"caption-attachment-3568-12\" class=\"wp-caption-text\">Tabela sa prevu\u010denim podacima iz CSV<\/figcaption><\/figure>[:en]<span>Loading\/drag data from CSV to Excel file is the same as TXT format wizard when we use delimiter to separate table columns.\u00a0We can do this kind of work in two ways, first, when we can use\u00a0<\/span><strong><span>Open<\/span><\/strong><span>\u00a0(choose the CSV file type), which has existed at least since version 2003, and second, when we use\u00a0<\/span><strong><span>PowerQuery<\/span><\/strong><span>\u00a0, which has existed since version 2010 as an additional, and since 2016 as a default functionality.<\/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 id=\"attachment_3557\" class=\"wp-caption alignnone\" aria-describedby=\"caption-attachment-3557\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3557\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv01.png\" sizes=\"auto, (max-width: 594px) 100vw, 594px\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv01.png 594w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv01-300x114.png 300w\" alt=\"CSV file layout\" width=\"594\" height=\"226\" \/><figcaption id=\"caption-attachment-3557\" class=\"wp-caption-text\"><span>CSV file layout<\/span><\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Loading_a_CSV_file_with_a_simple_OPEN_function\"><\/span><span id=\"Ucitavanje_CSV_datoteke_jednostavnom_OPEN_funkcijom\" class=\"ez-toc-section\"><\/span><span>Loading a CSV file with a simple OPEN function<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span>CSV (Comma-Separated Values) is basically a TXT format in which column values \u200b\u200bare separated by commas.\u00a0This is true if we have the regional setting in Windows set to English spelling.<\/span><\/p>\n<div>\n<h3><span class=\"ez-toc-section\" id=\"Using_the_character_semi-column_in_the_CSV_file\"><\/span><span id=\"Upotreba_znaka_polukolona_u_CSV_datoteci\" class=\"ez-toc-section\"><\/span><span>Using the character [\u00a0<\/span><strong><span>;\u00a0<\/span><span>] (semi-column) in the CSV file<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span>When we set the regional setting in Windows with Serbo-Croatian spelling (and other variations), the character for separating decimal numbers is a comma (,) then, due to the correctness of the CSV format, the comma [\u00a0<\/span><strong><span>,<\/span><span>\u00a0]\u00a0<\/span><\/strong><span>\u00a0is used instead of the comma [\u00a0<\/span><strong><span>;\u00a0<\/span><span>]<\/span><\/strong><\/p>\n<\/div>\n<p><span>When exporting data, these characters will default to the current setting.\u00a0If by any chance we need a temporary change of those characters, it is necessary to\u00a0select\u00a0<strong>Options in the\u00a0<\/strong><\/span><strong><span>File<\/span><\/strong><span>\u00a0tab , and in the\u00a0<strong>Advanced<\/strong>\u00a0tab, uncheck the\u00a0<strong>Use system separators<\/strong>\u00a0option , when cells for user settings become available.<\/span><\/p>\n<figure id=\"attachment_3566\" class=\"wp-caption alignnone\" aria-describedby=\"caption-attachment-3566\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-3566 size-full\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv02-1.png\" sizes=\"auto, (max-width: 843px) 100vw, 843px\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv02-1.png 843w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv02-1-300x247.png 300w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv02-1-768x631.png 768w\" alt=\"Adjusting the separator\" width=\"843\" height=\"693\" \/><figcaption id=\"caption-attachment-3566\" class=\"wp-caption-text\"><span>Adjusting the separator<\/span><\/figcaption><\/figure>\n<p><span>The size of the CSV 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 CSV file from the File type drop-down list in the\u00a0<\/span><\/strong><span><strong>Open<\/strong>\u00a0dialog\u00a0 .<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_3568\" class=\"wp-caption alignnone\" aria-describedby=\"caption-attachment-3568\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3568\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv03.png\" sizes=\"auto, (max-width: 643px) 100vw, 643px\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv03.png 643w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv03-300x270.png 300w\" alt=\"Drag data from CSV\" width=\"643\" height=\"579\" \/><figcaption id=\"caption-attachment-3568\" class=\"wp-caption-text\"><span>Drag data from CSV<\/span><\/figcaption><\/figure>\n<ul>\n<li><span>The dragged data will be as in the previous picture.<\/span><\/li>\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>You are expected to determine whether you will use a special character to separate the columns (delimiter is a synonym for separator) or whether you will determine the width for all rows by the number of characters.<\/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<figure id=\"attachment_3568\" class=\"wp-caption alignnone\" aria-describedby=\"caption-attachment-3568\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3568\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv05.png\" alt=\"Drag data from CSV\" width=\"643\" height=\"579\" \/><figcaption id=\"caption-attachment-3568\" class=\"wp-caption-text\"><span>Drag data from CSV<\/span><\/figcaption><\/figure>\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<figure id=\"attachment_3568\" class=\"wp-caption alignnone\" aria-describedby=\"caption-attachment-3568\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3568\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv06.png\" alt=\"Drag data from CSV\" width=\"643\" height=\"579\" \/><figcaption id=\"caption-attachment-3568\" class=\"wp-caption-text\"><span>Drag data from CSV<\/span><\/figcaption><\/figure>\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 CSV 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<figure id=\"attachment_3568\" class=\"wp-caption alignnone\" aria-describedby=\"caption-attachment-3568\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3568\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv07.png\" alt=\"Drag data from CSV\" width=\"643\" height=\"579\" \/><figcaption id=\"caption-attachment-3568\" class=\"wp-caption-text\"><span>Drag data from CSV<\/span><\/figcaption><\/figure>\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<figure id=\"attachment_3568\" class=\"wp-caption alignnone\" aria-describedby=\"caption-attachment-3568\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3568\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv08.png\" alt=\"Drag data from CSV\" width=\"643\" height=\"579\" \/><figcaption id=\"caption-attachment-3568\" class=\"wp-caption-text\"><span>Drag data from CSV<\/span><\/figcaption><\/figure>\n<ul>\n<li><span>You can format the resulting content as in the previous image by selecting all the columns and by moving the mouse to the line between the columns (red arrow), you can double-click to format the width of the columns as in the following image.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_3568\" class=\"wp-caption alignnone\" aria-describedby=\"caption-attachment-3568\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3568\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv09.png\" alt=\"Drag data from CSV\" width=\"643\" height=\"579\" \/><figcaption id=\"caption-attachment-3568\" class=\"wp-caption-text\"><span>Drag data from CSV<\/span><\/figcaption><\/figure>\n<ul>\n<li><span>Now simply select any cell and use the shortcut\u00a0<\/span><strong><span>Ctrl+T<\/span><\/strong><span>\u00a0to create a table.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_3568\" class=\"wp-caption alignnone\" aria-describedby=\"caption-attachment-3568\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3568\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv10.png\" alt=\"Drag data from CSV\" width=\"643\" height=\"579\" \/><figcaption id=\"caption-attachment-3568\" class=\"wp-caption-text\"><span>Drag data from CSV<\/span><\/figcaption><\/figure>\n<ul>\n<li><span>Without touching any option by selecting OK, you get a table object, which you can read more about in the text\u00a0<\/span><a href=\"https:\/\/kalkulacija.com\/wordpress\/kreirati-excel-tabele\/\"><strong><span>How to create Excel tables<\/span><\/strong><\/a><span>\u00a0.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_3568\" class=\"wp-caption alignnone\" aria-describedby=\"caption-attachment-3568\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3568\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv11.png\" alt=\"Drag data from CSV\" width=\"643\" height=\"579\" \/><figcaption id=\"caption-attachment-3568\" class=\"wp-caption-text\"><span>Drag data from CSV<\/span><\/figcaption><\/figure>\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 (recorded in CSV format), the only way to do it in Excel is to use the\u00a0<\/span><strong><span>PowerQuery<\/span><\/strong><span>\u00a0functionality.\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<figure id=\"attachment_3568\" class=\"wp-caption alignnone\" aria-describedby=\"caption-attachment-3568\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3568\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv12.png\" alt=\"Drag data from CSV\" width=\"643\" height=\"579\" \/><figcaption id=\"caption-attachment-3568\" class=\"wp-caption-text\"><span>Drag data from CSV<\/span><\/figcaption><\/figure>\n<p><span>In the file selection dialog (Files), select the folder and the CSV format 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<figure id=\"attachment_3568\" class=\"wp-caption alignnone\" aria-describedby=\"caption-attachment-3568\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3568\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv13.png\" alt=\"Drag data from CSV\" width=\"643\" height=\"579\" \/><figcaption id=\"caption-attachment-3568\" class=\"wp-caption-text\"><span>Drag data from CSV<\/span><\/figcaption><\/figure>\n<p><span>When we load data from CSV format and we do not know which character separates the data by column, the separator will be recognized in the Delimiter column as in the following image.<\/span><\/p>\n<figure id=\"attachment_3568\" class=\"wp-caption alignnone\" aria-describedby=\"caption-attachment-3568\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3568\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv14.png\" alt=\"Drag data from CSV\" width=\"643\" height=\"579\" \/><figcaption id=\"caption-attachment-3568\" class=\"wp-caption-text\"><span>Drag data from CSV<\/span><\/figcaption><\/figure>\n<p><span>Now it is enough to click on\u00a0<\/span><strong><span>Load<\/span><\/strong><span>\u00a0to load the data.<\/span><\/p>\n<p><span>If someone still wants to transform the data before loading, they should call the\u00a0<\/span><strong><span>PowerQuery Editor,<\/span><\/strong><span>\u00a0the use of which we explained in more detail in the attachment\u00a0<\/span><a href=\"https:\/\/kalkulacija.com\/wordpress\/prevlacenje-ucitavanje-importovanje-iz-txt-u-excel\/\"><span>Dragging-loading-importing from TXT format<\/span><\/a><span>\u00a0.<\/span><\/p>\n<figure id=\"attachment_3568\" class=\"wp-caption alignnone\" aria-describedby=\"caption-attachment-3568\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3568\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv15.png\" alt=\"Drag data from CSV\" width=\"643\" height=\"579\" \/><figcaption id=\"caption-attachment-3568\" class=\"wp-caption-text\"><span>Table with dragged data from CSV<\/span><\/figcaption><\/figure>\n[:]\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;3524&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;1&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 - (1 vote)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;[:sr]U\u010ditavanje\\\/prevla\u010denje podataka iz CSV u Excel [:en]LOADING\\\/DRAG DATA FROM CSV 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 - (1 vote)    <\/div>\n    <\/div>\n","protected":false},"excerpt":{"rendered":"<p>[:sr]U\u010ditavanje\/prevla\u010denje podataka iz CSV u Excel datoteku je isto kao i kod \u010darobnjaka za TXT format kada koristimo delimiter za<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":["post-3524","post","type-post","status-publish","format-standard","hentry","category-ekscel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>U\u010ditavanje\/prevla\u010denje podataka iz CSV u Excel<\/title>\n<meta name=\"description\" content=\"U\u010ditavanje\/prevla\u010denje CSV u Excel datoteku je isto kao i kod \u010darobnjaka za TXT format kada koristimo delimiter za razdvajanje kolona tabele.\" \/>\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\/ucitavanje-prevlacenje-podataka-iz-csv-u-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"U\u010ditavanje\/prevla\u010denje podataka iz CSV u Excel\" \/>\n<meta property=\"og:description\" content=\"U\u010ditavanje\/prevla\u010denje CSV u Excel datoteku je isto kao i kod \u010darobnjaka za TXT format kada koristimo delimiter za razdvajanje kolona tabele.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kalkulacija.com\/wordpress\/ucitavanje-prevlacenje-podataka-iz-csv-u-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Kalkulacija u osnovi svega!\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-14T16:41:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-15T12:09:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv01.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=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/ucitavanje-prevlacenje-podataka-iz-csv-u-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/ucitavanje-prevlacenje-podataka-iz-csv-u-excel\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"headline\":\"[:sr]U\u010ditavanje\\\/prevla\u010denje podataka iz CSV u Excel [:en]LOADING\\\/DRAG DATA FROM CSV TO EXCEL[:]\",\"datePublished\":\"2022-11-14T16:41:17+00:00\",\"dateModified\":\"2022-11-15T12:09:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/ucitavanje-prevlacenje-podataka-iz-csv-u-excel\\\/\"},\"wordCount\":2123,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/ucitavanje-prevlacenje-podataka-iz-csv-u-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2022\\\/11\\\/csv01.png\",\"articleSection\":[\"Poslovni Excel\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/ucitavanje-prevlacenje-podataka-iz-csv-u-excel\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/ucitavanje-prevlacenje-podataka-iz-csv-u-excel\\\/\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/ucitavanje-prevlacenje-podataka-iz-csv-u-excel\\\/\",\"name\":\"U\u010ditavanje\\\/prevla\u010denje podataka iz CSV u Excel\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/ucitavanje-prevlacenje-podataka-iz-csv-u-excel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/ucitavanje-prevlacenje-podataka-iz-csv-u-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2022\\\/11\\\/csv01.png\",\"datePublished\":\"2022-11-14T16:41:17+00:00\",\"dateModified\":\"2022-11-15T12:09:49+00:00\",\"description\":\"U\u010ditavanje\\\/prevla\u010denje CSV u Excel datoteku je isto kao i kod \u010darobnjaka za TXT format kada koristimo delimiter za razdvajanje kolona tabele.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/ucitavanje-prevlacenje-podataka-iz-csv-u-excel\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/ucitavanje-prevlacenje-podataka-iz-csv-u-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/ucitavanje-prevlacenje-podataka-iz-csv-u-excel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2022\\\/11\\\/csv01.png\",\"contentUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2022\\\/11\\\/csv01.png\",\"width\":594,\"height\":226,\"caption\":\"Izgled CSV datoteke\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/ucitavanje-prevlacenje-podataka-iz-csv-u-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"U\u010ditavanje\\\/prevla\u010denje podataka iz CSV 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":"U\u010ditavanje\/prevla\u010denje podataka iz CSV u Excel","description":"U\u010ditavanje\/prevla\u010denje CSV u Excel datoteku je isto kao i kod \u010darobnjaka za TXT format kada koristimo delimiter za razdvajanje kolona tabele.","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\/ucitavanje-prevlacenje-podataka-iz-csv-u-excel\/","og_locale":"en_US","og_type":"article","og_title":"U\u010ditavanje\/prevla\u010denje podataka iz CSV u Excel","og_description":"U\u010ditavanje\/prevla\u010denje CSV u Excel datoteku je isto kao i kod \u010darobnjaka za TXT format kada koristimo delimiter za razdvajanje kolona tabele.","og_url":"https:\/\/kalkulacija.com\/wordpress\/ucitavanje-prevlacenje-podataka-iz-csv-u-excel\/","og_site_name":"Kalkulacija u osnovi svega!","article_published_time":"2022-11-14T16:41:17+00:00","article_modified_time":"2022-11-15T12:09:49+00:00","og_image":[{"url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv01.png","type":"","width":"","height":""}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kalkulacija.com\/wordpress\/ucitavanje-prevlacenje-podataka-iz-csv-u-excel\/#article","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/ucitavanje-prevlacenje-podataka-iz-csv-u-excel\/"},"author":{"name":"admin","@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"headline":"[:sr]U\u010ditavanje\/prevla\u010denje podataka iz CSV u Excel [:en]LOADING\/DRAG DATA FROM CSV TO EXCEL[:]","datePublished":"2022-11-14T16:41:17+00:00","dateModified":"2022-11-15T12:09:49+00:00","mainEntityOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/ucitavanje-prevlacenje-podataka-iz-csv-u-excel\/"},"wordCount":2123,"commentCount":0,"publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/ucitavanje-prevlacenje-podataka-iz-csv-u-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv01.png","articleSection":["Poslovni Excel"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kalkulacija.com\/wordpress\/ucitavanje-prevlacenje-podataka-iz-csv-u-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kalkulacija.com\/wordpress\/ucitavanje-prevlacenje-podataka-iz-csv-u-excel\/","url":"https:\/\/kalkulacija.com\/wordpress\/ucitavanje-prevlacenje-podataka-iz-csv-u-excel\/","name":"U\u010ditavanje\/prevla\u010denje podataka iz CSV u Excel","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/ucitavanje-prevlacenje-podataka-iz-csv-u-excel\/#primaryimage"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/ucitavanje-prevlacenje-podataka-iz-csv-u-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv01.png","datePublished":"2022-11-14T16:41:17+00:00","dateModified":"2022-11-15T12:09:49+00:00","description":"U\u010ditavanje\/prevla\u010denje CSV u Excel datoteku je isto kao i kod \u010darobnjaka za TXT format kada koristimo delimiter za razdvajanje kolona tabele.","breadcrumb":{"@id":"https:\/\/kalkulacija.com\/wordpress\/ucitavanje-prevlacenje-podataka-iz-csv-u-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kalkulacija.com\/wordpress\/ucitavanje-prevlacenje-podataka-iz-csv-u-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kalkulacija.com\/wordpress\/ucitavanje-prevlacenje-podataka-iz-csv-u-excel\/#primaryimage","url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv01.png","contentUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/11\/csv01.png","width":594,"height":226,"caption":"Izgled CSV datoteke"},{"@type":"BreadcrumbList","@id":"https:\/\/kalkulacija.com\/wordpress\/ucitavanje-prevlacenje-podataka-iz-csv-u-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kalkulacija.com\/wordpress\/"},{"@type":"ListItem","position":2,"name":"U\u010ditavanje\/prevla\u010denje podataka iz CSV 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\/3524","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=3524"}],"version-history":[{"count":18,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/3524\/revisions"}],"predecessor-version":[{"id":3588,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/3524\/revisions\/3588"}],"wp:attachment":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/media?parent=3524"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/categories?post=3524"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/tags?post=3524"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}