📊 Excel Analytics Platform

Upload any Excel file → Get instant charts + AI-powered insights

A full-stack MERN application that lets users upload Excel/CSV files, visualize data as interactive charts, and receive AI-generated summaries — all secured with JWT authentication and role-based access control.

Most teams spend hours manually reading Excel reports and building charts. Excel Analytics Platform eliminates that entirely:

1. Upload any .xlsx or .csv file
2. Visualize data instantly as bar, line, pie, or area charts
3. Download charts as images
4. Read an AI-written plain-English summary of your data
5. Manage your full upload history from a personal dashboard

No data science expertise needed. No Excel formulas. Just upload and go.

• JWT-based authentication with protected routes
• Passwords hashed with bcrypt
• Role-based access control (Admin / User)
• Token expiry and refresh handling

excel-analytics-platform/
│
├── client/                          # React frontend
│   ├── public/
│   └── src/
│       ├── assets/                  # Images & static files
│       ├── components/              # Reusable UI components
│       │   ├── charts/              # Bar, Line, Pie, Area chart components
│       │   ├── admin/               # Admin-only components
│       │   └── shared/              # Navbar, Footer, ProtectedRoute
│       ├── pages/
│       │   ├── LandingPage.jsx      # Public landing page
│       │   ├── Dashboard.jsx        # User dashboard
│       │   ├── UploadHistory.jsx    # File history
│       │   ├── Profile.jsx          # User profile settings
│       │   └── admin/
│       │       ├── AdminDashboard.jsx
│       │       ├── UserDetails.jsx
│       │       └── Messages.jsx
│       ├── context/                 # Auth context (JWT state)
│       ├── hooks/                   # Custom React hooks
│       └── utils/                   # Axios instance, helpers
│
└── server/                          # Express backend
    ├── config/                      # DB connection, env config
    ├── controllers/                 # Route logic
    │   ├── authController.js        # Register, login, forgot password
    │   ├── fileController.js        # Upload, parse, process Excel
    │   ├── chartController.js       # Chart data generation
    │   ├── aiController.js          # OpenRouter LLM integration
    │   └── adminController.js       # Admin-only routes
    ├── middleware/
    │   ├── authMiddleware.js        # JWT verification
    │   └── roleMiddleware.js        # Admin/User role guard
    ├── models/
    │   ├── User.js                  # User schema
    │   ├── File.js                  # Uploaded file schema
    │   └── Message.js               # Contact form schema
    ├── routes/                      # Express routers
    └── server.js                    # Entry point

• Node.js v18+
• MongoDB (local or Atlas)
• OpenRouter API key → Get one free

git clone https://github.com/yourusername/excel-analytics-platform.git
cd excel-analytics-platform

cd server
npm install

Create a .env file inside /server:

PORT=5000
MONGO_URI=your_mongodb_connection_string
JWT_SECRET=your_super_secret_jwt_key
JWT_EXPIRES_IN=7d
OPENROUTER_API_KEY=your_openrouter_api_key
EMAIL_USER=your_gmail@gmail.com
EMAIL_PASS=your_gmail_app_password
CLIENT_URL=http://localhost:5173

npm run dev       # Starts backend on http://localhost:5000

cd ../client
npm install

Create a .env file inside /client:

VITE_API_URL=http://localhost:5000/api

npm run dev       # Starts frontend on http://localhost:5173

http://localhost:5173

Try the live app instantly — no signup needed:

🔗 Live URL: https://excel-analytics-platform-zidio.netlify.app/

(Add screenshots of your dashboard, chart view, AI summary panel, and admin dashboard here)

Landing Page	User Dashboard

Chart View	Admin Dashboard

This project uses the OpenRouter API to generate plain-English summaries of uploaded Excel data.

How it works:

1. After a file is parsed, key statistics (row count, column names, min/max/avg values) are extracted
2. A structured prompt is sent to the LLM via OpenRouter
3. The model returns a human-readable summary of trends, outliers, and insights
4. The summary is stored in MongoDB and can be downloaded by the user

// Example prompt sent to LLM
const prompt = `
  You are a data analyst. Analyze this Excel data summary and provide 
  clear insights in plain English (3-5 sentences):
  
  Columns: ${columns.join(', ')}
  Total Rows: ${rowCount}
  Key Stats: ${JSON.stringify(stats)}
  
  Highlight trends, notable values, and any actionable insights.
`;

JWT Authentication Flow

• Access token stored in localStorage, attached to every API request via Axios interceptor
• Protected routes use a ProtectedRoute wrapper component
• Forgot password sends a signed reset token via email (expires in 15 minutes)

Excel Parsing Pipeline

• File uploaded via multer → saved to server
• Parsed with SheetJS (xlsx) → converted to JSON
• Rows stored in MongoDB with status: pending → processing → processed

Role-Based Access Control

• Two middleware layers: verifyToken (checks JWT) + requireAdmin (checks role)
• Admin routes are completely inaccessible to regular users at both frontend and backend level

Chart Data Generation

• Raw JSON rows are aggregated server-side by column
• Sent to frontend where Recharts renders bar, line, pie, or area charts
• Chart export uses html2canvas to capture the chart DOM node as a downloadable PNG

• Google OAuth login
• Real-time collaboration on shared dashboards
• Email scheduled reports (weekly/monthly)
• Support for multi-sheet Excel files
• Dark mode UI

This project is licensed under the MIT License — see the LICENSE file for details.