Only 8 spots left$15 $2/seat/month for life for the next 8 founding teams.Claim your spot →

Free tool

Cold calling spreadsheet template (CSV)

This free cold calling spreadsheet template is a CSV file with eight columns (phone, first and last name, company, email, your own lead ID, notes and city) and three fictional sample rows. It opens in Excel, Google Sheets or Numbers, needs no sign-up, and its headers are the ones Rapidialer’s importer matches on its own, so a filled-in copy becomes a CSV call list without remapping. Only the phone column is required.

Updated · Reviewed by Jaffar Jawed

What columns are in the cold calling CSV template?

The template has 8 columns. Only phone is required; the rest fill in the contact card, and extra columns you add become custom fields (up to 20 per list).

Each column in the call-list template and what goes in it
ColumnWhat goes in it
phonerequiredOne number per row. E.164 (+12125550101) is safest; 10-digit US and Canadian numbers get +1 added, and a trailing extension (x45, ext. 45) is dropped. Also read from headers such as mobile, phone_number or tel, or any header with phone, mobile, cell or tel in it.
first_nameFirst name. Also read from headers such as first, given_name, name or full_name.
last_nameLast name. Also read from headers such as last, surname or family_name.
companyCompany or business name. Also read from headers such as organization, account or business.
emailEmail address. Also read from email_address or e-mail.
external_idYour own ID for the lead, such as a CRM ID. Also read from crm_id, lead_id or id.
notesShown in the Dialer as the contact’s last notes, and fills {{last_notes}} in talk tracks until notes from a call replace it.
cityAn example of a custom column: any other header becomes a field on the list (up to 20).

Sample rows

The three fictional sample rows in the template
phonefirst_namelast_namecompanyemailexternal_idnotescity
+12125550101MariaLopezExample Realtymaria@example.comA-1001Asked for a call after the holidaysNew York
+13125550102JamesCarterExample Insurancejames@example.comA-1002Referred by a current clientChicago
+14155550103PriyaShahExample Dentalpriya@example.comA-1003Met at the spring trade showSan Francisco

Download the CSV template

The sample rows use fictional 555-01 numbers, companies and example.com addresses. Replace them with your own leads, then import the file as a list.

Key takeaways

  • Only the phone column is required; the other seven columns are optional.
  • Rapidialer imports up to 5,000 rows and 10 MB per CSV file, with comma, semicolon, tab or pipe delimiters.
  • Any header the importer doesn’t recognize becomes a custom field on the list, up to 20 per list.
  • Ten-digit US and Canadian numbers get +1 on import; numbers from other countries need a + and their country code.

How do you turn the template into a call list?

  1. Download it and keep the headers

    Download the CSV and open it in your spreadsheet app. Leave the header row as it is: those names are what the importer matches, and a renamed header can end up as a custom field instead.

  2. Replace the sample rows

    Delete the three sample rows and add one person per row. Rapidialer dials one phone column per row, so a second number for the same person goes on its own row with the same name.

  3. Clean the phone column

    E.164, such as +12125550101, is safest. Ten-digit US and Canadian numbers also work, because the importer adds +1, but numbers from other countries need a + and their country code. In Excel, format the column as Text before you paste, or the + and any leading zeros are dropped.

  4. Save as CSV and import

    Save or download the sheet as CSV, open a list in Rapidialer and choose Import CSV on its Contacts tab. Before anything is saved, the preview shows how each column was matched and counts new leads, duplicates, bad numbers and Do Not Call matches.

Why does each column matter?

The phone column is the only one an import needs, and it does more than get dialed. Leads are matched on it across your organization, so one number is always one lead; each contact’s time zone for calling hours is worked out from it; and local presence uses its area code to pick a matching caller ID from your Twilio numbers. Write it in E.164, the format Rapidialer stores, and run a messy column through the E.164 phone number formatter first.

The first_name, last_name and company columns are what a rep sees when the call connects, and they fill the {{contact}} and {{company}} merge fields in talk tracks. email is stored with the lead and shown in the Dialer, for the prospect who asks you to send something. notes shows in the Dialer as the contact’s last notes and fills {{last_notes}} until notes from a call replace it, which carries context over from a list you worked somewhere else.

The external_id column holds your own ID for the lead, such as its record ID in your CRM or a row number in a master sheet. Rapidialer’s leads export includes this ID next to each lead’s stage, last outcome and call count, so results can be matched back to the source. city is an example of a custom column: other headers become fields on the list and appear with the contact in the Dialer. A city gives the rep something local to mention; it doesn’t set the contact’s time zone, which always comes from the phone number.

What columns should a cold calling spreadsheet have?

A cold calling spreadsheet needs a phone number, the person’s name and company, and one column of context the rep can use in the first ten seconds. This template has eight columns: phone (required), first_name, last_name, company, email, external_id, notes and city. Generic call-tracking sheets add columns for call date, outcome and follow-up date, because the spreadsheet is the whole system. With a dialer, those are logged for you on each call, so the sheet only needs to describe the lead.

The eight template columns and how Rapidialer reads them
HeaderRequiredWhat Rapidialer does with itAlso matched from
phoneYesDials it, matches the lead, sets time zone and local caller IDmobile, phone_number, tel, or any header containing phone, mobile, cell or tel
first_nameNoShows it on the call; fills {{contact}}firstname, first, given_name, full_name, name
last_nameNoShows it on the call; fills {{contact}}lastname, last, surname, family_name
companyNoShows it on the call; fills {{company}}organization, org, account, business_name, business
emailNoStores it with the leademail_address, e-mail
external_idNoKeeps your ID for matching exportscrm_id, lead_id, id
notesNoShows as last notes; fills {{last_notes}}last_notes
cityNoBecomes a custom field shown in the DialerAny other header works the same way

How do you fill in the template without breaking the import?

Fill in the template with one person per row, one number per cell and the header row unchanged. Most failed imports come from the phone column: Excel turns long numbers into scientific notation and drops a leading +, and extensions or two numbers in one cell can’t be dialed as written.

  • Format the phone column as Text in Excel before pasting, so +44… and 0044… survive.
  • Put extensions elsewhere: the importer strips a trailing extension such as x45 or ext. 45 from the number, so keep it in a notes or custom column if reps need it.
  • Give non-North American numbers a country code: a number starting with a single 0 is rejected with “Add the country code”, and a leading 00 is read as +.
  • Save as CSV, not XLSX: Rapidialer reads UTF-8, UTF-16 and Latin-1 text files, not workbooks.

What happens when you import the template into Rapidialer?

The preview checks the whole file before anything is saved. It shows how each column was matched, which you can change or leave out, and counts the rows that are new leads, duplicates within the file, numbers already on the list, invalid numbers and numbers on your internal Do Not Call list.

On import, a number that appears twice in the file is imported once, a number already on the list is skipped, and a number on your Do Not Call list is imported as closed, so it is never dialed from the list. Rows without a usable phone number are listed by line number with the reason. Then the list is ready for the power dialer, which calls one contact at a time and moves to the next after the rep logs an outcome and a five-second countdown, or rings 2 to 5 at once when parallel dialing is on.

Can you dial straight from Google Sheets or Excel?

You can’t dial live from Google Sheets or Excel with Rapidialer, but you can dial an exported copy. Rapidialer reads CSV files and doesn’t sync with Google Sheets or Excel, so you export a CSV, import it, and call from the list. Re-importing an updated file later skips the numbers already on the list and adds the new ones, which keeps a shared sheet as the place your team adds leads.

The steps for a Sheets workflow, including how to publish or download the sheet, are in power dialing a spreadsheet. If you want a dialer that runs inside Google Sheets itself, a Sheets add-on is the better fit; Rapidialer suits teams that want call outcomes, recordings and follow-ups kept with each lead instead of written back into cells.

When is a spreadsheet template not enough?

A spreadsheet template is not enough when the list itself is the problem or several reps share it. A template can’t tell you whether a number is on the national Do Not Call registry, and Rapidialer doesn’t scrub against it either: its Do Not Call list is your organization’s own. Scrub purchased or scraped lists before import; DNC scrubbing explains how.

A spreadsheet also stops working as a CRM once several reps share it, because two people can call the same lead and outcomes live in cells. That is when a dialer that logs every call earns its $15 per seat a month, and when the template becomes an import file rather than the system. The guide to building a cold calling list covers where the rows come from.

Cold calling CSV template: questions and answers

Is this cold calling spreadsheet template free?

Yes. Download the CSV with the button above; there is no sign-up or email gate. It opens in Excel, Google Sheets, Numbers or any text editor, and you can use it with any dialer or CRM that imports CSV files. Its headers happen to be the ones Rapidialer matches without remapping.

Which columns does Rapidialer require?

Only a phone column. Names, company, email and the rest are optional, and the import preview lets you change how any column is matched or leave extra columns out. If no header looks like a phone header, the importer uses the first column whose sample value looks like a phone number. Rows without a usable number are listed by line number instead of imported.

Can I add my own columns?

Yes. Add headers such as job_title, industry or best_time, and each becomes a custom field on the list, up to 20 per list, shown with the contact in the Dialer. One name behaves differently: a title column is read as the company when the file has no other company-like column, so call a job-title column job_title.

How does Rapidialer know each contact’s time zone?

From the phone number, when it maps to exactly one time zone, which for US and Canadian numbers usually means the area code. A time zone or city column is kept as a custom field but doesn’t change it. For numbers that could be in more than one zone, calling hours use the Fallback time zone set in Dialing settings; without one, such a contact is dialed only when every zone it may be in is inside the window.

How many rows can I import at once?

Up to 5,000 rows and 10 MB per CSV file. For a bigger list, split it into several files and import them into the same list one after another; numbers already on the list are skipped, so overlapping files don’t create duplicates. Every lead is matched on its number across your whole organization, so one number is always one lead.

Can I fill in the template in Google Sheets or Excel?

Yes. Edit it in either, then download or save it as CSV before you import, because Rapidialer reads CSV files, not XLSX workbooks. In Excel, set the phone column to Text before pasting so a leading + isn’t dropped. Importing an updated file again skips the numbers already on the list and adds only the new rows.

Start today

Import your list and make your first call today

Connect Twilio, upload a CSV and start dialing.