PatternsArtifacts

CSV Editor Artifact

Spreadsheet editor with AI chat for data analysis and manipulation. Edit tables through conversation.

Loading preview…

Problems solved

Technical challenges this implementation handles out of the box.

Products and workflows this pattern is designed to support.

Requirements, wiring steps, and what this pattern adds to your project.

Pick how you want to pull this pattern in — then wire env vars and routes the same way.

1
Install from the preview toolbar
Copy the install command above and run it in your project — Pro patterns include a short-lived token.
2
Add environment variables to .env.local
OPENAI_API_KEY, UPSTASH_REDIS_REST_URL, UPSTASH_REDIS_REST_TOKEN
3
Point client fetches at your API routes
Replace preview `/view/.../api/...` paths with `/api/...` in the installed files.
4
Customize the agent and tool files
Adapt prompts, tools, and stop conditions for your product — Copy for AI in the toolbar helps seed that work.
5
Run your dev server and open the pattern route
Install dependencies if needed, then start the app and verify responses.

AI SDK APIs

streamTexttoolconvertToModelMessagesgenerateText

Providers

OpenAI

External services

Upstash

25 files

12 total

npm packages

AISDKlucide-reactNext.jspapaparseReactreact-data-gridsonnerZod

Registry components

resizabletabletabstooltip

artifact-table/route.ts
API 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.ts
Massive 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.ts
Defines the TableEditorArtifact using the artifact() helper. Contains the comprehensive Zod schema for table editor state: title, stage, csvContent, summary, operations, version history.
ai/context.ts
AsyncLocalStorage-based context management for the artifact system. Provides runWithContext, getContext, getWriter, and artifact data accessors.
lib/sheet-utils.ts
Core 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.