# Data Utility: Free online data tools that never upload your files

> Free online data tools: convert JSON, CSV, Parquet, Excel and Avro, clean and join files, export steps as SQL or pandas code, mask data. Works offline.

Page: https://datautility.in/
This is the Markdown copy of the page. The tool itself runs in the browser: your files are processed on your own device and are not uploaded.

Works with CSV, JSON, Excel, Parquet, Avro, XML, YAML.

Data Utility is a set of 24 free online data tools that run in your browser. Convert files between JSON, CSV, Parquet and Excel, merge or split files, turn pasted text into a table, turn an API response into a table, edit nested JSON as a table, format and validate JSON, CSV, XML and YAML, compress files with gzip, turn a screenshot of a table into data, create SQL scripts, generate test data from a CREATE TABLE, join, trim and reshape files with Data Transformation, profile and compare datasets, write data contracts and check files against them, mask personal data before you share it, and follow every change in Data Lineage. The Cloud Storage Cost Calculator compares Amazon S3 and Azure Blob Storage costs for your own data size and access pattern, from official price lists. Recent files lets you reuse a result in another tool. Three AI tools let you chat with your data using your own Gemini key. Your files never leave your device, and there is nothing to install or sign up for.

## All tools

- [Data Contract Generator and Validator](https://datautility.in/data-contract-generator): Make a data contract from a CSV, Excel, JSON or Parquet file, then check new files against it. Saves ODCS YAML or a dbt schema.yml. Free, in your browser.
- [JSON, CSV, Parquet and Excel Converter](https://datautility.in/format-converter): Convert between JSON, CSV, Parquet and Excel online for free, one file or a whole folder. It runs in your browser, so nothing is uploaded.
- [Data Formatter: JSON, CSV, XML and YAML](https://datautility.in/data-formatter): Validate, beautify and clean JSON, CSV, XML and YAML for free. Highlight columns, rows and words and download as Excel. Runs in your browser.
- [File Compressor: Gzip JSON, CSV, XML, YAML, Parquet](https://datautility.in/file-compressor): Compress JSON, CSV, XML, YAML and Parquet files with gzip, or open .gz files. Shrink files by up to 90% in your browser. Nothing is uploaded.
- [Screenshot to Table Converter (OCR)](https://datautility.in/screenshot-to-data): Turn a screenshot or photo of a table into editable CSV, JSON, Parquet or Excel with free OCR. It runs in your browser and the image is never uploaded.
- [SQL INSERT Generator from CSV, JSON, Excel or Parquet](https://datautility.in/sql-generator): Generate CREATE TABLE and INSERT from CSV, JSON, Excel or Parquet for Snowflake, BigQuery, Databricks, Redshift, PostgreSQL and more, plus a dbt schema.yml.
- [Schema-Based Data Generator (JSON Schema)](https://datautility.in/schema-data-generator): Paste a CREATE TABLE statement and generate up to 500,000 rows of realistic test data that match every column. Free, and runs in your browser.
- [Mock Data Generator](https://datautility.in/mock-data-generator): Generate up to 500,000 rows of realistic fake data (names, emails, addresses, dates) and download as CSV, JSON, Parquet or Excel. Free, in your browser.
- [SQL Lineage Analyzer for a Folder of SQL Files](https://datautility.in/sql-lineage-analyzer): Upload a folder of SQL files or a dbt project and get table and column lineage across every file, a run order and impact analysis. Free, runs in your browser.
- [Cloud Storage Cost Calculator: AWS S3 vs Azure Blob](https://datautility.in/cloud-storage-cost-calculator): Compare Amazon S3 and Azure Blob Storage costs for your data: storage, requests, retrieval, egress and early-deletion fees, from official price lists. Free.
- [Data Profiler](https://datautility.in/data-profiler): Profile a dataset for free: column types, missing values, duplicates, distributions and outliers, with a shareable HTML report. Nothing is uploaded.
- [Data Comparison (CSV and Excel Diff)](https://datautility.in/data-comparison): Compare two CSV, Excel, JSON, Parquet or Avro files by a key column. See inserts, updates and deletes (CDC), cell by cell. Free, in your browser.
- [Chat with Your Data](https://datautility.in/chat-with-data): Ask questions about a CSV, Excel, JSON or Parquet file in plain English. Use your own free Gemini key. Your full file stays on your device.
- [Data Dictionary Generator](https://datautility.in/data-dictionary-generator): Upload a CSV, Excel, JSON or Parquet file and get a CREATE TABLE script with a description for every column, for 5 databases. Use your Gemini key.
- [Dataset README Generator](https://datautility.in/dataset-readme-generator): Upload a CSV, Excel, JSON or Parquet file and get a README.md that explains the data, with details for every column. Use your own Gemini key.
- [Free Data Lineage Tool: Transform Data and Download the Lineage](https://datautility.in/data-lineage): Free online data lineage tool: see every step applied to a file as a graph, then download a lineage report with a checksum. Runs in your browser, no upload.
- [API Response to Table: JSON API to CSV](https://datautility.in/api-response-to-table): Enter an API address and a token and get the JSON response as a clean table. Download CSV, Excel, JSON or Parquet. Free, and the token is never saved.
- [Merge or Split Files: CSV, JSON, Excel, Parquet](https://datautility.in/merge-or-split-files): Combine many CSV, JSON, Excel or Parquet files into one, or split one big file into many parts. Free, and your files stay in your browser.
- [Text to Table: Paste Text, Get a Table](https://datautility.in/text-to-table): Paste text from a web page, PDF, email or chat and get a clean table. Columns are detected for you. Download CSV, Excel, JSON or Parquet. Free.
- [JSON Table Editor: Edit Nested JSON as a Table](https://datautility.in/json-table-editor): Edit nested JSON as a tree or a spreadsheet-like table, then download JSON, CSV or Excel. Free, runs in your browser, nothing is uploaded.
- [SQL on Your Files: Query CSV, Excel and Parquet](https://datautility.in/sql-on-your-files): Run SQL on CSV, Excel, JSON and Parquet files in your browser with DuckDB. SELECT, JOIN, GROUP BY and more. Nothing to install or upload.
- [Synthetic Data Generator: Realistic Data From Your File](https://datautility.in/synthetic-data-generator): Free online synthetic data generator: learns from your CSV, Excel, JSON or Parquet file and makes new rows with the same patterns. No real row copied.
- [Data Transformation: Join, Trim, Concatenate](https://datautility.in/data-transformation): Join two CSV or Excel files on a key, then trim, filter, sort, calculate and group. Pick your steps and download the result. Free, in your browser.
- [Data Masking and Anonymization](https://datautility.in/data-masking): Find and hide personal data (emails, phones, names, card numbers) in CSV, JSON or Excel files before sharing. Runs in your browser; nothing is uploaded.

## Guides and topics

- [Blog and guides](https://datautility.in/blog)
- [dbt Project Visualizer and dbt Lineage Guides](https://datautility.in/guides/dbt)
- [Avro Guides and Free Avro Tools](https://datautility.in/guides/avro)
- [Snowflake, BigQuery, Databricks and dbt Tools](https://datautility.in/guides/snowflake-bigquery-dbt)
- [Export and Share Data Transformations as SQL, pandas and PySpark](https://datautility.in/guides/export-data-transformations-as-code)
- [Offline and Private Data Tools](https://datautility.in/guides/offline-data-tools)
- [Parquet Guides and Free Parquet Tools](https://datautility.in/guides/parquet)
- [CSV Guides and Free CSV Tools](https://datautility.in/guides/csv)
- [JSON Guides and Free JSON Tools](https://datautility.in/guides/json)
- [Excel Guides and Free Excel Tools](https://datautility.in/guides/excel)
- [Data Privacy Guides and Free Tools](https://datautility.in/guides/data-privacy)
- [Test Data Guides and Free Generators](https://datautility.in/guides/test-data)
- [Data Cleaning Guides and Free Tools](https://datautility.in/guides/data-cleaning)
- [AI Data Tools and Guides](https://datautility.in/guides/ai-data)
- [Extract Data from Screenshots and APIs](https://datautility.in/guides/extract-data)
- [Data Lineage and Audit Trail Guides](https://datautility.in/guides/data-lineage)
- [File Format Guides and Free Tools](https://datautility.in/guides/file-formats)
- [Free Data Tools for Marketing Lists](https://datautility.in/use-cases/marketing-lists)
- [Free Data Tools for Finance and Accounting Exports](https://datautility.in/use-cases/finance-exports)
- [Free Data Tools for Developers](https://datautility.in/use-cases/developers)
- [Free Data Tools for Data Analysts](https://datautility.in/use-cases/data-analysts)
- [Free Data Tools for Small Business](https://datautility.in/use-cases/small-business)
- [Data Tools for Quant Developers and Finance Teams](https://datautility.in/use-cases/quant-finance)
- [Test Data Tools for QA Engineers](https://datautility.in/use-cases/qa-engineers)
- [Free Data Tools for Data Engineers](https://datautility.in/use-cases/data-engineers)
- [Free Data Tools for Students and Educators](https://datautility.in/use-cases/students)

## Frequently asked questions

### Can I reuse a file I edited in another tool?
Yes. Files you download are kept under Recent files at the top of the left sidebar. Open the menu on a file and pick a tool, or choose it from the Recent files list above any tool input. The copy is stored in your browser only, up to 10 files of 100,000 rows each. Nothing is uploaded, and you can delete files at any time.

### Can Data Utility estimate my cloud storage bill?
Yes. The free Cloud Storage Cost Calculator compares Amazon S3 and Azure Blob Storage classes for your data size, growth, reads, writes, retrieval, egress and retention, using the providers' official list prices. It recommends the cheapest class that fits your access pattern, shows the cost at 2x, 5x and 10x growth, and exports a PDF, Excel or CSV report. It is an estimate, not a quote.

### How much data can I process?
It depends on your computer, because everything runs in your browser tab. As a guide: CSV: up to about 100 MB, roughly 500,000 rows. JSON: about 50 MB. Parquet: about 30 MB. Excel: about 20 MB. Data Comparison keeps two files in memory, so halve those numbers. The Data Generator and the Schema Data Generator create up to 500,000 rows at a time. Larger files may be slow or make the tab run out of memory. For anything over 100 MB, split the file first.

### Is it free?
Yes. Every tool is free, needs no sign-up and adds no watermark.

### Is my data uploaded anywhere?
No. Files are read and processed in your browser and never sent to a server. The site uses Google Analytics and PostHog to count visits and tool use (pages, which tool, which format), never file names or contents. The one exception is the AI tools (Chat with Data, Data Dictionary, Data README). They use your own Google Gemini API key and send a small summary (column names, statistics and, if you allow it, a few sample rows) to Google. Your full file is never sent.

### Which file formats are supported?
JSON, CSV, Parquet and Excel (.xlsx) for converting, profiling, masking and comparing. The formatter also handles XML and YAML.

### Why is a large file slow to open?
The whole file is read into memory and turned into rows before the tool can use it. Close other heavy tabs, or work with a smaller sample.

### Does Data Utility work offline?
Yes. Install it as an app from the sidebar, then click Make available offline once while you are connected. That stores the larger engines (SQL on files and OCR), and every tool then works without a network, including on air-gapped machines. Your files are never uploaded either way.

### Can I open or convert Avro files?
Yes. In the Format Converter choose Avro as the source to see the schema and records as a table and save them as CSV, JSON, Excel or Parquet, or choose Avro as the target to create an Avro file. Uncompressed and deflate files are supported. Every other tool opens and saves Avro too, so you can profile, compare, query, mask or merge an Avro file as you would a CSV.

### How long do Recent files stay?
Until you delete them or clear your browser data. The browser keeps up to 10 files of up to 100,000 rows each. Use "Save for other tools" to keep a result without downloading it.

More for machines: https://datautility.in/llms.txt (a short map) and https://datautility.in/llms-full.txt (the text of every page).
