Furfural and levulinic acid are valuable platform compounds that can be produced by acid catalyzed conversion of sugars. Modified MCM-41 with different contents of silicotungstic acid (20 wt%-50 wt%) was successfully prepared via a wet impregnation method in order to regulate the ratio of Brønsted acid to Lewis acid. Among these catalysts, 40 wt% HSiW/MCM-41 with superior acid site density (Brønsted acid 59.35 μmol/g, Lewis acid 33.69 μmol/g) showed excellent catalytic activity as it exposed the most acidic sites and the ratio of Brønsted acid to Lewis acid reached 1.76. The conversion of biomass-based sugar was as high as 99.01 %, the maximum yield of furfural could reach 56.75 %, and the yield of levulinic acid could reach 18.88 % catalyzed by 40 wt% HSiW/MCM-41. This study provided new insights into the development of efficient and sustainable catalytic systems for the production of biomass-derived compounds.