+ Start a Discussion
Sunil Kumar 545Sunil Kumar 545 

What's a good idea to load lots of Accounts into Salesforce when the CSV file has an address but not chopped to street/city/state?

Ashish DevAshish Dev
You can keep most of the part to Street field. In excel try to extract City and State and Country using excel formulas.
Abdul KhatriAbdul Khatri
Here are few ways you can use. All free.

Manual load
  • Data Loader
    • https://help.salesforce.com/articleView?id=data_loader.htm&type=5
  • Kingwaysoft (SSIS)
    • https://www.kingswaysoft.com/products/ssis-integration-toolkit-for-salesforce/download
  • Data Import Wizard
    • https://help.salesforce.com/articleView?id=data_import_wizard.htm&type=5
  • Bulk API
    • https://developer.salesforce.com/page/Bulk_API

Automation
  • Command Line Data Loader
    • https://developer.salesforce.com/docs/atlas.en-us.dataLoader.meta/dataLoader/using_the_command_line_interface.htm
  • Kingwaysoft (SSIS)
    • https://www.kingswaysoft.com/products/ssis-integration-toolkit-for-salesforce/download