Turn an Excel workbook into a dashboard.
Upload the workbook as it is. Daized reads the sheet you choose, works out what the columns mean and builds the dashboard, with no formulas to write.
What Daized does with a Excel file
- One dashboard for each sheet you chooseA workbook with several sheets asks which ones to open. Each becomes its own dashboard, and you can switch between them from the top bar.
- Reads a sheet for what was askedListing a large workbook's sheets only looks at the top of each one, and only the sheet you pick is read in full.
- Finds the real headerTitle rows and blank rows above the header are fine.
- Picks the metrics for your kind of fileThe metrics follow what the file is about, and one your columns cannot support is skipped.
- Tells you how it read each columnWhere two columns fit a role about equally, such as an order date and a ship date, it asks which to use.
What it needs from the file
- File typesXLSX and XLS, as well as CSV, TSV and TXT.
- SizeUp to 100 MB a file.
- LayoutOne header row, then your data, on each sheet you choose.
- Column namesAnything. Their meaning is worked out from the values.
Questions
- Does it read my formulas?
- It reads the values the sheet shows. Charts and formatting in the workbook are not carried over, because the dashboard is built from the data.
- Can I choose which sheets to use?
- Yes. When a workbook has several sheets, Daized lists them and you choose which become dashboards, up to what is left of your allowance.
- Does Daized change my workbook?
- No. The original file is never stored; only the parsed table is kept, and you can delete a dataset from My datasets.