Line Item Categorization Tool

A full-stack web application for processing and categorizing construction/project line items.

Features

• 📁 Upload CSV/Excel files or paste data directly
• 📑 Multi-sheet Excel support with sheet selection
• 🤖 AI-powered description generation
• 🏷️ Automatic categorization into 14 service types
• 📊 Duplicate detection and statistics
• 📋 Copy data by service type or all at once
• 👁️ View items by service in modal
• 💾 Export to Google Sheets compatible format

Installation

1. Install Python dependencies:

pip install -r requirements.txt --break-system-packages

2. Run the application:

python app.py

3. Open your browser and navigate to:

http://localhost:5000

Usage

1. Enter client/project name
2. Upload Excel/CSV file or paste data
3. Select sheets to process (for Excel files)
4. Click "Process & Categorize"
5. View results and copy to clipboard

Service Types

• Electrical
• Carpentry
• Plumbing
• Civil Glass
• Painting
• HVAC
• Fabrication
• Signage
• Fire/FAS
• Cleaning
• CCTV
• Inverter/UPS
• Pest Control
• Civil

API Endpoints

• POST /api/process - Process line items
• POST /api/sheets - Get sheet names from Excel file

Tech Stack

• Backend: Flask (Python)
• Frontend: HTML, CSS, JavaScript
• Data Processing: Pandas, OpenPyXL