Half the list twice
The file was loaded on two days.
Excel Online to Salesforce automation for teams whose lists begin in a workbook
Excel Online to Salesforce automation that upserts workbook rows as leads and contacts on an External ID, linked to the right account and campaign, never twice
Excel Online to Salesforce automation turns a list that starts in a workbook into clean CRM records without a duplicate. Salesforce can create or update a record in one request addressed by an External ID, its Collections request carries up to 200 records, and the Data Import Wizard treats every file as new. BoldBellows notes which worksheet and table the row sits in and the value in its key column, gives a late notice time to land and checks the order before it writes, then decides whether each row is a known contact or a new lead, upserts on the External ID, links the account and campaign, and logs a task for anything that needs a follow-up.
View Pricing
From $1,115, paid once. Upsert Salesforce leads from Excel Online.
The guarantees built into the Salesforce route
- Upsert, not insert an External ID updates what exists and creates only what does not
- Lead or contact existing people are matched before a lead is made
- Campaign linked each row joins the campaign it belongs to
- Inside the allowance requests are counted against the daily API limit
- Written handover The route, the controls and the repair steps arrive as a PDF
- A price you can plan around from $1,115 in a single payment, no seats and no usage fees
01 · the re-import problem
The Data Import Wizard treats every file as if nothing had ever been loaded
A conference list is built in a workbook by three people over a fortnight. It is loaded with the import wizard on the first day and again on the last, and half the contacts exist twice. Some are leads and some are contacts, a company is spelled two ways and becomes two accounts, and the campaign membership is added by a second import that only some people remember to run. Sales starts calling before anyone knows which record is right.
Leads and contacts for one person
Nothing checked which they were.
Two accounts for one company
The name was spelled two ways.
- Every event is written as it arrives
- The list is loaded by an import that remembers nothing
- Campaign membership needs a second, manual step
- Each write is keyed on an External ID field on the lead or contact filled from the row's email address, used for every upsert
- Rows are matched or created once, as they change
- Campaign membership is added in the same pass
02 · how it works
How a workbook row becomes a lead or contact that Salesforce already recognises
A change is admitted, identified, matched and written, always in that order.
- 01
Receive and qualify
The notification is authenticated, stamped with account, resource and time, then checked against the admission rule.
- 02
Detect, match, decide
Changed rows are found, each is looked up by address and External ID, and your rule decides between an existing contact and a new lead.
- 03
Upsert, link, log
The record is upserted on its External ID, linked to the account and added to the campaign, and a task is written where a follow-up is due.
Source and destination facts
Scripts are rationed
Running an Office Script is limited to 3 runs in 10 seconds and 1,600 a day, so scripts are kept for work that nothing else can do.
200 records, one request
Salesforce's Collections request can write up to 200 records at once and an upsert addressed by External ID creates or updates in the same step, so a changed list is handled in a few requests without creating duplicates.
If a reply is lost
The route reads Salesforce through an External ID field on the lead or contact filled from the row's email address, used for every upsert to learn whether the write landed, then acts on the answer.
03 · what ships in the build
Inside the route: what the Excel Online Salesforce build holds
Foundation sets the rules and the key. Operations does the writing. Assurance compares both sides over time.
Sync excel online with Salesforce, excel online to Salesforce error handling and excel online to Salesforce historical migration are all handled here. Related searches include excel online to Salesforce without Zapier, keep Salesforce updated from excel, Salesforce leads from excel table, excel online to Salesforce API integration, excel online to Salesforce Zapier alternative, excel online to Salesforce service, excel online to Salesforce workflow, excel online to Salesforce consultant, excel online to Salesforce integration, excel online Salesforce automation, excel online to Salesforce, excel online Salesforce integration, excel online to Salesforce implementation, excel online to Salesforce setup service, excel online to Salesforce duplicate prevention, connect excel online to Salesforce and import excel contacts into Salesforce.
Admission rule engine
Decides which Excel Online events may proceed and logs why the others were set aside.
FoundationStable identity ledger
Records the source key, the time of change and the Salesforce identifier for each sync, on the Excel Online to Salesforce route.
FoundationAllowlist mapper
Maps approved Excel Online fields to Salesforce fields one by one and rejects anything not on the list.
FoundationRecord and campaign builder
Maps each row to lead or contact fields, with account, owner and campaign membership from your rules.
OperationsExternal-ID matcher
Decides between create, update and leave alone by reading an External ID field on the lead or contact filled from the row's email address, used for every upsert.
OperationsLead-or-contact decider
Applies your matching order of address, domain and existing account before anything is created.
OperationsCRM register
Lines up Excel Online and Salesforce on a schedule and lists what no longer agrees.
AssuranceField and permission drift monitor
Spots a removed field, a changed picklist value or a narrowed profile before upserts start to be refused.
AssuranceOwner queue
Gives each unresolved Excel Online case a named owner, so nothing waits in a shared inbox.
Assurance04 · who it's for
Built for operations teams tracking orders and stock in shared tables, and for anyone who must get the people in a workbook list into Salesforce as leads or contacts, matched and tied to a campaign
The list is built in Excel Online. It has to live in Salesforce.
Event marketer
"The list changes every day."
Changed rows reach Salesforce within minutes, matched to the right record.
Revenue operations manager
"Stop the duplicate accounts."
Matching runs on address, domain and External ID first, and creation is the last resort.
Sales development lead
"Know which record is right."
One person is one record, so sales contacts the right lead once.
Campaign manager
"Members must be added automatically."
Each row joins its campaign in the same pass as the upsert.
Practice partner
"Clients must not share an org."
A client's workbook writes to that client's Salesforce org only.
Owner-manager
"I build the list in a sheet."
What I add to the sheet is in the CRM before the next outreach.
What drives the cost: objects, External IDs and lookups
What the Excel Online to Salesforce build costs, worked out live
From $1,115, with no monthly fee.
View Pricing
- One setup fee
- Range shown first
- PDF handover included
05 · compare your options
Three ways to connect Excel Online and Salesforce: the Data Import Wizard, a zap, or an External-ID upsert route
Each can load a list. Only one matches first and keeps loading as it changes.
| What sets it off | the Data Import Wizard | A standard Excel Online-Salesforce connector | The BoldBellows External-ID upsert route |
|---|---|---|---|
| What starts the work | A person spots the update | Every matching hook runs | Only a workbook change that meets the written rule |
| How identity is decided | Whoever it is checks the name | Email or name, compared as typed | An External ID on every lead and contact |
| What reaches Salesforce | Fields typed from memory | Every mapped field, as plain text | Matched or created once, with account, campaign and task |
| After an uncertain result | Someone checks by eye | Retry, or give up | Searches by an External ID field on the lead or contact filled from the row's email address, used for every upsert, compares, then repairs |
A late notice follows a newer update
The timestamp on the incoming event is checked first; a stale one is recorded and closed instead of rolling the lead or contact back.
A row has a company name spelled two different ways
The account is matched through domain and name rules you approve, or held for a person, so one company does not become two. The route looks for the lead or contact through an External ID field on the lead or contact filled from the row's email address, used for every upsert, compares it with the intended values and records a verdict: absent, correct, different or unclear. A new lead or contact is made only when the search proves there is none.
Start the Excel Online to Salesforce build with an External ID field on the lead or contact filled from the row's email address, used for every upsert; the rest of the route leans on it.
Pricing
Build your Excel Online to Salesforce price
Pick a package, answer three short questions about how Excel Online data should reach Salesforce, and your price and turnaround move as you choose.
06 · process & getting started
Six steps from a workbook list to clean CRM records
From the first brief to the first month live, six steps with clear outputs.
- Step 01
Decide who counts
We agree which tables and rows are prospects, which are colleagues or test entries, and which never go to Salesforce.
- Step 02
Approve access
Access is granted, tested and documented on both the Excel Online and Salesforce sides.
- Step 03
Map the objects
Lead and contact fields, the External ID, owners, campaigns and picklist values are agreed in writing before the build.
- Step 04
Break it on purpose
With Excel Online to Salesforce in place, we replay events, delay them, remove fields and revoke access in a safe Salesforce copy before anything goes live.
- Step 05
Launch with notes
Production begins at a boundary you have agreed, with a PDF covering the rules, owners and repair steps.
- Step 06
Review after launch
Once real events flow, the opening weeks are checked against the evidence log so early surprises are caught and recorded.
07 · turnaround
Delivery windows by package
With Excel Online to Salesforce in place, the schedule runs from the day access is granted.
Foundation
6 to 10 business days
Operations
10 to 16 business days
Assurance
16 to 24 business days
08 · before we start
What to gather before day one
A named Excel Online administrator who can approve the connection
Edit access to the workbook, and a Salesforce admin who can create an External ID field and a connected app
An authorised Excel Online connection for the resources named in scope
Your definition of which workbook changes should reach Salesforce
Permission to run tests against a copy of Salesforce
Your expected volume, so limits and pacing can be set
09 · security and ownership
Nothing is installed in Excel Online or Salesforce, only mapped data moves
Neither Excel Online nor Salesforce is modified.
Nothing installed inside either tool
The route talks to Excel Online and Salesforce only through documented endpoints, so neither needs a plugin, a patch or a hidden setting.
Scoped, revocable access
Credentials are limited to the agreed scope, and withdrawing them stops the route at once.
Only what the map allows
A written field map decides what crosses. Anything not on it, including private notes and billing data, is left behind.
Search before you write again
After any uncertain result the route looks for the lead or contact using an External ID field on the lead or contact filled from the row's email address, used for every upsert; only a proven absence allows a new one.
Minimal logging
Operational history is limited to IDs, timestamps and outcomes.
Full handover
You leave with the mapping, the settings and a plain-language guide.
10 · verified reviews
What BoldBellows clients say
Verified reviews from business owners who use BoldBellows automations every day, from marketing and sales to support and operations.
AI Data Entry & Reporting Automation
We used to spend hours collecting data and building weekly reports by hand. BoldBellows automated all of it.
The reports are clean, visual and easy to read, and our managers rely on them for quick decisions. Human error is gone and our numbers are more accurate across the board.
AI CRM Automation
Our CRM was barely used because updating it by hand was tedious. BoldBellows automated data entry, tagging, segmentation and follow-ups.
Now the CRM is always up to date and our campaigns are far more accurate. It improved our whole sales pipeline.
AI Accounting & Invoice Automation
BoldBellows automated our whole invoicing process: creating invoices, sending reminders and tracking payments.
Late payments dropped sharply, and our accounting team finally has time for strategy instead of repetitive admin. Worth every penny.
AI E-commerce Listings Automation
BoldBellows automated our product listings. The AI writes descriptions, organizes photos and publishes listings across several marketplaces.
It even answers customer questions instantly. Our store looks more professional and sales have noticeably increased.
AI Customer Journey Automation
We wanted a smoother path from first contact to purchase. BoldBellows built an AI system that guides each customer there automatically.
It sends personalized messages, recommends products and follows up at just the right moment. Customer retention has improved dramatically.
AI Document & Contract Automation
Onboarding was slow because we wrote every contract by hand. BoldBellows automated the lot: contracts, welcome emails and client setup.
What took 48 hours now takes under 10 minutes, and clients regularly tell us how professional it feels.
AI Social Comment & DM Automation
We get thousands of comments and messages every week. BoldBellows built an AI system that replies instantly, filters spam and surfaces the important ones.
Engagement is up and our page looks active around the clock. It’s like having a full social media team that never stops.
AI Voice Assistant
BoldBellows built a custom AI voice assistant for our customer hotline. It answers questions, books appointments and handles simple requests.
Customers love how fast it is, and our call-centre workload dropped dramatically. One of the smartest upgrades we’ve made.
AI Automation Partner
BoldBellows is hands-down the best AI automation partner we’ve worked with. Their systems are fast, reliable and built around how our business actually works.
Every automation they’ve delivered, from customer service to content, runs flawlessly. We’ve saved time, cut costs and grown faster than we expected.
AI Chatbot & Customer Support
BoldBellows built an AI support chatbot for our online boutique, and it has changed how we run the business. We used to have two full-time staff answering the same questions all day. Now the AI handles order tracking, product recommendations and even refund requests on its own.
What surprised me most is how natural it sounds. Customers compliment the ‘agent’ without realizing it’s AI. Our support workload dropped by 75% and customer satisfaction went up dramatically.
AI Content & Social Media Automation
Our marketing agency couldn’t keep up with content. BoldBellows set up an AI content engine that writes blog posts and captions and even designs our social media creatives.
It spots trends and suggests topics for us, so we stay ahead of competitors. We now produce three times the content with the same team, and engagement has soared. They didn’t just automate our workflow, they lifted our whole brand.
AI Lead Qualification & Sales Automation
Our sales team wasted hours chasing cold leads. BoldBellows built an AI lead-scoring system that reads behavior, email engagement and buying signals.
It filters out weak leads and sends personalized follow-ups automatically, so our team only talks to people who are ready to buy. Conversions rose 40% in the first month. It paid for itself straight away.
AI Video & Voice Automation
We publish product videos every week, and BoldBellows introduced us to AI video automation. The system writes the script, voices it and produces the finished video in minutes.
The quality is remarkable: professional voiceovers, clean visuals and smooth editing. Production time went from three days to under 30 minutes, and we scaled our video marketing without adding cost.
AI Email & Smart Inbox Management
Our inbox used to be chaos. BoldBellows built an AI email system that sorts messages, drafts replies and flags anything urgent.
It learns how we write and gets better every week. We reply faster and no longer miss important messages. It feels like having a personal assistant working around the clock.
AI Workflow Automation for Agencies
Running a digital agency with many clients was overwhelming. BoldBellows built one automation dashboard that tracks tasks, sends updates and creates client reports automatically.
Clients love the transparency and we love the time we get back. Productivity is up, and project delays have dropped to almost zero.
AI Booking & Scheduling Automation
Our coaching business needed a better way to schedule. BoldBellows automated all of it: bookings, reminders, cancellations and follow-ups.
No-shows fell by 60% and clients enjoy how smooth it is. It feels personal, not robotic. One of the best upgrades we’ve made.
AI Translation & Localisation
When we expanded abroad we needed fast, accurate translations. BoldBellows built an AI translation system that turns our content into several languages instantly.
The translations read naturally and suit each culture. We now serve customers in five new countries without hiring translators. BoldBellows helped us go global.
AI HR & Recruitment Automation
Our HR team was drowning in applications. BoldBellows automated screening, skills-based filtering and interview scheduling.
It saves us hours every week and means we only interview qualified people. Hiring is now faster, better organized and more professional.
11 · questions
Excel Online, Salesforce and your lists: what revenue operations leaders ask
These are the queries we hear most, with straight replies.
When is an Excel Online to Salesforce Zapier automation not enough?
When the list in the CRM, once is all that is wanted, a connector can manage that. It cannot choose lead or contact, avoid a duplicate or stay inside the daily API allowance. Those gaps are the reason this build exists.
How are duplicates avoided?
Every record carries an External ID, and the route matches on address and domain first. An upsert addressed by that ID updates the existing record instead of creating another.
How does it choose between a lead and a contact?
By the order you approve: a matching contact by address, then an account by domain, then a new lead. Anything ambiguous is held for a person.
How is campaign membership handled?
Each row can add its person to a campaign by a rule, such as a column value, in the same pass. A person already in the campaign is updated, not added twice.
Why not use the import wizard?
The wizard treats each file as new and cannot keep up with a list that changes daily. This route sends only changed rows and never loads the same row twice.
What about Salesforce's API limits?
Salesforce counts requests over 24 hours. The route batches related writes in Collections requests and keeps a running count, slowing down well before the allowance is reached.
Does Salesforce write back to the workbook?
Nothing is written back unless you set aside a column for the record ID and status. No other cell is changed.
What if my fields change after mapping in the Excel Online to Salesforce route?
Mapping is a standard step. Our Excel Online Salesforce field mapping service ends with a table you approve and a test that proves it.
Does it support our own routing rules in the Excel Online to Salesforce route?
Yes. We convert your conditions to a custom Excel Online workflow for Salesforce and explain each choice like an Excel Online Salesforce integration consultant would. From $1,115.
How do you handle breaking changes?
Upstream changes are caught at the point of use: the step pauses, the reason is recorded, and your owner is notified. Repair work is quoted outside the review window. It is also the answer to custom excel online to salesforce automation.
Get the workbook list into the CRM once, and keep it there
Give Salesforce records that arrive matched, in the right campaign
Bring one trigger, one destination and one person who owns exceptions, and we will build a route to automate Excel Online data to Salesforce around them. Foundation starts at $1,115.
Those are scoped and quoted separately.