Moving from Excel or another spreadsheet
Export these files from Excel or another spreadsheet, then upload them in Move to DIANO.
These are the same steps as in Move to DIANO. Last checked: 2026-10-19.
1. Download DIANO's Excel templates
Where: DIANO › Move to DIANO › Templates
One workbook per list, each with an example row (INVENTED), drop-down lists and an Instructions tab.
Keep them as Excel (.xlsx).
2. Fill in your trial balance on the day before your start date
Where: Templates › Trial balance
A trial balance lists every account with its balance on one day. Choose the date the day before your start date (the day before your start date). Show all accounts. It has a Debit and a Credit column, and the two totals are the same.
Save as Excel (.xlsx).
3. Fill in your unpaid customer invoices
Where: Templates › Unpaid customer invoices
One line for each customer invoice that is not fully paid, on the day before your start date: customer, invoice number, date and the amount still owed. Choose the detailed report (one line per invoice), not the summary.
Save as Excel (.xlsx).
4. Fill in your unpaid supplier invoices (if it applies)
Where: Templates › Unpaid supplier invoices
One line for each supplier invoice you have not fully paid, on the day before your start date: supplier, their invoice number, date and the amount you still owe. Choose the detailed report. If you owe no supplier anything, you can skip this file.
Save as Excel (.xlsx).
5. Fill in your customers, suppliers and items
Where: Templates › Customers / Suppliers / Items
One line per customer, supplier or item, as in the example row.
Save as Excel (.xlsx).