This article introduces a painting line equipment planning and data collection system based on Excel and associated with AutoCAD and Word through VBA programs.It can achieve the connection of equipment calculation sheets,electric control data collection,public consumption,flow charts,and technical parameter tables in painting workshops,such as painting rooms,air conditioners,and work areas,to achieve the effect of"counting one source,multi-point sharing,accuracy and efficiency".The article describes its planning ideas,composition and functions of each module for reference by relevant designers.