Import an address list from Excel or CSV
Last reviewed: November 11, 2026
Most routes start with a list: orders from your system, customers in Excel, members from a club database. Here is how to bring it into RouteTidy without retyping addresses.
Try it now: free up to 25 stops, no sign-up →
Which files work
- Excel files in .xlsx format (the first sheet is read).
- CSV and text files separated by commas, semicolons, tabs or pipes.
- The old Excel format .xls is not supported. In Excel, use “Save As” to save the file as .xlsx or CSV.
Route planning template
The quickest way is our template: in the planner open “Import a spreadsheet” → “Download template”. The CSV file opens in Excel, Google Sheets, LibreOffice or Numbers and has every column the import recognizes: name, street address, city, state, ZIP, notes, time window from, time window until and time at stop in minutes. Sample rows show the format; overwrite them with your stops and save the file as CSV or .xlsx again.
How to prepare your list
- One row per stop. A header row with column names helps but is not required.
- Complete addresses work best: street address, city, state and ZIP code – in one column or in separate columns.
- Optional: a column with a name (customer, company) and one with notes for the driver, e.g. “use back entrance”.
- Optional: time windows (“Time window from”, “Time window until”, e.g. 8:00 AM and 10:00 AM – Excel times work too) and time at stop in minutes. They go straight to the stop.
- If you have coordinates (latitude and longitude), include them – those rows need no address search.
Step by step
- Open the planner and click “Import a spreadsheet”.
- Choose your file. RouteTidy recognizes columns by names such as “Customer”, “Address”, “Street”, “City”, “ZIP code” or “Notes” – without a header row, by their content.
- Check the column matching and change it in the drop-downs if needed.
- With an account you can save the entries to your address book at the same time – next time you add regular customers without searching again.
- Click “Add rows”. Addresses that could not be found end up in the box at the top, where you can correct them and add them again.
What happens to your data
The file is read only in your browser and never uploaded. For the address search, only the addresses are sent to our server and from there to the search service – no names or notes.
Names and notes are stored only if you are signed in and save the entries to your address book or a saved route. You can delete both at any time.
Free for routes with up to 25 stops, nothing to install.
Plan a route nowQuestions
- How many addresses can I import?
- Up to 5,000 rows are read. A route holds 25 stops on the free plan and 200 with a day pass or Pro; the address book holds 5,000 entries.
- Why does importing some lists take a few minutes?
- Each address without coordinates is looked up one by one, at most 60 per minute. Saved address book entries and rows with coordinates need no lookup.
- What if an address was found in the wrong place?
- Drag the pin on the map to the right spot. If the stop came from your address book, its position is corrected there too.
More guides
- How to use Google Maps with more than 10 stops
- Share a route with your drivers
- The best stop order: round trip, fixed destination or open end
- How much time does an optimized route save?
- Calculate the mileage cost of a route
- Clean up addresses for route planning
- Paste addresses from an email or document
- Drive your route with Apple Maps or Waze
- Split stops across several drivers or days
- Customer addresses and privacy
- Plan your daily route faster
- Google Maps vs. a route planner: when to use which
- Free route planner for many stops: the checklist
- Route planner without an app
- Plan a route with multiple stops
- Plan routes by bike or on foot
- Breaks in route planning