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 SalesforceIn your Parody
AccountsAccounts
ContactsContacts
LeadsLeads
OpportunitiesOpportunities
CasesCases
ProductsProducts
CampaignsCampaigns
TasksTasks

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#

  1. 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.
  2. New Parodies come with sample records. Open Import & export in your Parody, and under Start empty, delete them.

2. Export from Salesforce#

  1. In Setup, search Quick Find for Data Export.
  2. Choose Export Now, tick Include all data, and start the export.
  3. 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, plus PricebookEntry.csv for 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 columnParody field
IdID (match and link rows)
NameName
WebsiteWebsite
IndustryIndustry
TypeType
AnnualRevenueAnnual revenue
NumberOfEmployeesEmployees
BillingCityCity
Owner nameOwner

Contacts

Salesforce columnParody field
IdID (match and link rows)
AccountIdAccount
FirstNameFirst name
LastNameLast name
TitleJob title
EmailEmail
PhonePhone
Owner nameOwner

Leads

Salesforce columnParody field
IdID (match and link rows)
FirstNameFirst name
LastNameLast name
CompanyCompany
EmailEmail
PhonePhone
StatusStatus
LeadSourceLead source
RatingRating
Owner nameOwner

Opportunities

Salesforce columnParody field
IdID (match and link rows)
AccountIdAccount
NameName
AmountAmount
StageNameStage
CloseDateClose date
ProbabilityProbability
NextStepNext step
Owner nameOwner

Cases

Salesforce columnParody field
IdID (match and link rows)
AccountIdAccount
ContactIdContact
SubjectSubject
DescriptionDescription
StatusStatus
PriorityPriority
OriginOrigin
Owner nameOwner

Products

Salesforce columnParody field
IdID (match and link rows)
NameName
ProductCodeProduct code
FamilyFamily
UnitPricePrice
IsActiveActive

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 columnParody field
IdID (match and link rows)
NameName
TypeType
StatusStatus
StartDateStart date
EndDateEnd date
BudgetedCostBudget

Tasks

Salesforce columnParody field
related_typeRelated type
WhatId (or WhoId)Related
SubjectSubject
ActivityDateDue date
StatusStatus
PriorityPriority
Owner nameOwner

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:

  1. Accounts
  2. Contacts
  3. Leads
  4. Opportunities
  5. Cases
  6. Products
  7. Campaigns
  8. Tasks

For each file:

  1. In your Parody, open Import & export.
  2. Under Import, choose the record type and the CSV file.
  3. 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.
  4. 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#

  1. Pick a cutover time and ask your team to stop editing in Salesforce.
  2. Export again and import the new files. Rows with an ID you've imported before update those records; new rows are added.
  3. Share the Parody's address with your team, and keep Salesforce read-only until you're sure nothing is missing.

Troubleshooting#

MessageWhat 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 … recordsSeveral 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 readUse YYYY-MM-DD. Day-first dates like 21/11/2026 aren't read, because 03/04/2026 would be ambiguous.
… is not a numberRemove words and units other than currency symbols, commas, and %.
The file has more than … rowsSplit 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.