Every month, the same ritual: one export per tool, columns that never line up, and hours of copy-pasting in Excel to rebuild a single table. This article explains how to cleanly merge several CSV or Excel files into one — without Python, without VLOOKUP, and without sending your data to a server.
Why merging files is so painful
The problem is rarely volume: it’s heterogeneity. Two exports from the “same” tool can differ month to month, and two different tools never name their columns the same way.
- Headers that change: “E-mail”, “Email”, “Mail” all mean the same column.
- Different column orders from one file to the next.
- Duplicates to remove once the files are combined.
- An expected output format (CSV? Excel?) that forces one last reformat.
Done by hand, each of these is a silent source of errors — and the whole job has to be redone next month.
The classic methods (and their limits)
Copy-pasting in Excel
It’s the default method. It works for two small identical files, but it doesn’t scale: no trace of what was done, and a single misaligned column throws off the whole table.
VLOOKUP
Useful to match two tables on a key, but it isn’t a merge: it’s a fragile lookup that breaks the moment a key changes case or carries an extra space.
A Python script (pandas)
Technically, a few lines are enough to concatenate files:
import pandas as pd
frames = [pd.read_csv(f) for f in ["january.csv", "february.csv"]]
merged = pd.concat(frames, ignore_index=True)
merged.to_csv("merged.csv", index=False)But this elegance is deceptive: you need a Python environment, you must realign columns by hand when headers differ, handle deduplication, and maintain the script. Out of reach for most teams — and hard to replay confidently every month.
Merging cleanly, step by step
The Intoone approach removes the code while keeping you in control. Processing runs 100% in your browser (WebAssembly): your files never leave your machine.
In practice, merging takes four steps, listed in the how-to below.
- Drop your monthly files
Drag your CSV and Excel exports into the browser. Nothing is sent to a server: everything stays on your machine.
- Align the columns
Intoone recognizes equivalent headers (“E-mail”, “Email”, “Mail”…) and offers to merge them onto a single column.
- Merge into a single table
Combine all files into one table, then deduplicate and filter according to your business rules.
- Export and save the workflow
Get a clean CSV or Excel file, and save the workflow to replay it next month.
Replaying the merge every month
The real saving isn’t the first merge: it’s the hundredth. By saving the sequence of operations as a workflow, next month boils down to dropping in the new files and replaying — cleaning, column alignment and deduplication run identically.
That’s exactly what Intoone’s free web app does: a replayable workflow, no install and no upload.