Merge and match spreadsheets
Append tables by column name or match two spreadsheets by key, then export CSV or XLSX.
Instructions and limits
- Add CSV, TSV or XLSX files and confirm each worksheet.
- Append rows, or select two tables and their matching columns; inspect statistics and preview before exporting.
Up to 10 files and 20 MB total. Each table and result: 20,000 rows, 200 columns, 200,000 cells. Appends align column names and leave missing cells blank. Left joins retain left rows; non-empty right keys must be unique, and blank keys never match. Styles are discarded; formulas use cached results only.
Use cases and example
Combine spreadsheets from different days, locations or channels, or enrich order rows with fields matched by an identifier.
Use orders as the left table and one customer record per ID as the right table. Match customer ID columns to keep all orders and add available details.
Column names are case-sensitive and trimmed. Duplicate right keys are rejected rather than silently choosing a row. Unmatched counts are shown. Cell data is processed without preserving workbook styles.