NuVentrec

Guides / Spreadsheet to CRM

Guide · Switching and importing

How to move your leads from a spreadsheet to a CRM in one day.

Most real estate businesses start with a spreadsheet, and most moves to a CRM go wrong in the same three places: phone numbers, ZIP codes and parcel numbers mangled by Excel, one person split into three rows, and opt-outs that get lost on the way. Here is a one-day plan that avoids all three.

By the NuVentrec team · Published October 19, 2026 · Sources last checked October 19, 2026

The short answer

  • Morning: clean a copy. One row per person, one column per fact, phones and ZIP codes stored as text.
  • Move opt-outs first. Anyone who said stop goes in before anyone else, so they can never be called by mistake.
  • Save as CSV, one tab at a time. Excel saves only the current sheet to a CSV file.
  • Import 50 rows, check them, then the rest. Look at real records on screen before you trust the counts.
  • Afternoon: work from the CRM, and lock the spreadsheet so nobody keeps two lists.

Before you start: what a CSV really is

Every CRM imports CSV files, so it helps to know the format's few rules. The format's reference, RFC 4180, says "each record is located on a separate line", that there "maybe an optional header line appearing as the first line of the file", and that fields are "separated by commas". Two rules explain most broken imports: "fields containing line breaks (CRLF), double quotes, and commas should be enclosed in double-quotes", and "a double-quote appearing inside a field must be escaped by preceding it with another double quote." A note with a comma or a line break in it is fine, as long as the program that wrote the file quoted it. Excel and Google Sheets do this for you; hand-edited files often do not.

Morning, part 1: make a clean copy (2 hours)

Never clean the original. Save a copy with today's date in the name and work on that.

  1. One header row. Delete title rows, blank rows and totals above or below the data. Give every column a short, plain name: First name, Last name, Phone, Email, Mailing address, City, State, ZIP, Property address, County, Parcel number, Source, Status, Notes.
  2. One fact per column. If one cell holds a name and a phone number together, split it into a name column and a phone column. If a cell holds two phone numbers, move the second one to a Phone 2 column.
  3. One row per person. If the same seller appears on three rows because they own three parcels, keep one row for the person and list the parcels in their own columns or a second file. Our guide to duplicate contacts explains how to decide who is the same person.
  4. Keep the history. Old notes and last-contacted dates are worth moving. Put them in a Notes column rather than throwing them away.

Morning, part 2: protect phones, ZIP codes and parcel numbers (30 minutes)

This is where Excel quietly damages a list. Microsoft's own help page says "Excel automatically removes leading zeros", so a Massachusetts ZIP code like 02134 becomes 2134. It also "converts large numbers to scientific notation, like 1.23E+15", and "any numbers past the 15th digit are rounded down to zero". Long parcel numbers and account numbers are exactly the kind of value that gets ruined.

Microsoft's fix is to format those columns as Text before the data goes in, or to import the file with each of those columns set to Text. Its help notes that formatting as Text "will not change numbers that have already been entered", so if the damage is already done, go back to the source (the county file, the old CRM export) and bring those columns in again as text. Do this for Phone, ZIP and Parcel number at least.

Late morning: opt-outs first (30 minutes)

Find everyone who ever asked not to be contacted: "stop", "do not call", "remove me", a returned letter marked refused, a note that says "angry, never call". Put them in their own file with a column that says which channel they opted out of. Import that file first, as opt-outs, before any other lead. Then if a duplicate of that person turns up later in the main list, the CRM already knows not to call them. The opt-out list guide covers what to keep and why.

Midday: save as CSV, one tab at a time (15 minutes)

In Excel, use File, Save As, and choose CSV as the file type. Excel then warns that "only the current worksheet will be saved to the new file", and that your worksheet "may contain features that are not supported by text file formats". Both are normal: colors, formulas and other tabs do not travel in a CSV. If your sellers and buyers are on separate tabs, save each tab as its own file and import them separately, so each gets the right type and tags.

Before importing, run the file through our import checker. It reads the file in your browser, uploads nothing, and points out empty rows, phone numbers that cannot be used, emails that do not look right and likely duplicates.

Early afternoon: test with 50 rows (30 minutes)

  1. Import the first 50 rows only. Match each column to a CRM field. Anything without a field becomes a custom field or a note, never dropped.
  2. Open five records and compare them with the spreadsheet, cell by cell. Check a ZIP code with a leading zero, a phone with an extension, and a note with a comma.
  3. Search for a person you know is in the file by phone number. If search cannot find them, the phone column did not import the way you think.
  4. If anything is wrong, undo the test import, fix the file, and try again. That is what the 50-row test is for.

Afternoon: import the rest and switch over (1 to 2 hours)

  • Import in pieces of a few thousand rows if your list is large, and check the counts after each one: rows in the file, contacts made, duplicates merged, rows skipped and why.
  • Assign owners so every lead has a person, and give every open lead a next task with a date.
  • Lock the spreadsheet. Rename it "OLD, do not edit" and make it read-only. Two lists means two versions of the truth by Friday.
  • Make tomorrow's call list in the CRM, so the first working day after the move proves the move.

Moving from another CRM rather than a spreadsheet? Read how to switch CRMs and keep your history, or answer a few questions in the switching checker.

How this fits in NuVentrec today

NuVentrec's Import page reads a CSV or Excel file in your browser, shows what it found before anything is saved, imports in pieces you can undo, and keeps a list of past imports. Columns without a standard field can become your own custom fields. Opt-outs are kept on one list for the whole business. If you would rather hand the move over, guided setup and done-for-you migration are on the pricing page.

Questions people ask

Why did my ZIP codes lose their first zero?

Excel treats them as numbers and, as Microsoft puts it, "automatically removes leading zeros". Format the ZIP column as Text before the data goes in, or bring the column in as Text when you import, then save the CSV again.

Why do my parcel numbers show as 1.23E+15?

Excel converts long numbers to scientific notation and rounds anything past the 15th digit to zero. Bring the column in again from the source as Text. Once the digits are rounded, they cannot be recovered from that file.

Should I import everything or start fresh?

Import everything you are allowed to keep, including old notes and opt-outs. Old leads are often the cheapest deals you will find, and old opt-outs are the ones you most need to remember.

How long does a move from a spreadsheet take?

For a list of a few thousand rows, one working day is realistic with the plan above. Most of the time goes into cleaning the copy, not into the import itself.

Can I import an Excel file directly?

Many CRMs, NuVentrec included, read Excel files. Saving each tab as CSV still helps you check exactly what will be imported, one tab at a time.

Sources

  1. RFC 4180, Common Format and MIME Type for Comma-Separated Values (CSV) Files
  2. Microsoft Support, "Import or export text (.txt or .csv) files"
  3. Microsoft Support, "Keeping leading zeros and large numbers"

Check the file first, import in pieces you can undo.

Check my fileBook a walkthrough
Call now