What’s the best way to clean and prepare messy real-world data for analysis?

I'm dealing with inconsistent and incomplete data collected from multiple sources (Excel, APIs, forms). What tools or pipelines (like Python libraries or cloud solutions) do you recommend for cleaning, deduplication, and merging before running analysis?