Your spreadsheet in. Optimized routes out.
Upload the Excel file you already keep. Lite finds the address columns, maps every row, keeps the columns you care about, and hands routes back as a spreadsheet.
- Free for up to 50 addresses
- No credit card
- No app to install
The short answer
Updated
Lite Route Planner makes a map from an Excel file: upload an .xlsx, .xls, .csv or .tsv file, or paste cells from Excel or Google Sheets, and it finds the address columns, pins every row and flags any address it couldn't place. Other columns, like service type or last service date, can come along as custom fields you can color and filter the map by. Lasso the pins into routes, optimize each in one click, and export them back to Excel, CSV or a printable PDF. It's free for up to 50 addresses.
Bring the sheet as it is
Here's the kind of customer list a lawn care company keeps. Nothing needs to be rearranged first.
| A | B | C | D | E | F | G | H | I | |
| 1 | Customer | Street | City | State | Zip | Service | Monthly ($) | Last service | Dog? |
|---|---|---|---|---|---|---|---|---|---|
| 2 | Marla Okafor | 1418 Juniper Ln | Round Rock | TX | 78681 | Mow + edge | 160 | 10/02/2026 | No |
| 3 | Briarwood HOA | 2200 Briarwood Ct | Round Rock | TX | 78681 | Common areas | 1,250 | 10/06/2026 | No |
| 4 | Dev Patel | 907 Sage Hollow Dr | Pflugerville | TX | 78660 | Mow | 120 | 09/18/2026 | Yes |
| 5 | Tran family | 315 Cedar Bend Trl | Hutto | TX | 78634 | Mow + fertilize | 185 | 08/29/2026 | No |
| 6 | Hollis Family Dental | 4501 Old Mill Rd | Round Rock | TX | 78664 | Commercial | 640 | 10/09/2026 | No |
Street, City, State and Zip are recognized as the address and joined into one line. The other columns can come along as custom fields, typed from what's in them: Customer and Service as text, Monthly ($) as a number, Last service as a date, and Dog? as yes/no. Columns titled Email, Phone or Notes are never mistaken for the address.
From spreadsheet to routes in five steps
- 1
Upload or paste
Drag in an .xlsx, .xls, .csv or .tsv file, or copy the cells in Excel or Google Sheets and paste them. Only the first sheet of a workbook is read, so keep your list there.
- 2
Check the columns
The address columns are picked for you; change them if the guess is wrong. Switch on any other column to keep it as a field. Dates are understood whether they're written 10/02/2026, Oct 2, 2026 or 2026-10-02.
- 3
Fix the flagged rows
Addresses that couldn't be found, or could only be placed roughly, are listed for you. Retype one, paste coordinates, or click the map to place it.
- 4
Lasso and optimize
Draw around a group of pins to make a route, or filter by a column like Service first. Press Optimize to put each route in the shortest order.
- 5
Export it back
Download routes as Excel or CSV in stop order, or as a printable PDF for the clipboard.
Made for a list that keeps changing
Re-import without duplicates
Load next month's sheet and the addresses you already have aren't added again. Their fields are filled in from the new file, so an updated Last service column updates every stop.
Codes stay codes
Columns like gate codes, account numbers and phone numbers stay text, so leading zeros don't disappear the way they can in Excel.
Up to 30 fields per stop
Service type, contract value, renewal date, key required. Each field is text, a number, a date or yes/no, and you can color and filter the map by any of them.
Headings optional
If the first row has headings, they name your fields. If it doesn't, the address column is found from what's in it, and the rest are named Column A, Column B and so on.
Paste from Google Sheets
Copy the cells and paste them in. They're read just like a file, headings included.
Big files welcome
A file can have up to 50,000 rows and 20 MB. How many addresses you keep depends on your plan, from 50 on Free to 10,000 on Business.
Spreadsheet-friendly route planners
If your list lives in Excel, these are the tools that take it as it is. Here's what each one does with it.
| Feature | Lite | MyRouteOnline | RouteXL | Google My Maps |
|---|---|---|---|---|
| Brings in your list | Excel, CSV, TSV or pasted cells | Excel, up to 1,000 addresses | Paste from Excel | CSV, XLSX or Google Sheets, 2,000 rows |
| Puts stops in the best order | Yes | Yes | Yes | No |
| Exports | Excel, CSV, PDF, Google Maps links | Not stated | GPX, ITN, CSV, KML | Not stated |
| Driver app | Phone's browser, nothing to install | Native MyRoute app | No driver app | No |
| Price to start | Free for up to 50 addresses | $19 a month for 50 address credits | Free up to 20 stops | Free |
Checked October 19, 2026 on each vendor's pricing pages. MyRouteOnline bills by address credits with unlimited users; RouteXL's paid plans start at €35 a month for 100 stops. See how MyRouteOnline compares.
What comes back out
Export one route or several as Excel or CSV. You choose which columns to include and in what order: route, stop number, address, status, latitude and longitude, distance from the previous stop in miles or kilometers, and a Google Maps link for each stop. Rows come out in driving order.
Export a completed route and the Status column becomes a record of the day: which stops were Visited, Attempted or skipped. The printable PDF puts the same route on paper for the truck.
Your custom fields stay with the stops in Lite, where you can color, filter and edit them; the export is the route itself. Setting up a sheet from scratch? Start with a route planning spreadsheet template, or read how to plan delivery routes from a spreadsheet.