Data files
Open data files on your phone
Use OpenOnPhone when a phone can download a data file but cannot show the structure clearly. The goal is quick local inspection: fields, rows, schema, tables, and safe limits before you move to a full data tool.
What OpenOnPhone can show
| Format | Can show | Does not do |
|---|---|---|
| JSON.json | Formatted structure for local reading. | Does not repair every invalid JSON file. |
| CSV.csv | Rows and columns in a scrollable table. | Does not replace a spreadsheet app for formulas or charts. |
| SQLite / DB.sqlite | Schema, tables, columns, and sample rows. | Does not run SQL or modify the database. |
| Parquet.parquet | Schema, row groups, and sample rows. | Does not run full queries, joins, aggregation, or conversion. |
| Avro.avro | Schema fields, codec clues, and sample records when supported. | Does not guarantee full dataset analysis. |
| Arrow.arrow | Arrow IPC schema and sample rows when supported. | Does not replace an analytics runtime. |
How to use it
- 1.Choose the data file from the file picker.
- 2.OpenOnPhone reads the file locally in the browser and selects a narrow viewer for that format.
- 3.Use the first screen to confirm the schema, fields, rows, tables, or structure.
- 4.Move to a database, notebook, spreadsheet, or analytics tool when you need full analysis.
Limits to know
- Very large files may be slow or hit browser memory limits on older phones.
- Encrypted or damaged data files may only show an error or a partial summary.
- OpenOnPhone does not upload file content, but you should still avoid sharing screenshots that expose private data.
Use SQLite, DuckDB, Python, R, a spreadsheet app, or your data warehouse when you need filtering, joins, formulas, charts, conversion, or full validation.
Related formats
FAQ
- Can I view Parquet rows on my phone?
- Yes, OpenOnPhone can show Parquet schema and sample rows locally for quick inspection. It is not a full query engine.
- Does OpenOnPhone run SQL on SQLite files?
- No. It shows schema, tables, columns, and sample rows, but it does not execute SQL or write to the database.
- Are data files uploaded to a server?
- OpenOnPhone reads file content in the browser for these previews. The content is not uploaded for normal local preview.
- Why not just use the phone file app?
- Phone file apps may show JSON or CSV as raw text and usually cannot explain SQLite, Parquet, Avro, or Arrow structure.