+ Start a Discussion

Populate Account IDs in spreadsheet

I have been provided a spreadsheet that has a list of accounts without the corresponding Salesforce account record ID. What are my options for getting the IDs into the spreadsheet next to the appropriate account name? I need to do this to run some updates through the Apex Data Loader.


I assume the list of accounts is for updates and not for insert. Because in Insert you dont need any account id.

If the record count is relatively less, I would run a report against these accounts if there any similarity between them, get the account ids and manually append them in the csv. If there is no similarity betwwen all of them, then it is time consuming process. But there is no other go. You cannot update through data loader without id being mapped.

There are other ETL tools available in appexchange that help in auto mapping fields with existing records.

Sumit KumarSumit Kumar

Use VLOOKUP function in excel