Upload Your First Spreadsheet to Unsheet — Complete Walkthrough

Unsheet works best with well-structured spreadsheets. Before uploading, make sure:

• Row 1 is your header row — Column names like "Item", "Quantity", "Price", "Total"
• Data starts in Row 2 — Your actual records begin immediately below the header
• Formulas are in the cells — Don't paste values over formulas. Unsheet extracts and evaluates them live
• File is under 10MB — Most spreadsheets are well within this limit

Tip: If your spreadsheet has multiple sheets (tabs), Unsheet will extract all of them but currently generates the UI from the first sheet.

1. From your Dashboard, click "New App" in the top right
2. You'll see the upload area — a large dropzone with a cloud icon
3. Drag and drop your .xlsx or .csv file onto the dropzone, or click to browse your files
4. Unsheet uploads your file and shows an animated loading state while the AI processes it
5. In 5-15 seconds, you'll be redirected to your new app

When you upload a file, here's what Unsheet does:

1. Formula extraction — For Excel files, openpyxl reads the workbook with data_only=False, preserving every formula as a string (e.g., =SUM(B2:B10))
2. Data analysis — pandas analyses column data types (string, number, date, currency) and extracts the first 5 rows as sample data
3. AI schema generation — Gemini 2.5 Flash receives the column context and generates a UISchema: which components to show (metric cards, tables, charts, dropdowns), column mappings, and a theme gradient
4. Storage — The schema and raw data (including formulas) are saved to Firestore
5. Client rendering — Your browser loads the data into HyperFormula, which evaluates all formulas and renders the interactive UI

Once processing completes, you'll see your spreadsheet transformed into a beautiful application:

• Metric cards at the top showing key totals (pulled from formula cells like =SUM(D2:D10))
• Interactive charts — bar or line charts visualising your numeric columns
• Editable table — your data in a clean table where number fields are editable. Change a value and watch everything recalculate
• Filter dropdowns — if your data has categorical columns (like Status or Region), Unsheet adds dropdowns that write back to the formula engine