Compare two (or more) CSV files

We are a market research team that regularly analyzes shopper metrics data. We have a specific use case where we need to compare two CSV files to each other to identify differences and pull together comparative data points.

Our current workflow involves looking at a lot of data comparatively, and we often need to tell year-over-year stories by comparing target audience data to control groups. We have CSV files containing shopper metrics data that we need to analyze, including calculations and breakdowns that we would like our tool to pull together automatically.

We understand that the tool may not have granular snapshot capability yet, but we're hoping that with its current capability, we can compare target audience data to control data more efficiently. Currently, this process is quite manual and time-consuming.

We attempted to work with the current system by converting CSVs to XML format to perform the analysis, but we're looking for a more streamlined approach that can handle CSV comparison natively.

Our ideal outcome would be to upload two CSV files and have the system automatically identify key differences, patterns, and provide comparative insights without requiring manual data transformation.