6.1 Data Import Wizard, Data Loader, Export, and Backup

Salesforce Admin Study Guide Exam

Track your progress as you read

Finished sections get a check mark.

1 Chapter 1: Platform Administrator Orientation and Official Source Control

1.1 Credential Name, Current Outline, and Search Language 1.2 Exam Format, Fee, Score, and Reference Rules 1.3 Trailhead, Trailhead Academy, and Pearson VUE Delivery Workflow 1.4 Domain Weights, Agentforce, and Study Prioritization 1.5 Maintenance Modules, Credential Ethics, and Exam Security 1.6 Developer Edition, Trailhead Playground, and Practice Bank Workflow

2 Chapter 2: Configuration, Setup, User Management, and Org Controls

2.1 Company Information, Fiscal Year, Business Hours, and Locale 2.2 User Records, Licenses, Profiles, Permission Sets, and Login Access 2.3 Login Security, Session Settings, and Identity Basics 2.4 Setup Navigation, Release Readiness, and Change Control 2.5 UI Settings, Home Pages, Apps, and Navigation 2.6 Configuration and Setup Case Lab

3 Chapter 3: Security, Access, Identity, and Sharing Model

3.1 Org-Wide Defaults, Roles, Sharing Rules, and Teams 3.2 Profiles, Permission Sets, Permission Set Groups, and Muting 3.3 Field-Level Security, Page Layouts, and Dynamic Forms 3.4 Record Access Troubleshooting and Login-As Workflow 3.5 Identity, Login History, MFA, and Session Risk 3.6 Data Visibility, Reporting, and Analytics Security 3.7 Security and Access Case Lab

4 Chapter 4: Object Manager, Lightning App Builder, and Data Modeling

4.1 Standard Objects, Custom Objects, and Schema Fit 4.2 Fields, Formulas, Rollups, Validation, and Requiredness 4.3 Lookup, Master-Detail, and Junction Relationships 4.4 Record Types, Business Processes, Page Layouts, and Lightning Pages 4.5 Dynamic Forms, Dynamic Actions, and User Experience 4.6 Schema Change Risk, Data Quality, and Deployment Readiness 4.7 Object Modeling Case Lab

5 Chapter 5: Sales, Marketing, Service, and Support Applications

5.1 Lead, Campaign, Account, Contact, and Opportunity Flow 5.2 Sales Processes, Path, Products, Price Books, and Forecasting 5.3 Case Management, Queues, Assignment, Auto-Response, and Escalation 5.4 Knowledge, Entitlements, Service Console, and Support Productivity 5.5 Sales-Service Data Quality and Automation Boundaries 5.6 Application Configuration Troubleshooting 5.7 Sales and Service Applications Case Lab

6 Chapter 6: Data and Analytics Management

6.1 Data Import Wizard, Data Loader, Export, and Backup 6.2 Duplicate Management, Validation, and Data Quality Controls 6.3 Data Transfer, Ownership, Mass Update, and Mass Delete 6.4 Report Types, Filters, Summary Formulas, and Buckets 6.5 Dashboards, Components, Subscriptions, and Sharing Impact 6.6 Analytics Security, Visibility, and Executive Reporting 6.7 Data and Analytics Case Lab

7 Chapter 7: Automation, Flow, Approval, and Operational Processes

7.1 Automation Tool Selection and Order of Execution 7.2 Flow Builder: Screen, Record-Triggered, Scheduled, and Autolaunched Flows 7.3 Approval Processes, Email Alerts, and Notification Patterns 7.4 Validation Rules, Assignment Rules, and Escalation Rules 7.5 Automation Testing, Debugging, and Governance 7.6 Automation Performance, Recursion, and Maintainability 7.7 Automation Case Lab

8 Chapter 8: Productivity, Collaboration, Mobile, and AppExchange

8.1 Activities, Tasks, Events, Calendar, and Email Productivity 8.2 Chatter, Feeds, Groups, Notifications, and Collaboration Governance 8.3 Salesforce Mobile Navigation, Actions, and Page Design 8.4 List Views, Kanban, Path, and User Adoption Tools 8.5 AppExchange Evaluation, Installation, Permissions, and Risk 8.6 Productivity and Collaboration Case Lab

9 Chapter 9: Agentforce for Platform Administrators

9.1 Agentforce Use Cases, Admin Boundaries, and Fit 9.2 Trusted AI, Security, Data Access, and Permission Implications 9.3 Agent Builder, Prompt Builder, and Grounding Concepts 9.4 Testing, Deployment, Monitoring, and Feedback Workflows 9.5 Agentforce Service, Sales, and Internal Productivity Scenarios 9.6 Agentforce Risk, Troubleshooting, and Governance 9.7 Agentforce Case Lab

10 Chapter 10: Integrated Salesforce Admin Scenario Labs

10.1 New Sales Org Setup Integrated Lab 10.2 Service Team Case Management Integrated Lab 10.3 Data Quality and Analytics Integrated Lab 10.4 Security, Access, and Reporting Integrated Lab 10.5 Flow Automation and Change Control Integrated Lab 10.6 Agentforce and Adoption Integrated Lab 10.7 Full Admin Simulation Strategy

11 Chapter 11: Final Review, Maintenance, and Test-Day Strategy

11.1 Final 30-Day Salesforce Admin Review Plan 11.2 Trailhead Playground Hands-On Drill Plan 11.3 105-Minute Exam Timing, Flagging, and Review Workflow 11.4 Test-Day Checklist: Online or Test Center 11.5 Post-Exam Maintenance Modules and Next Certifications 11.6 Salesforce Admin Final Mixed Review

6.1 Data Import Wizard, Data Loader, Export, and Backup

Key Takeaways Explain This Topic AI

Choose Data Import Wizard for guided, smaller imports and Data Loader for larger, repeatable, or delete-capable jobs.

A safe data load plan starts with source cleanup, ID strategy, field mapping, automation impact review, and a rollback export.

Data Export and Data Loader exports support backup and audit work, but an export file is not the same as a tested restore plan.

External IDs, record IDs, validation rules, duplicate rules, and sharing side effects determine whether an import succeeds cleanly.

Last updated: May 2026

Choosing the right data tool

Data and Analytics Management is the largest current Platform Administrator domain, so treat data movement as an operational control problem rather than a button-clicking topic. The admin must protect trust in the org while still helping business teams move quickly. A sales operations user may only ask to upload a spreadsheet, but the real admin question is broader: which object is affected, how many records are changing, what fields are required, which automations fire, how duplicate rules behave, and how the team will reverse the change if the load is wrong.

The Data Import Wizard is the guided, browser-based option. It is appropriate when the import is supported by the wizard, the record volume is within the wizard range, and the admin wants a safer mapping experience for accounts, contacts, leads, campaign members, person accounts where enabled, or custom objects. It can help avoid duplicates by using available matching choices during import. It is not the right tool for every object, very large files, complex updates, scheduled jobs, or delete operations.

Data Loader is the administrator workhorse for larger and more technical jobs. It supports insert, update, upsert, delete, hard delete where permitted, export, and export all. It can use record IDs or external IDs, save mapping files, run through the user interface, and support command-line automation in environments where that is approved. Because Data Loader can change many records quickly, the admin should use it with a tested file, explicit permissions, and a clear backup.

Need Better fit Admin judgment

Guided import of a supported object from a CSV Data Import Wizard Use when the data set is modest and the wizard supports the object and action.

Insert or update a large file Data Loader Prepare IDs, mappings, validation handling, and batch settings.

Upsert records from another system Data Loader with External ID Match on a stable external key instead of relying on names.

Delete records in bulk Data Loader or Mass Delete tools Export first and confirm Recycle Bin or hard delete behavior.

Export records for review Data Loader Export or reports Export All includes records in the Recycle Bin and archived activities when available.

Scheduled org-wide backup file Setup Data Export Treat it as one part of a broader backup and restore plan.

Setup paths matter in practice. Data Import Wizard is reached from Setup > Data Import Wizard . Data Export is reached from Setup > Data Export , where an admin can request an export or schedule recurring exports if the org edition and settings allow it. Data Loader is installed locally or launched through the supported Salesforce distribution, and it requires API-enabled access. Users also need object and field permissions for the work they are doing.

Safe import and backup workflow

A realistic import starts before Salesforce. Profile the spreadsheet first. Look for blank required fields, inconsistent picklist values, state and country formatting, duplicate names, phone number patterns, invalid email addresses, date formats, currency columns, owner names that do not match Salesforce users, and lookup references that need IDs. If the source file cannot identify existing Salesforce records reliably, pause and build a matching strategy. Updating by name alone is risky when two accounts share similar names.

Use a small test file in a sandbox or Trailhead Playground whenever the change has meaningful risk. The test should include clean rows, bad rows, duplicates, missing lookups, picklist edge cases, and records owned by different users. The goal is not only to prove that successful rows load. The goal is to see how failed rows are reported and whether validation rules, flows, triggers, duplicate rules, assignment rules, and required fields behave as expected.

Recommended workflow:

Define the business outcome, affected objects, record count, and required timing.

Export the target records before changes, including Salesforce record IDs and important lookup fields.

Clean and normalize the source file, then freeze the version that will be loaded.

Decide whether the action is insert, update, upsert, delete, or export.

Map every CSV column to a Salesforce field and remove columns that should not change.

Test with a small file and review success and error files row by row.

Run the production load during an approved window and monitor automation, errors, and user impact.

Save the original file, mapping, success file, error file, and rollback notes.

External IDs are important in integrations and migrations. An External ID field stores a key from another system, such as an ERP customer number. With Data Loader upsert, Salesforce can update a matching record when the external ID already exists or insert a new record when it does not. This avoids fragile name matching and reduces duplicate risk. The external ID field should be unique when the business process requires one source record to match one Salesforce record.

Exports are not just for migration. An admin may export data before a bulk owner change, before a deduplication cleanup, after a release that changed automation, or as part of a scheduled data retention process. Data Export produces compressed files that can include data, attachments, files, and related content depending on options. It does not automatically prove that the organization can restore quickly. A mature admin documents who downloads export files, where they are stored, how long they are retained, and how sensitive data is protected outside Salesforce.

Study trap: do not choose the biggest tool just because the job sounds important. A marketing coordinator importing 2,000 campaign members may be better served by a guided wizard or campaign member import flow. A system administrator updating 300,000 contacts with an external system key likely needs Data Loader. A compliance team asking for a periodic copy of all data needs Data Export or a backup product, plus retention and access controls. The right answer is the tool that fits object support, volume, operation, repeatability, and risk.