The invention discloses a water-based wiping-resistant and stain-resistant crack sealer and a preparation method thereof. According to the technical scheme, the crack sealer is mainly technically characterized by comprising a component A and a component B, wherein the component A comprises 0.5-1.5 parts of dispersant, 0.1-0.3 part of an antifoaming agent, 0.05-0.15 part of a wetting agent, 0.2-0.5 part of a flatting agent, 0.2-1 part of hydroxyethyl cellulose, 1-3 parts of a coalescing agent, 20-45 parts of water-based high-molecular polymer resin, 21-45 parts of colored sand, 0.5-2 parts of a coupling agent, 20-40 parts of pigment and filling materials and 14.5-17.5 parts of deionized water; the component B is a water-based curing agent; the component A and the component B are mixed for being used. The preparation method comprises the following steps: 1, preparation of dispersion slurry, wherein auxiliary agents such as the dispersant are added to the deionized water, and the pigment and the functional filling materials are added for dispersion; 2, preparation of film forming substances, wherein the water-based high-molecular polymer resin, the coupling agent and the like are added for stirring; 3, paint forming stage, wherein the film forming substances and the dispersion slurry are dispersed, then the colored sand is added, and the mixture is stirred to be uniform; packaging. By means of the water-based wiping-resistant and stain-resistant crack sealer, the water-retention rate of a product is raised, and the crack resistance, the caking property, the chemical properties, the wear resistance and the stain resistance of the product are improved.