Hi Cridland š
The current system has some limitations with handling Excel files containing multiple sheets. Here's the situation and what you can do: Currently, when you upload a multi-sheet Excel file, the TablesQuery tool can't properly process all sheets, leading to that "Table not found" error you're seeing.
Quick workarounds:
- 1.
Split your Excel file into separate CSV files (one per sheet) and upload them individually
- 2.
Use single-sheet Excel files instead of multiple sheets
- 3.
If you have access to Google Workspace, consider using Google Sheets (it handles multiple sheets better when connected through Drive!)
To convert Excel sheets to CSV: ā¢ Open your Excel file ā¢ For each sheet: File > Save As > Select CSV format ā¢ Upload the CSVs separately to Dust
The team is working on proper multi-sheet Excel support, but for now, these workarounds should get you going! Let me know if you need any help with the conversion process. š
