Dropbox Data Import – Plan Routes With Data From Dropbox

Dropbox is one of the most commonly used cloud-based file hosting services in the world. Since Dropbox is widely used by many businesses of all sizes for storing their information, the Route4Me Route Planner provides direct integration with Dropbox, allowing you to import and optimize your routing data in a fast and effortless manner. Thus, you can import spreadsheets with route data into the system directly from your Dropbox account and then use the imported data for planning and optimizing the most cost-effective routes with Route4Me’s dynamic routing software. Being able to import data into your Route4Me account right from the preferred cloud-based storage enables you to make your route-planning operations more mobile and flexible without having to rely on hard drive storages or being attached to a single computer or mobile device.

 

To plan one or multiple new routes with the data imported from your Dropbox account, first, go to “Plan New Route” from the navigation menu.

Dropbox Data Import - Importing Data from Dropbox for Planning Routes

 

Next, select the “Import Data” option in the corresponding window.

Dropbox Data Import - Importing Data from Dropbox for Planning Routes

 

After that, specify the preferred route parameters and then click on the corresponding button to proceed.

Dropbox Data Import - Importing Data from Dropbox for Planning Routes

 

Next, select “Dropbox” from the list of all supported third-party cloud-based storages.

Dropbox Data Import - Importing Data from Dropbox for Planning Routes

 

Then, click on the “Authorize” button to establish a connection between your Route4Me and Dropbox accounts.

Dropbox Data Import - Importing Data from Dropbox for Planning Routes

 

When authorizing Route4Me to connect to your Dropbox account, you can use Google single sign-on for signing into your Dropbox account. To do so, click on the corresponding button and then use your Google Account credentials to sign in.

Dropbox Data Import - Importing Data from Dropbox for Planning Routes

 

Alternatively, you can sign into your Dropbox account using your email and password accordingly. NOTE: By signing in, you authorize Route4Me to access the data on your Dropbox account.

Dropbox Data Import - Importing Data from Dropbox for Planning Routes

 

After that, you can use the “Home” root Dropbox directory to navigate through the folders and files on your Dropbox account in order to find and select the file that you want to use for planning and optimizing one or multiple routes.

Dropbox Data Import - Importing Data from Dropbox for Planning Routes

 

You can also use the search to find the preferred folders by name.

Dropbox Data Import - Importing Data from Dropbox for Planning Routes

 

Once you open the preferred folder, you can view all files that are stored in this folder on your Dropbox account. Before importing a particular spreadsheet with route data into the system, make sure that this file is either in CSVXLS, or XLSX format and that it corresponds to Route4Me’s spreadsheet requirements (learn more). In the “Name” column, you can view the names of all files that are stored in the opened folder, and in the “Extension” column you can view the format of each corresponding file.

Dropbox Data Import - Importing Data from Dropbox for Planning Routes

 

To import a particular file from your Dropbox account into the system, first, click on this file to select it and then click on the “Import Selected” button to proceed.

Dropbox Data Import - Importing Data from Dropbox for Planning Routes

 

Once you import the selected spreadsheet, Route4Me processes the imported data and displays it in the corresponding window. By default, the system automatically processes all imported data with the “Auto (attempt detection)” Upload Encoding. Alternatively, you can manually match column titles to the data contained in the corresponding columns. To proceed, click on the “Continue to Review” button.

Dropbox Data Import - Importing Data from Dropbox for Planning Routes

 

In the “Verify Addresses on Map” window, you can view all imported and processed addresses on the map, as well as check their geocoding statuses. Green colored dots indicate that the corresponding addresses were successfully geocoded with “High Confidence.” The addresses that have yellow or red colored dots next to them should be reviewed and fixed accordingly. After reviewing the imported addresses, click on the “Finish Import” button to plan the route(s).

Dropbox Data Import - Importing Data from Dropbox for Planning Routes

 

Once the route is planned, it is optimized and then opened in the Route Editor where you can modify it, as well as added to the Routes List with all your routes. When multiple routes are planned from a single spreadsheet, they are opened on the Routes Map (learn more).

Dropbox Data Import - Importing Data from Dropbox for Planning Routes

 

 

Visit Route4Me's Marketplace to Check out Associated Modules:

Was this article helpful?
Still can't find what you're looking for? Contact us
Route4Me

About Route4Me

Route4Me has over 40,000 customers globally. Route4Me's Android and iPhone mobile apps have been downloaded over 2 million times since 2009. Extremely easy-to-use, Route4Me's apps create optimized routes, synchronize routes to mobile devices, enable communication with drivers and customers, offer turn-by-turn directions, delivery confirmation, and more. Behind the scenes, Route4Me's operational optimization platform combines high-performance algorithms with data science, machine learning, and big data to plan, optimize, and analyze routes of almost any size in real-time.