LoadSheets

Automate the creation of customer-specific Excel "loadsheets" by merging data from multiple Excel and CSV sources into a single template — directed by a simple (end-user maintained), job-specific configuration file that's designed for automation and version control.

Learn More

LoadSheets

Benefits To Your Company

Automate repetitive new-part data file creation for retailers and distributors

Merge data from multiple Excel and CSV sources, joined transparently by part number

Handle coded ("stacked") data sources with automatic pivoting of code/value pairs

Validate data at the field level and between fields with conditional requirements

Filter rows using full Boolean expressions with runtime parameters

Generate complete error logs with cell references for both input and output files

LoadSheets

Product Features

Console application for automated/scheduled batch processing

YAML-based configuration — intuitive and version-control friendly

Multiple source files or worksheets joined by part number

Coded (stacked) data sources — multiple rows per part pivoted into template columns via lookup:code and lookup:value

Field-level data validation with configurable data types: text, number, decimal, date, price, GTIN-14, part number

Cross-field validation with conditional requirements (RequiredIf)

Boolean filter expressions with operators (==, !=, in, &&, ||) and short-circuit evaluation

Runtime parameters passed via command line for dynamic filtering

Built-in functions: Today(), Date(), DateEqual(), DateBefore(), trim, upper, lower, and more

Error highlighting in output Excel cells

Automatic date-stamped output file naming with {date} macro

Smart alphanumeric part number sorting (P9 before P10)

Supports Excel native data types or string output with “!” format prefix

LoadSheets

FAQ

What is LoadSheets?

How Is LoadSheets Configured?

Can LoadSheets Be Automated?

What Data Formats Are Supported?

What Are The System Requirements?

Where can I find more information?

LoadSheets

Purchase LoadSheets License

Renew LoadSheets License

Benefits To Your Company

Product Features

FAQ