Ask HN: How Do You Clean and Structure Data at Work?

Curious to hear from different industries—what’s the most frustrating or repetitive data task you deal with and how are you solving it?

I do software implementations, and we get customer data exports from legacy systems as CSV or XLSX. Cleaning and mapping them for import is always a pain.

Anyone else constantly structuring, formatting, or fixing data? How do you deal with it, any good tools or workarounds?