{"id":1897,"date":"2023-10-29T08:17:45","date_gmt":"2023-10-29T08:17:45","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/xlsx-ke-csv\/"},"modified":"2023-12-06T06:19:10","modified_gmt":"2023-12-06T06:19:10","slug":"xlsx-ke-csv","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/xlsx-ke-csv\/","title":{"rendered":"Bagaimana cara menyimpan file excel dalam format csv?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-288109265\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Anda dapat menyimpan file Excel dalam berbagai format dan di antara semua format ini, CSV sangat populer. Ya, Anda dapat menyimpan file Excel Anda dalam format CSV (XLSX dan CSV). CSV adalah singkatan dari Comma Separated Values yang mana nilai-nilainya dipisahkan dengan <a href=\"https:\/\/exceladvisor.org\/id\/menggabungkan-sel-dengan-koma\/\">koma<\/a> seperti yang Anda lihat pada contoh berikut. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72497\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-enregistrer-excel-au-format-csv.png\" sizes=\"auto, \" srcset=\"\" alt=\"simpan-excel-as-csv\" width=\"707\" height=\"416\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Simpan file Excel (buku kerja) dalam format CSV (format nilai dipisahkan koma).<\/h2><ol><li> Pertama, buka file yang ingin Anda simpan dalam format CSV. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-buka-file-untuk-menyimpan-sebagai-csv\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-ouvrir-le-fichier-a-enregistrer-au-format-csv.png\" sizes=\"auto, \" srcset=\"\" alt=\"open-file-to-save-as-csv\" width=\"621\" height=\"394\"><\/li><li> Setelah itu, buka tab File dan klik opsi Simpan Sebagai. <br><img loading=\"lazy\" decoding=\"async\" title=\"Opsi pendaftaran 3-klik\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-cliquez-sur-enregistrer-en-tant-quoption.png\" sizes=\"auto, \" srcset=\"\" alt=\"click-save-as-option\" width=\"457\" height=\"419\"><\/li><li> Sekarang, tentukan lokasi di mana Anda ingin menyimpan file dan di \u201cSave as type\u201d, pilih \u201cCSV UTF-8 (comma delimited)\u201d. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-pilih-csv-utf-8-untuk-menyimpan-file\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-selectionnez-csv-utf-8-pour-enregistrer-le-fichier.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-csv-utf-8-to-save-file\" width=\"550\" height=\"493\"><\/li><li> Pada akhirnya, klik OK untuk menyimpan file.<\/li><\/ol><p> Sekarang Anda dapat melihat bahwa kedua file (XLSX dan CSV) disimpan di desktop. Namun ada sedikit perbedaan antar ikon yang membantu Anda mengidentifikasi mana yang berformat CSV. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72501\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-icones-excel-xlxs-et-csv.png\" sizes=\"auto, \" srcset=\"\" alt=\"ikon excel-xlxs-dan-csv\" width=\"282\" height=\"166\"><\/figure><\/div><p> Sekarang, setelah Anda menyimpan buku kerja dalam format CSV, Excel tetap mengizinkan Anda membukanya karena mendukung penuh format CSV. Namun itu tidak memungkinkan Anda memformat data dan menggunakan fitur seperti rumus dan fungsi.<\/p><p> Selain itu, ketika Anda membuka file CSV yang baru saja Anda simpan dari Excel dengan aplikasi notepad, Anda dapat melihat pada contoh berikut, terdapat koma di antara nilai yang kita miliki sebagai tabel dalam format Excel. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72502\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-ouvrir-csv-avec-bloc-notes.png\" sizes=\"auto, \" srcset=\"\" alt=\"buka-csv-dengan-notepad\" width=\"641\" height=\"420\"><\/figure><\/div><p> Ada satu hal yang perlu Anda ketahui saat mengonversi file Anda dari XLSX ke CSV, jika buku kerja memiliki lebih dari satu lembar, Excel hanya akan menyimpan lembar (aktif) saat ini dalam format CSV. Ini akan mengabaikan sisa lembar dan Anda harus menyimpannya satu per satu. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72503\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-Excel-convertit-la-feuille-actuelle-en-csv-uniquement.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-mengonversi-lembar-saat ini-ke-csv-saja\" width=\"722\" height=\"201\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Kode VBA untuk mengonversi XLSX ke CSV<\/h2><p> Anda juga dapat menggunakan kode VBA berikut untuk menyimpan file Excel dalam format CSV.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub xlsx_to_csv() Dim myPath As String, myName As String, myTime As String Dim myAddress As String myPath = ActiveWorkbook.Path myName = Left(ActiveWorkbook.Name, InStr(ActiveWorkbook.Name, \".\") - 1) myTime = Format(Now, \"DD_MM_YY_HH_MM_SS\") myAddress = myPath &amp; \"\" &amp; myName &amp; \"_\" &amp; myTime ActiveWorkbook.SaveAs Filename:=myAddress, FileFormat:=xlCSVUTF8 End Sub<\/code><\/pre><p> Kode ini menyimpan buku kerja aktif sebagai CSV di lokasi yang sama dengan nama yang sama menggunakan tanggal dan waktu saat ini.<\/p><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/unggul-terlebih-dahulu\/\">Tutorial Excel Tingkat Lanjut<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutorial terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/memperbaiki-file-excel-yang-rusak\/\">Perbaiki File Excel yang Rusak<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/memulihkan-file-yang-belum-disimpan\/\">Pulihkan file Excel yang belum disimpan saat Excel mogok<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/sembunyikan-tampilkan-buku-kerja\/\">Sembunyikan dan tampilkan buku kerja di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menyalin-buku-kerja\/\">Membuat salinan buku kerja Excel (file)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/buka-file-teks\/\">Buka file teks di Excel (.TXT)<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1897","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u25b7 Bagaimana cara menyimpan file Excel dalam format CSV?<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, kita akan mempelajari cara menyimpan file Excel (Workbook) dalam format CSV (XLSX ke CSV).\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/xlsx-ke-csv\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara menyimpan file Excel dalam format CSV?\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, kita akan mempelajari cara menyimpan file Excel (Workbook) dalam format CSV (XLSX ke CSV).\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/xlsx-ke-csv\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:19:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-enregistrer-excel-au-format-csv.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/xlsx-ke-csv\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/xlsx-ke-csv\/\",\"name\":\"\u25b7 Bagaimana cara menyimpan file Excel dalam format CSV?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/xlsx-ke-csv\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/xlsx-ke-csv\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-enregistrer-excel-au-format-csv.png\",\"datePublished\":\"2023-10-29T08:17:45+00:00\",\"dateModified\":\"2023-12-06T06:19:10+00:00\",\"description\":\"Dalam tutorial ini, kita akan mempelajari cara menyimpan file Excel (Workbook) dalam format CSV (XLSX ke CSV).\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/xlsx-ke-csv\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/xlsx-ke-csv\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/xlsx-ke-csv\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-enregistrer-excel-au-format-csv.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-enregistrer-excel-au-format-csv.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/xlsx-ke-csv\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menyimpan file excel dalam format csv?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 Bagaimana cara menyimpan file Excel dalam format CSV?","description":"Dalam tutorial ini, kita akan mempelajari cara menyimpan file Excel (Workbook) dalam format CSV (XLSX ke CSV).","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:\/\/exceladvisor.org\/id\/xlsx-ke-csv\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara menyimpan file Excel dalam format CSV?","og_description":"Dalam tutorial ini, kita akan mempelajari cara menyimpan file Excel (Workbook) dalam format CSV (XLSX ke CSV).","og_url":"https:\/\/exceladvisor.org\/id\/xlsx-ke-csv\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:19:10+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-enregistrer-excel-au-format-csv.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/xlsx-ke-csv\/","url":"https:\/\/exceladvisor.org\/id\/xlsx-ke-csv\/","name":"\u25b7 Bagaimana cara menyimpan file Excel dalam format CSV?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/xlsx-ke-csv\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/xlsx-ke-csv\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-enregistrer-excel-au-format-csv.png","datePublished":"2023-10-29T08:17:45+00:00","dateModified":"2023-12-06T06:19:10+00:00","description":"Dalam tutorial ini, kita akan mempelajari cara menyimpan file Excel (Workbook) dalam format CSV (XLSX ke CSV).","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/xlsx-ke-csv\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/xlsx-ke-csv\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/xlsx-ke-csv\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-enregistrer-excel-au-format-csv.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-enregistrer-excel-au-format-csv.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/xlsx-ke-csv\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menyimpan file excel dalam format csv?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1897","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1897"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1897\/revisions"}],"predecessor-version":[{"id":2818,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1897\/revisions\/2818"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1897"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}