EXCEL GENIE

Objective

To create an AI-powered web application that automates the conversion of handwritten attendance sheets—from images or PDFs—into structured, ready-to-use Excel files, eliminating manual data entry and reducing errors.

Excel Genie

Excel Genie is an AI-powered web application designed to streamline the attendance recording process. It leverages cloud-based Optical Character Recognition (OCR) and custom data processing algorithms to accurately extract and organize data from uploaded images and PDF documents of handwritten records.

What We've Done

• Web Application Development: Built a responsive and user-friendly single-page application using React.
• File Handling: Implemented robust file upload functionality, including drag-and-drop support for images (JPG, PNG, etc.) and multi-page PDF documents.
• OCR Integration: Integrated Microsoft Azure's Vision API to perform high-accuracy text extraction.
• Custom Parsing Logic: Developed sophisticated algorithms (processOCRText) to interpret OCR output and extract employee data, overtime hours, work types.
• Data Structuring & Export: Created functions (createFinalJSON) to transform extracted data into JSON and Excel.
• UI/UX Enhancements: Added previews, progress bars, status messages, dark/light theme.

Development Process

• Analysis: Identified the problem of manually transcribing handwritten sheets.
• Prototyping & Logic Development: Built and tested core OCR parsing with multiple test scripts.
• Frontend Implementation: Built React-based UI (MainApp.js) with upload → process → download workflow.
• Feature Expansion: Added PDF support via convertPdfToImages.
• Refinement & Finalization: Iteratively improved UI and algorithms for accuracy and UX.