Salesforce · Moving in
Move from Salesforce to a Parody
Export your records from Salesforce, import them into a Salesforce Parody with CSV files, check them, then switch over. You can move back the same way: Move back to Salesforce.
Before you start#
Salesforce's Data Export Service packs every object into a zip of CSV files, one per object, using API field names like StageName and record IDs for links. That suits a Parody import well: map each Id to ID and links like AccountId resolve on their own.
Who can do this
You need the Weekly Data Export permission (System Administrators have it). Enterprise, Performance, and Unlimited editions can export weekly; Professional and Developer, monthly.
What comes over
| In Salesforce | In your Parody |
|---|---|
| Accounts | Accounts |
| Contacts | Contacts |
| Leads | Leads |
| Opportunities | Opportunities |
| Cases | Cases |
| Products | Products |
| Campaigns | Campaigns |
| Tasks | Tasks |
What doesn't
- Flows, validation rules, page layouts, Apex, and permission sets.
- Reports and dashboards. Recreate them on the Parody's report screens.
- Files and attachments. The export can include them, but Parodies don't store files.
- Field history, Chatter, events, campaign members, quotes, and approvals. Quotes and campaign members can be added in the Parody after importing.
- Custom objects and fields without a Parody field.
- Anything the Salesforce Parody has no field for. Check the column tables below; columns without a match are left out.
1. Set up your Parody#
- Create a Salesforce Parody with at least these features, so every record type has a home: Accounts, Contacts, Leads, Opportunities, Cases, Products and price book, Campaigns, Tasks and events. See what's in the Salesforce Parody.
- New Parodies come with sample records. Open Import & export in your Parody, and under Start empty, delete them.
2. Export from Salesforce#
- In Setup, search Quick Find for Data Export.
- Choose Export Now, tick Include all data, and start the export.
- When the email arrives, download the zip files and unzip them.
Download within 48 hours
Salesforce deletes export files 48 hours after the email, not counting weekends, and you can only run a new export after a waiting period.
Files to use:
- Accounts:
Account.csv - Contacts:
Contact.csv - Leads:
Lead.csv - Opportunities:
Opportunity.csv - Cases:
Case.csv - Products:
Product2.csv, plusPricebookEntry.csvfor prices. - Campaigns:
Campaign.csv - Tasks:
Task.csv
3. Prepare the files#
You need one CSV per record type. Open each export in a spreadsheet app, make the changes below, and save it as CSV (UTF-8). Keep the header row.
Owners are user IDs. Add an Owner name column that looks up each OwnerId in User.csv, for example =XLOOKUP(H2, User!A:A, User!E:E) where column E holds Name.
Dates (2026-11-21), booleans (true/false), and amounts import as they are.
Keep the ID column
Map Salesforce's own ID to ID. Your Parody remembers it, so later files can link to the record by that ID, and importing a fresh export later updates records instead of duplicating them.
Accounts
| Salesforce column | Parody field |
|---|---|
Id | ID (match and link rows) |
Name | Name |
Website | Website |
Industry | Industry |
Type | Type |
AnnualRevenue | Annual revenue |
NumberOfEmployees | Employees |
BillingCity | City |
Owner name | Owner |
Contacts
| Salesforce column | Parody field |
|---|---|
Id | ID (match and link rows) |
AccountId | Account |
FirstName | First name |
LastName | Last name |
Title | Job title |
Email | |
Phone | Phone |
Owner name | Owner |
Leads
| Salesforce column | Parody field |
|---|---|
Id | ID (match and link rows) |
FirstName | First name |
LastName | Last name |
Company | Company |
Email | |
Phone | Phone |
Status | Status |
LeadSource | Lead source |
Rating | Rating |
Owner name | Owner |
Opportunities
| Salesforce column | Parody field |
|---|---|
Id | ID (match and link rows) |
AccountId | Account |
Name | Name |
Amount | Amount |
StageName | Stage |
CloseDate | Close date |
Probability | Probability |
NextStep | Next step |
Owner name | Owner |
Cases
| Salesforce column | Parody field |
|---|---|
Id | ID (match and link rows) |
AccountId | Account |
ContactId | Contact |
Subject | Subject |
Description | Description |
Status | Status |
Priority | Priority |
Origin | Origin |
Owner name | Owner |
Products
| Salesforce column | Parody field |
|---|---|
Id | ID (match and link rows) |
Name | Name |
ProductCode | Product code |
Family | Family |
UnitPrice | Price |
IsActive | Active |
Prices live on price book entries, not products. Look up each product's UnitPrice in PricebookEntry.csv by Product2Id, using the standard price book.
Campaigns
| Salesforce column | Parody field |
|---|---|
Id | ID (match and link rows) |
Name | Name |
Type | Type |
Status | Status |
StartDate | Start date |
EndDate | End date |
BudgetedCost | Budget |
Tasks
| Salesforce column | Parody field |
|---|---|
related_type | Related type |
WhatId (or WhoId) | Related |
Subject | Subject |
ActivityDate | Due date |
Status | Status |
Priority | Priority |
Owner name | Owner |
A task's WhatId points at an account, opportunity, or case, and WhoId at a contact or lead. Add a related_type column from the first three characters of the ID: 001 Account, 003 Contact, 006 Opportunity, 00Q Lead, 500 Case.
4. Import, in this order#
Import parents before the records that link to them, so links resolve:
- Accounts
- Contacts
- Leads
- Opportunities
- Cases
- Products
- Campaigns
- Tasks
For each file:
- In your Parody, open Import & export.
- Under Import, choose the record type and the CSV file.
- Check the column list. Columns named like the tables above are matched for you; pick a field for any that aren't, or leave them out.
- Select Import. If any row has a problem, nothing is written and you get a list of the problems by line number. Fix the file and import again, or tick Skip rows with problems.
Files can hold up to 5,000 rows and 4 MB. Split bigger exports and import the parts one after another. The full rules are in Import & export.
5. Check the result#
- Compare the counts on your Parody's overview with the row counts of your files.
- Open a few records of each type and check their links (the project on a task, the account on a contact).
- Open the boards and reports and check that records sit in the right columns.
6. Switch over#
- Pick a cutover time and ask your team to stop editing in Salesforce.
- Export again and import the new files. Rows with an ID you've imported before update those records; new rows are added.
- Share the Parody's address with your team, and keep Salesforce read-only until you're sure nothing is missing.
Troubleshooting#
| Message | What to do |
|---|---|
| No … named or with id "…" | The record it links to isn't in the Parody yet. Import that record type first, or check the name is spelled exactly the same. |
| "…" matches 2 … records | Several records share that name. Also map the column that links to their parent (the project or board), or use the ID instead of the name. |
| … is not a date we can read | Use YYYY-MM-DD. Day-first dates like 21/11/2026 aren't read, because 03/04/2026 would be ambiguous. |
| … is not a number | Remove words and units other than currency symbols, commas, and %. |
| The file has more than … rows | Split it into files of up to 5,000 rows. |
Sources
Checked against these pages on 2026-11-21. Vendors change their export and import tools often; if a step doesn't match what you see, their page wins.