How to Import Multiple CSV Files Into One Google Sheet

Key Takeaways:You can import multiple CSV files into one Google Sheet using a merge tool, Apps Script, IMPORTRANGE, or add-onsMerging CSVs before importing is the fastest method — it takes under 60 seconds for most filesGoogle Apps Script can automate recurring imports from a Drive folderSmoothSheet's free CSV Merger combines files with different column structures without code

You have five CSV exports from different months, three vendor reports, or a dozen regional data files — and you need all of that data in one Google Sheet. The problem? Google Sheets only lets you open one file at a time through its built-in import dialog. There is no native "import multiple CSVs" button.

In this guide, I will walk you through four practical methods to import multiple CSV files into a single Google Sheet. Whether you prefer a no-code tool, a script, or a manual workaround, you will find a method that fits your workflow.

The Problem — Multiple CSVs, One Spreadsheet

If you work with data regularly, you already know this pain. Your CRM exports monthly reports as separate CSV files. Your e-commerce platform splits order data by region. Your analytics tool dumps weekly snapshots into individual files. And you need to analyze all of it together in one spreadsheet.

Google Sheets does not offer a built-in way to batch-import CSV files. The standard File > Import dialog handles one file at a time, and each import either replaces the current sheet, creates a new tab, or appends to the active sheet. For two or three files, that is manageable. For ten or more, it becomes tedious and error-prone.

Here are the main challenges you will face:

• Inconsistent headers: Not all CSV files have the same column order or naming conventions
• File size limits: Google Sheets has a 10 million cell limit, and large combined datasets can hit that ceiling fast
• Manual errors: Copy-pasting between files often leads to misaligned columns or duplicate headers
• Time cost: Manually importing 10+ files can easily take 30 minutes or more

Let's look at four methods that solve this, ranked from simplest to most flexible.

Method 1 — Merge CSVs First, Then Import

The most straightforward approach: combine your CSV files into a single file before uploading to Google Sheets. This eliminates the multi-import problem entirely.

SmoothSheet's free CSV Merger is built specifically for this. It runs entirely in your browser — no file uploads to any server, no sign-ups, no installations.

Step-by-Step Instructions

1. Open the CSV Merger tool — Go to smoothsheet.com/tools/csv-merger
2. Upload your CSV files — Drag and drop all your CSV files at once, or click to browse. You can add as many files as you need
3. Choose your merge mode:
   • Append mode: Stacks rows vertically — perfect when all files have the same columns (e.g., monthly exports from the same system)
   • Union mode: Merges files with different column structures — columns are matched by header name, and missing values are left blank
4. Enable source tracking (optional) — Check the "Add source file column" option to add a column that shows which file each row came from. Extremely useful for filtering later
5. Download the merged CSV — One click, one file with all your data combined
6. Import to Google Sheets — Open Google Sheets, go to File > Import, upload your merged CSV, and you are done

This method works best when you want a clean, one-time import. The entire process takes under 60 seconds for most file sets. If your merged file is larger than 100 MB, consider using SmoothSheet's CSV Splitter to break it into Google Sheets-friendly chunks first.

When to Use This Method

• One-time or occasional imports
• Files with the same or similar column structures
• You want the simplest, fastest solution with no coding
• You need to keep a record of which file each row came from

Method 2 — Google Apps Script

If you need to import multiple CSVs from a Google Drive folder on a recurring basis, Google Apps Script is a powerful (and free) option. This method reads every CSV in a specified folder, parses it, and appends the data to your active sheet.

The Script

Open your Google Sheet, go to Extensions > Apps Script, and paste the following code:

function importCSVsFromDrive() {
  var folderId = 'YOUR_FOLDER_ID_HERE'; // Replace with your Drive folder ID
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var folder = DriveApp.getFolderById(folderId);
  var files = folder.getFilesByType(MimeType.CSV);

  var isFirstFile = true;

  while (files.hasNext()) {
    var file = files.next();
    var csvData = Utilities.parseCsv(file.getBlob().getDataAsString());

    if (isFirstFile) {
      // Include headers from the first file
      csvData.forEach(function(row) {
        sheet.appendRow(row);
      });
      isFirstFile = false;
    } else {
      // Skip header row for subsequent files
      csvData.slice(1).forEach(function(row) {
        sheet.appendRow(row);
      });
    }
  }

  SpreadsheetApp.getUi().alert('Import complete! ' + sheet.getLastRow() + ' total rows.');
}

How to Use It

1. Create a Drive folder and upload all your CSV files to it
2. Copy the folder ID from the URL — it is the string after /folders/ in https://drive.google.com/drive/folders/abc123xyz
3. Replace YOUR_FOLDER_ID_HERE in the script with your folder ID
4. Run the function — Click the play button or go to Run > importCSVsFromDrive
5. Authorize access when prompted — the script needs permission to read your Drive files

For a complete reference on the Utilities.parseCsv() method and other automation patterns, see the official Google Apps Script CSV import guide.

Limitations to Know

• Execution time limit: Apps Script has a 6-minute execution limit per run. For very large datasets (100,000+ rows across files), the script may time out
• Same column structure assumed: This basic script assumes all CSVs have identical headers. For files with different columns, you would need additional logic to map headers
• appendRow() is slow: For large imports, batch-writing with setValues() is significantly faster than appending row by row
• Encoding issues: Some CSV files exported from non-English systems use different character encodings. If you see garbled text, run your files through an encoding fixer first

When to Use This Method

• Recurring imports (weekly, monthly data dumps)
• Files already stored in Google Drive
• You are comfortable with basic scripting
• You want automation without third-party tools

Method 3 — Manual Import to Separate Tabs + IMPORTRANGE

This approach uses only built-in Google Sheets features — no scripts, no tools. The idea is simple: import each CSV into its own tab, then pull data together using formulas.

Step-by-Step Instructions

1. Import each CSV to a separate tab — Go to File > Import, select your CSV, and choose "Insert new sheet" as the import location. Repeat for each file
2. Create a "Combined" tab — Add a new sheet where your merged data will live

For data in separate spreadsheets, use IMPORTRANGE:

=IMPORTRANGE("spreadsheet_url", "Sheet1!A1:Z1000")

Use formulas to pull data — In the Combined tab, use a query or array formula to stack data from each tab:

={Sheet1!A2:Z; Sheet2!A2:Z; Sheet3!A2:Z}

This array formula vertically stacks all rows from the three tabs (excluding headers from sheets 2 and 3).

Limitations to Know

• Manual and repetitive: You still need to import each CSV individually
• Formula maintenance: Every time you add a new file, you must update the combining formula
• Performance: IMPORTRANGE can slow down your spreadsheet, especially with large datasets. For tips on optimizing CSV imports, check our CSV import tips guide
• Column alignment: All tabs must have the same column order for the stacking formula to work correctly

When to Use This Method

• You only have 2-3 files to combine
• You want to keep source data on separate tabs for reference
• You prefer using only native Google Sheets features

Method 4 — Third-Party Add-ons

Several Google Workspace add-ons can automate multi-CSV imports. The two most popular options are Sheetgo and Coupler.io.

Sheetgo

Sheetgo connects multiple data sources (CSV files, Google Sheets, Excel) and consolidates them into one sheet. It supports scheduled imports and can handle files from Google Drive, OneDrive, and Dropbox.

• Pricing: Free plan limited to 1,000 rows/month; paid plans start at $22/month
• Best for: Teams that need automated, recurring data consolidation across cloud storage platforms

Coupler.io

Coupler.io pulls data from various sources (including CSV files, APIs, and databases) into Google Sheets. It offers a visual interface for setting up import workflows.

• Pricing: Free plan limited to 1,000 rows; paid plans start at $49/month
• Best for: Teams integrating data from multiple SaaS platforms alongside CSV files

The Add-on Trade-off

Add-ons offer powerful automation, but they come with costs and complexity. For straightforward CSV merging, a free tool like SmoothSheet's CSV Merger gets the job done without monthly fees or account setup. For ongoing large-file imports directly into Google Sheets, SmoothSheet's add-on ($9/month flat) handles server-side processing so your browser does not crash on big files.

Which Method Should You Choose?

Here is a quick comparison to help you decide:

My recommendation: Start with the CSV Merger tool for quick, one-off merges. If you need automation, set up an Apps Script. Only invest in a paid add-on if you need cross-platform integrations that justify the monthly cost.

FAQ

Can I import multiple CSV files into Google Sheets at once?

Google Sheets does not natively support batch CSV imports. However, you can merge your CSV files into one using a tool like SmoothSheet's CSV Merger, then import the single merged file. Alternatively, use Google Apps Script to automate importing from a Drive folder.

What if my CSV files have different column headers?

Use a merge tool with a "union" mode that matches columns by header name. SmoothSheet's CSV Merger handles this automatically — columns present in some files but not others will have blank values filled in for the rows from files that lack those columns.

Is there a limit to how many CSV files I can combine?

There is no hard limit on the number of files you can merge. The real constraint is Google Sheets' 10 million cell limit. Before importing, estimate your total data size (rows times columns across all files). If it exceeds the limit, use the CSV Splitter to break the merged file into manageable pieces.

How do I automate importing CSV files into Google Sheets on a schedule?

Use Google Apps Script with a time-driven trigger. After creating your import script, go to Triggers in the Apps Script editor and set it to run hourly, daily, or weekly. The script will automatically check your Drive folder and import any CSV files it finds.

Conclusion

Importing multiple CSV files into one Google Sheet does not have to be a manual, time-consuming process. For most users, the fastest path is to merge your files first with a free tool and then do a single import. If you need recurring automation, Google Apps Script gives you full control without any cost.

Need to merge your CSV files right now? Try the SmoothSheet CSV Merger — it is free, runs in your browser, and handles files with different column structures. And if your merged file is too large for a regular Google Sheets import, SmoothSheet's add-on processes it server-side so your browser stays responsive.