🧩 Column Crusher by MHT

A fast and powerful web-based tool for cleaning, splitting, merging, and transforming spreadsheet columns.

Column Crusher is a lightweight, browser-based data-processing tool built with PHP + JavaScript.
It helps users instantly clean, restructure, split, and optimize messy CSV/Excel data — without needing complicated formulas or macros.

---

🚀 Features

🔹 1. Upload & Parse

• Upload CSV files instantly
• Automatic delimiter detection
• Safe parsing using fgetcsv
• No data stored on server (privacy friendly)

🔹 2. Column Cleaner

• Remove empty rows
• Delete duplicate rows
• Trim extra spaces
• Normalize capitalization
  • UPPERCASE
  • lowercase
  • Title Case

🔹 3. Column Splitter

Split a single column into multiple columns using:

• Comma ,
• Space " "
• Semicolon ;
• Tab
• Custom delimiter

🔹 4. Column Merger

Merge any selected columns using:

• Space
• Comma
• Dash
• Custom separator

Includes:

• Auto-trim
• Automatic whitespace cleanup

🔹 5. Text Processing Tools

• Find & replace
• Remove symbols
• Extract only numbers
• Extract only letters
• Remove HTML tags
• Fix encoding issues

🔹 6. Smart Filters

• Filter rows by keyword
• Remove rows containing specific words
• Keep only rows matching patterns
• Supports case-insensitive & regex filters

🔹 7. Export Results

• Download cleaned CSV
• No server storage
• One-click export

---

🧰 Tech Stack

Component	Technology
Backend	PHP 8.x
Frontend	HTML5, CSS3, Bootstrap 5
Interaction	Vanilla JavaScript
Parsing	PHP fgetcsv()
Deployment	Any LAMP/LEMP environment

---

🖼️ Screenshots (Recommended)

Add example demo screenshots in a /screenshots folder, such as: