Fill a workbook

Group transactions by period and preview the changes before downloading a new copy.

Files stay on this device

Files

Source transactions

CSV or values-only XLSX, up to 5 MB

Workbook to fill

XLSX, up to 10 MB

Source columns

Amount Date Date format Group by

Matching keys

Every key must match. Alternate columns can also contribute. Excel dates match by day; use text for timestamps and long identifiers.

Ignore letter case in matching keys only

Source filters

Target rows and periods

First data rowLast data row

Map each source period to its target column. Existing values and formulas are never overwritten.

Reusable setups

Saved setup

Setup nameImport setup

Setups include column names and filter values, not spreadsheet rows. Protect exported setup files accordingly.

Up to 10,000 source rows, 10,000 selected target rows, 100,000 target cells and 10,000 updates. Unsupported workbook features are rejected during preview.

The selected rows cover this period, and amounts use the same unit and currency.

Review changes

Proposed workbook changes
Cell	Period	Amount	Source records	Result

The download is a new workbook. Reconcile preserves formulas but does not recalculate them; cached results can be stale. Recalculate in your spreadsheet app before relying on the copy. Source record numbers exclude the header and empty rows.