# XLSX Append Incremental

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

> Canonical page: https://elysiatools.com/en/tools/xlsx-append-incremental

- **Category:** Format Conversion

- **Keywords:** xlsx, incremental, append, cursor, etl, delta

## Overview

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

## Inputs

- **Base Workbook** (file)
- **Incremental Workbook** (file)
- **Target Sheet Name** (text): Sheet1
- **Header Row** (number)
- **Cursor Mode** (select)
- **Cursor Column** (text): updated_at or id
- **Last Cursor Value** (text): 2026-03-01T00:00:00Z or 1000

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

## Frequently asked questions

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

## Related tools

- [XLSX Column Mapper](https://elysiatools.com/en/tools/xlsx-column-mapper): Rename, reorder, and drop Excel columns with alias matching and case/whitespace normalization
- [XLSX Formula Injector](https://elysiatools.com/en/tools/xlsx-formula-injector): Fill formulas down worksheet columns and optionally lock formula cells for protected, template-friendly Excel workbooks
- [XLSX Freeze Pane Manager](https://elysiatools.com/en/tools/xlsx-freeze-pane-manager): Freeze top rows/left columns automatically and apply row or column outline groups for easier spreadsheet reading
- [XLSX Parquet Exporter](https://elysiatools.com/en/tools/xlsx-parquet-exporter): Export worksheet data to Parquet and/or NDJSON for data lake and data warehouse pipelines
- [XLSX SQL Insert Generator](https://elysiatools.com/en/tools/xlsx-sql-insert-generator): Read Excel headers and rows to generate SQL INSERT statements for bulk loading
- [XLSX Workbook Merger](https://elysiatools.com/en/tools/xlsx-workbook-merger): Merge multiple similarly structured workbooks as multiple sheets or append all rows into one sheet
- [Time Series Anomaly Detector](https://elysiatools.com/en/tools/time-series-anomaly-detector): Upload CSV or JSON time series data, detect anomalies with Z-Score and IQR methods, and return a chart-backed report
- [XLSX CSV Batch Converter](https://elysiatools.com/en/tools/xlsx-csv-batch-converter): Batch convert CSV/TSV to XLSX or convert XLSX back to CSV/TSV with delimiter and encoding handling

## Samples

- [XLSX Samples](https://elysiatools.com/en/samples/xlsx-samples): Sample XLSX spreadsheets for worksheet parsing and data extraction testing
- [XLS Samples](https://elysiatools.com/en/samples/xls-samples): Sample legacy Excel (XLS) files for binary spreadsheet parsing and import tests
- [Nginx Log Parser Samples](https://elysiatools.com/en/samples/nginx-log-samples): Comprehensive Nginx log samples for testing log-parser tool, including access logs and error logs with various formats and scenarios
- [Android Serialization Java Samples](https://elysiatools.com/en/samples/android-serialization-java): Android Java serialization examples including JSON serialization, deserialization, and XML parsing

## Related content

- [XLSX ETL Ingestion and Warehouse Handoff](https://elysiatools.com/en/hubs/xlsx-etl-ingestion-workflows): Turn mixed workbook and CSV sources into traceable, schema-aware outputs for SQL loading, Parquet pipelines, and object-storage batch handoff.
