Importing data into your app

Bring in data from a spreadsheet, CSV file, or another tool. Useful for migrating from existing systems.

Already have data in a spreadsheet, an old app, or a CSV? You don't have to retype it. The AI can import it directly.

The simplest method

Drag your file into the chat. Or paste data directly. Then describe what you want:

Import this spreadsheet as my customer list.

Take this CSV and create a record for each row in the Products data.

The AI:

1. Looks at the columns in your file
2. Maps them to the right fields in your app (or creates new fields if needed)
3. Imports every row
4. Tells you how many records were imported and flags any issues

Supported formats

• CSV (.csv) — the reliable one, and what we'd recommend
• JSON (for technical users)
• Plain text with one record per line

Native Excel files are not supported and can't be read from the chat — the editor won't accept a .xlsx or .xls attachment at all. If your data lives in Excel, open it and use File → Save As → CSV first. Same for a Google Sheet: File → Download → Comma-separated values, then bring the CSV in.

Is it a live connection?

No — an import is a one-time copy. Once the rows are in your app, the original file isn't linked to them any more, so later edits to the spreadsheet won't show up. There is no live sync between a sheet and your app; see Connecting Google Sheets for what is and isn't possible.

Fixing problems

If the AI can't figure out which column goes where, it asks you:

I see columns: Name, Email, Phone, Last Order Date. I'm planning to map them to: Customer Name, Email, Phone, Last Order. Does that look right?

Answer in chat. You can also tell it to skip columns:

Skip the Phone column for now.

Imports that need cleanup

If your data is messy, the AI catches common issues:

• Duplicate emails — it'll ask whether to merge or skip
• Missing required fields — it'll skip those rows and tell you which ones
• Bad formats (e.g. January 15th 2024 in a date column) — it tries to parse them but flags ones it can't

For a clean import, the AI gives you a summary at the end: Imported 1,247 rows. Skipped 3 (missing email). Merged 12 duplicates.

Large imports

Files up to about 50,000 rows import in under a minute. Larger imports work but take a few minutes — the chat shows progress.

What to read next

• Connecting Google Sheets — what's possible, and what isn't
• Exporting your data — always be able to get your data back out