Superhydrophobic surfaces with water contact angle higher than 150° generated a lot of interest both in academia and in industry because of the self-cleaning properties. Optically transparent superhydrophobic silica films were synthesized at room temperature (27 °C) using sol–gel process by a simple dip coating technique. The molar ratio of MTMS:MeOH:H 2O (5 M NH 4OH) was kept constant at 1:10.56:4.16, respectively. Emphasis is given to the effect of the surface modifying agents on the hydrophobic behavior of the films. Methyl groups were introduced in the silica film by post-synthesis grafting from two solutions using trimethylchlorosilane (TMCS) and hexamethyldisilazane (HMDZ) silylating agents in hexane solvent, individually. The percentage of silylating agents and silylation period was varied from 2.5 to 7.5% and 1 to 3 h, respectively. The TMCS modified films exhibited a very high water contact angle ( 166 ± 2 ° ) in comparison to the HMDZ ( 138 ± 2 ° ) modified films, indicating the water repellent behavior of the surface. When the TMCS and HMDZ modified films were heated at temperatures higher than 350 °C and 335 °C, respectively, the films became superhydrophilic; the contact angle for water on the films was smaller than 5°. Further, the humidity study was carried out at a relative humidity of 85% at 30 °C temperature over 30 days. The films have been characterized by scanning electron microscopy (SEM), atomic force microscopy (AFM), Fourier transform infrared spectroscopy (FT-IR), % optical transmission, humidity tests and contact angle (CA) measurements.