Thanks tried the import wizard and it said 10 out of 11 rows successfully imported but no new rows appear to have been added. This method anyway seems to only import new rows but what I want to do is insert values into existing rows where the productid matches, so overwrite the existing values in the colour field. There doesn't seem to be an option for this.