Spreadsheet Data Processing: Merge and Split, and Import Data.

Data Import and Management

• Import CSV, JSON, XML data into Excel files
  • Supports multiple data format conversions
  • Batch data import processing
  • Field mapping and format preservation

File Merging Operation

Basic Merging Functionality

• Merge Remote Excel Files into Specified Workbook
  • Merging across cloud storage files
  • Sheet-level merging control

Batch Merging Function

• Merge Multiple Excel Files into a Single Workbook
  • Intelligent Merging of Multiple Files
  • Automatic Handling of Conflicting Data

Folder-level Merging

• Merge Excel files that match in a remote folder
  • Filter files by rules
  • Batch folder operations

File Splitting Operation

Worksheet Level Splitting

• Split an Excel file into multiple files based on worksheets
  • Each worksheet generates an independent file
  • Preserves formatting and formulas

Custom Rule Splitting

• Split Excel File According to Custom Rules
  • Split by row count, column count
  • Split by content conditions