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) — most common
• Excel (.xlsx, .xls)
• Google Sheets (paste the share link)
• JSON (for technical users)
• Plain text with one record per line

Connecting Google Sheets directly

If you want a live link (not a one-time import), see Connecting Google Sheets.

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 — live sync instead of one-time import
• Exporting your data — always be able to get your data back out