How to move your Excel property list into a CRM
A step-by-step guide to bringing the sheet you already keep into Real Vista, with a preview of what will happen before anything is saved.
Before you start
Only an admin of the workspace can open the Import from Excel screen, at /admin/import in the web app. It accepts .xlsx, .xls and .csv files up to 15 MB, and one sheet at a time, so pick the sheet when the workbook has several.
Put your headings in the first row. A property needs at least a name, so if your sheet has only plot numbers, add a name column such as "Plot 214, Sector 57".
Step 1: choose the category and the file
Choose which kind of property the file holds. The category decides which extra fields the file can fill in, such as facing or khasra number. You can download a blank template for the category with the right headings and fill it in, then the next step maps itself. Then drop your file in or click to browse.
Step 2: match your columns
Real Vista reads your headings and guesses where each column goes. A column matched by guesswork is marked as a guess, and a column it could not place shows "Not matched". Next to each column you see an example value from your file, and you can change where it goes or choose not to import that column.
The importer understands the formats seen in Indian sheets: prices such as 1.2 Cr, 85 Lakh, 45L or Rs. 9,500,000, dates written day first, and yes or no style answers. It can fill the plot size in sq yard (gaj), the rate per sq yard and the area in sq ft. If a required field is not matched, it tells you before you go on.
Step 3: review before anything is saved
The review step checks every row and saves nothing. Each row is ready, already in the system, repeated in your file or cannot be imported, and a row that cannot be imported says why. You can download the problem rows and the skipped rows, fix them in Excel and import them again.
Properties already in the system are matched on the property number, or on name and address when there is no number. You choose what happens to them: leave the existing one alone, update it with the row, or add it anyway. Leaving it alone is the safe choice for topping up a list.
Step 4: import and check the result
Approve the review and the properties are imported in batches while you keep the tab open. You see how many were added, updated, skipped or failed. If the import stops partway, what was already imported is saved, and running the same file again skips the duplicates.
Frequently asked questions
Can I import leads or buyers the same way?
Leads have their own importer, which maps your column headings to lead fields. This guide covers properties.
Will it create duplicates if I run the file twice?
Not by default. Properties already in the system are matched and skipped unless you choose to update them or add them anyway.
What if some rows have mistakes?
They are marked in the review with the reason, and you can download the problem rows, fix them and import them again.
Who can import?
Only an admin of the workspace.
Want to see it on your own leads and plots? We will walk you through it in a short demo.
More from Real Vista: Lead capture and follow-ups · Plot inventory · Buyer matching and dealers · CRM for property dealers · CRM for property dealers in Bathinda · Gaj, marla and kanal calculator · Share properties with buyers safely · Pricing