--- title: "How to add orders" description: "Upload a spreadsheet into your Routific Workspace, or add orders one by one" url: https://help.routific.com/en/articles/6-how-to-add-orders collection: "Route planning" updated: 2026-10-30 language: en --- # How to add orders Upload a spreadsheet into your Routific Workspace, or add orders one by one ### Watch: Uploading orders into Routific Before you can plan a route, you need to know where you're going. The only thing Routific needs is a list of addresses. Everything else is optional. You might also want to add extra information like: - Customer name - Order or invoice number - Contact details (email or phone number) - Unit or buzzer number - Delivery time windows - Duration - Load - Delivery notes for the driver **There are three ways to add orders:** 1. Upload a spreadsheet 2. Add orders manually 3. Import them automatically with an integration ## **1\. Upload orders using a spreadsheet** ### Set up your spreadsheet This is what your spreadsheet should look like: ![](https://staticfiles.gleap.io/ghelparticle/7TMvMrndUii4o6dRtIQ0PFkNQoGnMtB7tDW1HWaJsNXfdjdrBBD2siGXeAhY6wdx6voeLUAfzVv.png) You can [download a sample to use as a formatting guide](https://docs.google.com/spreadsheets/d/11QFFxPaqbpBgRIeymLi_5hV59HCB7lisK_9CQaAid5o/edit?usp=sharing) or [learn more about how to format addresses](https://help.routific.com/en/articles/10-how-to-format-addresses.md). CSV, XLS and XLSX files are accepted. **Required information**

Address

The best format for making addresses easy to find is:

Street Number and Street Name, City, State/Province (when applicable), Zip/Postal Code (when applicable), Country.

You can also split the address into separate columns (Street Address, City, State, Zip/Postal Code, Country).

> **Info:** If you use lat-long coordinates, create two columns titled Latitude and Longitude instead of the Address column. **Optional information**

Customer Name

Adding a customer name makes it easier to find and manage orders. If you don't have one, Routific automatically assigns a unique number to each order.

Order Number

Use your own order or invoice number. It shows up in the order details for dispatchers, in the mobile app for drivers, and in the Delivery Tracker sent to your customers.

If you don't have your own order number, Routific automatically generates a unique Routific ID. Dispatchers, drivers, and customers will all see this ID instead.

Unit Number

Delivering to an apartment or suite? Put the unit number in its own column, not in the address. This makes sure the address is plotted correctly.

Time window start and end

Use these if an order must be served during a certain time window. If the order can be done at any time, leave these fields blank.

Routific accepts two time formats:
12-hour clock: 2:00 pm to 4:00 pm
24-hour clock: 14:00 to 16:00

Duration

How long, in minutes, you expect each order to take. A simple package drop-off is a lot quicker than delivering and installing equipment. You can also use it to add time where parking is hard to find.

*If you leave duration blank, we'll use the default duration from your Settings. Fractional durations work too: enter 4.5 for four-and-a-half minutes.

Load

How much you're delivering for each order. Routific matches loads to each route's capacity so you never deliver more than you can carry. Learn more about loads and capacities.

Notes

Anything your driver needs to know. Buzzer numbers, special delivery instructions, warnings about aggressive dogs — whatever you need in here.

Email

Required if you have customer email notifications turned on.

Packages

Add barcodes to the order for barcode scanning.

Got more columns? No problem — **you can create custom fields** and map them when you upload your spreadsheet. (See below.) ### Upload your spreadsheet to Routific You can upload from either the **Orders** page or the **Routes** page — whichever you're on. **From the Orders page** If you don't have any orders yet, drag and drop your file onto the upload box, or click it to choose a file. You can also download our template here. ![Orders screen showing a CSV, XLS, or XLSX upload area, template and column-mapping buttons, and other ways to add orders. Visible: Orders, Search orders, Select a CSV, XLS, or XLSX file to upload, or drag and drop your file here, Download template, Reset column mapping.](https://staticfiles.gleap.io/ghelparticle/lAsEX5Yya58aMd1jbiqWK7AE8B1zajjN8cxoJ02LPF9jXrF47lqG6oN1NGDvuwZUnL1Q0tsPbSi.png) Already have orders? Click **\+ Add orders** in the top right corner, then **Upload spreadsheet with orders**. ![Orders map screen with the Add orders menu open; a red arrow points to the menu’s upper-left edge. Visible: Status, Created date, Add orders, Upload spreadsheet with orders, Add order, Add orders from Shopify.](https://staticfiles.gleap.io/ghelparticle/6gF623yYeKgWB0Gpqf14Ot1HqhTWx9xeJ5BXhEJ8lSXr7aaxCYRjziC1uEan5CFt2RksgOLEnIf.png) **From the Routes page** Click the **+** button at the top, then **Upload spreadsheet with orders**. ![The Routes timeline screen shows a map and the open add menu, with a red arrow pointing to “Upload spreadsheet with orders.”. Visible: Routes timeline, 2, Sort, Plan routes, Add orders, Upload spreadsheet with orders.](https://staticfiles.gleap.io/ghelparticle/bYN82zNc73a1nXywJkXXquewGnvGkXh5jojKymAoAlJe2yLZGhVnuzAoqQd7SHS1uxbJtc5TJXI.png) ### Map your data If your column headings are different from ours, the data mapping tool pops up after your upload. Use the dropdowns to match each of your columns to a Routific field — customer name, driver notes, unit number, email, order number, and so on. ![](https://staticfiles.gleap.io/ghelparticle/4HmdTrvPglrU6psT7IAcOtLZKrbG7wAxpLZaNJb5CMXfAyTXDOuuzHfOcx8IeHNoCva7bWRDenB.png) Mapped the wrong column? Click **Reset column mapping** on the Orders page and upload again. ### Add custom fields Need a field we don't have — like an invoice number your drivers should see? Find the column and click **Select field**. Type the field name in the text box and click **+**. ![](https://staticfiles.gleap.io/ghelparticle/2lMFeRYSRxAe3OipthiQEQKnSXLnAcKjA01MahyEQhbWXZDB7FvGZWn3IVUNKOolw9tRQNmnT5R.png) Your custom field is now mapped. It appears on the order details page and in the Routific mobile app for drivers. When you're done, click **Upload** to continue. ![](https://staticfiles.gleap.io/ghelparticle/yDWYu3vKAUcOCSvHNIJvq07gMAqCq1An2T6gLnvrtGv3pViubsTGiYwxpZdpiB04qvJfdLi5XTD.png) ## **2\. Add orders manually** No spreadsheet? Add orders one at a time from either page: - **Orders** page: click **\+ Add orders**, then **Add order**. (If the page is empty, click **Create orders manually**.) - **Routes** page: click the **+** button, then **Add order**. Add the address and any other order details. ![](https://staticfiles.gleap.io/ghelparticle/jBoOObo8HAOTjF0uSAbBWr3PyomzaTYLpVgL2PrY7GyFAlkNYAHawULKVoeJRNv5yYAxZaBxDrh.png) _\*You can enter an address, lat-long coordinates, or pin the location on the map._ [_Learn how Routific makes sure you find the right address._](https://help.routific.com/en/articles/34-cant-find-your-address.md) Click **Add** when you're ready. > **Info:** Delivering to the same customers again and again? Save them once, then use Add order from customers to create their orders in a click. Learn [how to save customers in Routific](https://help.routific.com/en/articles/57-how-to-save-customers-in-routific.md). ## **3\. Import orders with an integration** If your orders already live in another system, skip the spreadsheet and send them straight to Routific: - [**Shopify**](https://help.routific.com/en/articles/59-connect-shopify-to-routific.md) — click **Add orders from Shopify** on the Orders or Routes page - [**Zapier**](https://help.routific.com/en/articles/76-connect-routific-with-zapier.md) — connect Routific to thousands of other apps, no code needed - [**API**](https://help.routific.com/en/articles/33-automate-your-delivery-operations-with-routifics-apis.md) — link your own system using our REST API Once your orders are in, you're ready to [schedule and optimize your routes](https://help.routific.com/en/articles/7-how-to-plan-and-optimize-routes.md).