Sample CSV
Download Sample CSVThis sample file mirrors a small contact export with messy phone data. It is designed to show how the homepage tool keeps safe rows import-ready while separating risky rows into a needs-review file.
What this sample input includes
- Already valid international numbers
- Local-format numbers with country context
- Rows with no country context
- Extension text inside the phone cell
- Multiple phone numbers stored in one field
- Free-text notes mixed into the phone field
How to use it
- Download the sample CSV
- Upload it on the homepage tool
- Select Phone as the phone column
- Select Country as the optional country column
- Process the file and compare the cleaned and needs-review outputs using the same workflow shown on How It Works
Sample input preview
The input file keeps familiar contact-export columns such as name, company, phone, country, and email. Only the phone column is normalized. All other columns stay intact.
| First Name | Company | Phone | Country | Expected outcome |
|---|---|---|---|---|
| Ava | North Peak Labs | +1 415 555 0123 | US | Cleaned |
| Liam | Harbor Metrics | (415) 555-0198 | US | Cleaned |
| Sophia | Blue Oak Media | 555-0123 | (empty) | Needs review |
| Ethan | Atlas Freight | 555-0123 ext 4 | US | Needs review |
| Charlotte | Verity Systems | +1 415 555 0123, +1 415 555 9999 | US | Needs review |
Sample cleaned-output preview
The cleaned CSV is the file meant for import. It keeps the original columns, replaces the selected phone value with plain E.164 format, and appends status fields so you can audit the result if needed.
| First Name | Company | Phone | Country | phone_status | phone_reason |
|---|---|---|---|---|---|
| Ava | North Peak Labs | +14155550123 | US | valid | Already international |
| Liam | Harbor Metrics | +14155550198 | US | valid | Normalized to E.164 |
| Mia | Brightline Health | +442079460056 | United Kingdom | valid | Normalized to E.164 |
| Noah | Summit Ops | +442079460056 | United Kingdom | valid | Already international |
Sample needs-review preview
The needs-review CSV protects import quality by isolating rows that should not be auto-fixed. These rows keep the original columns and add reason fields so the problem is easy to understand before import.
| First Name | Company | Phone | Country | phone_status | phone_reason |
|---|---|---|---|---|---|
| Sophia | Blue Oak Media | 555-0123 | (empty) | needs-review | Ambiguous local number |
| Ethan | Atlas Freight | 555-0123 ext 4 | US | needs-review | Extension detected |
| Charlotte | Verity Systems | +1 415 555 0123, +1 415 555 9999 | US | needs-review | Multiple numbers in one cell |
| Benjamin | Pine Harbor Legal | call after 5pm: 415-555-0130 | US | needs-review | Extra text / notes in the cell |
Why some rows are intentionally not auto-fixed
This tool is designed to improve import quality, not to guess through risky data. Rows are sent to needs-review when auto-fixing them could create bad contact records or failed imports.
- Rows without enough country context stay out of the cleaned file
- Rows with extensions are separated instead of being silently rewritten
- Rows containing more than one phone number are not auto-picked
- Rows with note text inside the phone field are preserved for manual review
Review rows are separated to protect import quality and preserve trust in the cleaned output. For more edge cases, see the FAQ.
Ready to try it with your own file? Upload the sample first, then compare it to your real CSV.
Back to Tool