DocsUploading Excel & CSV Files
Import your property listings from Excel or CSV files
Uploading Excel & CSV Files
The fastest way to get your properties into Sift is uploading an Excel (.xlsx, .xls) or CSV file. Sift auto-maps your columns to property fields and runs a quality check on the data.
Upload Steps
In the dashboard sidebar, click Sources.
Click the Upload File button. A file picker opens.
Choose an Excel or CSV file from your computer. Supported formats:
.xlsx(Excel).xls(Legacy Excel).csv(Comma-separated values)
Sift reads your file headers and auto-maps them to property fields:
| Sift Field | Commonly Matched Headers |
|---|---|
| Title | title, property name, listing name |
| Price | price, amount, cost, asking price |
| Bedrooms | bedrooms, beds, bed, BR |
| Bathrooms | bathrooms, baths, bath |
| Area (sqft) | area, size, sqft, square feet |
| Location | location, area, district, neighborhood |
| Type | type, property type, category |
| Description | description, details, notes |
The mapping uses fuzzy matching — your columns don't need to be named exactly. Review the mapping and adjust if needed.
Click Import to process the file. Sift imports the properties and shows you:
- Total rows in the file
- Imported rows successfully processed
- Quality score (0–100) based on data completeness
- Quality report with details on any issues
Quality Score
After import, each upload receives a quality score from 0 to 100:
| Score Range | Rating | Meaning |
|---|---|---|
| 80–100 | Excellent | Most fields filled, data is clean |
| 60–79 | Good | Some missing fields but usable |
| 40–59 | Fair | Many missing fields — agent will have limited matching |
| 0–39 | Poor | Critical fields missing — consider improving the data |
The quality report highlights specific issues like:
- Missing prices (agent can't match by budget)
- Missing locations (agent can't filter by area)
- Missing bedroom counts (limits property suggestions)
Tip
Tips for Best Results
- Use a header row — Sift reads the first row as column names
- One property per row — avoid merged cells or multi-line entries
- Prices as numbers — use
350000instead of£350,000(Sift handles currency formats, but clean numbers work best) - Consistent location names — use the same neighbourhood names across rows (e.g., always "Hackney", not sometimes "Hackney" and sometimes "London E8")
Download Template
If you'd like a reference file, click the Download Template button on the Sources page. This gives you an Excel file with all the supported columns pre-named.
Upload History
All your past uploads are listed on the Sources page with:
- Filename
- Upload date
- Number of properties imported
- Quality score