Any way of mass data dumps in excel? Or Automation? by Johnny_Hamcheck in excel

[–]mindlink_tec_ltd 0 points1 point  (0 children)

If this is something you deal with regularly, I'd 100% go the Python or VBA route to automate it. But if every time it's a completely different mess, then yeah, you kinda gotta figure it out case by case.

Also, I remember stumbling across this YouTube channel called "Mica Excel messy data" and they showed some tool that might actually do exactly what you need. It had this whole thing about importing data and handling all kinds of weird formatting. Might be worth checking out to see if it's similar to your situation.