ODB Buildings Data to Excel

Customer: AI | Published: 05.02.2026

I have an ODB database sourced from the Statistics Canada page ( https://www150.statcan.gc.ca/n1/pub/34-26-0001/342600012018001-eng.htm ) that lists every non-residential building across Canada. I need the entire dataset— every province, every building— exported into a single, clean .xlsx workbook. Please place all fields in one master sheet and activate an auto-filter row so I can sort and slice instantly. At minimum each record must include: building name (if present), street address, city, province, latitude, longitude, number of floors, and every other column that appears in the original ODB file. Both the full address string and the explicit lat/long coordinates have to be preserved so I can map or geocode later. The ODB occasionally stores lookup tables in separate relations; bring those values across so the sheet is human-readable— no foreign-key IDs left unresolved. If you use any transformation scripts (Python, LibreOffice Base, SQL, Power Query, etc.) please hand those over as well; I may need to re-run the process when updated releases appear. If I decide to add extra columns later, I’ll let you know, so keep your workflow flexible enough to accommodate a quick re-extract. Deliverables for acceptance: • Clean, filter-ready .xlsx file with every building in Canada • Any code or queries used for the export/conversion That’s all— looking forward to a smooth, accurate conversion.