Excel Workbook Designer
Every business keeps its spreadsheets its own way. The designer reads yours first — every sheet, its columns and its values — tells you what it found and what is missing, asks only what it cannot tell, and then makes a clear, well-designed workbook from your actual data. Your original file is never changed.
What it can make
| From | You can get |
|---|---|
| An attendance register or log, any layout | A WarehouseCalc attendance register: one sheet per month, a row per person, your marks as written, totals and attendance rate per person, days not recorded marked to complete, a dashboard |
| An employee list without attendance | A new attendance register for the month you choose, with your people, IDs and departments, ready to fill in |
| A stock list (any headings: Part No., Bal Qty, Rate …) | A WarehouseCalc stock list with status and a "Check" column, or a redesigned copy of your own sheet, with a dashboard |
| An item list without quantities | A stock list to count: your items with the quantity left empty |
| Expenses, or any table with numbers | An expense log or a summary report with a dashboard, or a redesigned copy |
How it works
| Step | What happens |
|---|---|
| 1. Files | Choose one or more workbooks or CSV files (for example an attendance log and an employee list). |
| 2. What we found | Every sheet: what it is, what it holds, and what is missing or doubtful — rows without a date, blank statuses, subtotals, repeated codes, sheets that are copies of each other. The output that fits your data is recommended. |
| 3. Columns and questions | Which of your columns is which, and only the questions your file cannot answer: what a blank day means, which column is stock on hand, which month a register is for. |
| 4. Review and download | What will be made, how, and what is left to check; a preview of the dashboard; then the workbook, checked against your file before it is offered. |
Nothing is invented. A missing value stays blank and is marked; a day without a mark is never counted as absent unless you say so; rows that cannot be used are listed with the reason. Every output is checked against your file: record counts, identifiers, quantities, totals, attendance marks, and that the charts show the workbook's own figures.
What you get
- A dashboard sheet in front (when there is data to show): six key figures, up to three charts, findings and data checks, all formulas over your data.
- Your records in the chosen format, with every value as in your file. The WarehouseCalc registers and lists add a "Source data" sheet listing each source row and what was done with it; the summary report keeps the source row on every line instead.
- A "Changes and notes" sheet: the columns used, the rules you chose, the rows left out and why, and the checks against your file.
Beta limits
- Tested on synthetic data; outputs checked in LibreOffice, not yet in Microsoft Excel.
- Charts, pivot tables, pictures and macros of the original are not carried into a redesigned copy (your original keeps them); the designer says so first.
- Old .xls files and password-protected workbooks are not read. An attendance register holds up to 12 months.
- Your files are read in this browser tab only: they are not uploaded, stored or sent to an AI service.
Free to use, no account needed
Open the tool and try it with invented sample files first. Your files are read in your browser and are not uploaded. The tool is in beta and has been checked on synthetic data: compare its results with what you know. Privacy