[Skip to content](#main-content)

Features

[Land Lead Management](/features/land-lead-management)[Field Execution](/features/field-execution)[Pricing Intelligence](/features/ai-pricing)[Document Verification](/features/document-verification)[Task Management](/features/task-management)[Competitor Intelligence](/features/competitor-intelligence)[Location Intelligence](/features/location-intelligence)[Smart Dashboard](/features/smart-dashboard)[Audit Trail](/features/audit-trail)[View all features](/features)

Solutions

For your business

[Real Estate Developers](/solutions/real-estate-developers)[Banks & NBFCs](/solutions/banks-nbfcs)[Land Valuation Teams](/solutions/land-valuation-teams)[Legal Teams](/solutions/legal-teams)

For your team

[Decision Maker](/roles/decision-maker)[Team Lead](/roles/team-lead)[Field Team](/roles/field-team)

By Use Case

[Land Acquisition](/solutions/land-acquisition)[Site Analysis](/solutions/site-analysis)[Portfolio Management](/solutions/portfolio)[View all roles](/roles)

Compare

[Proquiro vs Excel](/vs/excel)[Proquiro vs Google Sheets](/vs/google-sheets)[Proquiro vs WhatsApp](/vs/whatsapp-tracking)[Proquiro vs Manual Process](/vs/manual-process)[Proquiro vs LAMS](/vs/lams)[Proquiro vs ERP](/vs/erp)

Resources

[Land Area Converter](/tools/land-area-converter)[Price Per Sq Ft](/tools/price-per-sqft-calculator)[ROI Calculator](/tools/land-roi-calculator)[OSR Calculator](/tools/osr-calculator-india)[Due-Diligence](/tools/land-due-diligence-checklist)[Site Visit](/tools/site-visit-checklist)[Legal Documents](/tools/document-readiness-checker)[Excel Template](/tools/excel-template)[All tools](/tools)

[Pricing](/pricing)

[ Sign in ](https://app.proquiro.com)[Request a Demo](/contact/sales)[Start at ₹639/mo](https://app.proquiro.com/users/sign%5Fup?plan=solo)

# Importing competitors in bulk

Upload a spreadsheet of competitors to add them to multiple lead sites quickly, instead of entering the same records one by one.

3 min readUpdated Mar 10, 2026

In this category · 2 articles

[Tracking competitors near your sites](/help/competitors/tracking-competitors)[Importing competitors in bulk](/help/competitors/competitor-import)

## Competitor Tracking

[Tracking competitors near your sites](/help/competitors/tracking-competitors)[Importing competitors in bulk](/help/competitors/competitor-import)

If you have an existing spreadsheet of competing projects, you can import them in bulk instead of adding each one manually. This is especially useful when you’re onboarding a new market or consolidating research from multiple team members.

![Competitor import dialog](/help/screenshots/competitor-import.png)

## Before you start

Your CSV must use UTF-8 encoding. Maximum 500 rows per import. Each row becomes one competitor record.

**Tip:** If you’re using Excel, go to File → Save As and explicitly choose “CSV UTF-8” — the default CSV option in some Excel versions uses a different encoding that can corrupt special characters.

## Import steps

1. Go to **Competitors** in the sidebar.
2. Click **Import** → **Download Template**.
3. Open the downloaded `competitors-template.csv` in Excel or Google Sheets.
4. Fill in your data. Column headers must not be changed — only add rows below the header row.
5. Save as CSV (UTF-8).
6. Back in Proquiro, click **Import** → **Upload CSV** and select your file.
7. On the column mapping screen, confirm that each CSV column is matched to the correct Proquiro field. Adjust any mismatches using the dropdowns.
8. Click **Validate**. Proquiro checks for formatting errors before importing.
9. Review the validation summary (see below), then click **Import** to finish.

## Column reference

| CSV column       | Proquiro field                    | Required |
| ---------------- | --------------------------------- | -------- |
| name             | Name                              | Yes      |
| developer        | Developer                         | No       |
| type             | Type (Apartment / Villa / Layout) | No       |
| stage            | Stage                             | No       |
| price\_per\_sqft | Price/sqft                        | No       |
| village          | Village                           | No       |

The **Type** column must contain exactly `Apartment`, `Villa`, or `Layout` (case-insensitive). Any other value will fail validation for that row.

**Tip:** Start with the downloaded template rather than building your own CSV from scratch — it guarantees the column headers match exactly what Proquiro expects.

## Validation and errors

After clicking **Validate**, you will see:

- **Valid rows** — ready to import
- **Rows with errors** — listed with the row number and a clear reason (e.g., “Invalid type value”, “Name is required”)

You can download an error report as a CSV, fix the rows in your spreadsheet, and re-upload. Rows with errors are skipped; valid rows will still import if you choose to proceed — so you don’t have to fix everything in one pass.

## Checking import results

Once the import completes, a summary shows how many records were created. The new competitors appear immediately on the Competitors page. Use the search or filters to verify the data looks correct.

If you need to undo an import, you must delete records individually or contact support for a bulk delete. Because of this, it’s worth doing a quick spot-check of your CSV before importing.

Share:

Sorted?YesNo

Still need help?

We usually reply within hours.

[Contact support](/contact)

## Related articles

[Competitor TrackingTracking competitors near your sites](/help/competitors/tracking-competitors)[Account SettingsManaging account settings](/help/account/account-settings)[Account SettingsReviewing audit logs](/help/account/audit-logs)