The experimental results on the “influence of preparation conditions on nanoporous structure and optical transmission of sodium silicate based ambient pressure dried aerogels employing shaking” are reported. Sol–gel derived gels shaked in the presence of ammonium fluoride (NH4F) and organically modified with various silylating agents and aprotic solvents are useful in controlling the magnitude of capillary stress imposed on the gel. These parameters enormously affect the optical transmission and density of the aerogels. Therefore, in the present paper the influence of different concentrations of NH4F, silylating agents and aprotic solvents on the physical properties of the aerogels were studied. The aerogels were characterized by measuring the bulk density, volume shrinkage (%), porosity (%) and thermal conductivity. The microstructural studies were carried out using transmission electron microscopy (TEM). The hydrophobicity is confirmed by measuring the contact angle of water on the surface of aerogel and Fourier Transform Infrared (FTIR) spectroscopy. The optical transmission of the aerogels is measured by the visible spectrophotometer. The thermal stability of the aerogels was checked by the thermo gravimetric and differential thermal analyses (TGA-DTA).