Preparing your files
Supported formats
| Format | Notes |
|---|---|
| CSV, TSV, TXT | Comma- or tab-separated. The first row must be column headers. |
| Excel (.xlsx) | The first sheet is used. Old .xls files aren't supported; save them as .xlsx or .csv. |
| JSON | An array of objects, e.g. [{"name": "Ada", "email": "ada@example.com"}]. |
Files can be up to 25 MB. The number of rows per file depends on your plan and is shown under the upload boxes; see Pricing for each plan's limits.
Your files are read in your browser
Files are opened in your browser. Only the rows are sent when you run a match, not the original file.
Tips for better matches
- Keep a header row. Rows above the headers, such as a report title, become data. Delete them first.
- Split combined columns when you can. A single Address column matches less reliably than separate street, city and postcode columns.
- Remove totals and blank rows. Summary rows at the bottom of a report will look like records. Fully blank rows are skipped.
- Duplicate headers are fine. If two columns share a name, the second becomes Name (2).
- Don't fix capitalisation. Differences in case and surrounding spaces are ignored when comparing.
Which file goes first?
Results list one line per row of the first file, so put the list you care about most first, for example your CRM. The second file is the list to search. A row in the second file can match more than one row in the first.