JS MyJS

Query Files

Query CSV, Excel and JSON files with SQL, right in your browser: join them, reach into JSON values, and download the results. Your files are never uploaded.

Drop files to add them as tables
{{ notice.text }}

SQL

Loading the editor…
Tips

Reach into JSON values with favorite.color, name["First Name"] and grades[-1] (the last item), and count a JSON list’s items with json_array_length(grades). This is SQLite’s SQL: type a few letters to see its functions, or read about its functions and JSON functions. {{ runKey }} runs the selected SQL when some is selected, otherwise all of it. Tab adds a tab or picks the highlighted suggestion; to leave the editor with the keyboard, press Esc, then Tab.

Result

· {{ result.ms < 1000 ? Math.max(1, Math.round(result.ms)) + ' ms' : (result.ms / 1000).toFixed(1) + ' s' }}
The SQL that ran 
{{ (error || result).ranSql }}

The rows a query gives show up here.
Write some SQL above and press Run or {{ runKey }}.

© 2026 MyJS