Cara Mengubah Berkas Excel Menjadi Berkas DAT

Unduh PDF
Disusun bersama Staf wikiHow

Unduh PDF

Artikel wikiHow ini akan mengajarkan kepada Anda cara mengubah berkas Microsoft Excel (.XLS) ke dalam format .DAT pada komputer Windows. Anda perlu mengubah berkas .XLS ke dalam format .CSV ( comma separated values ) terlebih dahulu, kemudian mengonversinya menjadi berkas .DAT melalui aplikasi seperti Notepad.

Bagian 1
Bagian 1 dari 2:

Mengubah Dokumen Excel Menjadi Berkas .CSV

Unduh PDF
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/5\/5a\/Convert-Excel-to-Dat-Step-1.jpg\/v4-460px-Convert-Excel-to-Dat-Step-1.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/5a\/Convert-Excel-to-Dat-Step-1.jpg\/v4-728px-Convert-Excel-to-Dat-Step-1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Aplikasi ini berada pada kelompok aplikasi “ Microsoft Office ” di segmen “ All Apps ” pada menu “Windows”/”Start“.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/2\/2c\/Convert-Excel-to-Dat-Step-2.jpg\/v4-460px-Convert-Excel-to-Dat-Step-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/2c\/Convert-Excel-to-Dat-Step-2.jpg\/v4-728px-Convert-Excel-to-Dat-Step-2.jpg","smallWidth":460,"smallHeight":348,"bigWidth":728,"bigHeight":551,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Menu ini berada di pojok kiri atas layar.
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/39\/Convert-Excel-to-Dat-Step-3.jpg\/v4-460px-Convert-Excel-to-Dat-Step-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/39\/Convert-Excel-to-Dat-Step-3.jpg\/v4-728px-Convert-Excel-to-Dat-Step-3.jpg","smallWidth":460,"smallHeight":348,"bigWidth":728,"bigHeight":551,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/6\/6e\/Convert-Excel-to-Dat-Step-4.jpg\/v4-460px-Convert-Excel-to-Dat-Step-4.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/6e\/Convert-Excel-to-Dat-Step-4.jpg\/v4-728px-Convert-Excel-to-Dat-Step-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Berkas akan dibuka di jendela Excel.
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/b\/bf\/Convert-Excel-to-Dat-Step-5.jpg\/v4-460px-Convert-Excel-to-Dat-Step-5.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/bf\/Convert-Excel-to-Dat-Step-5.jpg\/v4-728px-Convert-Excel-to-Dat-Step-5.jpg","smallWidth":460,"smallHeight":348,"bigWidth":728,"bigHeight":551,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/c8\/Convert-Excel-to-Dat-Step-6.jpg\/v4-460px-Convert-Excel-to-Dat-Step-6.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c8\/Convert-Excel-to-Dat-Step-6.jpg\/v4-728px-Convert-Excel-to-Dat-Step-6.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  7. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/38\/Convert-Excel-to-Dat-Step-7.jpg\/v4-460px-Convert-Excel-to-Dat-Step-7.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/38\/Convert-Excel-to-Dat-Step-7.jpg\/v4-728px-Convert-Excel-to-Dat-Step-7.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  8. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/3c\/Convert-Excel-to-Dat-Step-8.jpg\/v4-460px-Convert-Excel-to-Dat-Step-8.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3c\/Convert-Excel-to-Dat-Step-8.jpg\/v4-728px-Convert-Excel-to-Dat-Step-8.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Daftar jenis berkas akan dibuka.
  9. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/1\/1b\/Convert-Excel-to-Dat-Step-9.jpg\/v4-460px-Convert-Excel-to-Dat-Step-9.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/1b\/Convert-Excel-to-Dat-Step-9.jpg\/v4-728px-Convert-Excel-to-Dat-Step-9.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Dengan demikian, Anda bisa membuat berkas yang dapat dikonversi ke dalam format .DAT.
  10. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/eb\/Convert-Excel-to-Dat-Step-10.jpg\/v4-460px-Convert-Excel-to-Dat-Step-10.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/eb\/Convert-Excel-to-Dat-Step-10.jpg\/v4-728px-Convert-Excel-to-Dat-Step-10.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Masukkan nama pada kolom “ File name ”. Jika ingin menggunakan nama yang sudah ada saat, lewati langkah ini.
  11. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/b\/bb\/Convert-Excel-to-Dat-Step-11.jpg\/v4-460px-Convert-Excel-to-Dat-Step-11.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/bb\/Convert-Excel-to-Dat-Step-11.jpg\/v4-728px-Convert-Excel-to-Dat-Step-11.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Pesan konfirmasi akan ditampilkan.
  12. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/7\/7f\/Convert-Excel-to-Dat-Step-12.jpg\/v4-460px-Convert-Excel-to-Dat-Step-12.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/7f\/Convert-Excel-to-Dat-Step-12.jpg\/v4-728px-Convert-Excel-to-Dat-Step-12.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Berkas .CSV akan disimpan dan siap dikonversi.
    Iklan
Bagian 2
Bagian 2 dari 2:

Mengonversi Berkas .CSV ke Dalam Format .DAT

Unduh PDF
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/a0\/Convert-Excel-to-Dat-Step-13.jpg\/v4-460px-Convert-Excel-to-Dat-Step-13.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a0\/Convert-Excel-to-Dat-Step-13.jpg\/v4-728px-Convert-Excel-to-Dat-Step-13.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Jendela File Explorer akan dibuka.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/0\/01\/Convert-Excel-to-Dat-Step-14.jpg\/v4-460px-Convert-Excel-to-Dat-Step-14.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/01\/Convert-Excel-to-Dat-Step-14.jpg\/v4-728px-Convert-Excel-to-Dat-Step-14.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Jangan klik berkas setelah folder terbuka; cukup biarkan folder ditampilkan di layar.
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/4a\/Convert-Excel-to-Dat-Step-15.jpg\/v4-460px-Convert-Excel-to-Dat-Step-15.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/4a\/Convert-Excel-to-Dat-Step-15.jpg\/v4-728px-Convert-Excel-to-Dat-Step-15.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/ee\/Convert-Excel-to-Dat-Step-16.jpg\/v4-460px-Convert-Excel-to-Dat-Step-16.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/ee\/Convert-Excel-to-Dat-Step-16.jpg\/v4-728px-Convert-Excel-to-Dat-Step-16.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Daftar aplikasi akan ditampilkan.
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/0\/08\/Convert-Excel-to-Dat-Step-17.jpg\/v4-460px-Convert-Excel-to-Dat-Step-17.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/08\/Convert-Excel-to-Dat-Step-17.jpg\/v4-728px-Convert-Excel-to-Dat-Step-17.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Berkas akan dibuka di aplikasi Notepad.
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/6\/6b\/Convert-Excel-to-Dat-Step-18.jpg\/v4-460px-Convert-Excel-to-Dat-Step-18.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/6b\/Convert-Excel-to-Dat-Step-18.jpg\/v4-728px-Convert-Excel-to-Dat-Step-18.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Menu ini berada di pojok kiri atas jendela Notepad.
  7. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/c6\/Convert-Excel-to-Dat-Step-19.jpg\/v4-460px-Convert-Excel-to-Dat-Step-19.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c6\/Convert-Excel-to-Dat-Step-19.jpg\/v4-728px-Convert-Excel-to-Dat-Step-19.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  8. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/48\/Convert-Excel-to-Dat-Step-20.jpg\/v4-460px-Convert-Excel-to-Dat-Step-20.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/48\/Convert-Excel-to-Dat-Step-20.jpg\/v4-728px-Convert-Excel-to-Dat-Step-20.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Menu ini berada di bawah kolom “ File name ”. Daftar jenis berkas akan ditampilkan.
  9. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/af\/Convert-Excel-to-Dat-Step-21.jpg\/v4-460px-Convert-Excel-to-Dat-Step-21.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/af\/Convert-Excel-to-Dat-Step-21.jpg\/v4-728px-Convert-Excel-to-Dat-Step-21.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Dengan opsi ini, Anda bisa menentukan sendiri ekstensi yang akan digunakan.
  10. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/4c\/Convert-Excel-to-Dat-Step-22.jpg\/v4-460px-Convert-Excel-to-Dat-Step-22.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/4c\/Convert-Excel-to-Dat-Step-22.jpg\/v4-728px-Convert-Excel-to-Dat-Step-22.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Sebagai contoh, jika kolom “ File name ” saat ini berlabel Buku1.txt , ubah menjadi Book1.dat .
    • Kapitalisasi ekstensi .DAT tidak berpengaruh (mis. “.DAT” atau “.dat”).
  11. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/0\/08\/Convert-Excel-to-Dat-Step-23.jpg\/v4-460px-Convert-Excel-to-Dat-Step-23.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/08\/Convert-Excel-to-Dat-Step-23.jpg\/v4-728px-Convert-Excel-to-Dat-Step-23.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Berkas asli sekarang berhasil disimpan ke dalam format .DAT.
    Iklan

wikiHow Terkait

Cara
Mengecilkan Tampilan pada Komputer
Cara Pindah Direktori dengan Command Prompt
Cara
Mengaktifkan Pratinjau Gambar untuk Menampilkan Gambar di Folder (Windows 10)
Cara
Menghentikan Printer Spooling pada Komputer Windows
Cara
Mengatasi Suara yang Tidak Muncul di Windows
Cara
Membuka Slot CD di Windows 10
Cara
Membuka Command Prompt di Windows
Cara
Memperbesar Tampilan di PC
Cara
Menggunakan Tombol Fungsi tanpa Menekan Fn pada Windows 10
Cara
Membuka Folder di Command Prompt
Cara
Membuka Windows Task Manager
Cara
Menghapus Berkas Temporer dan Prefetch dari Komputer
Cara
Mengakses Komputer Lain dalam Jaringan yang Sama Melalui PC atau Komputer Mac
Cara
Menukar Monitor 1 dan 2 di PC
Iklan

Tentang wikiHow ini

Bahasa lain
Halaman ini telah diakses sebanyak 8.755 kali.

Apakah artikel ini membantu Anda?

Iklan