The reporting feature is really great, but the format of exported data into excel is not. I always have to spend a few minutes editing certain export files to make it easy for me to sort columns and manipulate data.
See attachment. I always deal with extra unneeded columns and Headers to not line up with columns. It would be better to export in a CSV with no formatting for cross-platform compatibility.
Hey @Tony, thank you for posting your idea! I looked into the excel formatted reports and found that the issue is because of the way some columns are merged. You’ll have to unmerge them for now.
How often are you pulling these reports? Please vote for or add your comments to this idea if you’re interested!