Skip to content

This project automates the extraction and visualization of graphical data from Excel sheets while maintaining a secure log of user login/logout activities. It provides an intuitive interface for generating dynamic charts and reports from spreadsheet data while tracking user sessions for security and auditing purposes.

Notifications You must be signed in to change notification settings

Ishantmishra18/-ExAnaly

Folders and files

NameName
Last commit message
Last commit date

Latest commit

History

32 Commits

Repository files navigation

📊 Excel Graph - Data Visualization & Analysis Tool

MERN StackJWT AuthLive

Excel Graph is a powerful data visualization platform that transforms your spreadsheet data into interactive graphs and charts. Built with the MERN stack, it offers secure user authentication and real-time data rendering capabilities.


🌐 Live Demo


✨ Key Features

📈 Dynamic Graph Generation

  • Upload Excel/CSV files
  • Multiple chart types (Line, Bar, Pie)
  • Customizable axes and labels

🔒 Secure Authentication

  • JWT protected routes
  • Google OAuth integration
  • Session management

Real-time Updates

  • Instant visualization changes
  • Collaborative editing support
  • History tracking

🛠️ Tech Stack

Frontend

  • React.js + Vite
  • Chart.js (Data Visualization)
  • Tailwind CSS (Styling)
  • Axios (HTTP Client)

Backend

  • Node.js + Express
  • MongoDB (Database)
  • Mongoose (ODM)
  • Passport.js (Authentication)
  • JWT (Session Management)

Deployment

  • Render (Hosting)
  • MongoDB Atlas (Cloud Database)

🚀 Installation Guide

Prerequisites

  • Node.js (v18+)
  • MongoDB (Local or Atlas URI)
  • Google OAuth Credentials

Setup Instructions

# Clone the repository git clone https://github.com/yourusername/excel-graph.git cd excel-graph

Backend Setup

cd server npm install cp .env.example .env # Fill in your environment variables npx nodemon server.js 

Frontend Setup (in new terminal)

cd client npm install npm run dev 

About

This project automates the extraction and visualization of graphical data from Excel sheets while maintaining a secure log of user login/logout activities. It provides an intuitive interface for generating dynamic charts and reports from spreadsheet data while tracking user sessions for security and auditing purposes.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Contributors 3

  •  
  •  
  •  

Languages