ngetichishmael/csv-phone-validator

Smart CSV cleaner with Kenya phone number validation | Nuxt 3 + TypeScript | Bulk SMS & CRM tool # CSV Phone Validator > Smart CSV data cleaner with Kenya phone number validation, built with Nuxt 3 and TypeScript A production-ready web application that validates, cleans, and formats CSV data with focus on Kenya mobile phone number validation. Perfect for bulk SMS services, airtime distribution, and customer data management. 🌐 **Live Demo**: csv-phone-validator.netlify… ## ✨ Features ### Core Functionality - 📤 **CSV Upload**: Drag-and-drop or click to browse - ✅ **Smart Phone Validation**: Validates and formats Kenya mobile numbers to `+2547XXXXXXXX` - 🎨 **Visual Error Highlighting**: Color-coded rows (green=valid, red=invalid, yellow=duplicate) - ✏️ **Inline Editing**: Double-click phone numbers to fix errors in real-time - 📄 **Pagination**: Navigate through large datasets with configurable page size (25-500 rows) - 📊 **Sort by Bundle Size**: One-click sorting by package/bundle column - 💾 **Clean Data Export**: Download cleaned CSV with only valid rows ### Advanced Features - 🔍 **Duplicate Detection**: Automatically identifies duplicate phone numbers - 📈 **Real-time Statistics**: Live dashboard showing validation success rate - 💰 **Balance Analysis**: Check available units vs required units with visual warnings - 📱 **Telco Identification**: Detects Safaricom, Airtel, and Telkom numbers - 🔬 **Scientific Notation Support**: Handles Excel's scientific notation (e.g., `2.54708E+11`) - 🎯 **Smart Auto-Fix**: Handles leading zeros, missing prefixes, and various formats ## 🚀 Quick Start ### Prerequisites - Bun 1.0+ installed - Node.js 18+ (optional) ### Installation ```bash # Clone the repository git clone github.com cd csv-phone-validator # Install dependencies bun install # Start development server bun run dev ``` Visit **http://localhost:3000** and start cleaning your CSV files! ### Quick Test 1. Upload the included `public/Sample Dataset.csv` (5000+ rows) 2. See instant validation w …