YYTOOLS / THE EVERYDAY TOOLBOX
CSV Workflow
Map fields, clean rows and join two tables in one run. Reuse local rules.
Processed locally · No upload · No sign-up
Put your tables to work
Map → clean → deduplicate → join → export, in one run.
0 / 2,000,000 characters · UTF-8 · 5 MiB
Configure once. Run again.
Read headers to choose output fields. Reading again resets mappings; editing data preserves your rules.
Save rules for next time
Only field names and options are saved in this browser, never input data. Up to 20 templates; saving the same name replaces it.
How to use
- Paste or import the main CSV and read its headers. Add a second CSV when joining.
- Adjust options, run the tool, then check the preview or error message.
- Review row and column counts, then copy or download the complete result. Run again after editing input.
Read main-table headers, select fields, rename, reorder and trim. Remove empty rows, deduplicate, then join a lookup table. Use mapped names for main keys. Empty keys never match; lookup values match exact text and use the lookup. field prefix. Duplicate keys can raise an error, use the first match or expand all matches. Templates save rules locally. Field names must be non-blank and at most 1,000 characters; incompatible rule versions are rejected.
Previews show up to 50 rows; downloads contain all results. Limits: 5,000 data rows, 200 columns, 100,000 data cells and 5 MiB per file. Combined exported text and text read from Excel are limited to 10,000,000 characters. Exceeding a limit raises an error; data is truncated only when "Truncate long cells" is enabled, with a count shown.