Import the old spreadsheet
Read jobs-tracker.xlsx, say what was cleaned, ask about the rest
The file
- Workbook
- before/jobs-tracker.xlsx
- Size
- 94 KB
- Sheets
- Jobs, Price List, CUSTOMERS, Pivot, Timesheets, Invoices, Sheet1
Nothing is written to the system yet. This reads the file and shows you what it found.
How this works
- Read. Every row of every sheet, including the merged headings and the broken pivot.
- Clean what is unambiguous. Eight date formats become one. Thirty spellings of "done" become one status. Every fix is listed with the value before and after.
- Ask about the rest. Where two answers are both defensible, it asks. Identical questions are grouped, so answering once covers every row it applies to.
- Match, do not duplicate. Rows that already exist are matched on job number, or on customer, date and description when the number is missing.
- Apply, or undo. Everything created is tagged with the import, so the whole thing comes back out in one click.