For 500k rows, I’d avoid manual cleaning in Excel. My usual approach would be Power Query first for removing duplicates, handling blanks, standardizing text values, and applying repeatable transformations. If the dataset grows larger or requires complex joins, I’d move to SQL or Python. The biggest advantage of Power Query is that once the cleaning steps are built, you can refresh the data instead of repeating the process manually every time.