You can export a report for all locations from Compare Mode. To have each location on a separate sheet, select XLSX (Tabs).