Skip to content

Latest commit

 

History

History
102 lines (65 loc) · 1.94 KB

README.md

File metadata and controls

102 lines (65 loc) · 1.94 KB
Raw

ExcelToMongo

ExcelToMongo is a web application built with Node.js, React.js, and MongoDB that allows users to upload Excel files and store their data into a MongoDB database.

Features

  • Upload Excel files
  • Convert Excel data to JSON
  • Store JSON data in MongoDB
  • Backend endpoint for fetching stored data

Technologies Used

  • Node.js
  • React.js
  • MongoDB

Getting Started

Follow the steps below to set up and run the project locally.

Prerequisites

Make sure you have the following installed on your machine:

  • Node.js
  • npm
  • MongoDB

Installation

  1. Clone the repository to your local machine.
git clone https://github.com/utkarshilh/ExcelToMongo
  1. Navigate to the project directory.
cd your-repository
  1. Install dependencies for both frontend and backend.

Install frontend dependencies

cd client
npm install
  1. Install backend dependencies
cd ../server
npm install
  1. Set up the MongoDB database.

Make sure MongoDB is running on your machine. Create a .env file in the server directory and provide the MongoDB connection URL.

MONGODB_URI=your_mongodb_connection_url
  1. Running the Application
npm start

Usage

  • Upload an Excel file using the provided input field.
  • Click the "Upload" button to store the data into the MongoDB database.
  • Check the response for success or error messages.

Backend API

The backend API provides the following endpoints:

  • `GET /collectionDetails: Fetch all entries stored in the database.
  • `POST /uploadData: Upload JSON data to store in the database.

Screenshots

Project Image

Contributing

Contributions are welcome! Please follow these steps:

  • Fork the repository
  • Create your feature branch (git checkout -b feature/YourFeature)
  • Commit your changes (git commit -am 'Add some feature')
  • Push to the branch (git push origin feature/YourFeature)
  • Create a new Pull Request