Share a Data Transformation With a Link

Build a data clean-up in your browser and share the steps with a link. It holds only your steps, never your data. Free, no sign-up, nothing uploaded.

Quick answer: Join files on a key, trim, concatenate, fix dates, filter and more, in the order you choose.

Related: Data Transformation: Join, Trim, Concatenate · Chart and Pivot Table Builder for CSV and Excel · Export Data Cleaning Steps as SQL, pandas or PySpark Code · Delete Columns from a CSV File · Export and Share Data Transformations as SQL, pandas and PySpark

How to use the Share a Data Transformation With a Link

Join files on a key, trim, concatenate, fix dates, filter and more, in the order you choose.

Data Transformation lets you reshape a file with a list of steps instead of formulas. Join two files on a key with an inner, left, right or full join, trim spaces, concatenate or split columns, change date formats, change case, find and replace, filter, sort, remove duplicates and fill empty cells. Add a calculated column, round numbers, extract numbers, emails or URLs from text, pad IDs with leading zeros, clean text, and group and summarize rows with count, sum, average, min or max. Export the whole recipe as runnable DuckDB SQL, pandas, PySpark or a dbt model, share the steps with a link that holds no data, or chart the result (bar, line, scatter, histogram) and build a pivot table. See the result straight away, then download it or send it to another tool. Every step is recorded in Data Lineage.

  1. Load a file (and a second one to join)
  2. Add the transformations you want
  3. Check the result and download

Tips

Example

Input: steps: trim, filter, join, calculate, group

Output: datautility.in/data-transformation#r=v2.i442RJJGI6KVYEGj…

Browse by topic

Who uses Data Utility

Frequently asked questions · Data format benchmark

Frequently asked questions

Which file types does it work with?

Any file Data Transformation can open: CSV, Excel, JSON or Parquet. The link holds only the steps, so it does not depend on the format. The other person can even use a different format with the same column names.

What does the share link contain?

Only your steps and their settings, including column names and any values you typed into a step. It never contains your data or file names.

Is the recipe stored on a server?

No. The link is created in your browser and holds the recipe itself, in the part after the # sign, which browsers do not send to any server.

What does the other person need?

The link and their own file. If their column names differ, a warning shows which steps to adjust. A recipe that joins needs their own second file.

Can I join two files or combine columns?

Yes. Data Transformation lets you join two CSV or Excel files on a key (inner, left, right or full), and trim spaces, concatenate columns, change case, find and replace, split, rename, filter, sort, remove duplicates and fill empty cells. You choose the steps, check the result and download it. Your files stay in your browser.

Which transformations are available?

Join with a second file (inner, left, right or full), trim spaces, concatenate columns, change date formats, change text case, find and replace, split a column, rename or remove columns, filter rows, remove duplicates, sort, fill empty cells, add a calculated column, round numbers, extract part of text (numbers, emails, URLs or a pattern), pad IDs with zeros, clean text (accents, hidden characters), group and summarize (count, sum, average, min, max) and keep the first or last rows. Steps run from top to bottom and you can reorder them. Export the recipe as DuckDB SQL, pandas, PySpark or dbt code.

Can I draw a chart or build a pivot table from my result?

Yes. In Data Transformation and in SQL on Your Files, open the chart and pivot builder under the result. Choose a bar, line, scatter or histogram chart, pick the columns, and download the chart as a PNG or SVG, or copy it as an image. The pivot table groups rows by one column and optionally columns by another, with totals, and downloads as CSV or Excel. Everything is drawn on your device and nothing is uploaded. Very large results are summarized or sampled, and the chart says so.

Can I share my transformation steps with someone?

Yes. Click Share recipe link to copy a link that holds your steps. Whoever opens it can load the steps, then use their own file. The link contains only the steps, which include column names and any values you typed into steps (for example a filter value), but never your data or file names. It is built in your browser and stored nowhere, so nothing is uploaded and we cannot see it. Share it only with people who may see those column names.

Can I export my transformations as code?

Yes. After you add and fill in your steps, open Export recipe as code under the result. Choose DuckDB SQL, Python (pandas), PySpark or a dbt model, then copy or download the code. It is a readable starting point: run it on a small sample first and adapt it for your own pipeline. The DuckDB SQL is checked against the real DuckDB engine for every step.

Can I change the date format of a column?

Yes. Add a Change date format step, pick the column and the new format, such as 2026-03-09, 09/03/2026 or March 9, 2026. It reads many layouts, Excel date numbers and unix timestamps, and can also give only the year, month, weekday or quarter. If 03/04/2026 is unclear, you choose day first or month first.

Is Data Transformation a VLOOKUP alternative?

For lookups between two files, yes. A join adds the matching columns from the second file to every row of the first, with no formulas. Keys are matched ignoring case and extra spaces.

Related pages

Topic guides

Guides