Interactive controls could not load. Reload this page to try again; the content and guides below are still available.
Reload pageData Studio
Combine XLSX, CSV and TSV tables by column name for free. Review header mappings and source rows, then export one table or split records by a chosen field.
YOUR WORKSPACE
Combine XLSX, CSV and TSV tables by column name for free. Review header mappings and source rows, then export one table or split records by a chosen field.
Collect department lists. Map Employee and Name to Name, and Team and Department to Department. The merged table should align these values while source columns locate the original file, worksheet and row.
Up to 30 files / 50 MB total, 10 MB per file, 50,000 rows, 200 columns and 1 million cells. Split into up to 200 groups. Exports contain cell values, without original formatting, pictures, macros or formulas. Formula cells need saved calculated values. Legacy XLS and scanned tables are not supported. Use UTF-8 CSV/TSV and store leading-zero identifiers as text in Excel.
Only matching names after trimming surrounding whitespace align automatically. Review and rename synonyms yourself to avoid combining different business meanings.
All records are retained by default. Select deduplication keys to retain the first matching record. Records with any blank key value remain for review.
Review the reason, repair and reimport. To process only successfully read sources, explicitly confirm that choice; failed data is excluded.
Prefer XLSX, which stores output cells as text. CSV retains characters, but opening it directly in Excel may convert identifiers to numbers. Import it as text and set identifier columns to text.
Inputs and the preview remain only in this page session. Download or explicitly save to this browser’s result library. Use downloaded files to move between devices.
Use this tool for free without a KitNelo account. Processing runs in your browser; input limits, browser support and device memory still apply.
Merge values and check mappings; original workbook formatting and formula evaluation are not retained.
Read KitNelo data and privacy detailsSelect the worksheets to combine and align their values by column names rather than physical position. Review header mappings and source rows before export; the merged table preserves values, while original workbook formatting and formula evaluation are not retained.
Load CSV or TSV sources and inspect how their headers map into a shared table. Check similarly named fields and missing columns before downloading the combined values, especially when exports use different units or represent identifiers as numbers.
Choose a field from the reviewed combined table to divide its rows into separate outputs. Inspect blank or inconsistent grouping values before export, since spelling differences can create unintended groups that look like separate departments, products or reporting periods.
