Query CSV with SQL Online
Run SQL SELECT queries against a CSV in your browser: it loads into a table you can filter, group and join. Nothing is uploaded.
כיצד להשתמש בQuery CSV (SQL)
- 01
Paste your CSV into the input; it loads into a table named data.
- 02
Write a SELECT query and press Run (or Ctrl/Cmd + Enter).
- 03
Copy or download the result as CSV.
What it does
This tool loads your CSV into a real SQLite table and lets you query it with SQL. Filter with WHERE, summarise with GROUP BY, sort, and shape the output exactly as you need.
It is the quickest way to answer a question about a spreadsheet without importing it into a database, and the result can be copied or downloaded as CSV.
How the CSV becomes a table
The header row becomes the column names and each row becomes a record in a table (named data by default, which you can change). Values that look numeric are stored as numbers so comparisons and sums work.
SQLite runs the query in your browser through WebAssembly, so joins, aggregates and subqueries all work and nothing is uploaded.
Private and unlimited
Every conversion happens locally in your browser, so your data is never uploaded, logged or stored on a server. You can use it on confidential exports without a second thought, and it keeps working offline once the page has loaded.
There is no sign-up, no watermark and no row limit: the only ceiling is your device's memory.
שאלות נפוצות
What is the table called?
By default your CSV is loaded into a table named data, so a query like SELECT * FROM data works right away. You can rename it in the table field.
Which SQL is supported?
The full SQLite dialect, since it is the real engine compiled to WebAssembly: WHERE, GROUP BY, HAVING, ORDER BY, joins, subqueries and aggregate functions.
Is my CSV uploaded to run the query?
No. The CSV is parsed and queried entirely in your browser, so the data never leaves your device.
Is there a row or file-size limit?
There is no fixed row cap or daily quota. Because everything runs locally the practical limit is your device's memory, which comfortably handles the tens of thousands of rows most exports contain.
Is my data uploaded anywhere?
No. The conversion runs entirely in your browser with client-side JavaScript, so nothing you paste or drop ever leaves your device. That makes it safe for spreadsheets that contain customer emails, financial figures or other sensitive data.
מקורות
הטמע את הכלי הזה
הוסף את הכלי הזה לאתר שלך. העתק את קטע הקוד שלהלן; הוא מתעדכן אוטומטית.
<iframe src="https://monu.tools/embed/he/query-csv-sql" width="100%" height="640" style="border:1px solid #e5e5e5;border-radius:12px;max-width:680px" loading="lazy" title="Monu Tools"></iframe>כלים קשורים
CSV Editor
Edit CSV in a spreadsheet-style grid in your browser: add or remove rows and columns, rename headers, then export clean CSV. Nothing is uploaded.
Change delimiter
Change a file's delimiter: read CSV with one separator and write it with another, such as comma to tab (TSV) or pipe. Runs in your browser.
CSV / Excel
המירו CSV לקובץ Excel .xlsx ו-Excel בחזרה ל-CSV, כולו בדפדפן שלכם. עובד בשני הכיוונים.
Pivot CSV
Build a pivot table from CSV in your browser: group by a field, spread another across columns and aggregate. Nothing is uploaded.