Lovable Prompt Creator - AI Prompt Generator

## APPLICATION OVERVIEW
The application is a web tool that allows users to upload images, PowerPoint presentations, or PDFs and uses AI to analyze the content of these files. The extracted data is then converted into a CSV format, which can be exported to Excel. Users can further edit the Excel file with functionalities such as adding new columns and rows, deleting, and moving rows and columns.

## CORE FEATURES
1. **File Upload**: Users can easily upload images, PPTs, or PDFs for analysis.
2. **AI Data Extraction**: The application employs AI algorithms to analyze the uploaded files and extract relevant data into a CSV format.
3. **CSV to Excel Conversion**: Automatically converts the generated CSV into an Excel file, allowing users to download it.
4. **Excel Editing Interface**: Users can edit the Excel file directly within the application, including adding/deleting rows and columns and moving data.
5. **User Authentication**: Secure user accounts to save and retrieve files and settings.
6. **History Log**: A feature that tracks previously uploaded files and conversions for easy access.

## DESIGN SPECIFICATIONS
- **Visual Style**: Minimalist - Clean and simple design with plenty of white space to enhance readability and focus on functionality.
- **Color Mode**: Light theme with dark text on light backgrounds to ensure high contrast and readability.
- **Layout**: A single-page layout featuring a header with navigation, a main section for file uploads, an AI analysis area, and a results display section. The footer will include contact information and links to support.
- **Typography**: Use a modern sans-serif font for headings (e.g., 'Roboto' or 'Open Sans') with a hierarchy that distinguishes between headings, subheadings, and body text.

## TECHNICAL REQUIREMENTS
- **Framework**: React with TypeScript for building the user interface.
- **Styling**: Tailwind CSS for utility-first styling, ensuring quick and responsive design adjustments.
- **UI Components**: Utilize shadcn/ui for pre-built UI components that align with the minimalist aesthetic.
- **State Management**: Use Context API or Zustand for managing global state where necessary.

## IMPLEMENTATION STEPS
1. **Set Up Project**: Initialize a new React project with TypeScript and install required dependencies (React, Tailwind CSS, shadcn/ui).
2. **Create File Upload Component**: Develop a user-friendly file upload component that handles different file types.
3. **Implement AI Data Extraction**: Integrate AI functionalities to analyze files and extract data into a CSV format.
4. **Develop CSV to Excel Conversion Logic**: Build the backend logic that takes the generated CSV and converts it into an Excel file for download.
5. **Design Excel Editing Interface**: Create a responsive interface that allows users to edit the Excel sheet directly, incorporating drag-and-drop functionality for moving rows/columns.
6. **Implement User Authentication**: Set up user accounts with secure login/logout functionality to save user progress and file histories.
7. **Testing and Optimization**: Conduct thorough testing for usability and performance, optimizing for responsiveness across devices.

## USER EXPERIENCE
Users will access the application via a clean landing page with an intuitive layout. They can upload their files through a prominent upload button. Once files are uploaded, a progress indicator will show the AI analysis status. After conversion, users will be redirected to the editing interface, where they can easily modify their data. The application will maintain a history of uploads for quick re-access, enhancing the overall user experience. The minimalist design ensures that users can navigate the application without distractions, focusing on their tasks efficiently.