Auto Merge Sheet

Merge multiple Google Sheets™ from a Google Drive™ folder into a master sheet. --- no coding required.

Auto Merge Sheets is a simple yet powerful Google Sheets™ add-on that helps you consolidate data from multiple Google™ spreadsheets into one central sheet — all with a single click. It’s perfect for business owners, educators, analysts, and managers who regularly collect standardized reports from multiple branches, outlets, or team members.

Whether you're running weekly sales reports, monthly inventory updates, or daily stock tracking from different sources, this tool streamlines process and get your data ready for pivot tables, charts, for deeper analysis. — saving hours of manual copy-paste work.

Key Features:

Seemless Consolidation: Collect and merge data from all Google Sheets™ in a selected Drive folder.

Smart Header Matching: Ensures only compatible sheets (with matching headers) are merged.

Skips Irregular Files: Automatically detects and skips files with incorrect formats.

Auto Label Extraction: Extract name and date automatically based on file name, making merged data clean and structured.

Ready for Analysis: Ideal for creating dashboards, pivot tables, and visual reports with ease.

One-Time Setup, Reusable Anytime: Configure once using the sidebar — then just click “Start Merge” anytime to refresh your data.

One-Click Backup & Reset : Back up your data with just 1 click.

Automated Consolidation* : Fully automate by setting time / event trigger by minutes/hourly/daily/weekly as per need. (PREMIUM PAID FEATURE)

Use Case Scenario

Sales Reports: Consolidate monthly or weekly sales data from multiple regional stores or teams into a single sheet for a comprehensive overview.
Inventory Management: Merge product reports from various departments into one file to track inventory levels across your business.
Employee Performance Reports: Collect employee data from different departments and merge them into a single sheet for easier evaluation and reporting.
Data Analysis: Organize raw data from various sources into one sheet to create dynamic pivot tables or charts for deeper insights.

How to Prepare Your Raw Google Sheets™

To ensure a smooth merge, follow these simple steps:

✅ Make Sure Files Are in Google Sheets™ Format
- Files must be Google Sheets (not Excel). If you're uploading Excel files to Google Drive, turn on this setting:
  - Go to Google Drive™
  - Click the gear icon > Settings
  - Turn ON the toggle for: “Convert uploads to Google Docs™ editor format”
  - This ensures all uploaded Excel files are converted into Google Sheets™.
🗂️ Same Structure, Same Headers
- All files should follow the same structure and column headers (e.g., Name, Quantity, Date).
- Column names must match exactly (spelling, spaces, etc.)
📌 File Names Must Include Name & Report Date
- Example: ABC - 10 March 2024
- We'll extract “ABC” as the namr and “10 March 2024” as the report date.
🔄 Data Must Be in Vertical Format (Top-Down)
- Each row should represent one data entry (e.g., a product, a transaction).
- The first row should be your header (column titles).
- Do not arrange your data sideways (columns as entries). If unsure, think of your data like a spreadsheet you'd use for pivot tables — each row = 1 record.

Step by step how to use :

✅ Step 1: Install the Add-on

Open any Google Sheets™ file.
Click on “Extensions > Add-ons > Get add-ons.”
Search for “Auto Merge Sheets.”
Click “Install” and grant the necessary permissions.

📍 Step 2: Launch the Add-on

After installation:

Open your Google Sheet™.
Go to the menu bar and click “Extensions > Auto Merge Sheets > Open General Setting”
The add-on sidebar will appear on the right.

🧩 Step 3: Fill In the Required Settings

In the Sidebar-General tab, fill in the following:

Google Drive™ Folder ID: The folder where all your source sheets are stored.
Master Sheet ID: The Google Sheets™ where merged data will be saved.
Sheet Name: The name of the sheet/tab where merged data will be written.
Backup Folder Link: Drive folder where backup files will be stored.
Backup File Base Name: File name prefix. Date will be auto-added (e.g. Backup_Retail_Stock_Report).
Sheet(s) to Backup: Choose which sheet you want to back up. Insert "ALL" if you want to backup whole file

*You only need to set this once unless you want to change folders.

🔄 Step 4: Run the Merge

Click the “Run Merge” button.
The add-on will:
- Scan the selected folder.
- Detect and combine all matching data into your master sheet.
- Avoid duplicate headers.
- Create New Header with Names and Date from file name.
When new spreadsheet is added to gdrive, click "Run Merge" again, now new entries is extract from new spreadsheet.

💾 Step 5: Enable Backup (Optional)

To create a backup copy:

Go to the Sidebar - General tab.
Click the Backup button.
A new Google Sheets™ file will be created in your specified backup folder.

♻️ Step 6: Re-run Anytime

When there's a situation you want to clear all memory and re-run as fresh again:

Go to Extensions > Auto Merge Sheets > Clear Processed Files.
This will:
- Clear the memory of previously merged files.
- Clear entries recorded on target sheet.
- Allow the same files to be re-merged if needed.

🕒 Premium Feature: Automate the Merge (Coming Soon!)

Upgrade to premium to unlock:

Daily, Weekly, or Monthly automatic merging.
Fully hands-free operation for teams handling lots of data.

Install Add On

Page updated

Google Sites

Report abuse