XLSX Append Incremental

Append new rows incrementally and emit next processing cursor based on time or primary-key column

Incrementally append new records into an existing workbook.

  • Filter incoming rows by cursor column and last cursor value
  • Supports time cursor or primary-key cursor
  • Emits updated workbook + cursor JSON in one ZIP package

Example Results

1 examples

Append Incremental Data and Emit Next Cursor

Append rows newer than last cursor and return updated workbook with cursor JSON in ZIP

xlsx-append-incremental-example1.zip View File
View input parameters
{ "baseWorkbookFile": "/public/samples/xlsx/workbook-sales.xlsx", "incrementalWorkbookFile": "/public/samples/xlsx/workbook-sales.xlsx", "targetSheetName": "Tools API", "cursorMode": "primary-key", "cursorColumn": "id", "lastCursorValue": "5" }

Click to upload file or drag and drop file here

Maximum file size: 200MB Supported formats: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, application/vnd.ms-excel

Click to upload file or drag and drop file here

Maximum file size: 200MB Supported formats: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, application/vnd.ms-excel

Key Facts

Category
Conversion & Encoding
Input Types
file, text, number, select
Output Type
file
Sample Coverage
4
API Ready
Yes

Overview

The XLSX Append Incremental tool allows you to efficiently update existing Excel workbooks by appending only new records based on a specific time or primary-key cursor. It automates the delta-loading process, ensuring your master files stay current without manual data entry or duplicate entries.

When to Use

  • •When you need to sync daily transaction logs into a master sales report.
  • •When maintaining a growing dataset where only new entries since the last update should be added.
  • •When you want to automate data consolidation while tracking the progress of your last processed record.

How It Works

  • •Upload your base workbook and the new incremental data file.
  • •Define the cursor column (e.g., 'id' or 'updated_at') and the last known value to filter incoming rows.
  • •The tool identifies rows newer than your cursor and appends them to the target sheet.
  • •Download the resulting ZIP file containing the updated workbook and a JSON file with the new cursor position.

Use Cases

Automating weekly inventory updates from incoming supplier spreadsheets.
Consolidating fragmented customer feedback logs into a single master database.
Syncing time-stamped sensor data into a centralized performance tracking workbook.

Examples

1. Incremental Sales Data Sync

Data Analyst
Background
A sales team generates a new export file every day. The analyst needs to add only the new sales records to the master annual report.
Problem
Manually copying and pasting new rows daily is prone to errors and duplication.
How to Use
Set the cursor mode to 'primary-key', select the 'id' column, and input the last processed ID (e.g., 5).
Example Config
cursorMode: primary-key, cursorColumn: id, lastCursorValue: 5
Outcome
The tool appends all records with an ID greater than 5 to the master workbook and provides the new maximum ID in the output JSON.

2. Updating Time-Series Logs

Operations Manager
Background
An operations manager receives hourly status updates from a production line in separate Excel files.
Problem
The master log needs to be updated continuously without re-importing historical data.
How to Use
Set the cursor mode to 'time', specify the 'updated_at' column, and provide the timestamp of the last update.
Example Config
cursorMode: time, cursorColumn: updated_at, lastCursorValue: 2026-03-01T00:00:00Z
Outcome
Only rows with a timestamp later than the provided value are appended, keeping the master log clean and up-to-date.

Try with Samples

xml, xlsx, xls
XLSX Samples
Sample XLSX spreadsheets for worksheet parsing and data extraction testing
title token xlsx
xlsx, xls
Copyright-Free AAC Audio Samples
High-quality AAC encoded audio samples for testing and development, featuring nature sounds and meditation music with excellent compression
preferred input family xlsx
xlsx
Copyright-Free OGG Vorbis Audio Samples
Open-source OGG Vorbis audio samples for testing and development, featuring excellent compression with nature sounds and meditation music
preferred input family xlsx
xlsx
Nginx Log Parser Samples
Comprehensive Nginx log samples for testing log-parser tool, including access logs and error logs with various formats and scenarios
matched family xml
xml

Related Hubs

XML Conversion, Mapping, and XPath Tools
Curated tools for XML conversion, mapping, merging, and XPath extraction in one hub.
Excel and XLSX Data Automation Tools
Convert, clean, reshape, import, export, and report on Excel or XLSX workbooks with tools for spreadsheet ETL and reusable business reporting.

FAQ

What file formats are supported?

The tool supports standard Excel formats including .xlsx and .xls.

How does the tool identify new data?

It compares the values in your chosen cursor column against the 'Last Cursor Value' provided and only appends rows that exceed that value.

Can I choose which sheet to append to?

Yes, use the 'Target Sheet Name' field to specify exactly where the new rows should be added.

What is returned after processing?

You receive a ZIP file containing the updated Excel workbook and a JSON file that provides the latest cursor value for your next update.

Is there a limit to the file size?

The tool supports files up to 200MB.

API Documentation

Request Endpoint

POST /en/api/tools/xlsx-append-incremental

Request Parameters

Parameter Name Type Required Description
baseWorkbookFile file (Upload required) Yes -
incrementalWorkbookFile file (Upload required) Yes -
targetSheetName text No -
headerRow number No -
cursorMode select No -
cursorColumn text Yes -
lastCursorValue text No -

File type parameters need to be uploaded first via POST /upload/xlsx-append-incremental to get filePath, then pass filePath to the corresponding file field.

Response Format

{
  "filePath": "/public/processing/randomid.ext",
  "fileName": "output.ext",
  "contentType": "application/octet-stream",
  "size": 1024,
  "metadata": {
    "key": "value"
  },
  "error": "Error message (optional)",
  "message": "Notification message (optional)"
}
File: File

AI MCP Documentation

Add this tool to your MCP server configuration: 

{
  "mcpServers": {
    "elysiatools-xlsx-append-incremental": {
      "name": "xlsx-append-incremental",
      "description": "Append new rows incrementally and emit next processing cursor based on time or primary-key column",
      "baseUrl": "https://elysiatools.com/mcp/sse?toolId=xlsx-append-incremental",
      "command": "",
      "args": [],
      "env": {},
      "isActive": true,
      "type": "sse"
    }
  }
}

You can chain multiple tools, e.g.: `https://elysiatools.com/mcp/sse?toolId=png-to-webp,jpg-to-webp,gif-to-webp`, max 20 tools.

Supports URL file links or Base64 encoding for file parameters.

If you encounter any issues, please contact us at [email protected]