{"id":1919,"date":"2023-10-28T02:40:46","date_gmt":"2023-10-28T02:40:46","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/buka-file-teks\/"},"modified":"2023-12-06T06:14:05","modified_gmt":"2023-12-06T06:14:05","slug":"buka-file-teks","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/buka-file-teks\/","title":{"rendered":"Bagaimana cara membuka file teks di excel? (.txt)"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-4184584789\"><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>Untuk membuka file teks di Excel, Anda cukup membukanya menggunakan kotak dialog terbuka. Setelah Anda membukanya, Excel akan menampilkan opsi teks ke kolom untuk mengimpor data ke lembar kerja. Jika datanya berbentuk tabel, hanya perlu beberapa klik untuk menambahkannya ke Excel. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77769\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fichier-texte-ouvert-dans-excel.png\" sizes=\"auto, \" srcset=\"\" alt=\"buka-file-teks-di-excel\" width=\"687\" height=\"506\"><\/figure><\/div><p> Dalam tutorial ini, kita akan melihat tiga cara berbeda untuk membuka file teks menggunakan Excel.<\/p><h2 class=\"wp-block-heading\"> Langkah-langkah untuk membuka file teks di Excel<\/h2><ol><li> Pertama, buka tab File, klik Buka, lalu klik Telusuri. <br><img loading=\"lazy\" decoding=\"async\" title=\"Buka dan jelajahi dalam 2 klik\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-cliquez-sur-ouvrir-et-parcourir.png\" sizes=\"auto, \" srcset=\"\" alt=\"click-open-and-browse\" width=\"436\" height=\"480\"><\/li><li> Setelah itu, di kotak dialog navigasi, pilih \u201cSemua File\u201d dari menu drop-down di sebelah nama file. <br><img loading=\"lazy\" decoding=\"async\" title=\"3-pilih-semua-file\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-selectionner-tous-les-fichiers.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-all-files\" width=\"550\" height=\"95\"><\/li><li> Selanjutnya, klik pada file teks yang ingin Anda buka dan klik OK. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-pilih-file-teks\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-selectionnez-le-fichier-texte.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-the-text-file\" width=\"436\" height=\"362\"><\/li><li> Anda memiliki kotak dialog teks-ke-kolom. Klik tombol berikutnya untuk melanjutkan ke langkah berikutnya dan centang \u201cData saya memiliki header\u201d. Jika data Anda sudah memiliki header. <br><img loading=\"lazy\" decoding=\"async\" title=\"5 Dialog Teks ke Kolom\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-boite-de-dialogue-de-texte-en-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"text-to-column-dialog-box\" width=\"618\" height=\"442\"><\/li><li> Pada langkah selanjutnya, centang kotak \u201cTab\u201d lalu klik Berikutnya. <br><img loading=\"lazy\" decoding=\"async\" title=\"6-periksa-tab-dan-klik-berikutnya\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-onglet-coche-et-cliquez-sur-suivant.png\" sizes=\"auto, \" srcset=\"\" alt=\"checkmark-tab-and-click-next\" width=\"528\" height=\"410\"><\/li><li> Pada akhirnya, klik Selesai untuk memasukkan data ke dalam spreadsheet. <br><img loading=\"lazy\" decoding=\"async\" title=\"Selesai dalam 7 klik\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Terminer-en-7-clics.png\" sizes=\"auto, \" srcset=\"\" alt=\"click-finish\" width=\"529\" height=\"408\"><\/li><\/ol><p> Setelah Anda mengklik Selesai, Anda akan memiliki data di lembar seperti yang kami miliki di bawah ini: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77776\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-donnees-ouvertes-dans-la-feuille.png\" sizes=\"auto, \" srcset=\"\" alt=\"buka-data-dalam-lembar\" width=\"487\" height=\"425\"><\/figure><\/div><p> Setelah Anda membuka file teks di Excel, Anda akan mendapatkan datanya, tetapi file teks tersebut tidak akan disimpan sebagai file Excel. Simpan sebagai buku kerja Excel, buka File \u21e2 <a href=\"https:\/\/exceladvisor.org\/id\/simpan-sebagai\/\">Simpan Sebagai<\/a> .<\/p><h2 class=\"wp-block-heading\"> Buka file teks di Excel dengan Power Query<\/h2><ol><li> Buka Data \u21e2 Dari File \u21e2 Dari Teks\/CSV. <br><img loading=\"lazy\" decoding=\"async\" title=\"9-buka-file-teks-dengan-power-query\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-fichier-texte-ouvert-avec-requete-de-puissance.png\" sizes=\"auto, \" srcset=\"\" alt=\"open-text-file-with-power-query\" width=\"515\" height=\"482\"><\/li><li> Pilih file yang ingin Anda impor dan klik tombol Impor. <br><img loading=\"lazy\" decoding=\"async\" title=\"10-pilih-file-dan-impor\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-selectionner-le-fichier-et-importer.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-file-and-import\" width=\"498\" height=\"245\"><\/li><li> Klik tombol muat untuk memuat data ke dalam spreadsheet. <br><img loading=\"lazy\" decoding=\"async\" title=\"11-muat-file\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/11-charger-le-fichier.png\" sizes=\"auto, \" srcset=\"\" alt=\"load-the-file\" width=\"663\" height=\"308\"><\/li><li> Anda sekarang memiliki data di spreadsheet. <br><img loading=\"lazy\" decoding=\"async\" title=\"12 data dimuat dalam satu lembar\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/12-donnees-chargees-dans-la-feuille.png\" sizes=\"auto, \" srcset=\"\" alt=\"data-loaded-in-sheet\" width=\"530\" height=\"237\"><\/li><\/ol><p> Bagian terbaik menggunakan <a href=\"https:\/\/exceladvisor.org\/id\/permintaan-kekuatan\/\">power query<\/a> untuk mengimpor data dari file teks adalah sifatnya yang dinamis. Saat Anda memperbarui data dalam file teks, Anda cukup memperbaruinya di Excel hanya dengan mengklik tombol segarkan.<\/p><h2 class=\"wp-block-heading\"> Salin dan tempel data dari file teks ke spreadsheet Excel<\/h2><p> Untuk melakukan ini, buka file teks dan gunakan pintasan keyboard Ctrl + A untuk memilih semua data dalam file teks. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77781\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/13-copier-coller-des-donnees-du-texte-vers-excel.png\" sizes=\"auto, \" srcset=\"\" alt=\"salin-tempel-data-dari-teks-ke-excel\" width=\"674\" height=\"362\"><\/figure><\/div><p> Buka spreadsheet, pilih sel A1 dan <a href=\"https:\/\/exceladvisor.org\/id\/salin-tempel\/\">tekan Ctrl + V<\/a> untuk menempelkan data di sana. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77782\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/14-donnees-textuelles-collees-dans-la-feuille.png\" sizes=\"auto, \" srcset=\"\" alt=\"teks-data-ditempel-dalam-lembar\" width=\"513\" height=\"372\"><\/figure><\/div><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\/xlsx-ke-csv\/\">Simpan file Excel (workbook) dalam format CSV (XLSX TO CSV)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/sembunyikan-tampilkan-buku-kerja\/\">Sembunyikan dan tampilkan buku kerja di Excel<\/a><\/li><\/ul><\/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-1919","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>Bagaimana cara membuka file teks di Excel? (.TXT)<\/title>\n<meta name=\"description\" content=\"Pelajari cara membuka file teks (.txt) di Excel dan cara memasukkan data dari file tersebut ke dalam spreadsheet.\" \/>\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\/buka-file-teks\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara membuka file teks di Excel? (.TXT)\" \/>\n<meta property=\"og:description\" content=\"Pelajari cara membuka file teks (.txt) di Excel dan cara memasukkan data dari file tersebut ke dalam spreadsheet.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/buka-file-teks\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:14:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fichier-texte-ouvert-dans-excel.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\/buka-file-teks\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/buka-file-teks\/\",\"name\":\"Bagaimana cara membuka file teks di Excel? (.TXT)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/buka-file-teks\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/buka-file-teks\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fichier-texte-ouvert-dans-excel.png\",\"datePublished\":\"2023-10-28T02:40:46+00:00\",\"dateModified\":\"2023-12-06T06:14:05+00:00\",\"description\":\"Pelajari cara membuka file teks (.txt) di Excel dan cara memasukkan data dari file tersebut ke dalam spreadsheet.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/buka-file-teks\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/buka-file-teks\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/buka-file-teks\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fichier-texte-ouvert-dans-excel.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fichier-texte-ouvert-dans-excel.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/buka-file-teks\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara membuka file teks di excel? (.txt)\"}]},{\"@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":"Bagaimana cara membuka file teks di Excel? (.TXT)","description":"Pelajari cara membuka file teks (.txt) di Excel dan cara memasukkan data dari file tersebut ke dalam spreadsheet.","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\/buka-file-teks\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara membuka file teks di Excel? (.TXT)","og_description":"Pelajari cara membuka file teks (.txt) di Excel dan cara memasukkan data dari file tersebut ke dalam spreadsheet.","og_url":"https:\/\/exceladvisor.org\/id\/buka-file-teks\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:14:05+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fichier-texte-ouvert-dans-excel.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\/buka-file-teks\/","url":"https:\/\/exceladvisor.org\/id\/buka-file-teks\/","name":"Bagaimana cara membuka file teks di Excel? (.TXT)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/buka-file-teks\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/buka-file-teks\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fichier-texte-ouvert-dans-excel.png","datePublished":"2023-10-28T02:40:46+00:00","dateModified":"2023-12-06T06:14:05+00:00","description":"Pelajari cara membuka file teks (.txt) di Excel dan cara memasukkan data dari file tersebut ke dalam spreadsheet.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/buka-file-teks\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/buka-file-teks\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/buka-file-teks\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fichier-texte-ouvert-dans-excel.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fichier-texte-ouvert-dans-excel.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/buka-file-teks\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara membuka file teks di excel? (.txt)"}]},{"@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\/1919","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=1919"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1919\/revisions"}],"predecessor-version":[{"id":2329,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1919\/revisions\/2329"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1919"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}