Loading request...
A user seeks a feature that can automatically standardize formatting across multiple Excel files, addressing issues like inconsistent column names and merged cells.
I regularly receive batches of Excel files that all contain the same type of data but come formatted differently every time — column names slightly changed, inconsistent date formats, extra empty rows, merged cells, etc. Right now the cleanup process is mostly manual and takes way longer than the actual analysis. I’m curious how others handle this situation when dealing with dozens or even hundreds of files. Do you rely on formulas, Power Query, macros, or some kind of automation outside Excel? What workflow has worked best for you?