Skip to main content

Bulk Import - How to Import Locations into AscendTMS

Import your existing pickup and delivery locations into AscendTMS using the Bulk Import tool. Follow these simple steps to prepare your CSV file, automatically map location information, and get your locations ready for use.

📍 Bring Your Locations Along for the Ride!

Moving from another TMS platform or have a list of frequently used pickup and delivery locations? No need to enter them one by one!

With the AscendTMS Bulk Import tool, you can bring your existing locations into AscendTMS in just a few simple steps. Whether you're getting started or expanding your existing location database, we'll walk you through preparing your data, uploading your file, and completing your import.

📋 Before You Begin

A few things to know before importing your locations:

  • Use the Official Import Template: All location imports must use the official AscendTMS Location Import Template. This ensures your location information is properly organized and mapped to the correct fields, helping your data flow smoothly into AscendTMS.
    ​

  • 2,000-Record Limit: You can import up to 2,000 location records at a time. For larger lists, split your records into smaller files and import them separately.
    ​

  • Check Your Permissions: Administrator, Standard, and Accounting permission groups can access Location Bulk Imports by default. However, an Administrator can disable this permission.

💡 A Fresh TMS Deserves a Fresh Start!

Switching TMS platforms is a great opportunity to clean up your location database. Why bring years of outdated, duplicate, or rarely used pickup and delivery locations into your new AscendTMS account?

There's no need to import every location you've ever shipped to or from!

Instead, focus on importing locations you regularly use or expect to use frequently.

AscendTMS also has built-in location search capabilities, making it easy to find and add locations as you need them while building loads.

Remember: Importing thousands of old, unused locations just recreates the same cluttered database you were probably happy to leave behind!

A little housekeeping now can save you plenty of headaches later. 📍


Step 1: Access the Location Bulk Import Tool

From the main navigation menu in AscendTMS, select Locations, then Bulk Import.

This takes you directly to the Location Bulk Import screen, where you can download the required import template, review the import requirements, and begin uploading your location data.


Step 2: Download and Prepare Your Location Import Template

On the Location Bulk Import screen, download the official Location Import Template.

Open the template and enter or copy your existing location information into the appropriate columns.

⚠️ Important: Do not rename, rearrange, or remove the template's existing columns. AscendTMS relies on the predefined template structure to automatically map your location information.

Before saving, review your data to ensure that location names, addresses, cities, states, ZIP codes, and other information are accurate and complete.

Once finished, save your file in CSV format (.csv) somewhere easy to locate on your computer.

💡 Good to Know: If your location information comes from another TMS or spreadsheet, simply transfer that information into the corresponding columns of the AscendTMS Location Import Template.


Step 3: Upload Your Location List

Once you've completed and saved your Location Import Template, you're ready to upload it into AscendTMS.

  1. From the Location Bulk Import screen, click Select a File to locate your completed template, or simply drag and drop your file into the Drag & Drop File Here area.
    ​

  2. Once your file has been selected, click Import File to continue.
    ​

💡 Good to Know: If your list contains more than 2,000 locations, divide it into smaller files and import each separately.


Step 4: Review Your Location Data

Once you've uploaded your completed Location Import Template, AscendTMS automatically maps your location information to the appropriate fields. No manual mapping required!

Before completing your import, take a moment to review the data preview and make sure everything looks correct.

  1. Review Your Data: Confirm that your location information appears in the correct fields.
    ​

  2. Check for Accuracy: Look for missing information, misplaced values, or anything that doesn't look quite right.
    ​

  3. Proceed or Start Over:
    ​

    • Everything looks good? You're ready to proceed with your import!
      ​

    • Something doesn't look right? Click Cancel and Start Over, then review your Location Import Template for errors or formatting issues before uploading it again.
      ​

💡 Good to Know: If your location information isn't displaying correctly, double-check your import file to ensure the data is accurate, properly formatted, and entered into the correct columns.


Step 5: Complete Your Location Import

Everything looking good? You're ready to bring those locations into AscendTMS!

Once you've reviewed your location data and confirmed everything is accurate, click Start Import to begin importing your location records.

AscendTMS will process your file and import your location information into the system.

🎉 That's it! Once your import has successfully completed, your location records will be available in AscendTMS, ready for use when building and managing loads.


🔍 One Last Thing: Verify Your Imported Locations!

After your import is complete, navigate to Locations, then View Locations to review your newly imported records.

Take a moment to confirm that your locations were successfully imported and that their information appears accurate and complete.

💡 Good to Know: A quick review after importing helps catch any missing or incorrect information before you begin using those locations in your day-to-day operations.


❓ Frequently Asked Questions

How many locations can I import at one time?

AscendTMS allows you to import up to 2,000 location records at a time.

If your location list contains more than 2,000 records, divide it into smaller files using the official Location Import Template and import each file separately.

Can I import locations from another TMS or spreadsheet?

Absolutely! You can import location information from another TMS platform, Excel spreadsheet, or CSV file.

However, all location data must first be transferred into the official AscendTMS Location Import Template to ensure it's properly formatted and recognized by the import tool.

What happens if my location data doesn't import correctly?

If something doesn't look right during the import preview, click Cancel and Start Over.

Review your Location Import Template for missing information, incorrect formatting, or data entered into the wrong columns. Make the necessary corrections and try again.

If you've already completed the import, navigate to Locations, then View Locations to review your records.

Can I import additional locations later?

Of course! You can use Locations, then Bulk Import whenever you need to add more locations.

Simply prepare a new Location Import Template containing the additional records and follow the same steps.

Who can import locations into AscendTMS?

By default, users assigned to the Administrator, Standard, and Accounting permission groups can access the Location Bulk Import tool.

However, Administrators can disable this permission. If you don't see the option, check with your account Administrator.

Will importing locations create duplicate location records?

Yes, if duplicate records are included in your import file or if you're importing locations that already exist in AscendTMS.

The Location Bulk Import tool does not automatically detect, prevent, or remove duplicate location records.

💡 Good to Know: Before importing, compare your Location Import Template against your existing records in Locations, then View Locations to avoid unnecessary duplicates.

Do I need to import every pickup and delivery location I've used before?

Not at all!

AscendTMS can help you find and add locations as you build loads, so there's no need to import every location from your previous system.

We recommend importing only the locations you use frequently and adding others as needed.


Can AscendTMS handle the import for me?

Yes! We do offer you the option to import your Location data for you. Depending on the size and complexity of the import file, a small fee may apply.
​
If you are interested in having the AscendTMS Gurus perform the import on your behalf, or, would like more info, please send an email to our AMAZING AscendTMS Support team, at support@inmotionglobal.com.


🎉 Your Locations Are In. Let's Get Moving!

You've successfully brought your pickup and delivery locations into AscendTMS without the hassle of entering each one manually.

With your locations imported and ready to go, you're one step closer to building loads faster and keeping your freight moving.

Need a hand? Our friendly AscendTMS Support Gurus are always happy to help. Reach out through live chat or email us at support@inmotionglobal.com.

Did this answer your question?