- Home
- Merge CSV Files
Merge CSV Files Online — Combine, Align & Dedupe
Combine any number of CSV or XLSX files into one, with columns matched by name and, if you want, duplicate rows removed. Made for Google Maps exports, works with any spreadsheet, and your files never leave your browser.
Free CSV merger CSV or XLSX · No sign-up · Files stay on your device
No files to hand?
How columns line up
Preview
Merge CSV Files in 3 Steps
The whole job takes about a minute, whatever the number of files.
Add Your Files
Drop CSV or XLSX files onto the box above; exports from our Google Maps scraper or Chrome extension, from other tools and from Excel all work, in any column order.
Check How Columns Line Up
The column table shows which header in each file feeds each merged column, so you can see Phone and phone_number land in the same place before you download.
Merge and Download
Switch on duplicate removal if you need it, then download the result as a UTF-8 CSV that opens cleanly in Excel or as an XLSX workbook.
How Columns Are Matched
A merge is only as good as its column match. Most free mergers glue files together by position, which works only when every file has exactly the same columns in the same order. This merger reads each header, ignores case, spaces and underscores, treats common variants such as Phone Number and Telephone as one name, and matches columns by that name.
Different Column Orders
Two exports rarely list their columns in the same order, especially when they come from different tools or different runs. Matching by name puts every value under the right header, whatever its position.
| Input A | Input B | Blind merge | This tool |
|---|---|---|---|
| Name, Phone, Place ID Blue Fern Dental, (512) 555-0142, ChIJb3aF…V0E |
place_id, name, phone_number ChIJ9KdT…1cD, Oak Hill Family Dentistry, (512) 555-0177 |
Name: ChIJ9KdT…1cD Phone: Oak Hill Family Dentistry Place ID: (512) 555-0177 |
Name: Oak Hill Family Dentistry Phone: (512) 555-0177 Place ID: ChIJ9KdT…1cD |
Missing Columns
When a column exists in only some files, it is added to the merged file and left empty for rows that come from files without it. Nothing is cut off, so the email column from a paid export survives a merge with a free export that has none.
| Input A | Input B | Blind merge | This tool |
|---|---|---|---|
| name, phone Pecan Grove Smiles, (512) 555-0111 |
name, phone, email Oak Hill Family Dentistry, (512) 555-0177, front@oakhill-dental.example |
Header taken from A: name, phone front@oakhill-dental.example has no column and is lost |
name, phone, email Pecan Grove Smiles, (512) 555-0111, (empty) Oak Hill Family Dentistry, (512) 555-0177, front@oakhill-dental.example |
Files with Different Encodings (UTF-8 / GBK)
Files saved by Excel on a Chinese-language Windows PC are often encoded in GBK rather than UTF-8, and read as UTF-8 their names turn into replacement characters. The merger checks every file: valid UTF-8 is read as UTF-8, anything else is tried as GBK and then as Windows-1252, and the file list shows which encoding it used. The merged file is always UTF-8 with a byte order mark, so Excel opens it correctly.
| Input A · UTF-8 | Input B · GBK | Blind merge | This tool |
|---|---|---|---|
| name, phone Café Lumière, (512) 555-0190 |
name, phone 北京烤鸭店, 010-5555-0123 |
Café Lumière, (512) 555-0190 ������Ѽ��, 010-5555-0123 |
Café Lumière, (512) 555-0190 北京烤鸭店, 010-5555-0123 |
Remove Duplicate Rows from Maps Exports
Duplicate removal is off by default, so the merger never deletes rows you did not ask it to. Switch it on and it tells you how many rows it will remove before you download.
How Duplicates Happen: Overlapping Keyword Searches
Searches overlap. “Dentists in Austin” and “dentists 78745” return many of the same practices, and a city split into neighborhoods returns the businesses on every border twice. If you build lists with our lead scraper one keyword or one area at a time, stacking the exports lists those businesses twice, and your team calls them twice.
| Input A · dentists in Austin | Input B · dentists 78745 | Blind merge | This tool, by place_id |
|---|---|---|---|
| Blue Fern Dental · ChIJb3aF…V0E Pecan Grove Smiles · ChIJ2vXk…0aA Lady Bird Family Dental · ChIJ5mQx…0bC |
Blue Fern Dental · ChIJb3aF…V0E Oak Hill Family Dentistry · ChIJ9KdT…1cD Lady Bird Family Dental · ChIJ5mQx…0bC |
6 rows: Blue Fern Dental and Lady Bird Family Dental appear twice | 4 rows: Blue Fern Dental, Pecan Grove Smiles, Lady Bird Family Dental, Oak Hill Family Dentistry |
Dedupe by Place ID, Phone, or Full Row
Pick the rule that fits your files. The place_id is the safest key for Google Maps data because names repeat across chains and spellings drift. If a file has no place_id column, look the businesses up with our place ID finder first, or fall back to phone numbers.
| Rule | Two rows count as duplicates when | Best for |
|---|---|---|
| place_id | They share a place_id. Rows without one are compared on the full row. | Google Maps exports |
| Phone number | Their phone numbers have the same digits, ignoring spaces, brackets and dashes. Rows without a phone are compared on the full row. | Lists from mixed sources |
| Full row | Every column is identical. | Any CSV; the most cautious rule |
Keep the Newest Record When Duplicates Conflict
Two copies of one business often disagree: the rating moved, or one export added an email. The newer copy wins, judged by the scraped_at timestamp when your files have one and by the file you added later when they do not. Empty cells in the newer copy are then filled in from the older one, so nothing useful is lost, and the row keeps the position of its first appearance.
| Blue Fern Dental | rating | scraped_at | |
|---|---|---|---|
| Copy in dentists-austin.csv | 4.8 | (empty) | 2026-10-12 |
| Copy in dentists-78745.csv | 4.9 | hello@bluefern-dental.example | 2026-10-30 |
| Merged row | 4.9 | hello@bluefern-dental.example | 2026-10-30 |
Merging lists you have just scraped? Export them from our business search with the place_id column included, and the duplicates disappear here in one click.
Merge Multiple CSV Files
There is no limit on the number of files. Select a whole folder’s worth at once in the file picker, or keep dropping more onto the box; each one is read, checked and added to the column table as it arrives. Files are merged in the order you add them, and rows keep their order within each file, so naming files by date or by city gives you a merged file in the same order.
The limits are on size, not count: up to 50 MB per file and 100 MB in total, which is several hundred thousand rows of typical Google Maps data. The merge runs in a background thread, so the page stays responsive, a progress bar shows how far it has got, and Cancel stops it at any point. Larger merges run on our servers on paid plans.
Merge CSV Files in Python / pandas
For merges inside a script or on a schedule, pandas does the same job in a few lines. Each step below builds on the previous one. They need Python 3.9 or later and pandas.
pandas concat — the 5-Line Version
import glob
import pandas as pd
files = sorted(glob.glob("exports/*.csv"))
merged = pd.concat((pd.read_csv(f, dtype=str) for f in files), ignore_index=True)
merged.to_csv("merged.csv", index=False, encoding="utf-8-sig")
dtype=str keeps postal codes and phone numbers exactly as written, so leading zeros survive, and utf-8-sig adds the byte order mark Excel needs to show accented names. Write the output outside the folder so the next run does not read it back in. For XLSX files, use pd.read_excel instead of pd.read_csv.
Aligning Columns with pd.concat(axis=0, join="outer")
ALIASES = {"phonenumber": "phone", "placeid": "place_id",
"fulladdress": "full_address", "scrapedat": "scraped_at"}
def clean(col):
key = "".join(ch for ch in col.lower() if ch.isalnum())
return ALIASES.get(key, key)
frames = [pd.read_csv(f, dtype=str, keep_default_na=False).rename(columns=clean) for f in files]
merged = pd.concat(frames, axis=0, join="outer", ignore_index=True).fillna("")
pd.concat already lines columns up by name, but only when the names match exactly, so the clean function first turns Phone, phone and Phone Number into one name. join="outer" keeps columns that only some files have; join="inner" would quietly drop them.
Dropping Duplicates with drop_duplicates(subset="place_id")
if "scraped_at" in merged.columns:
merged = merged.sort_values("scraped_at", kind="stable")
has_id = merged["place_id"] != ""
merged = pd.concat([
merged[has_id].drop_duplicates(subset="place_id", keep="last"),
merged[~has_id].drop_duplicates(),
]).sort_index()
merged.to_csv("merged.csv", index=False, encoding="utf-8-sig")
Sorting by scraped_at first makes keep="last" keep the newest copy of each business, and sort_index puts the rows back in their original order. Rows without a place_id are only removed when the whole row repeats. Unlike the tool above, this version does not fill empty cells from the older copy.
Merge CSV Files in Excel & Command Line
Excel: Power Query Append
Put the files in one folder. In Excel, choose Data › Get Data › From File › From Folder, pick the folder, then Combine › Combine & Load. Power Query stacks every file into one table and matches columns by header name. Two catches: the expand step lists the columns of the first file only, so a column that exists only in later files is dropped unless you edit that step, and nothing is deduplicated; afterwards, use Data › Remove Duplicates and tick the place_id column.
macOS / Linux: cat with Header Handling
# cat repeats every file's header row inside the data
cat exports/*.csv > merged.csv
# keep only the first file's header
awk 'FNR > 1 || NR == 1' exports/*.csv > merged.csv
The awk version prints line 1 of the first file and skips line 1 of every other file. It also ends every line with a newline, so when a file has no final line break its last row does not run into the next file, which plain cat allows. Both still join by position, so every file must have the same columns in the same order.
Windows: copy /b with Header Handling
:: copy /b repeats every file's header row inside the data
copy /b exports\*.csv merged.csv
:: keep only the first file's header
@echo off
set first=1
(for %%f in (exports\*.csv) do (
if defined first (type "%%f" & set "first=") else (more +1 "%%f")
)) > merged.csv
Save the second part as a .bat file and run it from the folder above exports. more +1 skips each later file’s header. It also turns tab characters into spaces, which does not matter for comma-separated files, and it can stall on files of more than about 65,000 lines, so use the Python version for large exports. Like awk, this joins by position.
CSV Merger vs Combiner vs Joiner — Which Do You Need?
A csv merger and a csv combiner are the same tool under two names: they stack the rows of several files that hold the same kind of records, so ten city exports become one long list. Whether you call it combine csv or merge csv online, that is what this page does. A joiner is different. It places columns side by side, matching rows on a shared key, for example adding website data from one file to a list in another by place_id.
| Tool | Direction | Use it when | Also done with |
|---|---|---|---|
| Merger / combiner | Rows, top to bottom | Files hold the same kind of records, such as businesses from different searches | This page, Power Query Append, pd.concat |
| Joiner | Columns, side by side | Files hold different facts about the same records | VLOOKUP or XLOOKUP, Power Query Merge, pd.merge, SQL JOIN |
Common Use Cases
Google Maps Lead Lists
Scrape one city or one keyword at a time and you end up with a folder of overlapping exports. Merge them, remove duplicates by place_id, and you have one list with each business once. The merged latitude and longitude columns go straight into a mapping tool; if it expects another format, convert them on our Google Maps coordinates page.
CRM Imports
HubSpot, Salesforce and Pipedrive import one file at a time and create a new contact for every row. Merging first gives you a single import with consistent column names to map once, and removing duplicates by phone number keeps the same company from being created twice.
Analytics Exports
Monthly exports from Search Console, Google Analytics or an ad platform share the same columns, but each covers one period. Merge them into one file to chart the trend, and remove duplicates by full row when two exports overlap by a few days.
Frequently Asked Questions
Last updated: November 1, 2026
Is this CSV merger really free?
Yes. There is no account, no email address and no limit on the number of files. Each file can be up to 50 MB and all files together up to 100 MB, which covers several hundred thousand rows. You can merge as often as you like.
Do my files get uploaded?
No. Your files are read and merged by JavaScript inside your browser tab and are never sent to a server. Once the page has loaded you can even go offline and the merger keeps working. Closing the tab clears everything.
Can it merge files with different column orders?
Yes. Columns are matched by header name, not by position, after ignoring case, spaces and underscores. Common variants such as Phone, phone_number and Telephone count as one column, and a column that only some files have is kept and left empty for the others.
Does it remove duplicate rows?
Yes, when you switch it on. Unlike generic mergers, it can remove duplicates by place_id, the ID Google Maps gives each business, as well as by phone number or by full row. When two copies disagree, the newer one is kept and its empty cells are filled from the older one.
Can I merge XLSX files?
Yes. Drop XLSX workbooks alongside CSV files and the first sheet of each workbook is merged like any other file, with columns matched by header. You can download the result as a CSV or as an XLSX workbook. Older .xls files need to be saved as XLSX or CSV first.
How large can the files be?
Up to 50 MB per file and 100 MB in total, merged in your browser. That is several hundred thousand rows of typical Google Maps data. For more, split the files into batches, merge each batch, then merge the results.
Will merging break my Google Maps data?
No. Addresses, opening hours and category lists that contain commas or line breaks are read as single quoted values and written back out quoted. Coordinates, place IDs, phone numbers and postal codes are kept as text, exactly as they appear in your files, with no rounding or lost leading zeros.
What's the difference between merging and joining CSV files?
Merging stacks rows: several files with the same kind of records become one longer file. Joining places columns side by side, matching rows on a shared key such as place_id. Use this page to merge, and VLOOKUP, XLOOKUP or pandas merge to join.