⚡ Advancedadvanced4 min read
Working with Multi-Sheet Excel Workbooks in Unsheet
Unsheet extracts all sheets from multi-tab Excel workbooks. Learn how sheet extraction works and what to expect with complex workbook structures.
How Multi-Sheet Extraction Works
When you upload an .xlsx file with multiple sheets (tabs):
- Unsheet reads all sheet names from the workbook
- Each sheet's data (including formulas) is extracted as a separate 2D grid
- The API response includes a
sheetsobject mapping sheet names to their data grids, and asheet_namesarray - Currently, the first sheet is used for UI generation and rendering
Best Practices for Multi-Sheet Workbooks
- Put your primary data in Sheet 1 — This is what the AI will analyse and render
- Use lookup formulas carefully — Cross-sheet references (e.g.,
=Sheet2!A1) are extracted but may not resolve in the single-sheet HyperFormula instance - Keep summary/dashboard data on Sheet 1 — If your workbook has a summary tab, make it the first sheet
Found this useful?
Share it with your team or network.
Frequently Asked Questions
Does Unsheet support multiple sheets in an Excel file?
Yes. Unsheet extracts data from all sheets in a workbook. Currently, the AI generates the UI from the first sheet. Additional sheet data is stored and accessible.
Related Guides
🚀Getting Started· 5 min
Upload Your First Spreadsheet to Unsheet — Complete Walkthrough
Step-by-step guide to uploading an Excel or CSV file and watching Unsheet's AI transform it into a live web application with charts and formulas.
🔗Integrations· 6 min
Supported Excel Formulas in Unsheet — Complete Function Reference
Full list of 400+ Excel functions supported by Unsheet's HyperFormula engine. SUM, IF, VLOOKUP, INDEX/MATCH, and more — all recalculate live.
Ready to kill your spreadsheets?
Upload your first file and see the magic in under 30 seconds.
Get Started Free →