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.

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 setting:
Go to Google Drive™ top right corner
Click on Settings (gear icon)
Look for “Convert uploads to Google Docs™ editor format” > Turn ON the toggle
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.)
🔄 Data Must Be in Vertical Format (Top-Down)
Each row should represent one data entry (e.g. a product, a transaction, a person).
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 Sheet”
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 > Merge 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:
Click on "Select Source Spreadsheet" to pick files to merge
*Tips : Press "Shift" to select multiple files*Tips : Utilize file search bar to look for your files
🔄 Step 4: Run the Merge
Click the “Run Merge” button.
The add-on will:
Scan the selected files.
Detect and combine all matching data into your master sheet.
Avoid duplicate headers.
Create New Header from file name.

🕒 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.