Microsoft Excel + Pardot

Microsoft Excel + Pardot integrations

Add new Pardot prospects to a Microsoft Excel table effortlessly when added to a list

Automate your lead management process by connecting Pardot to Microsoft Excel. Every time a new prospect is added to Pardot, this automation swiftly creates a corresponding row in your designated Excel table. This effectively eliminates time-consuming data entry, allowing you more time to focus on nurturing your leads. A convenient and efficient solution, this process ensures smooth upkeep of your prospect list.

When this happens...
Prospect Added to ListTriggers when a Prospect is added to a list.
TriggerPolling
automatically do this!
Add Row to TableAdds a new row to the end of a specific table.
ActionWrite

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

More things you can do with Pardot and Microsoft Excel

Discover other triggers and actions you can use with Pardot and Microsoft Excel

New Form Submission
Triggers when a form is submitted.
Trigger
Polling
Try It
- List
  Required
Trigger
Polling
Try It
- List
  Required
- Prospect
  Required
Action
Write
- List
  Required
- Prospect
  Required
Action
Write
- Prospect
  Required
- Email Address
- First Name
- Last Name
- Salutation
- Campaign
- Address One
- Address Two
- City
- Zip
- State
- Territory
- Country
- Website
- Phone
- Fax
- Job Title
- Department
- Company
- Number of Employees
- Years in Business
- Industry
- Notes
- Comments
- Source
- Score
- Password
- Account
- Annual Revenue
- Do Not Email?
- Review Status
- Star Status
- Do Not Call?
Action
Write

- Email Address
  Required
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
Trigger
Polling
Try It

- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
Trigger
Polling
Try It
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Table
  Required
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- Column Index
  Required
- Apply To
- Header Preservation
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Title
  Required
- Column Headers
- Zap_step_id
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Row
  Required
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Lookup Column
  Required
- Lookup Value
  Required
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- Range
  Required
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet Name
  Required
- Column Headers
Action
Search or write

New Prospect
Triggers when a new Prospect is synced to Pardot.
Trigger
Polling
Try It
New or Updated Prospect
Triggers when a Prospect is created or updated in Pardot.
Trigger
Polling
Try It
- Email Address
  Required
- First Name
- Last Name
- Last Activity At
- Salutation
- Campaign
- Address One
- Address Two
- City
- Zip
- State
- Territory
- Country
- Website
- Phone
- Fax
- Job Title
- Department
- Company
- Number of Employees
- Years in Business
- Industry
- Notes
- Comments
- Source
- Score
- Password
- Account
- Annual Revenue
- Is Do Not Email
- Is Reviewed
- Is Starred
- Is Do Not Call
Action
Write
- Name
  Required
- Campaign
  Required
- Lists
  Required
- From Name
  Required
- From Email
  Required
- Subject Line
  Required
- Email Body (Text)
  Required
- Email Body (HTML)
- Tags
- Custom Reply-To Address
- Suppression Lists
- Scheduled Time
Action
Write
- Api_docs_info
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Email Address
  Required
- First Name
- Last Name
- Last Activity At
- Salutation
- Campaign
- Address One
- Address Two
- City
- Zip
- State
- Territory
- Country
- Website
- Phone
- Fax
- Job Title
- Department
- Company
- Number of Employees
- Years in Business
- Industry
- Notes
- Comments
- Source
- Score
- Password
- Account
- Annual Revenue
- Is Do Not Email
- Is Reviewed
- Is Starred
- Is Do Not Call
Action
Search or write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Table
  Required
Trigger
Polling
Try It
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Trigger Column
Trigger
Polling
Try It
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- Range
  Required
- Apply To
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- Row ID
  Required
- Apply To
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet Name
  Required
- Column Headers
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- New Name
  Required
Action
Write
- Api_docs_info
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet Name
  Required
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- Row ID
  Required
- No_match_copy
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Lookup Column
  Required
- Lookup Value
  Required
Action
Search or write

About Microsoft Excel

Microsoft's Excel is a spreadsheet application used by millions of users across the world. It is part of the Office ecosystem and is considered the industry standard for spreadsheets. Only files on OneDrive for Business (available with Office 365 and Sharepoint server) are supported at this time with Zapier.

Learn moreLearn moreHelpHelp

Related categories

Microsoft

Spreadsheets

Similar apps

OneDrive

File Management & Storage, Microsoft

Smartsheet

Spreadsheets

Quip

Documents

About Pardot

Pardot is no-hassle marketing automation that makes sales and marketing teams best friends. Increase marketing accountability, gain greater insight into ROI, and much more.

Learn moreLearn moreHelpHelp

Related categories

Marketing Automation

Premium

Similar apps

HubSpot

Marketing Automation

Intercom

Customer Support

Autopilot Journeys

Marketing Automation

Related Zap Templates

Create new Pardot prospects from new Microsoft Excel rows

Add new Pardot prospects to a list and create rows in Microsoft Excel