/ExcelToMongo

ExcelToMongo is a web application developed with Node.js, React.js, and MongoDB. It facilitates the seamless uploading of Excel files and their storage in MongoDB, streamlining data management tasks. Ideal for users seeking efficient data storage and analysis capabilities.

Primary LanguageJavaScript

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