Import Locations

The Import Locations panel allows you to bulk import geographic location data—such as countries, states, cities, and areas—into your Houzez site using a CSV file. This saves time and ensures consistent location taxonomy across listings.

Key Stats Overview

• Countries: Total number of countries currently imported.
• States/Counties: Total states or provinces.
• Cities: Total cities added.
• Areas: Total neighborhoods or districts.

CSV File Upload

You can upload a .csv file containing the location hierarchy you want to import.
Click Choose File, select your CSV file, and optionally click Fetch CSV Headers to preview the column structure.

The file must include at least one column each for Country, State, City, and Area. You can include only the levels you need.

CSV Format Requirements

CSV Structure

• Include column headers (e.g., Country, State, City, Area)
• Headers should match the expected field names
• Each row represents a location hierarchy (from country to area)

Hierarchical Import

Houzez automatically creates relationships:

• Areas belong to Cities
• Cities belong to States
• States belong to Countries

No need to manually assign these relationships.

Smart Import

• Detects and updates existing locations
• Avoids duplication by intelligently checking existing entries
• Automatically adds only the missing or new items

Sample CSV Format

Here's an example of the correct CSV layout:

COUNTRY	STATE	CITY	AREA
United States	California	Los Angeles	Beverly Hills
United States	California	San Francisco	Mission District
United Kingdom	England	London	Westminster

Tips

• You can clear selection if you uploaded the wrong file
• Use Fetch CSV Headers to double-check the column structure before import
• Click Refresh Page to see updated stats after an import