Check out the video below for a narrated overview of how to import spreadsheets into Route Planner. For best results, turn your audio volume up and use the full-screen icon to maximize the size of the embedded video.
With Route Planner, you can import up to 26 addresses from an Excel (XLS) or Comma Delimited (CSV) worksheet. Here's how:
- Create columns in your sheet in the following order: Street, City, State, Zip, Country (Optional), Notes (optional)
- Head to mapquest.com/routeplanner
- Click the Import tab
- Drag your file into the upload box, or browse to select the spreadsheet from your computer
- Once Route Planner has populated your route stops, click View Route Directions
Please note: If you're having trouble importing a CSV, please check your commas and ensure that all 5 address fields are represented on each line and properly separated by commas or spreadsheet cells. Comment values are always optional, but if you include comments be sure they are in the 6th column, or have the correct amount of commas preceding them based on the required fields.
If you have any trouble uploading a spreadsheet after reading through these tips and instructions, feel free to reach out to our support team for help by clicking here.