What CSV merging is
Combine compatible exports without sending them to a server
CSV merging creates one table from two source files. You can stack records that share the same structure or combine fields from records that share a unique identifier. UtilityDock validates both files before creating a new download.
Append vs join
Choose the operation that matches your data
| Mode | Use it when | Output |
|---|---|---|
| Append | Both files have identical headers | File A rows followed by File B rows |
| Join by key | Both files share one unique identifier | Only matching records with combined columns |
Common workflows
Bring related exports into one useful file
- Append monthly exports with the same columns
- Combine regional order files into one report
- Join customer details to an order export by customer ID
- Add inventory status to a product list by SKU
- Match campaign results to contacts by record ID
- Combine two clean batches after reviewing a CSV Split
Examples
Predictable results from two small rules
| File A | File B | Result |
|---|---|---|
| 500 January orders | 600 February orders | 1,100 appended rows |
| Products keyed by SKU | Prices keyed by SKU | Matching products with price columns |
| 3 customer IDs | 2 matching IDs | 2 inner-joined rows; unmatched rows reported |
CSV Toolkit
Inspect, prepare, and clean CSV files locally
FAQ
Questions about merging CSV files
Does UtilityDock upload or store my CSV files?
No. Your files never leave your computer. Parsing, validation, merging, preview, and download creation all happen locally inside your browser.
What is the difference between append and join?
Append places File B's rows after File A and requires matching headers. Join by key combines columns from records whose selected key value appears exactly once in both files.
Which joins are supported?
Version 1 performs a simple inner join using one shared column. It does not support left, right, outer, fuzzy, multiple-key, or many-to-many joins.
What happens to rows without a matching key?
An inner join excludes unmatched rows from the merged output. UtilityDock reports their combined count before download.
Why are duplicate join keys blocked?
Duplicate keys can create one-to-many or many-to-many results. Version 1 requires unique nonblank keys so every match remains predictable.
Which file controls the output format?
File A controls the output encoding, BOM behavior, delimiter, and line endings. Differences in File B are reported before merging.