Securely merge data from Excel, CSV, or pasted lists into any custom template. 100% client-side, no data is uploaded.
Welcome to the most powerful, secure, and free data formatting tool on the web. This is not just a simple text cleaner; it's a full-fledged application designed to **consolidate multiple CSV files into one**, perform **multi-column data merge** operations, and format your data to any specification. And the best part? It's all 100% client-side. Your sensitive data never leaves your browser.
Whether you're a marketer, a developer, or an analyst, you know the pain of manual data work. You have one CSV of user data, another from a sales report, and you need to combine them. Or you have a list of 1,000 email addresses from Excel and need to turn them into personalized SQL queries. This tool was built to solve that exact problem in seconds, not hours.
We've designed this tool to be a simple 3-step workflow: Input, Control, and Output. Here’s how you can **consolidate multiple CSV files** and format your data.
You have two options to get your data into the Refinery:
This is where the magic happens. The middle column gives you full control over your data with simple, tabbed controls:
In the "Template" tab, you'll find the "Your Template" box. This is where you define your final output. Write your text and insert placeholders (like `{{Name}}` or `{{col1}}`) for each column. The "Output" box on the right will update in real-time, showing you exactly what your formatted text looks like. When you're done, just click the "Copy to Clipboard" button.
See how this tool can save you time with real-world examples.
Stop manually formatting text for your database. You can perform a **multi-column data merge** to build hundreds of queries instantly. Paste a CSV of `ID` and `Email` to generate `UPDATE` statements.
Input Data (Pasted from CSV):
101,john@test.com
102,jane@test.com
Template (using {{col1}} and {{col2}}):
UPDATE users SET email = '{{col2}}' WHERE id = {{col1}};
Instant Output:
UPDATE users SET email = 'john@test.com' WHERE id = 101;
UPDATE users SET email = 'jane@test.com' WHERE id = 102;
Quickly create hundreds of personalized lines for an email campaign or outreach list. This is the perfect **client-side mail merge**.
Input Data (with header row):
Name,City
John,New York
Jane,London
Template (using your headers):
Hi {{Name}}, how is the weather in {{City}}?
Instant Output:
Hi John, how is the weather in New York?
Hi Jane, how is the weather in London?
This page is our "Pro" application, but it's just one part of the Clipboard Refinery. We have a whole suite of fast, free, and secure "spoke" tools, each built to solve one specific problem perfectly. Explore our other tools to see how you can fascinate your workflow.
Find what's changed between two text blocks with instant highlighting.
Compare TextCheck your H1–H3 tags structure & keyword density for SEO optimization.
Analyze HeadingsConvert text to clean HTML or HTML → plain text instantly.
Convert TextConcatenate PDFs, organize pages, and convert documents.
Extract TextClean, beautify, and validate complex JSON data.
Validate JSONThis is the most important promise of our **multi-column data merge** tool. Your data's privacy is guaranteed. All processing—from parsing your CSV to merging it with the template—happens entirely within your web browser using JavaScript. **No data is ever sent to our servers.** You can disconnect your internet, and this tool will continue to work. This makes it the only truly safe way to **consolidate multiple CSV files** that contain sensitive customer, sales, or personal data.
To consolidate multiple CSV files into one, simply drag and drop all your files into the "Step 1: Input Data" box. Our tool will read them in your browser and merge their contents into a single dataset. You can then clean, map, and format this consolidated data.
Yes. This tool is 100% client-side. All data processing, including file reading and data merging, happens in your browser. No data (from your CSV, Excel sheet, or pasted text) is ever uploaded to our server, ensuring your information remains completely private and secure.
After you load your data, go to the "Mapping" tab in the "Step 2: Controls" column. The tool will show you all detected headers. You can then enter your own template names (like `{{FirstName}}` or `{{email}}`) for each column. These are the names you will use in the "Template" box.
A delimiter is the character that separates your data into columns. The most common is a comma (`,`) used in CSV files. When you copy from Excel, it's often a `Tab` character. Our tool auto-detects this, but you can force it to use a comma, tab, pipe (`|`), or semicolon (`;`).