+ Start a Discussion
cl0s3rcl0s3r 

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 force.com explorer but I am looking for an easier to manage process. How is everyone else accomplishing this?

cl0s3rcl0s3r

No one else has had this issue?

 

tedwardtedward

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.

then

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