Our CSV and Excel file guide - importing prospects

If you wish to upload the database from a file, you can do it using a .csv, .xls or .xlsx extension.

CSV stands for Comma-separated value. CSV file format uses a comma as a field separator and a new line as a new data record. Woodpecker uses CSV files to import and export the data.

You can export your sheet to a CSV file from any web or desktop sheet editor.

Please make sure your Sheet program is configured to use UTF-8 coding. Some programs such as Microsoft Excel make it difficult to export a properly coded CSV file. For that reason, we advise using Google Sheets in the process.

How to create and import a CSV or Excel (XLSX, XLS) file?

1. Prepare your spreadsheet

You can use Google Sheets, Excel or Libre Office, for example. Woodpecker considers an email address as a unique contact ID, please include a single email address per row and one data entry per cell. Here are some of Woodpecker fields which you can find in the App: First Name, Country, City, Phone, Company, Email (required), Title, Last Name, Website, and snippets.

2. Download your sheet as CSV, XLSX or XLS file

In Google Sheets, click File → Download as → Microsoft Excel (.xlsx) or Comma-separated values.

An example of the exported CSV file:

Opening and saving the downloaded file through notepad may clear the text from diacritic signs such as ć, ż, ó. You might want to check if your program is configured to use UTF-8 coding.

3. Import your CSV or Excel file to Woodpecker

When your CSV, XLS or XLSX file is ready, you can import it to Woodpecker. You can add your contacts to the Prospects database or straight to your campaign. When adding prospects to the campaign, don't switch to the Prospects database!

Open your campaign, click "Add prospects" → "Import".

If you're editing a campaign, click PROSPECTS → "Import".

Then, click " Browse", select your file and hit the button "Upload and Import".

Map Woodpecker fields to those in your spreadsheet. Any unmapped fields won't be imported. If the first row contains column headers, check “Ignore the first row when importing”, right below. When this is done, don't forget to click “IMPORT”.

You can find additional information about how to import prospects in Woodpecker in our Quickstart guide - Step 4.

You're trying to import your prospects database to Woodpecker yet you're receiving an error? Download it and check the file. It will show you the wrongly matched fields. Make sure you didn't include the column "STATUS" with values like "Verified" or "Non-verified". As a status, you can use only statuses available in Woodpecker. Learn more about our statuses.

Sometimes you may want to add already existing prospects to a new campaign. Here's the detailed instruction on how to add duplicates.