FuzzyMatchUploading files
Add one file on each side of the matcher: drag it onto the upload box or click to choose it. Signed in, you can also click Import from Google Sheets once Google Sheets is connected on the app's Integrations page.
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.
Next
Matching & confidence scores explains how to pair columns and read the score.