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

FormatCan showDoes not do
JSON.jsonFormatted structure for local reading.Does not repair every invalid JSON file.
CSV.csvRows and columns in a scrollable table.Does not replace a spreadsheet app for formulas or charts.
SQLite / DB.sqliteSchema, tables, columns, and sample rows.Does not run SQL or modify the database.
Parquet.parquetSchema, row groups, and sample rows.Does not run full queries, joins, aggregation, or conversion.
Avro.avroSchema fields, codec clues, and sample records when supported.Does not guarantee full dataset analysis.
Arrow.arrowArrow IPC schema and sample rows when supported.Does not replace an analytics runtime.

How to use it

  1. 1.Choose the data file from the file picker.
  2. 2.OpenOnPhone reads the file locally in the browser and selects a narrow viewer for that format.
  3. 3.Use the first screen to confirm the schema, fields, rows, tables, or structure.
  4. 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.
Open Data Files on Phone - OpenOnPhone