Structure changes
Identify added or removed columns and type changes before comparing the business values themselves.
COMPARE EXCEL & CSV FILES
Compare two datasets and understand what actually changed.
Use Azhan Data Studio to compare previous and current CSV or Excel datasets, review structural changes, quantify movement and identify the records or categories behind the difference.
✓ Previous vs current✓ Schema change detection✓ Record-level evidence✓ Movement summaries
WHAT YOU CAN DO
Built for practical data work, not dashboard setup.
Key-based matching
Use suitable identifier fields to align records across versions and understand what was added, removed or changed.
Movement analysis
Quantify changes in numeric measures and categorical distributions rather than relying on manual spreadsheet scanning.
Explain the difference
Trace important movement back to the fields, categories and records contributing to the change.
WORKFLOW
A straightforward path from raw file to useful output.
Upload the previous file
Choose the earlier dataset or workbook sheet that represents your baseline.
Upload the current file
Add the newer dataset using the same or a compatible structure.
Confirm comparison fields
Review detected keys and candidate measures so the comparison uses appropriate columns.
Review what changed
Use the summary, field evidence and record-level output to understand the movement.
USE CASES
Useful when you need a fast answer from everyday business data.
Month-on-month reportingSystem extract validationPrice-list changesInventory movementCustomer or dealer file changesBefore/after data checks
FAQ
Common questions
Can I compare Excel files as well as CSV files?
Yes. The comparison workflow supports CSV and Excel .xlsx files, including sheet selection for Excel workbooks.
Do the two files need identical columns?
No. The tool first identifies schema differences such as added, removed or changed fields, then uses the common structure for compatible comparisons.
Can it show which individual records changed?
Where a suitable key field is available, the comparison can align records and surface added, removed and changed records as supporting evidence.
Is this the same as comparing spreadsheet formatting?
No. The tool focuses on dataset structure and values rather than workbook formatting, cell colours or formulas.
TRY IT FREE
Compare datasetsReady to work with your own data?
Open Azhan Data Studio, upload a CSV or Excel file and use the tool directly in your browser.