{"id":124,"date":"2023-12-14T12:48:17","date_gmt":"2023-12-14T11:48:17","guid":{"rendered":"https:\/\/vendino.com\/?p=124"},"modified":"2024-02-22T17:55:29","modified_gmt":"2024-02-22T16:55:29","slug":"ce-este-un-fisier-csv","status":"publish","type":"post","link":"https:\/\/vendino.com\/ro\/ce-este-un-fisier-csv\/","title":{"rendered":"Ce este un fi\u0219ier CSV?"},"content":{"rendered":"<p><em>CSV \u00eenseamn\u0103 Comma Separated Values (Valori separate prin virgul\u0103), adic\u0103 un fi\u0219ier care con\u021bine date sub form\u0103 de numere \u0219i litere. Exist\u0103 multe utiliz\u0103ri pentru fi\u0219ierele CSV, dar aceste fi\u0219iere sunt adesea folosite pentru schimbul de date cu diferite aplica\u021bii. Formatul de fi\u0219ier este adesea utilizat \u00een atelierele web pentru crearea de produse, date privind comenzile \u0219i multe altele.<\/em><\/p>\n\n\n\n<p>Fi\u0219ierele CSV sunt excelente deoarece sunt potrivite pentru bazele de date care con\u021bin seturi mari de date \u0219i func\u021bioneaz\u0103 bine cu acestea. Prin urmare, cu un fi\u0219ier CSV, pute\u021bi prelua cantit\u0103\u021bi mari de date f\u0103r\u0103 nicio problem\u0103.<\/p>\n\n\n\n<p>Fi\u0219ierele CSV sunt utilizate \u00eentr-o mare varietate de aplica\u021bii.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"strukturen-for-en-csv-fil\">Structura unui fi\u0219ier CSV<\/h2>\n\n\n\n<p>Un fi\u0219ier CSV are o structur\u0103 destul de simpl\u0103. Fi\u0219ierul const\u0103 dintr-o list\u0103 de date, separate prin virgul\u0103. De exemplu, un extras simplu de produse din magazinul dvs. online va ap\u0103rea dup\u0103 cum urmeaz\u0103 atunci c\u00e2nd \u00eel exporta\u021bi ca fi\u0219ier CSV:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Titlu,Descriere,Pre\u021b (DKK)\nScaun,Scaun frumos din piele maro,349\nSaltea,Saltea moale \u0219i confortabil\u0103,899<\/code><\/pre>\n\n\n\n<p>Practic, acesta este un fi\u0219ier CSV. Desigur, aceste tipuri de fi\u0219iere vor deveni mult mai complicate pe m\u0103sur\u0103 ce se adaug\u0103 mai multe c\u00e2mpuri de date. Dar, pentru a simplifica lucrurile, acestea pot fi explicate cu u\u0219urin\u021b\u0103 cu ajutorul exemplului de mai sus. Unele fi\u0219iere CSV nu con\u021bin neap\u0103rat informa\u021biile din antet (linia de sus), iar altele pot utiliza delimitatori diferi\u021bi, cum ar fi punct \u0219i virgul\u0103 (;) \u00een loc de virgul\u0103 (,).<\/p>\n\n\n\n<p>Fi\u0219ierele CSV sunt concepute pentru a fi o modalitate rapid\u0103 \u0219i u\u0219oar\u0103 de a exporta date \u0219i de a le importa \u00een alte programe. Datele rezultate sunt lizibile de c\u0103tre om \u0219i pot fi vizualizate cu u\u0219urin\u021b\u0103 \u00eentr-un editor de text precum Notepad sau \u00eentr-o foaie de calcul precum Excel.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"hvordan-\u00e5bner-man-en-csv-fil-i-en-text-editor\">Cum se deschide un fi\u0219ier CSV \u00eentr-un editor de text?<\/h2>\n\n\n\n<p>Pentru a vizualiza con\u021binutul unui fi\u0219ier CSV \u00eentr-un editor de text, cum ar fi TextEdit (Mac), pur \u0219i simplu face\u021bi clic dreapta pe fi\u0219ier \u0219i selecta\u021bi \"Deschide \u00een\", apoi selecta\u021bi \"TextEdit\".<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"894\" height=\"523\" src=\"https:\/\/vendino.com\/wp-content\/uploads\/aaben-csv-fil-i-textedit.png\" alt=\"Deschide\u021bi fi\u0219ierul Csv \u00een Textedit\" class=\"wp-image-214\" srcset=\"https:\/\/vendino.com\/wp-content\/uploads\/aaben-csv-fil-i-textedit.png 894w, https:\/\/vendino.com\/wp-content\/uploads\/aaben-csv-fil-i-textedit-768x449.png 768w\" sizes=\"(max-width: 894px) 100vw, 894px\" \/><\/figure>\n\n\n\n<p>TextEdit poate avea probleme la deschiderea fi\u0219ierului dac\u0103 acesta este prea mare. \u00cen acest caz, trebuie s\u0103 utiliza\u021bi un alt program pentru a deschide fi\u0219ierul.<\/p>\n\n\n\n<p>\u00cen acest fel, ve\u021bi putea vizualiza con\u021binutul fi\u0219ierului \u00een format brut.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"688\" height=\"425\" src=\"https:\/\/vendino.com\/wp-content\/uploads\/csv-fil-i-textedit.png\" alt=\"Fi\u0219ier Csv \u00een Textedit\" class=\"wp-image-219\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"hvordan-\u00e5bner-man-en-csv-fil-i-et-regneark\">Cum se deschide un fi\u0219ier CSV \u00eentr-o foaie de calcul?<\/h2>\n\n\n\n<p>Pentru a citi un fi\u0219ier CSV \u00eentr-un mod mai u\u0219or \u0219i mai clar dec\u00e2t cu un editor de text, pute\u021bi utiliza o foaie de calcul precum Microsoft Excel sau Numbers. Pur \u0219i simplu face\u021bi clic dreapta pe fi\u0219ierul CSV, face\u021bi clic pe \"Open in\" \u0219i apoi selecta\u021bi programul preferat.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"924\" height=\"524\" src=\"https:\/\/vendino.com\/wp-content\/uploads\/aaben-csv-fil-i-numbers.png\" alt=\"Deschide\u021bi fi\u0219ierul Csv \u00een Numbers\" class=\"wp-image-213\" srcset=\"https:\/\/vendino.com\/wp-content\/uploads\/aaben-csv-fil-i-numbers.png 924w, https:\/\/vendino.com\/wp-content\/uploads\/aaben-csv-fil-i-numbers-768x436.png 768w\" sizes=\"(max-width: 924px) 100vw, 924px\" \/><\/figure>\n\n\n\n<p>Dac\u0103 nu ave\u021bi Excel sau Numbers, pute\u021bi utiliza Google Sheets, de exemplu.<\/p>\n\n\n\n<p>Excel, Numbers \u0219i alte programe de foi de calcul prezint\u0103 con\u021binutul fi\u0219ierelor .CSV a\u0219a cum ar ap\u0103rea \u00eentr-o foaie de calcul. Aici, valorile sunt sortate \u00een coloane.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1094\" height=\"595\" src=\"https:\/\/vendino.com\/wp-content\/uploads\/csv-fil-i-numbers.png\" alt=\"Fi\u0219ier Csv I Numere\" class=\"wp-image-218\" srcset=\"https:\/\/vendino.com\/wp-content\/uploads\/csv-fil-i-numbers.png 1094w, https:\/\/vendino.com\/wp-content\/uploads\/csv-fil-i-numbers-768x418.png 768w\" sizes=\"(max-width: 1094px) 100vw, 1094px\" \/><\/figure>","protected":false},"excerpt":{"rendered":"<p>CSV st\u00e5r for Comma Separated Values, hvilket er en fil der indeholder data i form af tal og bogstaver. Der findes mange anvendelsesmuligheder for CSV-filer, dog benyttes disse filer ofte til at udveksle data med forskellige applikationer. Filformatet bliver i forbindelse med webshops ofte produkt til produktoprettelse, ordredata og meget andet. CSV-filer er gode, da [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":229,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"iawp_total_views":487,"footnotes":""},"categories":[{"term_id":1,"name":"Uncategorized","slug":"uncategorized","term_group":0,"term_taxonomy_id":1,"taxonomy":"category","description":"","parent":0,"count":2,"filter":"raw","cat_ID":1,"category_count":2,"category_description":"","cat_name":"Uncategorized","category_nicename":"uncategorized","category_parent":0}],"tags":[],"class_list":["post-124","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"acf":[],"images":{"thumbnail":"https:\/\/vendino.com\/wp-content\/uploads\/hvad-er-en-csv-fil-768x513.jpg","medium":"https:\/\/vendino.com\/wp-content\/uploads\/hvad-er-en-csv-fil-768x513.jpg","medium_large":"https:\/\/vendino.com\/wp-content\/uploads\/hvad-er-en-csv-fil-768x513.jpg","large":"https:\/\/vendino.com\/wp-content\/uploads\/hvad-er-en-csv-fil.jpg","full":"https:\/\/vendino.com\/wp-content\/uploads\/hvad-er-en-csv-fil.jpg"},"_links":{"self":[{"href":"https:\/\/vendino.com\/ro\/wp-json\/wp\/v2\/posts\/124","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/vendino.com\/ro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vendino.com\/ro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vendino.com\/ro\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/vendino.com\/ro\/wp-json\/wp\/v2\/comments?post=124"}],"version-history":[{"count":0,"href":"https:\/\/vendino.com\/ro\/wp-json\/wp\/v2\/posts\/124\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/vendino.com\/ro\/wp-json\/wp\/v2\/media\/229"}],"wp:attachment":[{"href":"https:\/\/vendino.com\/ro\/wp-json\/wp\/v2\/media?parent=124"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vendino.com\/ro\/wp-json\/wp\/v2\/categories?post=124"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vendino.com\/ro\/wp-json\/wp\/v2\/tags?post=124"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}