**To export the contacts generated by an Extractor Run and import them into Papo's CRM (https://papo.global/), you download the Run's results as a CSV, review and standardize the spreadsheet, and then use the bulk contact import. This path lets you clean phone numbers, add tags, and avoid duplicate records before placing the leads in your sales funnel.**

## Flow summary

| Step | What to do | Result |
| :--- | :--- | :--- |
| 1. Download the Run | Open the Extractor results and export the generated contacts. | CSV file with the extracted leads. |
| 2. Clean up the spreadsheet | Review columns, standardize phone numbers, remove empty and duplicate rows. | Clean CSV ready for import. |
| 3. Import into the CRM | Upload the CSV in the contacts section and map the columns. | Leads available in Papo's CRM. |
| 4. Check for duplicates | Compare against the existing database before importing. | An organized database with no repeats. |

## Why export the Extractor Run to CSV

Papo's Extractor is a prospecting tool that finds new contacts from public databases, such as Brazilian CNPJs, Google Maps, and the web. The generated contacts are saved in your account, but exporting the results of a Run to CSV is useful for:

- Reviewing and standardizing the data outside the platform.
- Adding segmentation tags, such as niche, region, or funnel stage.
- Creating a backup of the extracted list.
- Checking for duplicates before importing into the CRM again.
- Adjusting custom fields or supplementing information with other spreadsheets.

The CSV format is compatible with Google Sheets, Microsoft Excel, and most spreadsheet editors.

## How to export the contacts from an Extractor Run

After running the Extractor, open the list of contacts generated by that Run. Papo lets you export segmented lists to CSV, so select only the contacts from the desired Run before downloading the file.

If you prefer, you can also use the CRM's contacts area, apply a filter to isolate the leads that came from that extraction, and export the selection. The generated file will contain the data of the selected contacts and can be opened in any spreadsheet.

## How to clean up the spreadsheet before importing

The quality of the import depends on how organized the file is. Before uploading the list, follow this checklist:

| Column | Example | Recommended handling |
| :--- | :--- | :--- |
| name | Maria Silva | No abbreviations; keep it consistent across rows. |
| email | maria.silva@email.com | Lowercase, with no extra spaces. |
| phone | 5511987654321 | Country code + area code + number, without parentheses, hyphens, or spaces. |
| tags | hot-lead, sp-event | Separate multiple tags with commas, with no space after the comma. |

In addition:

- Save the file in `.csv` format.
- The first row must contain the column headers, such as "name", "email", "phone", and "tags".
- Remove merged cells, blank rows in the middle of the data, and special formatting.
- Use spreadsheet tools to find and delete duplicate rows, especially by phone or email.
- Standardize all phone numbers with the country code and area code, for example `55119XXXXXXXX`.

## How to import the contacts into Papo's CRM

With the CSV cleaned up, run the bulk import:

1. Go to the Contacts section in Papo's CRM.
2. Find the option to import contacts.
3. Upload the prepared CSV file.
4. Map the file's columns to the corresponding fields in the CRM. For example, match the "name" column to the Name field and "phone" to the Phone field.
5. Review the mapping to make sure all the data, including custom fields, goes to the right places.
6. Start the import. The platform processes the file and adds the new contacts to your database.

## How to avoid duplicates

Before importing, export Papo's current contact database or apply a filter to see who already exists. In a spreadsheet, compare the phone and email columns with the Extractor CSV and remove the records that are already in the CRM. Doing this check before uploading is the safest way to keep your database clean.

If you already have many repeated contacts, you can use the spreadsheet itself to highlight duplicates by column and review them manually before sending the file.

## Who this flow is useful for

- SDRs and B2B hunters who use the Extractor to generate CNPJ lists and want to import leads with clean tags.
- Agencies and consultancies that need to segment contacts by niche or city before launching campaigns.
- Sales operations that centralize prospecting, CRM, and WhatsApp in Papo and need a database without duplicates.

## Frequently Asked Questions

### Do I need to export the Extractor Run, or can I import directly?
Exporting to CSV lets you review the data, standardize phone numbers, and avoid duplicates. Even if the contacts are already saved in the account, cleaning up the spreadsheet before importing helps keep the CRM organized.

### What file format is accepted for the import?
Papo uses the CSV format (Comma-Separated Values), which is compatible with Google Sheets and Microsoft Excel.

### How do I avoid duplicate contacts in the CRM?
Compare the Extractor CSV with an export of your current database, looking for repeated phone numbers and emails. Remove the existing records before importing.

### Can I use tags in the import?
Yes. Use the "tags" column to segment contacts right at import. Multiple tags can be separated by commas.

### Are the Extractor and the contact import the same thing?
No. The Extractor finds and generates new leads from sources such as CNPJ and Maps. The import is for adding lists you already have or that were previously cleaned up in CSV.

### Are the extracted contacts automatically saved in the CRM?
Yes, the contacts generated by the Extractor are saved in your account. Exporting to CSV lets you review, segment, and import them again with standardized data.

## Read also

- [How to migrate your conversations and contacts from another platform to Papo](/hc/papo/articles/migrate-conversations-contacts-from-another-platform-to-papo)
- [How to export report metrics to external spreadsheets](/hc/papo/articles/how-to-export-report-metrics-to-external-spreadsheets)

---
**[Create your free account and try the Extractor with the CRM →](https://papo.global/?utm_source=helpcenter&utm_medium=article&utm_campaign=export-extractor-contacts-to-csv-and-import-to-papo-crm&utm_content=en)**

The first Papo user pays R$ 0, with the web platform to extract contacts, clean up the CSV, and import into the CRM without a credit card.