Loading pattern preview
TemplatesArtifacts
CSV Editor Artifact
CSV Editor Artifact
Spreadsheet editor with AI chat for data analysis and manipulation. Edit tables through conversation.
Loading pattern preview
Problems solved
Technical challenges this implementation handles out of the box.
- Import and normalize CSV data for an interactive spreadsheet
- Edit tabular data through a spreadsheet artifact UI
- Analyze spreadsheet contents with an AI assistant
- Detect column and data types automatically
- Hydrate prior table state from conversation context
Use cases
Products and workflows this pattern is designed to support.
- AI-assisted spreadsheet editors
- Financial modeling and forecasting tools
- CSV cleanup and analysis applications
- Business intelligence dashboards
- Data visualization and reporting workflows
Setup
Requirements, wiring steps, and what this pattern adds to your project.
Getting started
Pick how you want to pull this pattern in. Then wire env vars and routes the same way.
- 1
Download → Next.js app
Use Download → Next.js app in the preview toolbar. You get a zip scaffold (Pro downloads rewrite preview `/view/.../api/*` paths to `/api/*` automatically).
- 2
Extract the zip and install dependencies
Unzip the archive, then run `pnpm install` (or npm / yarn) in the project folder.
- 3
Fill .env.local
The download includes .env.local placeholders when needed. Add real values for: OPENAI_API_KEY.
- 4
Customize the agent and tool files
Adapt prompts, tools, and stop conditions in the generated project for your product.
- 5
Run the app and open the pattern route
Run `pnpm dev`, open the setup/checklist page if present, then navigate to the generated pattern route and verify responses.
Environment variables
OPENAI_API_KEYGet key
Capabilities
AI SDK APIs
streamTexttoolconvertToModelMessagesgenerateTextProviders
OpenAI
External services
Upstash
Files added
25 filesapp/page.tsxapp/layout.tsxapp/api/artifact-table/route.tscomponents/expandable-panel.tsxcomponents/panel-left-chat.tsxcomponents/chat-message-input.tsxcomponents/chat-message-list.tsxcomponents/intro-heading.tsxcomponents/panel-right-artifact.tsxcomponents/sheet-editor.tsxcomponents/table-artifact-loading.tsxcomponents/table-artifact.tsxcomponents/table-chat.tsxcomponents/table-artifact-mobile.tsxcomponents/table-artifact-context.tsxhooks/use-artifact-panel-state.tsxhooks/use-table-editor-artifact.tslib/ai/artifacts/table-editor.tslib/ai/context.tslib/ai/tools/index.tslib/ai/tools/table-editor.tslib/error-handler.tslib/ai/types.tslib/sheet-utils.tsREADME.md
Dependencies
12 totalnpm packages
8AISDKlucide-reactNext.jspapaparseReactreact-data-gridsonnerZod
Registry components
resizabletabletabstooltip
Critical files
artifact-table/route.tsAPI route for the table artifact system. Uses runWithContext for AsyncLocalStorage-based context management. Implements hydrateContextFromMessages to restore previous table state. Configures streamText with tableEditor and addData tools.
tools/table-editor.tsMassive tool implementation containing addDataTool and tableEditorTool (handles create, add_column, filter_rows, sort_data, calculate, clean_data, edit_column, merge_data operations). Implements CSV parsing, column profiling, data transformations, and progressive artifact streaming.
artifacts/table-editor.tsDefines the TableEditorArtifact using the artifact() helper. Contains the comprehensive Zod schema for table editor state: title, stage, csvContent, summary, operations, version history.
ai/context.tsAsyncLocalStorage-based context management for the artifact system. Provides runWithContext, getContext, getWriter, and artifact data accessors.
lib/sheet-utils.tsCore spreadsheet utility library: CSV parsing with fallback, row normalization, Excel-style column reference resolution, filter predicate builder, value type coercion, and automatic column type detection.
Requirements
- Complexity
- Intermediate
- Setup time
- ~15 minutes
- Node
- 24+
- Memory
- 512MB
Upstash Redis
