Synthetic Dataset from an Excel File

Turn an Excel file into a synthetic dataset with the same patterns and no real records. Choose how many rows and download CSV, Excel or Parquet. Free.

Quick answer: Load real data and get new rows that behave like it, without copying any real row.

Related: Synthetic Data Generator: Realistic Data From Your File · Generate Synthetic Data from a CSV · Privacy-Safe Test Data from Real Data · Excel Guides and Free Excel Tools

How to use the Synthetic Dataset from an Excel File

Load real data and get new rows that behave like it, without copying any real row.

The Synthetic Data Generator learns from your own file and makes new rows that behave like it. Number and date columns keep their range, spread and the way they move together, such as age and salary. Category columns keep their shares. Names, emails, phones and similar fields get new fake values, ids are renumbered, free text gets the same shape without the same words, and rare values are hidden. No real row is copied. It runs in your browser, and a table shows the real and the synthetic numbers side by side so you can check.

  1. Load your real file
  2. Check how each column will be made
  3. Generate and compare with the real data

Tips

Example

Input: sales.xlsx

Output: a synthetic sales dataset

Browse by topic

Who uses Data Utility

Frequently asked questions · Data format benchmark

Frequently asked questions

Can I use an Excel file?

Yes. Load the .xlsx file; the first sheet is read. CSV, JSON and Parquet files also work.

Do the columns still relate to each other?

Number and date columns keep their relationships, for example age and salary moving together. Category columns keep their shares.

How is the Synthetic Data Generator different from the Data Generator?

The Data Generator makes random rows from column types you choose, such as names, emails and dates, so the columns do not relate to each other. The Synthetic Data Generator learns from your own file and makes rows that match its ranges, shares and the way number columns move together, so the result looks like your real data. Use the Data Generator for quick fake data, and the Synthetic Data Generator when the data should behave like production.

Is synthetic data safe to share?

No real row is copied, names and emails are replaced, ids are renumbered and rare values are hidden. That lowers the risk a lot, but it is not a guarantee, so review it before you share it publicly.

Related pages

Topic guides

Guides