Withdata DataFileConverter merges Excel files into one yaml file locally — any number of files, mapped column by column, with the output options of your choice. 100% local, secure, and cross-platform.

Why Choose Withdata DataFileConverter as a Excel Merger?

🔒 100% Local & Secure

All merging runs on your own computer. Nothing is uploaded to any cloud server.

⚡ Fast Streaming Merge

Millions of rows within a minute. Large files are streamed with low memory usage.

📁 Any Number of Files

Add two files or a whole folder, then combine everything into a single YAML file.

🔄 Column Mapping

Files with a different column order or extra columns can be mapped to the output columns before merging.

🖥 Windows, macOS, Linux

Native builds for Windows, macOS and Linux, with a step-by-step GUI wizard and a command line interface.

⏱ CLI & Scheduled Tasks

Save a merge session and run it automatically from Windows Task Scheduler or crontab.

Full Feature Comparison

Feature	Supported details
Input	Any number of Excel files, added one by one or as a folder
Output format	YAML with configurable indent (2 spaces by default) and flow style
Merge mode	All input rows into one output file
Running mode	GUI wizard · command line · scheduled tasks
Column handling	Source columns are mapped to the output columns
Output options	Indent (2 spaces by default), flow style, nested mappings
Platform	Windows, macOS, Linux (native, 64-bit)

Excel to YAML — What Changes

Each sheet row becomes one YAML mapping. Dates leave as formatted text rather than as spreadsheet serial numbers, and formulas are replaced by their results.

All Excel Merge Options You Need

Merge several Excel files into one YAML file — step by step in the GUI wizard
Merge a whole folder of Excel files in one run
Map the columns of each input file to the output columns
Run the merge from the command line, and schedule it as a scheduled task
All Excel tools and all YAML tools

Same source format, other targets

This page merges Excel into another format. If you need a different output, these pages each do that one job:

All merge tools, by format

Merging into YAML — Notes

Each merged row is written as one mapping in a top-level YAML sequence.
The output indent is 2 spaces by default and can be changed; flow style ({ } / [ ]) can be toggled.
Column names that contain dots (for example address.city) can be written back as nested mappings.
When reading YAML: a top-level sequence of mappings is one row per mapping, nested mappings become dotted column names, and anchors/aliases/tags/multi-document files are not supported.

How to Merge Excel Files (4 Steps)

Open Withdata DataFileConverter and choose Merge (combine multiple files into one).
Add the Excel files you want to merge — two files, a list, or a whole folder.
Check the preview and map the source columns to the output columns; then set the output options (Indent (2 spaces by default), flow style, nested mappings).
Click Convert — the single YAML file is written in seconds. Save the session if you want to run it again from the command line.