From Excel to Odoo: a practical data migration checklist

When spreadsheets stop scaling

Spreadsheets are a great way to start. But as a business grows, the same files become a risk: versions multiply, formulas break, and nobody is sure which number is correct. Moving to Odoo gives you one source of truth. The key to a smooth move is the data migration.

Step 1: Inventory your data

List every set of data you rely on today and decide what moves to Odoo:

• Customers and vendors with contact and tax details
• Products, units of measure, categories and price lists
• Opening balances for accounts, customers and vendors
• Current stock levels per warehouse and location
• Open sales orders, purchase orders and unpaid invoices

Step 2: Clean before you move

Migration is the best moment to fix old problems. Remove duplicates, standardize names and phone formats, check VAT numbers and make sure units of measure are consistent. Clean data in means reliable reports out.

Step 3: Map your columns to Odoo fields

Odoo can import CSV and Excel files and provides import templates for common records. Map each column in your files to the right Odoo field, and use external IDs so that related records, such as products and their price lists, stay connected.

Step 4: Test in a staging database

Never import straight into production. Run the full import in a test database, then ask each department to check its own data: sales checks customers and prices, the warehouse checks stock, finance checks balances. Fix, re-import and repeat until everything matches.

Step 5: Plan the cut-over

• Choose a cut-over date, ideally at the start of a month or period.
• Freeze changes in the old files shortly before go-live.
• Run the final import and reconcile opening balances with finance.
• Count stock physically if needed, so Odoo starts from real numbers.

Step 6: Train and verify

Train each team on real data they recognize, and keep a short checklist for the first weeks: are invoices correct, is stock moving as expected, do reports match reality? Small fixes early prevent big problems later.