1. Home
  2. 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

Drop CSV or XLSX files here or Up to 50 MB per file and 100 MB in total. Nothing is uploaded.

No files to hand?

      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.

      Two Google Maps export files added to the CSV merger

      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.

      Column match table showing which header in each file feeds each merged column

      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.

      Merged file ready to download as CSV or XLSX

      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 AInput BBlind mergeThis 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 AInput BBlind mergeThis 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-8Input B · GBKBlind mergeThis 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 AustinInput B · dentists 78745Blind mergeThis 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.

      RuleTwo rows count as duplicates whenBest for
      place_idThey share a place_id. Rows without one are compared on the full row.Google Maps exports
      Phone numberTheir 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 rowEvery 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 Dentalratingemailscraped_at
      Copy in dentists-austin.csv4.8(empty)2026-10-12
      Copy in dentists-78745.csv4.9hello@bluefern-dental.example2026-10-30
      Merged row4.9hello@bluefern-dental.example2026-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

      Python
      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")

      Python
      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")

      Python
      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

      Terminal
      # 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

      cmd · merge.bat
      :: 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.

      ToolDirectionUse it whenAlso done with
      Merger / combinerRows, top to bottomFiles hold the same kind of records, such as businesses from different searchesThis page, Power Query Append, pd.concat
      JoinerColumns, side by sideFiles hold different facts about the same recordsVLOOKUP 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.