Hi,

I have downloaded csv file of nearly 3000 customer contact details, and have the following issues.

Names are not always Proper Capitalised?

Phone format are not consistant, eg some has 440 some 44 and some 07.

And out of the 3000, only 29 duplicate emails! 

Some gmail.coN etc.

So I can sort out these with excel...no problem. 

However where do I upload them back so the corrections over write the errors to the Bookings Customer list?

I am sure it must be possible, but need guidance please.

Thanks