How do you remove water spots from car paint?

Fresh spots often come off with a water-spot remover or quick detailer. Spots etched into the clear coat need polishing.