excel-as-DB

A React application for managing Excel data. Users can upload an Excel file, view and edit its contents in a dynamic table using Ag-Grid, and save changes. Features include pagination, search filtering, bulk actions, and row deletion. Ideal for web-based Excel data manipulation.

Sheetwise

Sheetwise is an advanced data management tool designed to simplify the handling and manipulation of Excel files and Google Sheets directly in your browser, without the need for server storage, ensuring your data remains secure and private. A React application for managing Excel data. Users can upload an Excel file, view and edit its contents in a dynamic table using Ag-Grid, and save changes. Features include pagination, search filtering, bulk actions, and row deletion. Ideal for web-based Excel data manipulation.

Features

• Excel File Upload: Easily upload your Excel files and access your data in a web-friendly format.
• Dynamic Data Table: View and edit your data in real-time with our dynamic table powered by Ag-Grid.
• Advanced Editing: Make quick changes, apply bulk actions, and seamlessly manage your data with our user-friendly interface.
• Search and Filter: Locate specific entries with our advanced search and filtering options, making data analysis a breeze.
• Google Sheets Integration: Connect your Google Sheets and manage your data directly within Sheetwise. Changes are instantly reflected in your Google Sheets.
• Custom Form Builder: Create forms tailored to your needs for data collection such as employee registration or attendance tracking.
• No Server Storage: Your data stays on your device, with no need to send it to a server, maintaining your privacy and security.

Technologies

Sheetwise is built using the following technologies:

• React.js
• Next.js
• Tailwind CSS
• Ag-Grid
• Zustand for state management
• Clerk for user authentication
• Framer Motion for animations
• Various other libraries listed in package.json
• XLSX

Getting Started

Prerequisites

Make sure you have Node.js installed (preferably the latest LTS version). You can download it from Node.js official website. minimum v18.0.0

Installation

• Clone the repository using HTTPS

git clone https://github.com/DanteLentsoe/excel-as-DB

• Clone the repository using SSH

git clone git@github.com:DanteLentsoe/excel-as-DB.git

• Navigate to the cloned repo

cd excel-as-DB

• yarn
• yarn start

Environments

There are 2 environments each corresponding to a branch on the repository:

• Production - master branch
• Development - dev branch

Deployment

The application is deployed on vercle