Q: Does it handle complex multi sheet excel files?
If I added some fairly complex sales data in excel form, that has pivot tables, multiple sheets, etc - would Scoop be able to handle that?
Brad_ScoopAnalytics
Oct 23, 2025A: Scoop loads normal tables. So the tables that are the source of your pivot tables can be what Scoop loads - it will do all the pivoting and more for you, so pivots are actually counterproductive. Just name the range and you can connect to it.
According to the FAQ section of the deal page, Scoop supports file uploads (CSV, Excel), API connectors and database connections, and it automatically scans your data, detects formats, suggests schemas, and recommends any necessary data-preparation steps. So yes — Scoop can ingest Excel workbooks with multiple sheets and will scan them and recommend how to shape the data; note that complex objects like pivot tables are not always treated as raw transaction tables, so for best results either upload the underlying source table(s) or a cleaned sheet per table. If you’d like, tell me a bit about your workbook and I’ll suggest the easiest prep approach.