Datasets

Written By Minh

Last updated 1 day ago

A dataset is a spreadsheet of data that powers your content. Each row becomes a page, and each column becomes a variable you can use in your content template. Import your data from a CSV, Google Sheets, or build it directly in the app.

Quick Example

City

Service

Phone

New York

Plumbing

(212) 555-0100

Chicago

Roofing

(312) 555-0200

Miami

Landscaping

(305) 555-0300

3 rows = 3 pages. Each column ({{ City }}, {{ Service }}, {{ Phone }}) becomes a variable you can use in your content template.

Importing Data

Go to the Data tab in your project. You have three ways to add data:

  • Upload a file - Drag and drop a CSV or Excel file (.csv, .xls, .xlsx) up to 120 MB. A preview shows your columns and first rows before you confirm the import.

  • Google Sheets - Connect your Google account and select a spreadsheet. Choose which sheet to import. Your data is pulled in directly.

  • Start from scratch - Create an empty table and add rows and columns manually, or describe the data you need and let AI generate it for you.

Importing new data replaces the current dataset. Each project has one active dataset at a time.

How to Manage Your Data

Editing cells - Double-click any cell to edit it. Changes save automatically. Press Escape to cancel.

Rows and columns - Right-click to add, delete, duplicate, or rename rows and columns. You can also drag column headers to reorder them.

Search - Use the search bar to find values across your entire dataset. Matching cells are highlighted.

Find and replace - Press Ctrl+H (Cmd+H on Mac) to open Find and Replace. You can match by case, whole word, or limit to selected cells only.

Bulk edit - Select multiple cells, then press Ctrl+B to set the same value for all of them.

Export - Download your dataset as Excel, CSV, or JSON from the toolbar.

Tips

  • The first row of your file is used as column headers. Make sure your spreadsheet has headers.

  • Column names become your variable names. Keep them short and clear - City is better than Column_A_Data.

  • Column names must start with a letter and can contain letters, numbers, spaces, underscores, and hyphens.

  • You can undo and redo changes with Ctrl+Z and Ctrl+Y.

  • Press ? to see all keyboard shortcuts.

Troubleshooting

Problem

Solution

Import fails or shows an error

Check that your file has column headers in the first row and is under 120 MB. Supported formats: CSV, XLS, XLSX.

Duplicate column names

Column names must be unique (case-insensitive). Rename any duplicates in your file before importing.

Column name rejected

Column names must start with a letter and be 1-63 characters.

Changes not saving

If a cell shows a red border, the save failed. Try editing the cell again. Check your internet connection.

Variables not showing new columns

After importing new data, go back to the Fields tab. The new column names should appear in the autocomplete when you type {{.