Skip to main content

Bulk Import - How to Import Customers into AscendTMS

Import your existing customer list into AscendTMS using the Bulk Import tool. Follow these simple steps to prepare your CSV file, map customer information, and get your customer records into AscendTMS quickly and easily.

🚀 Bring Your Customers Along for the Ride!

Got a customer list sitting in a spreadsheet or another TMS? No need to enter everyone manually!

With the AscendTMS Bulk Import tool, you can bring your existing customer records into AscendTMS in just a few simple steps. Whether you're getting started with AscendTMS or adding customers to an existing account, 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 customers:

  • 2,000-Record Limit: You can import up to 2,000 customer records at a time. If your list exceeds that limit, simply split it into smaller files and import them separately.
    ​

  • Use the Official Import Template: All customer imports must use the official AscendTMS Customer Import Template. This ensures your customer information is properly organized and mapped to the correct fields in AscendTMS, helping your data flow smoothly into the system and preventing unnecessary import errors.
    ​

  • Keep Your Customer List Relevant: We recommend importing customers you actively work with rather than large lists of rarely used records.
    ​

  • Check Your Permissions: Administrator, Standard, and Accounting permission groups all have access to Customer Bulk Imports by default. However, an Administrator can disable this permission. If you don't see the option, check with your account Administrator.

💡 Good to Know: You don't have to import every customer you've ever worked with! AscendTMS allows you to add customers individually as needed, so you can always build your customer list over time.


Step 1: Access the Customer Bulk Import Tool

From the main navigation menu in AscendTMS, select Customers > Bulk Import.

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


Step 2: Download and Prepare Your Customer Import Template

On the Customer Bulk Import screen, select the option to download the Customer Import Template.

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

⚠️ Important: Do not rename, rearrange, or remove the template's existing columns. The import tool relies on the template's predefined structure to recognize and process your customer data.

Before saving your file, double-check that your customer information is accurate and properly organized.

Once complete, save the file in CSV format (.csv) somewhere easy to find on your computer.

💡 Good to Know: If your customer list comes from another TMS or spreadsheet, you can copy the information into the AscendTMS template. Just make sure each piece of information is placed in its corresponding column.


✅ Step 3: Upload Your Customer List

Once you've completed the Customer Import Template and saved it as a CSV file, you're ready to upload your customer data into AscendTMS.

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

  2. Once your file has been selected or uploaded, click Import File to continue to the next step.
    ​

💡 Good to Know: If your customer list contains more than 2,000 records, you'll need to divide it into smaller files and import each one separately.


✅ Step 4: Review Your Customer Data

Once you've uploaded your completed Customer Import Template, AscendTMS automatically maps your customer 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 customer 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 Customer Import Template for errors or formatting issues before uploading it again.
      ​

💡 Good to Know: Because AscendTMS automatically handles the mapping, it's especially important to use the official Customer Import Template and preserve its original structure.


Step 5: Complete Your Customer Import

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

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

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

🎉 That's it! Your customer records will be available in AscendTMS once the import has successfully completed (this usually takes just a few minutes), ready for you to use when building and managing loads.


🔍 One Last Thing: Verify Your Imported Customers!

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

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

💡 Good to Know: A quick review after importing is always a good idea! It helps catch any missing or incorrect information before you begin using those customer records in your day-to-day operations.


❓ Frequently Asked Questions

How many customers can I import at one time?

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

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

Can I import customers from another TMS or spreadsheet?

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

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

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

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

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

If you've already completed the import, navigate to Customers > View Customers to review your records and identify any issues.

Can I import additional customers later?

Of course! You can use the Customers, then Bulk Import tool whenever you need to add more customers.

Just prepare a new Customer Import Template containing the additional records you'd like to import and follow the same steps outlined in this guide.

Who can import customers into AscendTMS?

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

However, Administrators can disable this permission for other users.

If you don't see the Bulk Import option under Customers, check with your AscendTMS account Administrator to verify your permissions.

Will importing customers create duplicate customer records?

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

The Customer Bulk Import tool does not automatically detect, prevent, or remove duplicate customer records.

💡 Good to Know: Before importing, we strongly recommend reviewing your Customer Import Template and comparing it against your existing customer list in Customers > View Customers to avoid importing duplicate records.

Can AscendTMS handle the import for me?

Yes! We do offer you the option to import your Customer 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 Customers Are In. Let's Get Moving!

You've successfully brought your customer list into AscendTMS, saving yourself the time and hassle of entering those records one by one.

With your customers imported and ready to go, you're one step closer to putting AscendTMS to work for your business!

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?