View Categories

Cara Menghubungkan SQLite ke Excel – Mengalirkan Data Basis Data Ringan Secara Langsung

Waktu baca 8 menit

0:00 8:29
Hubungkan SQLite ke Excel

Dapatkan data dari sebuah SQLite berkas ke dalam Excel

Buka basis data SQLite Anda di Excel dan perbarui kapan pun Anda mau. Tanpa driver ODBC, tanpa ekspor ke CSV, tanpa makro. Sekitar sepuluh menit untuk pertama kali, dan paket Gratis sudah mencakupnya.

Sekitar 10 menit Tidak perlu coding. File tetap di tempatnya Gunakan Excel di mana saja, bahkan di web.
Mengalami kesulitan di suatu titik? Tanyakan saja pada kami. Membuka Dukungan Di Query Streams (menu kanan atas → Dukungan) dan kirimkan pesan kepada kami. Ada orang sungguhan yang membacanya, dan "Saya tidak tahu apa yang diminta layar ini" adalah pertanyaan yang sangat wajar.

Inilah hasil akhirnya

Logo SQLiteLembar kerja yang menampilkan hasil langsung dari kueri SQL terhadap file SQLite Anda, dengan tombol yang mengambil baris terbaru setiap kali data berubah. Seperti ini:

Basis data SQLite adalah file tunggal, biasanya berakhiran dengan .db, .sqlite, .sqlite3Excel tidak dapat membukanya sendiri, dan solusi umum berarti menginstal driver ODBC dan berurusan dengan string koneksi. Query Streams melewati itu: program pembantu kecil membaca file di tempatnya berada, dan add-in Excel meminta baris yang Anda inginkan. Keduanya tidak perlu berada di komputer yang sama. File dapat berada di komputer kantor dan Anda dapat berada di mana saja: laptop Anda di rumah, komputer kolega di seberang negara, atau Excel di web.

DI MANA BERKAS ITU BERADAkomputer kantor, server, atau komputer di rumahFile SQLite Andasales.db · tetap di siniAgen Aliran Kueriwhere it can open the fileAliran Kueritautan terenkripsimelalui internet · hanya hasilDIMANAPUN KAMU BERADAlaptop Anda, kantor lain, hotel, ponsel AndaExcelWindows, Mac, atau Excel di web
The Agent runs where it can open the file. Excel does not have to. Open the sheet anywhere and the rows come to you.

Yang Anda butuhkan

Akun Query Streams

Paket gratis sudah cukup untuk panduan ini. Daftar di sini. my.querystreams.com.

The Agent on a computer that can open the file

Sebuah program kecil yang berjalan di latar belakang dan membaca file saat Excel memintanya. Langkah 2 di bawah menunjukkan di mana mendapatkannya.

File SQLite Anda

Ketahuilah di mana letaknya, misalnya. C:\Data\sales.db atau \\server\share\sales.db. If it lives in OneDrive, Dropbox or Google Drive, make sure it is synced to the Agent’s computer.

Komputer mana yang mendapatkan Agen? The one where the file is, or one that can open it from a network share (see Reaching a file on a network share below). That computer needs to stay on. Excel bisa berada di mana saja.: laptop Anda di rumah, komputer kolega Anda di tempat lain, atau Excel di web. Tidak ada hal lain yang perlu diinstal di tempat Excel dijalankan.

Hubungkan dalam lima langkah

  1. Buat akun Anda

    Pergi ke my.querystreams.com dan mendaftar. Pilih Gratis Rencana ini adalah rencana nyata, bukan percobaan, dan mencakup cara menghubungkan file SQLite Anda dan menjalankan kueri dari Excel.

  2. Install the Agent on a computer that can open the file

    Masuk, buka Unduh, and install the Agent for your system on the computer where the file is, or on one that can open it from a network share. It takes a minute and starts on its own from then on.

    Mengapa menggunakan program kecil alih-alih driver? The Agent is one install for Windows, Mac or Linux (about 85 MB on Windows, a little over 100 MB on Mac and Linux) that runs quietly in the background. It makes one outbound, encrypted connection to Query Streams, the same way a browser does, so you open no firewall port and set up no VPN. The file stays where it is, and the rows travel to wherever you are, across the internet if need be. The only thing on your side is the add-in.

    Halaman Unduhan menampilkan Kunci Akses AndaTempelkan ke dalam Agent saat diminta, dan tunggu hingga badge terbaca. Terhubung ke Aliran KueriItulah satu-satunya hal yang Anda lakukan pada Agent itu sendiri.

    Panduan lengkap jika Anda menginginkannya: Windows, Mac, Linux.

  3. Arahkan ke file SQLite Anda

    Kembali ke browser Anda, buka Agen Data (di bawah Data (di menu atas). Agen Anda terdaftar di sana. Klik Tambahkan konektor, memilih SQLite, dan isi:

    Nama koneksi
    Nama apa pun yang akan Anda kenali nanti, seperti basis data Penjualan.
    Jalur File Basis Data
    Where the SQLite file is: a path on the Agent’s computer, like C:\Data\sales.db, or a network path, like \\server\share\folder\sales.db, never a mapped drive letter such as S:. Use Browse to pick it.

    Klik Uji koneksiSaat terbaca Terhubung, klik SimpanKoneksi akan sampai ke Agen Anda dalam beberapa detik.

    Agen Data Terbuka

    Tes gagal? Usually the path has a typo, or it uses a mapped drive letter such as S:, which the Agent cannot see. Open the folder, copy the path from the address bar, and paste it in again. For a file on another computer, see Reaching a file on a network share di bawah.

  4. See your data in Query Builder Opsional

    You can look at your SQLite file before Excel is involved at all. Open Pembuat Kueri in the portal and pick the connection you just made. The Skema tab lists your tables and columns, and clicking one puts its name in the editor, so you can write a query without remembering exact names. Click Jalankan and the rows appear under Hasil. Query Builder is on every plan, Free included.

    On Business plans you can also ask Nova in plain English (“show me customers in the USA”) and it writes the SQL for you. When the query looks right, save it: from Personal Core up it shows in the add-in’s Saved Queries list, and on any plan you can copy the SQL into the next step.

  5. Menambahkan Aliran Kueri ke Excel

    Di Excel, buka Sisipkan → Dapatkan Add-in, cari Aliran Kuerilalu klik MenambahkanAtau buka langsung dari Aliran Kueri di Microsoft AppSourceTombol Query Streams muncul di pita menu. Masuk dengan akun yang sama.

    Berfungsi di Excel untuk Microsoft 365 di Windows dan Mac, serta di Excel versi web.

  6. Tarik meja pertama Anda

    Klik tombol Query Streams, lalu pilih Mengalirkan Kueri, dan pilih koneksi yang baru saja Anda buat.

    Ketik kueri yang ingin Anda jalankan. Kueri ini mengambil beberapa kolom dari sebuah pelanggan meja:

    Contoh · SQL
    SELECT customer_id, name, city FROM customers ORDER BY name LIMIT 100;

    Di bawah Lembar Tujuan memilih Buat lembar kerja baruKemudian tekan tombol putar (panah ▶). Baris-baris tersebut akan masuk ke Excel dalam satu atau dua detik. Tekan lagi setiap kali data berubah dan lembar kerja akan diperbarui secara otomatis.

    Tidak tahu SQL? Build it in Pembuat Kueri first and paste it here, or pick it from Saved Queries if you saved it.

Reaching a file on a network share

The Agent opens files as a background service, not as you, so a file on another computer needs one extra step. Which step depends on the computer the Agent runs on.

Windows

Type the network path, like \\server\share\folder, never a mapped drive letter such as S:, which the Agent cannot see. If the share only lets in named people, click Service identity (the chip under the path) and store a login for that server: a company domain account, or an account made on the server itself with Domain left blank. The Agent then signs in to that server and reads the file there, and every connector on that Agent that reads the same server must use the same login. Without a login, it reads as its own service account, which a company domain sees as the computer itself. Step by step on Windows

Linux

Share logins stored in the Portal are not used on Linux: an administrator mounts the share on the Agent’s computer first, in a folder under /mnt atau /media, because the Agent’s service cannot see /home atau /run/user. In the connector, keep the \\server\share path, which the Agent maps onto the mount, or type the mount path instead, such as /mnt/fileserver-shared/Accounts. How to mount a share on Linux

Mac

Share logins stored in the Portal are not used on a Mac: mount the share first from Terminal with sudo, in a folder under /Volumes, so the Agent’s background service can see it. In the connector, keep the \\server\share path, which the Agent maps onto the mount, or type the mount path instead, such as /Volumes/fileserver-shared/Accounts. How to mount a share on a Mac

If the test cannot get to the share, look for these words in its result: unreachable means the Agent’s computer got no answer from the server. On Linux or a Mac, not mounted means the share still has to be mounted, and that message includes the exact mount command for your server.

SQLite file on a share? Meninggalkan Read-Only (Immutable) ticked, as it is by default; reads then take a point-in-time view of the file without locks. SQLite cannot use its WAL mode over a network, so with that box unticked a WAL-mode database on a \\server\share path is refused, and the test says it is a WAL-mode SQLite database.

Test failed on a share?

A Windows Agent signs in to the file server itself, so its test result can also say:

PesanMenyebabkanMemperbaiki
Access denied for the agent’s service account under the path, or Akses ditolak in the test resultThe share lets in named people only, and the Agent’s own Windows account is not one of them. Or the login stored for that server may not read this share.Klik Service identity under the path and store a login that can read the share. If one is stored already, ask whoever runs the server to give that account read access.
the credentials were refusedThe server turned the stored login down: a typo, the wrong domain, or a password changed since it was saved.Click the account name under the path and type the login again; for an account made on the server itself, leave Domain blank. were refused moments ago means the Agent waits a minute before it tries that same login again, so the account is not locked out; saving a corrected password tries again straight away.
Another connector on this agent already signs in to, atau Windows already holds a sign-in toThis Windows computer already signs in to that server as a different account, through another connector or another program. Windows allows one account per server.Store the login the other connector uses, or change it on every connector that reads that server. After Windows already holds a sign-in, the rest of the message says which account it is and what to do.
This agent build cannot sign in toThe Agent is an older version that cannot use stored share logins.Update the Agent, then test again.

Itu saja. Data Anda ada di lembar kerja dan selalu diperbarui hanya dengan satu klik. Tidak ada data yang keluar dari jaringan Anda kecuali baris yang Anda minta.

Langkah selanjutnya yang bagus

  • Simpan kueri di portal sehingga Anda dapat menjalankannya lagi dengan sekali klik, dari Excel atau Google Sheets.
  • Tambahkan filter misalnya rentang tanggal, sehingga kueri yang sama dapat menjawab "bulan ini" tanpa perlu diedit.
  • Bagikan hasilnya bersama seorang kolega. Mereka melihat baris-barisnya, bukan file Anda dan bukan jalur file Anda.

Pertanyaan yang diajukan orang

Apakah Excel harus berada di komputer yang sama dengan file SQLite Anda?

No. Only the Agent has to be able to open your SQLite file. Excel can be on any computer with an internet connection, including Excel on the web and Excel on a Mac. Sign in to the add-in with your account and your connections are there.

Apakah file basis data saya diunggah ke mana pun?

No. The Agent reads the file where it sits and sends only the rows your query asks for. The file stays where it is.

Apakah file tersebut dapat berada di OneDrive, Dropbox, atau Google Drive?

Ya, selama file tersebut disinkronkan ke komputer tempat Agent berjalan, sehingga Agent menganggapnya sebagai file lokal biasa. Arahkan koneksi ke salinan yang telah disinkronkan.

Apakah paket gratis benar-benar mencakup hal ini?

Ya. Gratis adalah paket yang bisa Anda pertahankan, bukan uji coba yang akan berakhir. Lihat detail lengkapnya di sini. halaman harga.

Apakah ini berfungsi dengan Excel untuk Mac?

Ya. Excel untuk Microsoft 365 di Mac dan Windows, serta Excel di web.

Masih bingung? Membuka Dukungan Di Query Streams, beri tahu kami Anda berada di langkah mana dan apa yang Anda lihat. Kami akan menghubungkan Anda.
Buat akun paket gratis AndaLihat apa saja yang termasuk dalam versi Gratis.
Query Streams juga menghubungkan data yang sama keLembar Kerja GoogleClaude, Kursor, dan ChatGPTAPI RESTdan lainnya

Setiap panduan untuk SQLite

Apakah pengaturan Anda kurang tepat?

  • Apakah Anda memiliki folder berisi file SQLite, bukan hanya satu? SQLite Folder menggabungkan tabel yang memiliki nama yang sama menjadi satu tabel dan menandai setiap baris dengan file asalnya → SQLite Folder
  • Ingin melakukan query langsung ke buku kerja Excel? Excel Folder membaca folder buku kerja sebagai tabel → Excel Folder

Setup trouble?

  • Agent says the file or folder does not exist, or access is denied? Mapped drives, network shares, OneDrive and Linux home folders each need one fix → Where the Agent can read files from
  • Agent shows Offline, or Test connection and Browse are greyed out? Check that the Agent is online → Is the Agent online?
Updated on Oktober 17, 2026
otomatisasi integrasi basis data unggul tanpa kode sqlite

What are your Feelings

  • Happy
  • Normal
  • Sad

Powered by BetterDocs