Abstract: CPT is widely used in the field in-situ tests with good continuity, reproducibility and reproducibility, but its digital management and the study of correlation is still little. The CPT database what not only has the characteristics of large information content, simple operation, code open and so on, but also has the advantage that the analysis result is more reliable as the data is more abundant, was established by Excel VBA. Based on the experimental data of geotechnical engineering investigation come from 18 projects in Shanghai in CPT database, three groups of relationship formula of specific penetration resistance Ps and soil compression modulus E₀, consolidated-quickly shear indicators(c_cq、φ_cq) and triaxial consolidation draining shear indicators(c_cu、φ_cu) are got by correlation analysis. Test of significance shows that:these formulas can be used as engineering design reference in some areas that are similar to Shanghai.