# How to Prepare Startup Data for Investor Due Diligence

> Clean, check and safely share customer and financial data with investors. A founder checklist using free browser tools: profile, reconcile, mask, export.

Page: https://datautility.in/blog/prepare-data-for-investor-due-diligence
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 · investor due diligence data, startup due diligence checklist, data room preparation, share data with investors safely, startup metrics data room, mask customer data before sharing, due diligence data cleaning

During due diligence, investors will ask for customer lists, revenue by month, cohort data and more. Messy files, numbers that do not reconcile and accidentally shared personal data are what slow a deal down. This checklist shows how to get the data ready with free tools that run on your own machine, so nothing is uploaded to a third party while you prepare it.

Open the tool: [Data Masking](https://datautility.in/data-masking)

## What investors usually ask for

- Revenue and customer counts by month.

- Customer or account lists, often with plan and start date.

- Churn and retention by cohort.

- Product usage or order data samples.

## 1. Get every file into a clean format

Convert spreadsheets and exports to consistent CSV or Excel with the [data transformation tool](https://datautility.in/data-transformation). Use the same column names and date formats across files.

## 2. Profile each file

Run the [data profiler](https://datautility.in/data-profiler). Fix blank required fields, duplicate IDs and strange outliers before an investor finds them.

## 3. Reconcile the numbers

Revenue in the billing export should match the figure in your financial statements. Use [SQL on your files](https://datautility.in/sql-on-your-files) to total each export and compare. When two versions of a file exist, [data comparison](https://datautility.in/data-comparison) lists exactly which rows differ.

## 4. Mask personal data

Most investors do not need customer emails or phone numbers at the start. Use [data masking](https://datautility.in/data-masking) to hide them, keeping the rest of the row useful. Review the result, because detection works by pattern and column name.

## 5. Share sample data safely

If you must show product data, use realistic generated rows from the [test data generator](https://datautility.in/test-data-generator) rather than real customer records.

## 6. Keep a short data note

Add a one-page note explaining each file: source, period, definitions (what counts as an active user) and known gaps. Clear definitions build more trust than perfect numbers.

## Honest limits

These tools prepare files; they do not certify accuracy. Have your accountant confirm financial figures, and take legal advice on what personal data you may share.

## How to use the Data Masking: step by step

1. Standardise formats across files.
2. Profile for blanks and duplicates.
3. Reconcile totals with SQL.
4. Mask personal columns and write a data note.

## When to use the Data Masking

- Data room preparation
- Reconciling revenue exports
- Masking customer lists before sharing
- Comparing two versions of a file

## Example

Input:

```
ada@example.com, +1 555 0100
```

Output:

```
a**@example.com, +1 *** ****
```

## Frequently asked questions

### What data do investors ask for in due diligence?
Typically revenue and customers by month, account lists, churn and retention by cohort, and usage samples.

### How do I share customer data with investors safely?
Share the least that answers the question. Mask emails, phones and names, and use aggregates where possible.

### Is my data uploaded when I mask it here?
No. Masking runs in your browser, so the file is not uploaded to our servers.

### Can these tools verify my financial numbers?
No. They help you check consistency between files, but an accountant should confirm financial figures.

Tip: Share the least data that answers the question. You can always send more later; you cannot take it back.

## Related tool pages

- [Test Data Masking](https://datautility.in/data-masking-for-testing): Test data masking in your browser: hide emails, phones, names and card numbers in a production export and keep formats and joins. Free, no upload.
- [GDPR Test Data Generator](https://datautility.in/gdpr-safe-test-data): GDPR test data without real people: generate synthetic rows that follow the patterns of your own file, in your browser. Not legal advice.
- [Mask Emails in a CSV File](https://datautility.in/mask-emails-in-csv): Hide email addresses and phone numbers in a CSV file before you share it. Detects personal columns for you. Free, in your browser.
- [Anonymize CSV Data](https://datautility.in/anonymize-csv-data): Anonymize a CSV before sharing it: hide names, emails, phones and card numbers with the method you choose. Free, in your browser.
- [Mask PII in Excel Files](https://datautility.in/mask-pii-in-excel): Find and hide personal data in an Excel file before you share it, such as emails, phone numbers and names. Free, in your browser.
- [Mask Phone Numbers in a CSV](https://datautility.in/mask-phone-numbers-in-csv): Hide phone numbers in a CSV, Excel or JSON file before you share it. Keep the country code or last digits, or replace with fake numbers. Runs in your browser.

## Also try

- [Startup analytics without a data engineer](https://datautility.in/blog/startup-analytics-without-a-data-engineer)
- [Mask emails, phones and PII](https://datautility.in/blog/data-masking-hide-emails-phones-pii)
- [Free data tools for startups](https://datautility.in/blog/data-tools-for-startups-free-no-signup)

## 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)
