Supported files and imports
What you can upload, how it is read, and how to prepare a file that produces a good dashboard.
Formats and limits
| Format | Extensions | Notes |
|---|---|---|
| Excel | .xlsx .xls .xlsb | All sheets are read. Several tables on one sheet are detected separately. Title rows above the table are skipped. |
| CSV | .csv | One table. The first row is treated as the header. |
| JSON | .json | Passed to the AI as-is. Works best as an array of objects with the same keys. |
| Google Sheets | Connected live, see Live Google Sheets. Also importable as a one-time copy through the Drive chip. |
- Maximum upload size: 20 MB.
- Files are checked by content, not by name. A file whose content does not match its extension is rejected with a message telling you which extension to use.
- Archives and executables are rejected.
Workbooks with several sheets
Every sheet in the workbook is read and kept under its tab name. If you want the dashboard built from one tab, say so in the description, for example "Use the Orders tab". Without a hint, the AI works from all tabs and picks what looks like the main table.
Preparing a file that works well
- One header row, with a distinct name in every column.
- One value type per column: dates in the date column, numbers in the number column, no notes mixed into numeric cells.
- No merged cells in the data area. A title above the table is fine.
- Totals rows at the bottom are best removed; the dashboard computes its own totals.
- Column names that say what the values are ("Revenue (USD)", "Order date") give better charts than "Col1".
Importing from cloud storage
The Drive, Dropbox and OneDrive chips in the prompt box let you browse your storage and pick a file. The file is copied to VibeFactory once, exactly like a local upload. Later changes to the file in your cloud storage do not reach the dashboard. A Google Sheet picked this way is exported as a snapshot.
For a dashboard that follows the spreadsheet as it changes, use the Live Dashboards card instead.
| Provider | Permission requested | Result |
|---|---|---|
| Google Drive (chip) | Files you select only (drive.file) | One-time copy |
| Dropbox | Read access to browse and download | One-time copy |
| OneDrive | Read access to your files | One-time copy |
| Google Sheets / Excel on Drive (Live Dashboards card) | Files you select only, plus Viewer sharing with our reader account | Live connection |