Note: All credit goes to Salesforce, I am just a developer who enjoy playing trailhead and try to make note to myself.
Importing DataTwo methods of importing data :
When to use Data Import wizard :
- Need to load less than 50000 records
- The objects that need to be imported is supported by wizard
- No need automation process
When to use Data Loader :
- Need to load 50000 to 5 Million records.
- The object is not supported by Data Import Wizard
- Want to schedule regular data loads
Useful tips for cleaning data using Excel
Two methods of exporting data
- Data export wizard - accessible through the Setup menu. It allows you to export data manually once every six days (for weekly export) or 28 days (for monthly export). You can also export data automatically, at weekly or monthly intervals.
- Data Loader -this is a client application that you must install separately. It can be operated either through the user interface or the command line. The latter option is useful if you want to automate the export process, or use APIs to integrate with another system.
Salesforce Trailhead link : Exporting Data