Home Install Functions Blog Pricing About

SheetFlash Functions

Basic
  • Copy and Paste
  • Native Formulas
  • Text
  • Insert Rows/Columns
  • Delete Rows/Columns
  • Clear
Visualization / Format
  • Chart
  • Format as Table
  • Bar Chart Race
  • Hierachical Tree
Text Processing
  • Join Texts
  • Replace Words
  • Replace by Regex
  • Sort Letters
  • Trim
  • Insert Letters
Text Extraction
  • Extract Segmented Strings
  • Extract Words
  • Extract by Regex
Data Analysis
  • Countifs
  • Sumifs
Table Manipulation
  • Deduplicate
  • Expand
  • Fill Empty
  • Filter
  • Group
  • Sort
  • Deduplicate Hierarchical Categories
Join / Lookup
  • Lookup
  • Join Tables
AI
  • Generative AI
Date and Time
  • Convert Number to Date
Sheet Processing
  • Merge Sheets
  • Add Sheets
  • Delete Sheets
File Processing
  • Merge Files
  • Split File

Merge Files

Category: File Processing Updated at: 2024-02-12

The Merge Files function is a feature that allows you to combine two or more files(unlimited) into a single file.

See it in Action

Requirements

Data

  • Data Input: Drag and drop the files you want to merge.

  • Merge Pattern

    • One Sheet: Merges all files into a single sheet.

    • Separated Sheets: Keeps each file's data on different sheets in one workbook.

  • Merge Direction (Only for One Sheet)

    • Vertical: Stacks the data from each file on top of the last.

    • Horizontal: Places the data from each file next to the last.

Result Destination

  • CSV File: Merges files into a CSV.

  • Excel File: Keeps the merged file in Excel format.

  • Specify Start Cell: Choose where in the sheet your merged data begins.

  • New Sheet: Output each file to be merged as a new sheet in the currently open Excel file.

Limitation

  • File Size: Depends on your subscription.

    • Free account: 5MB

    • Standard: 100MB

    • Premium: 500MB

  • File Types Supported: Currently, the function only supports files with the .xlsx, .xls, and .csv extensions.

Related Articles and Topics

Sheet Processing
November 29, 2024

How to Add Excel Sheets in Bulk for Free?

Sheet Processing
November 28, 2024

How to Merge Excel Sheets into One Sheet in Bulk for Free?

File Processing
November 27, 2024

How to Split an Excel / CSV File into Multiple Files for Free?

File Processing
November 26, 2024

How to Merge Multiple Excel / CSV Files for Free?

SheetFlash Product
September 18, 2024

Is Excel Slow? Crashing? The Reasons Why and a Fast, Simple No-Code Solution | SheetFlash

SheetFlash Product
September 17, 2024

Accelerate DX with Excel Workflow Visualization and Automation | How to Achieve It with the No-Code Tool SheetFlash

SheetFlash Product
September 16, 2024

Master Excel Automation Without Coding: The Ease of Use of SheetFlash

SheetFlash Product
September 15, 2024

No VBA, No Python: Advanced Excel Data Transformation | SheetFlash

Table Manipulation
June 28, 2024

How to Expand Data in Excel in Bulk for Free?

Table Manipulation
June 25, 2024

How to FIlter Big Data in Excel in Bulk for Free?

Table Manipulation
June 25, 2024

How to Group Big Data in Excel in Bulk for Free?

Table Manipulation
June 25, 2024

How to Sort Big Data in Excel in Bulk for Free?

Previous Next
Home Install Functions Blog Pricing About

© 2025 SheetFlash Ltd. All rights reserved.