When you import records into Insightly, you can update existing records in bulk by matching the Record ID in the CRM to the Record ID in the file you import (for example, a CSV file).
What's a Record ID?
A Record ID is a number that's assigned by Insightly to a record as it is created. The Record ID is displayed in the highlights bar and in the Details tab on the default page layout of every record.
If you cannot find it, ask your administrator to create a new page layout that includes it.
Do I have to use the Record ID? Couldn't I just use the name of the record?
Yes, it is possible to bulk update without using a record ID, but we do not recommend this. If you bulk update your records using the name of the record, you may accidentally connect it to another record with the same name.
For example, say you do business with two schools that are both named Sierra High School. If you just used the name, Insightly might import your data to the wrong school. Using the record ID will ensure your data is connected correctly.
How to add the Record ID to the import file
The easiest way to do this is to export the records from Insightly first. If you can export it from Insightly first, the Record ID will be included in the export file and found in the first column of the file.
To do this:
- Export the records you'd like to update from Insightly.
- Update the file as needed.
- Import the file back into Insightly and choose Update Existing Records or Add New Records and Update Existing Records.
If you cannot do this because you are starting with a file from a source outside of Insightly, you will need to add the matching Record IDs to the file yourself.
To do this:
- Export the records from Insightly that correspond to the records you want to update (contacts, organizations, etc.). Save an extra copy of this file in case you make errors.
- Add a field for the ID to the spreadsheet that you'll be importing into Insightly.
For example, if you are importing into an Organization, label the field Organization Record ID.
- If you don't have many records to update, you can manually find and enter the matching record information into your import file.
If you need to update many records: Using Excel or Google Docs, you can use a VLOOKUP formula to match to the record names and update your record ID field for you. This will be dependant on how your files are set up. Check your software documentation or consult an expert.
- Once the records are updated, use the Save As or Download As options to save the file as a comma-delimited CSV file.
- Import the file into Insightly and choose Update Existing Records or Add New Records and Update Existing Records.