This paper aims to develop a user-friendly tool based on Excel macros, allowing the general public to easily conduct tidal harmonic analysis and make tidal level predictions based on the analysis results. This tool is offered free of charge to the public, requiring no additional software installation-only an Excel environment is needed for operation, making tidal predictions convenient and efficient.