function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Large Data manipulation

I have a spreadsheet with 15k rows that I would like to bounce the data against Salesforce to get the Salesforce ID, what is the best way to accomplish this?  I know I can break it down into 1k rows and feed it into explorer but I am looking for an easier to manage process. How is everyone else accomplishing this?


No one else has had this issue?



Assuming you are using excel, you could

1. Export the complete data set from the object that you need to match on, include the Id field and at least the fields you will need to match against.


2 Use the VLOOKUP funtion in excel to match your records and assign the Salesforce Id.

If your dataset is very large you could also create a custom object with a lookup to the object that you are matching against and use the Import Wizard