Zoho Desk Viewer

A local, read-only viewer for Zoho Desk data exported as CSV files. Browse tickets, conversations, contacts, and accounts with an interactive dashboard -- all without sending data to any external service.

• Dashboard -- stat cards, status/priority/channel pie and bar charts, ticket volume over time, agent workload
• Ticket browser -- sortable, filterable table with search, status/priority/agent/channel filters, and pagination
• Conversation threads -- view email threads with color-coded incoming/outgoing messages and rendered HTML content
• Comments and time entries -- internal agent notes and time tracking per ticket
• Contacts and accounts -- browse contact and account records with linked ticket views
• Department filter -- global department selector scoped across all views

• Node.js 18+
• npm 9+

git clone https://github.com/byeager-uptime/zoho-desk-viewer.git
cd zoho-desk-viewer
npm install

CSV_DIR=sample-data npm run seed
npm run dev

Open http://localhost:5173 in your browser.

# Place your Zoho Desk CSV exports in csv-data/
CSV_DIR=csv-data npm run seed
npm run dev

To re-seed with different data, delete the database first:

rm -f data/zoho.db
CSV_DIR=sample-data npm run seed

Export your data from Zoho Desk as CSV files and place them in a directory (default: csv-data/, which is gitignored). The expected files are:

Each CSV must have Row 0 as display names, Row 1 as API field names, and Row 2+ as data rows (standard Zoho Desk export format).

Set the CSV_DIR environment variable to point to your export directory:

CSV_DIR=path/to/your/exports npm run seed

• Read-only -- the SQLite database is never written to after seeding
• No credentials stored -- no Zoho API keys, tokens, or passwords are needed or saved
• Data stays local -- all data remains on your machine; nothing is sent to external services
• XSS protection -- HTML email content is sanitized with DOMPurify and rendered in sandboxed iframes

├── packages/
│   ├── client/          # React frontend (Vite)
│   │   └── src/
│   │       ├── api/     # API hooks (TanStack Query)
│   │       └── components/
│   │           ├── common/      # DataTable, HtmlContent
│   │           ├── dashboard/   # Charts and stats
│   │           ├── layout/      # AppShell, Sidebar
│   │           ├── tickets/     # List, detail, threads
│   │           ├── contacts/    # Contact views
│   │           └── accounts/    # Account views
│   ├── server/          # Express API server
│   │   └── src/
│   │       ├── db/      # SQLite schema, seed, queries
│   │       └── routes/  # REST endpoints
│   └── shared/          # Shared TypeScript types
├── sample-data/         # Mock CSV data (safe to commit)
├── csv-data/            # Your real Zoho exports (gitignored)
├── data/                # SQLite database (gitignored)
└── docs/                # Screenshots

MIT