You have a file. Maybe it’s a list of 800 alumni who attended reunion weekend and need an updated engagement score. Maybe it’s 2,000 phone numbers from a vendor append. Maybe it’s a donor file from a giving day platform that needs to land in CRM Advance before the thank-you letters go out Thursday.
Whatever the file is, the process looks roughly the same:
Every advancement team we’ve worked with has some version of this loop. It’s not a technology problem in the traditional sense — the CRM can accept bulk data. The problem is that there’s no guardrails between “I have a file” and “it’s in production,” so the entire process depends on human vigilance and institutional knowledge.
Import Studio is the guardrail layer.
Import Studio is a guided, template-driven import engine built into Corral Works. Instead of handing a raw file to a generic import tool and hoping the column mappings are right, you start with a pre-configured import template that already knows:
Think of it as the difference between handing someone a blank form and handing them a form that’s already filled in with the parts that don’t change — and that won’t let them submit until the parts that do change are correct.
Here’s what a data import looks like inside Import Studio:
When you open Import Studio, you’re greeted with a library of pre-built import templates — each one designed for a specific kind of data:
Contact Updates · Activity Loads · Gifts & Contributions · Prospect Lifecycle · Email Addresses · Phone Numbers · Affiliations · Awards & Ratings · Marketing Lists · Communication Preferences
…or create your own custom template
Think of these like pre-addressed envelopes. You don’t need to remember which columns map to which CRM fields — the template already knows. Just pick the one that matches your data and move on.
Upload an Excel workbook or CSV. Import Studio immediately validates the structure:
You see a preview of the first few rows so you can confirm you’re looking at the right data before anything touches CRM.
Before a single record is written, Import Studio runs every row through a validation pipeline and shows you a clear summary:
Pre-Import Review
Total rows 847 ✅ Passed validation 831 ❌ Failed validation 16 ⚠️ Potential duplicates 23 16 rows have issues:
- 9 rows are missing a required “Last Name”
- 4 rows have an invalid email format
- 3 rows have phone numbers longer than 15 digits
From here you can download the error report to fix issues in your source file, or proceed with the 831 valid rows and handle the rest later.
No guessing. No “let’s run it and see what fails.” You know exactly what will succeed and what won’t — before you commit.
Once you confirm, Import Studio processes rows in real time with a live progress indicator. If something goes wrong mid-import — a network hiccup, a CRM timeout — the engine pauses automatically and saves a checkpoint. You can resume later without reprocessing rows that already succeeded.
Importing: Contact Updates — 78% complete
- Processed: 651 of 831 rows
- Succeeded: 648
- Failed: 3
You can pause at any time and pick up where you left off — even from a different computer.
When the import finishes, you get a clear summary: how many rows succeeded, how many failed, and a downloadable error file with per-row explanations for anything that didn’t make it.
No ambiguity. No “I think it worked?” emails.
The magic isn’t in any single step — it’s in the fact that the template encodes your team’s decisions once, and every future import follows the same rules automatically.
| Without templates | With Import Studio |
|---|---|
| Each import is a bespoke project | Each import follows a known path |
| Validation depends on who’s running it | Validation is enforced by the template |
| Duplicates are caught after the fact | Duplicates are caught before the write |
| Only one person knows how to do it | Anyone with the template can run it |
| Errors surface days later | Errors surface before the import starts |
That last row is the important one. The most expensive data quality problems aren’t the ones you catch today — they’re the ones you catch six months from now, after a thousand thank-you letters went to the wrong address.
Import Studio is currently available in DLight, our desktop companion for Advance. It’s being migrated to Corral Works — our browser-based platform — which means:
The core engine is the same. The experience is getting better.
This is part one of a three-part series on Import Studio:
Import Studio is included in Corral Works. If your team is spending more than an hour on any single data import, reach out for a demo.