csv-ai-analyzer

📊 CSV AI Analyzer

🚀 Try it live →

App preview:

A modern, elegant application to analyze your CSV files with Artificial Intelligence using multiple AI providers (OpenAI, Anthropic, Google, Mistral, and more). Privacy-first: the app does not store your data. Use a self-hosted/custom endpoint to keep processing entirely local; otherwise API calls go to the selected provider. Self-hostable with Docker.

✨ Features

📁 CSV Upload & Parsing

• Drag & Drop or file selection
• Automatic detection of delimiters (comma, semicolon, tab)
• Configurable settings: delimiter, header row, encoding
• Type inference for columns (text, number, date)

📋 Data Visualization

• Interactive table with sorting and pagination
• Data preview with automatic formatting
• Smooth navigation for large datasets

🤖 AI-Powered Analysis

• Multiple AI providers: OpenAI, Anthropic Claude, Google Gemini, Mistral, and more
• Custom endpoint support: Connect to Ollama, LM Studio, vLLM, or any OpenAI-compatible API
• Intelligent analysis of your data with AI-generated insights
• Markdown rendering: AI responses rendered with full Markdown support (headings, lists, tables, syntax-highlighted code blocks)
• Streaming with Markdown: Real-time streaming responses are rendered progressively as formatted Markdown
• Smart chart suggestions tailored to your dataset
• Chart types: Bar, Line, Pie, Scatter, Area

🔒 Privacy

• Local or direct-to-provider: the app does not store your data. Processing can happen in your browser when using a self-hosted/custom endpoint; otherwise API calls go directly to the chosen AI provider.
• API keys stored locally in your browser
• No tracking or third-party cookies

🐳 Self-Hostable

• Docker ready: Deploy in seconds with a single command
• Custom AI endpoints: Use your own LLM server (Ollama, LM Studio, vLLM, etc.)
• Full control: Host on your own infrastructure

🚀 Installation

Option 1: Local Development

# Clone the repo
git clone https://github.com/maxgfr/csv-ai-analyzer.git
cd csv-ai-analyzer

# Install dependencies
pnpm install

# Run in development
pnpm dev

The application will be accessible at http://localhost:3000

Auto-updating the models catalog

This project ships a static public/models.json that contains the models catalog fetched from https://models.dev/api.json.

• You can regenerate the file locally with:

pnpm run fetch-models

• A GitHub Action is configured to run this script once per day and automatically commit public/models.json if it changes.

  • Workflow: .github/workflows/update-models.yml
  • Runs daily (UTC 06:00) and is also triggerable manually with workflow_dispatch.

If you’d like the file to be refreshed more/less often you can update the cron schedule in the workflow file.

Option 2: Docker (Self-Hosting)

# Build the Docker image
docker build -t csv-ai-analyzer .

# Run the container
docker run -p 3000:3000 csv-ai-analyzer

Or use Docker Compose:

# docker-compose.yml
version: '3.8'
services:
  csv-ai-analyzer:
    build: .
    ports:
      - "3000:3000"
    restart: unless-stopped

docker compose up -d

The application will be accessible at http://localhost:3000

Or use the live version directly!

🎮 Usage

1. Upload a CSV

Drag and drop your CSV file or click to select a file.

2. Configure Parsing (Optional)

If automatic detection doesn’t work perfectly, adjust the settings:

• Custom delimiter
• Header row choice
• File encoding

3. Configure your AI Provider

Click the ⚙️ icon to configure your AI provider:

• Choose a provider: OpenAI, Anthropic, Google, Mistral, or others
• Enter your API key: Each provider has its own API key format
• Custom Endpoint: Enable “Use Custom Endpoint” to connect to local/self-hosted OpenAI-compatible APIs (Ollama, LM Studio, vLLM, etc.)

Using Custom Endpoints (Ollama, LM Studio, vLLM, etc.)

1. Toggle “Use Custom Endpoint” in settings
2. Enter your API Base URL (e.g., http://localhost:11434/v1 for Ollama)
3. Enter your model name (e.g., llama3.2, mistral, codellama)
4. API key is optional for most local servers

Example configurations:

Provider	Base URL	Model Examples
Ollama	http://localhost:11434/v1	llama3.2, mistral, codellama
LM Studio	http://localhost:1234/v1	Model name from LM Studio
vLLM	http://localhost:8000/v1	Your loaded model name
OpenRouter	https://openrouter.ai/api/v1	openai/gpt-4o, anthropic/claude-3

4. Analysis & Charts

Click “Run Complete Analysis” and the AI will analyze your data, detect anomalies, and suggest relevant visualizations.

📦 @maxgfr/csv-charts — Reusable Chart Package

The chart components are extracted into a standalone npm package @maxgfr/csv-charts, available for use in any React project.

Installation

pnpm add @maxgfr/csv-charts

Peer dependencies: react, recharts, lucide-react.

Quick Example

import { ChartDisplay } from "@maxgfr/csv-charts";

const data = {
  headers: ["Category", "Sales"],
  rows: [["Electronics", "1200"], ["Clothing", "800"]],
  columns: [
    { name: "Category", type: "string", index: 0 },
    { name: "Sales", type: "number", index: 1 },
  ],
  rowCount: 2,
};

const charts = [{
  id: "1",
  type: "bar",
  title: "Sales by Category",
  description: "Compare sales across categories",
  xAxis: "Category",
  yAxis: "Sales",
  aggregation: "sum",
}];

<ChartDisplay data={data} charts={charts} />

Exported API

Export	Description
ChartDisplay	Multi-chart container with optional card wrapper
SingleChart	Individual chart with toolbar (sort, zoom, trendline, export)
ChartToolbar	Standalone toolbar component
processChartData	Data processing utility with aggregation
COLORS	Default color palette

Chart types: bar, line, area, scatter, pie. Aggregations: sum, avg, count, min, max, none.

See the full documentation in packages/csv-charts/README.md.

🛠️ Tech Stack

Technology	Usage
Next.js	React Framework with App Router
TailwindCSS	Styling and design system
PapaParse	Client-side CSV parsing
Recharts	React charting library
react-markdown	Markdown rendering for AI responses
rehype-highlight	Syntax highlighting in code blocks
Lucide React	Modern icons
js-cookie	Secure local persistence
tsup	Package bundling for @maxgfr/csv-charts
semantic-release	Automated npm publishing via CI

📁 Project Structure

csv-ai-analyzer/
├── src/                          # Next.js application
│   ├── app/_components/          # React components
│   ├── lib/                      # Services, parsers, stores
│   └── styles/                   # Global CSS
├── packages/
│   └── csv-charts/               # @maxgfr/csv-charts npm package
│       ├── src/                   # Package source (ChartDisplay, SingleChart, etc.)
│       ├── dist/                  # Built output (ESM + .d.ts)
│       └── package.json
├── pnpm-workspace.yaml           # Monorepo workspace config
└── package.json                  # Root app

📝 License

MIT - Use as you wish!

This site is open source. Improve this page.