CiviCRM Community Forums (archive)

I don't know if CiviCRM import lets you match on address criteria (rather than contact criteria). If that was possible, perhaps you could do that.

However, you can do something similar in SQL. For example, load a CSV like this into a temp table:
Number,Street,Addr2,Addr2,Postcode
23,Winton Rd,Dingleton,Wellington,3093
12,Queen St,Ak Central,Auckland,1000

Then do an SQL update like this (example below simplified, but you get the idea)
UPDATE civicrm_address a, temp.imported_csv c
   SET a.postal_code = c.postcode
 WHERE a.street_number = c.number
   AND a.street_name = c.street
   AND a.supplemental_address_1 = c.addr2
   AND a.supplemental_address_2 = c.addr3 ;

That will match the addresses using SQL and copy the updated postcodes from the CSV to your civicrm_address table.

This is example code only!

Code which did something like this in CiviCRM (a contact-agnostic method for address cleanups) would be a useful feature for us.

I wonder if there's much demand from other users for such a thing?