You have 80 clients in a spreadsheet, another 30 in your phone contacts, and a handful scribbled in a notebook. You just signed up for lawn care software. Now you're staring at an "Add Client" button wondering if you really have to type each one in manually.
You don't. Importing your existing lawn care clients into new software should take minutes, not hours. The right tool handles spreadsheets, messy notes, and even data exported from other software like Jobber or HouseCall Pro. Here's how each method works and when to use which one.
Importing Lawn Care Clients From a Spreadsheet
If your clients are in a CSV or Excel file, this is the fastest path. Export from your old software, Google Sheets, or Excel, then upload the file.
In FieldPlexus, go to Clients, tap "Import Clients," and choose "Upload a File." Drag and drop your file or tap "Choose File." The system reads your column headers and uses AI to suggest which columns map to which fields: your "Customer" column maps to Client Name, your "Mobile" column maps to Phone, your "Street" column maps to Address.
The Column Mapping screen shows each of your columns with a suggested match. Green checkmarks mean the system is confident. If something looks wrong (your "Phone" column shows email addresses in the preview), fix it with the dropdown. Select "Skip this column" for columns you don't need, like internal IDs from your old software.
After mapping, the Preview screen shows exactly what will be imported. Stats at the top tell you how many are ready, how many have notes (like missing contact info), and the total row count. Rows with missing names are flagged and excluded automatically. You see the data before anything happens.
Tap "Import X Clients" and they're in. For 85 clients, the actual import takes seconds. You're redirected to your Clients page with everything populated.
When Your Clients Are Scattered Across Notes and Texts
Not every landscaper has a tidy spreadsheet. Some have clients in phone notes, text message threads, email signatures, and a mix of Word documents. The Paste Text method handles this.
Go to Clients, tap "Import Clients," choose "Paste Text." Copy whatever you have (from notes, documents, anywhere), paste it into the text box, and tap "Extract Clients." AI reads the messy text and pulls out names, phone numbers, email addresses, and addresses.
It works with genuinely messy input. Something like "John Martinez - 239-555-1234, john@email.com, lives on Oak Street, gate code 5555" alongside "Mike's Pool Service, mike@poolservice.com, (239) 555-9876, commercial account net 30" gets correctly parsed into two separate clients with the right fields populated.
The limit is about 20 clients per paste. More than that and the AI extraction can time out. For larger lists, do multiple batches of 20. Five batches of 20 takes about 10 minutes total.
Setting Up Parent-Child Billing During Import
If you service property management companies, you can set up parent-child billing relationships during import instead of configuring them one by one afterward.
Two columns control this: "Is Parent" and "Parent Name." For the property management company row, put Y in the Is Parent column. For each property row, put the exact name of the parent in the Parent Name column.
Example: Sunshine Properties has Y in Is Parent. The rows for 123 Oak Lane, 125 Oak Lane, and 127 Oak Lane each have "Sunshine Properties" in the Parent Name column. The system creates Sunshine Properties first, then creates each property and links it automatically.
Spelling matters. "Sunshine Properties" in the parent row and "Sunshine Property" in the child row won't match. Copy and paste the parent name to avoid typos. The preview screen shows a note on child rows: "Will link to parent: Sunshine Properties" so you can verify before importing.
The Template Method for Starting Clean
If you don't have a spreadsheet yet and want to start organized, FieldPlexus provides a Google Sheets template with the right columns already set up.
Choose "Start Fresh" from the import options. Tap "Open Template in Google Sheets." Make a copy to your own Google Drive. Delete the example rows, enter your clients, then download as CSV and upload back to FieldPlexus.
The template has three tabs: Instructions (step-by-step guide), Template (where you enter data), and Examples (sample data for reference). Columns include Name, Email, Phone, Address, City, State, Zip, Notes, Is Parent, Parent Name, and Autopay. Only Name is required. Everything else is optional but helpful.
Quick Add for Small Lists
If you have fewer than 15 clients, Quick Add might be faster than any file-based method. Choose "Quick Add" from the import options and you get a simple form with rows for Name, Phone, and Email. Type them in, tap "Import X Clients," done.
Quick Add doesn't capture addresses or notes. If you need those, use file upload or the template. But for a small list where you just need names and phone numbers in the system fast, it's the quickest path.
What Happens With Duplicates and Phone Numbers
Two things the import handles automatically that save you headaches.
Duplicate detection compares client names (case-insensitive). If "John Smith" already exists in your account and your import file also has "john smith," the duplicate is skipped. Your existing client stays untouched. The results screen shows exactly which clients were skipped and why. This means you can safely re-import the same file without creating doubles.
Phone number formatting is automatic. Your spreadsheet might have (239) 555-1234 in one row, 2395551234 in another, and +1-239-555-1234 in a third. The system normalizes all of them. You don't need to clean up phone formats before importing.
After the Import: What to Do Next
Clients are in. Now set up the rest of your workflow.
Notification preferences are set automatically based on what contact info was imported. Client with both email and phone gets "Email & SMS." Client with only email gets "Email Only." You can change these per client later.
If you set up parent-child relationships during import, verify them by opening a few child properties and confirming the parent is linked correctly. The Clients page shows parent names on child records.
Next, set up your recurring schedules. The import brings in clients but not appointments. Create weekly, biweekly, or monthly recurring schedules for each client. With smart defaults, each one takes about 30 seconds.
Finally, import your equipment and services catalog if you have them. Services import works the same way (Settings, Services tab, Import Services) with the same four methods: file upload, paste text, template, and quick add.
Jason from Trusting & Affordable Tree Service brought over 85+ clients when he started with FieldPlexus, including two property management companies with 20 to 30 individual properties. The parent-child relationships were set up during import. "Super easy to navigate and learn. Any questions, just ask the help AI."
If you're switching from another system or starting from scattered notes, FieldPlexus imports your client list in minutes with four different methods to match however your data lives today. Try it free for 14 days.