{"id":10203,"date":"2024-08-14T17:06:07","date_gmt":"2024-08-14T10:06:07","guid":{"rendered":"https:\/\/www.linkqu.id\/?p=10203"},"modified":"2024-08-14T17:06:07","modified_gmt":"2024-08-14T10:06:07","slug":"cara-convert-file-excel-xlsx-ke-format-csv","status":"publish","type":"post","link":"https:\/\/www.linkqu.id\/en\/support\/cara-convert-file-excel-xlsx-ke-format-csv\/","title":{"rendered":"Cara Convert File Excel (.XLSX) ke Format .CSV dengan LibreOffice dan EditPadLite"},"content":{"rendered":"<p>Mengonversi file Excel (.XLSX) ke format .CSV bisa dilakukan dengan mudah menggunakan aplikasi LibreOffice dan EditPadLite. Berikut adalah langkah-langkah yang dapat Anda ikuti:<\/p>\n<h4>1. Instalasi LibreOffice<\/h4>\n<ul>\n<li><strong>Unduh terlebih dahulu<\/strong> dari <a href=\"https:\/\/www.libreoffice.org\/download\/download-libreoffice\" target=\"_new\" rel=\"noreferrer noopener\">LibreOffice<\/a>.<\/li>\n<li>Pastikan Anda memilih versi yang sesuai dengan sistem operasi Anda dan lakukan instalasi.<\/li>\n<\/ul>\n<h4>2. Instalasi EditPadLite<\/h4>\n<ul>\n<li><strong>Unduh EditPadLite<\/strong> melalui <a href=\"https:\/\/www.editpadlite.com\/download.html\" target=\"_new\" rel=\"noreferrer noopener\">tautan ini<\/a>.<\/li>\n<li>Ikuti petunjuk instalasi yang ada.<\/li>\n<\/ul>\n<h3>Langkah-langkah Mengonversi .XLSX ke .CSV<\/h3>\n<h4>1. Buka File .XLSX dengan LibreOffice<\/h4>\n<ul>\n<li><strong>Klik kanan<\/strong> pada file .XLSX yang ingin Anda ubah, lalu pilih <strong>Open With -&gt; LibreOffice Calc<\/strong>.<\/li>\n<\/ul>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone size-full wp-image-10207\" src=\"https:\/\/www.linkqu.id\/wp-content\/uploads\/2024\/08\/Gambar1.png\" alt=\"\" width=\"1234\" height=\"389\" title=\"\" srcset=\"https:\/\/www.linkqu.id\/wp-content\/uploads\/2024\/08\/Gambar1.png 1234w, https:\/\/www.linkqu.id\/wp-content\/uploads\/2024\/08\/Gambar1-18x6.png 18w\" sizes=\"(max-width: 1234px) 100vw, 1234px\" \/><\/p>\n<h4>2. Menyimpan File sebagai CSV<\/h4>\n<ul>\n<li>Setelah file terbuka, <strong>pilih &#8220;File&#8221; -&gt; &#8220;Save As&#8221;<\/strong>.<\/li>\n<li>Pada jendela yang muncul, pilih lokasi penyimpanan, dan di bagian <strong>&#8220;Save as type&#8221;<\/strong>, pilih <strong>Text CSV (.csv)<\/strong>.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-10209\" src=\"https:\/\/www.linkqu.id\/wp-content\/uploads\/2024\/08\/Gambar3.png\" alt=\"\" width=\"1284\" height=\"694\" title=\"\" srcset=\"https:\/\/www.linkqu.id\/wp-content\/uploads\/2024\/08\/Gambar3.png 1284w, https:\/\/www.linkqu.id\/wp-content\/uploads\/2024\/08\/Gambar3-18x10.png 18w\" sizes=\"(max-width: 1284px) 100vw, 1284px\" \/><\/p>\n<h4>3. Konfirmasi Penyimpanan dalam Format CSV<\/h4>\n<ul>\n<li><strong>Setelah menekan &#8220;Save&#8221;,<\/strong> akan muncul jendela konfirmasi. Pilih <strong>&#8220;Use Text CSV Format&#8221;<\/strong>.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-10210\" src=\"https:\/\/www.linkqu.id\/wp-content\/uploads\/2024\/08\/Gambar4.png\" alt=\"\" width=\"1296\" height=\"598\" title=\"\" srcset=\"https:\/\/www.linkqu.id\/wp-content\/uploads\/2024\/08\/Gambar4.png 1296w, https:\/\/www.linkqu.id\/wp-content\/uploads\/2024\/08\/Gambar4-18x8.png 18w\" sizes=\"(max-width: 1296px) 100vw, 1296px\" \/><\/p>\n<h4>4. Pengaturan Format CSV<\/h4>\n<ul>\n<li>Di jendela <strong>&#8220;Export Text File&#8221;<\/strong> yang muncul, pastikan <strong>tidak ada kotak yang dicentang<\/strong>.<\/li>\n<li>Tekan <strong>&#8220;OK&#8221;<\/strong> untuk menyimpan file ke format CSV.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-10211\" src=\"https:\/\/www.linkqu.id\/wp-content\/uploads\/2024\/08\/Gambar5.png\" alt=\"\" width=\"1093\" height=\"684\" title=\"\" srcset=\"https:\/\/www.linkqu.id\/wp-content\/uploads\/2024\/08\/Gambar5.png 1093w, https:\/\/www.linkqu.id\/wp-content\/uploads\/2024\/08\/Gambar5-18x12.png 18w\" sizes=\"(max-width: 1093px) 100vw, 1093px\" \/><\/p>\n<h3>Langkah Tambahan untuk File BRI<\/h3>\n<h4>1. Membuka File CSV BRI di EditPadLite<\/h4>\n<ul>\n<li>Buka <strong>EditPadLite<\/strong>, lalu <strong>pilih &#8220;File&#8221; -&gt; &#8220;Open&#8221;<\/strong> dan cari file CSV BRI yang baru disimpan.<\/li>\n<\/ul>\n<h4>2. Mengedit Header Kolom<\/h4>\n<ul>\n<li><strong>Perhatikan bagian yang diblok biru<\/strong>, hapus hingga hanya tersisa header kolom yang dibutuhkan seperti <strong>MID, TID, Nama Merchant,<\/strong> dan seterusnya.<\/li>\n<li>Pastikan untuk memperhatikan posisi koma agar format tetap benar.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-10212\" src=\"https:\/\/www.linkqu.id\/wp-content\/uploads\/2024\/08\/Gambar6.png\" alt=\"\" width=\"1031\" height=\"265\" title=\"\" srcset=\"https:\/\/www.linkqu.id\/wp-content\/uploads\/2024\/08\/Gambar6.png 1031w, https:\/\/www.linkqu.id\/wp-content\/uploads\/2024\/08\/Gambar6-18x5.png 18w\" sizes=\"(max-width: 1031px) 100vw, 1031px\" \/><\/p>\n<h4>3. Simpan Perubahan<\/h4>\n<ul>\n<li>Setelah selesai mengedit, simpan file dengan <strong>klik &#8220;File&#8221; -&gt; &#8220;Save&#8221;<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-10213\" src=\"https:\/\/www.linkqu.id\/wp-content\/uploads\/2024\/08\/Gambar7.png\" alt=\"\" width=\"995\" height=\"395\" title=\"\" srcset=\"https:\/\/www.linkqu.id\/wp-content\/uploads\/2024\/08\/Gambar7.png 995w, https:\/\/www.linkqu.id\/wp-content\/uploads\/2024\/08\/Gambar7-18x7.png 18w\" sizes=\"(max-width: 995px) 100vw, 995px\" \/><\/p>","protected":false},"excerpt":{"rendered":"<p>Mengonversi file Excel (.XLSX) ke format .CSV bisa dilakukan dengan mudah menggunakan aplikasi LibreOffice dan EditPadLite. Berikut adalah langkah-langkah yang dapat Anda ikuti: 1. Instalasi LibreOffice Unduh terlebih dahulu dari LibreOffice. Pastikan Anda memilih versi yang sesuai dengan sistem operasi Anda dan lakukan instalasi. 2. Instalasi EditPadLite Unduh EditPadLite melalui tautan ini. Ikuti petunjuk instalasi [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":8099,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"aside","meta":{"_acf_changed":false,"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":"","_wpscppro_dont_share_socialmedia":false,"_wpscppro_custom_social_share_image":0,"_facebook_share_type":"","_twitter_share_type":"","_linkedin_share_type":"","_pinterest_share_type":"","_linkedin_share_type_page":"","_instagram_share_type":"","_medium_share_type":"","_threads_share_type":"","_google_business_share_type":"","_selected_social_profile":[],"_wpsp_enable_custom_social_template":false,"_wpsp_social_scheduling":{"enabled":false,"datetime":null,"platforms":[],"status":"template_only","dateOption":"today","timeOption":"now","customDays":"","customHours":"","customDate":"","customTime":"","schedulingType":"absolute"},"_wpsp_active_default_template":true},"categories":[1181,1182,1395],"tags":[],"class_list":["post-10203","post","type-post","status-publish","format-aside","has-post-thumbnail","hentry","category-support","category-cognos","category-panduan","post_format-post-format-aside"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.linkqu.id\/en\/wp-json\/wp\/v2\/posts\/10203","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.linkqu.id\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.linkqu.id\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.linkqu.id\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.linkqu.id\/en\/wp-json\/wp\/v2\/comments?post=10203"}],"version-history":[{"count":0,"href":"https:\/\/www.linkqu.id\/en\/wp-json\/wp\/v2\/posts\/10203\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.linkqu.id\/en\/wp-json\/wp\/v2\/media\/8099"}],"wp:attachment":[{"href":"https:\/\/www.linkqu.id\/en\/wp-json\/wp\/v2\/media?parent=10203"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.linkqu.id\/en\/wp-json\/wp\/v2\/categories?post=10203"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.linkqu.id\/en\/wp-json\/wp\/v2\/tags?post=10203"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}