Lovable Prompt Creator - AI Prompt Generator

## APPLICATION OVERVIEW
This web application is designed to provide a seamless service for users to upload CSV and XLS files, automatically correcting data formatting issues and removing unnecessary entries, such as those lacking email addresses. The purpose is to prepare clean and structured data for easy import into HubSpot, streamlining the process for users who handle large datasets.

## CORE FEATURES
1. **File Upload Functionality**: Users can drag and drop or browse to upload CSV and XLS files for processing.
2. **Data Formatting Correction**: The application automatically corrects common formatting issues, including standardizing telephone numbers.
3. **Data Validation**: It checks for and removes entries that do not meet specified criteria, such as records without email addresses.
4. **Preview and Edit**: Users can preview the cleaned data and make manual adjustments before finalizing the import.
5. **Download Processed File**: After the data has been validated and cleaned, users can download the modified file in a ready-to-import format.
6. **Integration Instructions**: The app provides clear instructions on how to import the cleaned data into HubSpot.

## DESIGN SPECIFICATIONS
- **Visual Style**: minimalist - Clean, simple design with plenty of white space, minimal color palette, and focus on typography
- **Color Mode**: Light theme with dark text on light backgrounds
- **Primary Color**: #1978E5 (accent for buttons, links, highlights)
- **Typography**: Use Inter from Google Fonts for headings, Inter for body text and UI elements
- **Border Radius**: 8px (moderately rounded) for buttons, cards, and inputs
- **Layout**: The main layout will feature a top navigation bar, a central upload area, a data preview section, and a footer with integration instructions. The upload area will be prominently displayed, encouraging user interaction.

## TECHNICAL REQUIREMENTS
- **Framework**: React with TypeScript
- **Styling**: Tailwind CSS
- **UI Components**: shadcn/ui
- **State Management**: React Context API for managing application state related to file uploads and data processing.

## IMPLEMENTATION STEPS
1. **Set Up React Project**: Initialize a new React project with TypeScript and install Tailwind CSS and shadcn/ui.
2. **Create File Upload Component**: Implement a drag-and-drop file upload area using an appropriate library or native HTML elements.
3. **Develop Data Processing Logic**: Create functions to read and process CSV/XLS files, including data formatting corrections and validations.
4. **Implement Preview Feature**: Add a section to display the cleaned data in a table format, allowing users to review and edit entries before downloading.
5. **Add Download Functionality**: Implement functionality to convert the processed data back into a CSV/XLS format for download.
6. **Build Integration Instructions**: Create a footer section with clear instructions on importing the cleaned data into HubSpot.

## USER EXPERIENCE
Users will begin by uploading their files through the prominent upload area. Once a file is uploaded, the application will automatically process the data, allowing users to see a preview of the cleaned data. Users can make any necessary edits before downloading the final version. The integration instructions will guide users through the import process into HubSpot, ensuring a smooth transition from data cleaning to data usage. The minimalist design will facilitate easy navigation and a straightforward user experience, focusing on the task at hand without distractions.