To top

Import Addresses

Excel format or template, csv and more

  1. I’m trying to import a list of addresses but it doesn’t seem to be working. What is the issue?

    Answer: I’ve looked at your file and all of your data is in one single column, therefore, MyRouteOnline is seeing everything as an address (including customer name, notes, etc), and it is unable to import this extraneous data as an “address”.
    Please change your spreadsheet such that column 1 is the Title field (customer name), Column 2 is the Address (only the address…nothing more), and Column 3 is the Comments field (this can contain all of your additional information. You can have multiple fields named “Comments”.
    Once the data is in the correct format, MyRouteOnline will import it with no problem at all.