What do you mean “spit out”? Is it being put into a new open workbook, an existing open workbook, or is it being saved as a file?

And I don’t mean to suggest I know better than the person actually dealing with the situation (I hate when people do that), but if you can do it manually, it can be automated.

There is definitely a way to automate that process. Even if you can’t somehow sanitize the input before Excel reads it as dates, unfucking the data can definitely be reduced to a single button-push. I’ve based my entire career on my ability to do that.