Excel Analyzer

Demo

excel_analyzer_demo.mov

Link to Demo Video

Tech Stack

• Create-T3-App - boilerplate

• Next.js - Full-stack react framework

• Tailwind CSS - Utility-first CSS framework

• tRPC - End-to-end type safe APIs

• FastAPI - Python web framework for building APIs

• LangChain - Framework for developing applications powered by language models

Description

Drag and drop your excel file and ask ai about the data. AI data analyst will answer your question.

This project is a proof of concept that building back office powered by LLM will be cool.

Features

• Load excel file easily by drag and drop

• View data of excel file in a table view

• Ask LLM questions about the data and get answer

Installation

1. Clone the repository

git clone https://github.com/Peter-Roh/excel-analyzer.git

2. Install dependencies

bun install

3. Download model

Go to Ollama website and download model mistral:latest. (You can easily change model and add secret key by changing code if necessary. I am just using free model here.)

4. Python virtual environment

python3 -m venv ./api/env
source ./api/env/bin/activate

5. Run the application

bun run dev