CRM & Salesforce

Why I reach for Salesforce Inspector before Data Loader

Data Loader makes sense when I know exactly what needs loading. Most spreadsheets land on my desk a step earlier. That’s where I reach for Inspector.

Michael SkinnerNovember 20263 min read
A magnifying glass highlights a teal tick beside one entry on an event attendance list.

“Here’s the sign-in sheet from last night. Can you mark everyone who came?”

It sounds like an import job. I’d start with an export. The sheet tells me who signed in. Salesforce can tell me which of those people already belong to the event campaign, what status they have and which records actually need changing.

That’s why Salesforce Inspector has taken over a lot of my everyday import and export work. The version I’d point admins to today is Salesforce Inspector Reloaded, a free, community-maintained browser extension. I can open it from the Salesforce record I’m looking at and follow the question through to an answer.

Forty names, 36 updates

Take a sign-in sheet with 40 names. In Inspector’s Data Export, I can run a SOQL query (Salesforce’s query language) for the members of that one campaign. I’d bring back the Campaign Member ID, name, email and current status, then copy the results into my working sheet. Salesforce Inspector reloaded

Suppose 36 people match and need their status changed. Two are already marked as attended. One email address belongs to two supporters, and one person turned up on the night without registering. I’ve now got 36 straightforward updates, two rows I can leave alone and two questions for the events team. I can deal with the confirmed matches while someone who was there checks the other names.

The two columns I paste back

When I prepare a spreadsheet for Inspector, I use Salesforce’s API field names as the column headings. For those 36 updates I only need Id and Status. The ID belongs to the Campaign Member, the record linking a supporter to this event. The status is Attended, assuming that’s the value the team uses for this campaign.

I keep the original statuses, choose Update on Campaign Member in Inspector’s Data Import, and paste the two columns straight from the sheet. With Data Loader, I’d save those rows as a CSV and open the file for import. Here, Inspector recognises the field names in the headers and I can check the mapping on screen. I check one confirmed row first, including any follow-up it triggers, then run the rest. Afterwards I can rerun the original query and see whether the right people are marked as attended.

That last check matters. If changing a status triggers a thank-you email, putting the old value back won’t recall it.

Sometimes the export is the whole job

I’ve used Inspector to trace a soft credit in Salesforce’s Nonprofit Success Pack. A fundraiser looking at a supporter’s record might reasonably ask, “Why are they getting credit for a donation someone else made?” From the donation, I can query its Opportunity Contact Roles and see whether the supporter has a role the charity uses for soft credit. Show All Data also lets me check fields I have permission to see even when they’re missing from the page layout.

For a question about one gift, that can be enough. The fundraiser gets an explanation, and nobody has to build a report for a question they might only ask once.

When I’d still open Data Loader

Inspector assumes you know your way around the data. Someone doing their first Contact import may find Salesforce’s Data Import Wizard easier because it walks them through matching columns. Inspector also needs Salesforce API access and an extension your organisation is happy to approve. Its support comes from the community.

For last night’s sign-in sheet, I’d open Inspector. If the same spreadsheet lands on the admin’s desk every Monday, I’d ask a different question. Could the team record attendance in Salesforce when people arrive?

Written by

Michael Skinner

Michael helps charities choose, connect and improve the technology they rely on, with particular experience across CRM, integrations, Salesforce and practical AI.