# Free Data Tools for Data Engineers: Quick Checks Without Spinning Up a Pipeline

> Data engineers: convert CSV, JSON and Parquet, run SQL on files, generate test data and map dbt and SQL lineage in the browser. Free, no sign-up, no upload.

Page: https://datautility.in/blog/free-data-tools-for-data-engineers
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.

Published 2026-11-19 · Analyze & protect · data engineer free tools, data engineering tools free, csv to parquet online, parquet viewer online, sql on parquet in browser, dbt lineage free, test data for etl, data engineer browser tools

Data engineers have plenty of heavy tooling, but a lot of daily work is small: peek into a Parquet file, convert a vendor's CSV, check a schema, build test data, work out what a model feeds. Spinning up a pipeline or a notebook for those is overkill. This guide lists browser tools that handle the small jobs quickly and keep data on your machine.

Open the tool: [SQL Lineage Analyzer](https://datautility.in/sql-lineage-analyzer)

## Inspect and convert formats

Open and convert CSV, JSON, Excel, Parquet and more with the [data transformation tool](https://datautility.in/data-transformation). For the common analytics case, see [CSV to Parquet](https://datautility.in/blog/how-to-convert-csv-to-parquet), which also explains compression and types.

## Query a file with SQL

Skip the database for a quick look. [SQL on your files](https://datautility.in/sql-on-your-files) runs queries on CSV, JSON, Excel and Parquet in the browser, which suits row counts, distinct values and spot checks on a delivered file.

## Profile incoming data

Run vendor files through the [data profiler](https://datautility.in/data-profiler) before wiring them into a pipeline: null rates, duplicate keys and mixed types are better found now than in a failed job.

## Generate test data for ETL

The [test data generator](https://datautility.in/test-data-generator) produces linked tables with realistic values, with up to 500,000 rows and export to CSV, JSON or Parquet. Useful for testing a pipeline without production data; see [synthetic data for ETL testing](https://datautility.in/blog/synthetic-data-for-etl-testing).

## Understand and change SQL and dbt safely

Load a folder, ZIP or public GitHub link in the [SQL lineage analyzer](https://datautility.in/sql-lineage-analyzer). It reads the SQL text only, with no warehouse connection, and shows:

- Table-level and column-level lineage, including dbt `ref()` and `source()`.

- Missing models and sources, cycles and unused tables.

- What a change would break: edit a file and read the impact card.

- Where tagged personal data flows.

See [best free dbt lineage tools](https://datautility.in/blog/best-free-dbt-lineage-tools-for-data-engineers) for a comparison of options.

## Compare two outputs

After a refactor, compare old and new outputs by key with [data comparison](https://datautility.in/data-comparison) to confirm only the intended rows changed.

## Limits

These are for files and SQL text. They do not connect to live databases, do not schedule, and macros and Jinja are not expanded in lineage. Browser memory limits file size. Keep your orchestrator and warehouse for production.

## How to use the SQL Lineage Analyzer: step by step

1. Open the delivered file.
2. Profile and query it.
3. Convert it to the format you need.
4. Map and check SQL changes with lineage.

## When to use the SQL Lineage Analyzer

- Inspecting and converting delivered files
- Spot-checking Parquet with SQL
- Generating ETL test data
- Lineage and impact analysis for dbt

## Example

Input:

```
models/ folder: raw schema, staging views, marts, reports (7 .sql files)
```

Output:

```
A graph of 10 tables and views, 40 column links and the order to run the files
```

## Frequently asked questions

### What free tools can a data engineer use in the browser?
Format conversion, SQL on CSV, JSON, Excel and Parquet files, data profiling, test data generation and SQL and dbt lineage all run in the browser with no sign-up.

### Can I query a Parquet file without installing anything?
Yes. SQL on your files runs queries on Parquet in the browser.

### Does the lineage tool need a warehouse connection?
No. It reads the SQL text of your files, so it needs no connection or dbt run.

### Does it expand dbt macros?
No. ref() and source() are resolved, but macros and Jinja logic are not expanded.

Tip: Use the lineage impact card before opening a pull request and paste its summary into the description. Reviewers will thank you.

## Related tool pages

- [dbt Lineage Viewer for Your SQL Models](https://datautility.in/dbt-lineage-viewer): Drop your dbt models folder and see the lineage graph from sources through staging to marts, with column links. No dbt run, no warehouse. Free, private.
- [SQL Column Lineage Tool](https://datautility.in/sql-column-lineage-tool): See which source columns build every column of a view or table across many SQL files. Trace to the raw table or forward to dependants. Free, in your browser.
- [SQL File Dependency Analyzer](https://datautility.in/sql-file-dependency-analyzer): Find out which SQL file must run before which, from the tables each file creates and reads. Get a run order, circular dependencies and tables nothing uses.
- [SQL Impact Analysis: What Breaks If a Table Changes](https://datautility.in/sql-impact-analysis): Pick a table and see everything downstream that depends on it, and every upstream source it is built from. Works across a whole folder of SQL files, free.
- [SQL File Lineage Tool](https://datautility.in/sql-file-lineage): Free SQL file lineage tool: drop a folder of .sql files and see which file feeds which table, column by column. Nothing is uploaded.
- [SQL Query Visualizer](https://datautility.in/sql-query-visualizer): Free SQL query visualizer: paste a query or drop SQL files and see tables, joins and columns as a clear diagram. Runs in your browser, no upload.

## Also try

- [Free data profiling tool for data analysts](https://datautility.in/blog/free-data-profiling-tool-for-data-analysts)
- [Free data tools for business analysts](https://datautility.in/blog/free-data-tools-for-business-analysts)
- [Free data tools for product analysts](https://datautility.in/blog/free-data-tools-for-product-analysts)
- [Why lineage matters for data engineers](https://datautility.in/blog/why-data-lineage-matters-for-data-engineers)

## More guides

- [Data Profiler: Check Data Quality Before You Use It](https://datautility.in/blog/data-profiler-check-data-quality)
- [Compare Two CSV or Excel Files: Find Added, Removed and Changed Rows](https://datautility.in/blog/compare-two-csv-files-find-differences)
- [Data Masking: Hide Emails, Phones and Names Before Sharing](https://datautility.in/blog/data-masking-hide-emails-phones-pii)
