Can I import from spreadsheets or other files?

Categories: Route Planning, Top Questions

Importing Spreadsheets

.XLSX files can be imported directly from within inRoute, sent as email attachments to your device and opened from Mail, or shared from your spreadsheet app (.XLSX is the native format for MS Excel and supported by Apple Numbers and Google Sheets as well). For example,

1) Within inRoute, tap the map’s More icon (on Mac, the File menu), then tap “Import”, and select the file from its location.

2) Or, email the file to yourself. Then, in the iOS Mail app, tap the attached file at the bottom of the message, and select “inRoute” from the second row of app icons to import it (“inRoute” may be under the “More” button at the far right). On a Mac, drag and drop the file onto inRoute.

.XLSX files must include a header row at the top, and during import you will be prompted to choose the columns that contain addresses (street, city, etc.), then the columns that contain the name to use for each map pin (first name, last name, business, etc). The format is flexible so a single column list of addresses works as well. Each row of the file creates a pin on the map, and the resulting route is automatically optimized if that is enabled under the Route button. Examples are available for download below:

inRoute_Template1.xlsx

inRoute_Template2.xlsx

Importing other File Types

For more information about importing files, see Can I import from files or other apps?

Show all FAQs