Turn a raw CSV into a usable lead sheet
A CSV file is often the starting point for outreach, but it is rarely ready to use on its own. Columns may be incomplete, names may be duplicated, and the fields that matter for qualification may live in different places across rows. This workflow turns that raw file into a spreadsheet that can be reviewed row by row.
The first important decision is what to keep visible. Source columns should stay in the sheet so the team can tell where an email, domain, role, or company field came from. That makes it easier to trust the output and easier to fix a row if something looks off later.
- Import the CSV before deciding which rows are worth enrichment.
- Add only the enrichment columns you actually need.
- Keep review and export fields separate from source data.
Cockpit is most useful here when the list needs cleanup before anyone sends email, updates a CRM, or hands the rows to another system. You can enrich missing values, check the results, and filter the sheet down to the subset that is good enough for the next step. If a row is still uncertain, it can stay in the sheet for a second pass instead of being forced into the final export.
| Stage | What good looks like |
|---|---|
| Import | Rows land with the original CSV fields still visible. |
| Enrichment | Missing data is filled in separate, reviewable columns. |
| Review | Uncertain rows are easy to filter out or revisit. |
| Export | The handoff file contains only the fields the next tool needs. |
That simple pattern is what makes the workflow repeatable. Once you have a reliable mapping for one lead list, you can reuse the same structure for the next one without rebuilding the process from scratch.