• Skip to main content
Client Portal
(888) 391-4493
  • Salesforce Services
    Salesforce Managed Services

    Maximize your ROI and say goodbye to costly in-house Salesforce staffing with StarrData Team as a Service.

    Salesforce Administration

    Stop worrying about the day to day details of Salesforce and outsource to a 5-star certified Salesforce team.

    Salesforce Implementation

    We'll help you get up and running quickly - from simple implementations to fully customized instances.

    Salesforce Optimization

    Get the most out of your Salesforce investment by fine tuning your instance specifically for your needs.

  • Salesforce Clouds
    Salesforce Revenue Cloud
    Salesforce CPQ

    Deliver fast & accurate proposals that empowers your sales team and maximizes company revenue.

    Salesforce Products
    Sales Cloud

    Empower your sales team by leveraging best practices throughout the company.

    Experience Cloud

    Connect your customers, employees & partners with the power of Salesforce.

  • Who We Serve
  • Success Stories
  • Blog
  • About
    Guaranteed Customer Satisfaction

    A commitment to customer satisfaction doesn’t go far without a process for ensuring it. Learn how the StarrData Action Loop works to guarantee customer satisfaction, eliminating misunderstandings and scope creep.

    5-Star Certified Salesforce Partner

    Since 2009, StarrData has helped hundreds of companies leverage the power of Salesforce. We are a 5-star certified partner with an experienced team of consultants, solution architects, engineers, and administrators.

    Success Stories & Testimonials

    Read first-hand accounts of how StarrData solutions, customizations and ongoing support helped clients in multiple industries get more out of their Salesforce investment, enhancing productivity and customer satisfaction.

    Commitment to Equality

    At StarrData we believe that all humans are equal, and diversity is a strength. We are committed to providing equal employment opportunities and world-class service to anyone, regardless of sex, color, gender, religion, or sexual orientation.

  • Talk to an Expert

Our Salesforce Best Practice of the Week: Tips for Importing Salesforce Data

By Darren Starr
Linkedin
X (Twitter)
starrdata-logo

If you’re like most customers, you already have existing data when you become a salesforce.com customer. A key task in getting Salesforce CRM up and running is getting your data from its current location into Salesforce CRM.

The following tips for importing Salesforce data are best practices that we use to help our customers import their Salesforce data while keeping their records clean and avoiding duplicates.

CSV files cannot have any commas.

  • Do a “Find & Replace” to find commas and replace with nothing before importing or your data will end up in the wrong field.
  • CSV stands for Comma Separated Values so if a comma is in a cell, then the import will move everything after the comma to the next cell. Each comma shifts the data by one cell.

Remove all duplicates before importing data.

  • It is easier to remove duplicates from a spreadsheet than merging them in Salesforce.
  • The Import Wizards will attempt to merge duplicate accounts, contacts and leads but you will stand a better chance of a clean import if you clean them yourself
  • The Data Loader, or Excel Connector, will not attempt to merge any duplicates.

Click here to download our FREE Salesforce Best Practices Guide!

Compare data already in Salesforce before importing more.

  • Use the Excel Connector or Apex Data Loader and V-lookup to compare new records against existing records before importing. If you have under 10,000 records of the type you want to import, export matching information (like email, phone, company, name, etc. along with the Salesforce record ID. Then do a V-lookup from your import sheet to your exports to see if any return an ID as a match.
  • Consider using a third party app from the AppExchange if you regularly import records and you have too many for the above to be practical. Apps like RingLead or Dupe Blocker will check your list against your database before import and flag duplicates.

Do a small import first

  • Import 5-10 records first to make sure they uploaded as expected before importing all records.
  • Be sure to check that zip codes and phone numbers are formatted correctly and that the data is in the right fields
  • If they all look good, then you can do the main import – Be sure that the first imported records are removed from your main list before importing them or you may end up with duplicates.

CSV files do not save formatting

  • After formatting columns for Number, Date, or Zip Code, save the CSV but keep it open when importing or formatting (like leading zeros in zip codes) will be lost – Use Excel’s special formatting for zip codes and dates.
  • Date formatting is different for the import wizards and the Data Loader – For the import wizards, see article 97633 in Salesforce help. For the Data Loader, see articles 101977, 344999 and 105697 in Salesforce help. The Data Loader articles also cover time zone differences that you should be aware of.

Search before creating records manually.

  • A quick search will tell you if the contact or account already exists before creating it.

Use validation rules to maintain your data structure.

  • By using validation rules, you can enforce data formatting such as two letter states or three letter country codes.
  • Be sure to test your rules against all scenarios – If you create a rule that says a pick list cannot be changed, what happens if there are blank values in existing records? Be sure to let your users know when you create new rules so they know what to expect when you activate them.
  • Salesforce has a list of sample validation rules that you can use as a start or to get ideas from – Search for “Examples of Validation Rules” in Salesforce help for the help topic of the same name.

Use “Required Fields” where needed, but don’t over do it.

  • On certain objects, required fields may be necessary, such as Phone or Status fields but if you make every field required, records may not be created or false data may be entered.

Use reports to check data integrity on a regular basis.

  • Create reports for your different objects and include the fields that are most important to you. Sort by those columns to do a spot check on their utilization.
  • For Enterprise and above, you can use free apps from the AppExchange to tell you how complete records are or how much a field is used – Field Trip and % Complete are both free and will give you.


StarrData is a Salesforce Partner that helps companies deploy, simplify and support Salesforce.com. If you would like information on the services we offer call us at (888) 391-4493 x101.

 

Posted in CRM, Salesforce Best Practices, Salesforce.com
StarrData Logo

StarrData

3527 Mt. Diablo Blvd. #392
Lafayette, CA 94549

(888) 391-4493 x101

info@starrdata.com

Popular Links

  • Salesforce Implementation
  • Salesforce Managed Services
  • Salesforce Optimization
  • Salesforce Administration
  • Salesforce CPQ

Follow Us

Copyright© 2024 | Privacy Policy

Our Spring Sale Has Started

You can see how this popup was set up in our step-by-step guide: https://wppopupmaker.com/guides/auto-opening-announcement-popups/

Our Spring Sale Has Started

You can see how this popup was set up in our step-by-step guide: https://wppopupmaker.com/guides/auto-opening-announcement-popups/

Contact Us Today

To speak with someone right away, give us a call at (510) 984-3648.

  • This field is for validation purposes and should be left unchanged.