Export results to Excel

Last updated: 2026-04-13

Use this workflow when you need to share comparison output with spreadsheet users, QA teams, procurement teams, or operations analysts.

Run a comparison on the home tool.
Open a results tab (for example A only).
Click Download .csv.
Open the CSV in Excel. If characters look wrong, use Excel’s import wizard and pick UTF-8.

Why CSV?

ListDiff’s CSV export is intentionally simple (single column). It’s the most reliable interchange format for moving results back into spreadsheets.

Recommended export sequence

Review Intersection to confirm expected overlap quality.
Export A only and B only for reconciliation tasks.
Export Duplicates tabs if your team needs data-cleaning reports.

Which tab should you export first?

Intersection for confirmed overlap and matched records.
A only when auditing missing items in system B.
B only when auditing missing items in system A.
Symmetric difference for total mismatch review in one file.

Excel import tips

If characters are garbled, import as UTF-8 explicitly in Excel.
If values split into multiple columns unexpectedly, use the text import wizard and select comma delimiter.
Keep a copy of the original export file for audit traceability.

Reporting pattern for teams

Export A only and B only as separate action lists.
Attach duplicates tabs to highlight source quality risks.
Keep one intersection export as baseline evidence of successful matches.

Input -> tab -> export example

Input context: two user ID lists with partial overlap
Tab selected: A only
Action: Download .csv
Result: one-column action list for IDs present only in source A.

FAQ

Why is export single-column only?
Single-column CSV is the most portable format for downstream merge, filter, and lookup workflows.

Can I export all tabs at once?
Current workflow is tab-by-tab export. Export only what your downstream step requires to stay focused.

Need upstream preparation? Read Excel paste: use TSV (tabs). Need result semantics? Read Compare Basics.