Search Text in JSON Files Online

What search modes does the JSON text search tool support?

Plain text (case-insensitive substring match), case-sensitive exact match, and regular expression search using RE2 syntax. All modes return only the matching rows, ready to download as a filtered file.

Can I search across all columns in a JSON file at once?

Yes. Choose "All text columns" to search every VARCHAR column simultaneously. A row is included in the output if the search term appears in any text column. Or select a specific column for a targeted search.

When should I use text search instead of the Filter tool for a JSON file?

Text search is faster for keyword lookups across multiple columns simultaneously. The Filter tool is more powerful for precise conditions like equals, greater than, or is null on a specific column. For complex multi-condition logic, use the SQL Query tool.

Is my data private?

Yes — completely. Your file is never uploaded to any server. Everything runs locally in your browser using WebAssembly — processing happens entirely inside your tab. Once you close the tab, nothing is retained.

What is the maximum file size?

The free limit is 50 MB. For larger files, performance depends on your device's available memory — most modern machines handle 500 MB to 1 GB comfortably.