📊 MERN Excel Analysis Platform
This is a full-stack MERN (MongoDB, Express, React, Node.js) project for uploading and analyzing Excel files. The app allows users to upload Excel sheets, parse the data, and perform basic analytics or visualizations on the uploaded content.
🚀 Features
📁 Upload .xlsx files securely 📊 Parse and preview Excel content in the frontend 🧮 Perform basic analytics (rows, columns, values) 👤 User authentication system 🗃 File storage using backend uploads/ folder 📦 MongoDB for saving user and file metadata
📁 Project Structure
internwork/
│
├── backend/ # Node.js + Express API
│ ├── routes/ # Express routes for upload and user
│ ├── models/ # Mongoose models
│ ├── uploads/ # Uploaded Excel files (auto-created)
│ ├── index.js # Entry point
│ └── .gitignore # Ignores sensitive files like .env
│
├── frontend/ # React application
│ ├── public/
│ ├── src/
│ └── package.json
│
└── README.md # This file
⚙️ Setup Instructions
- Clone the repository
git clone https://github.com/Lpriya018/MERN-Excel-Analysis.git cd MERN-Excel-Analysis
- Backend Setup
cd backend npm install Create a .env file in the backend/ folder with the following variables: PORT=5000 MONGO_URI=your_mongodb_connection_string JWT_SECRET=your_jwt_secret_key Start backend: node index.js
- Frontend Setup
cd ../frontend npm install npm start
🧪 Technologies Used
MongoDB + Mongoose Express.js React.js Node.js Multer (file upload) XLSX (Excel parser) JWT (auth) dotenv