This website uses cookies to collect usage information in order to offer a better browsing experience. By browsing this site or by clicking on the "ACCEPT COOKIES" button you accept our Cookie Policy.

Duration: 2:39


Contributor: Interactive Brokers

Level: Beginner

In this lesson you’ll learn how to upload multiple client accounts into IBKR’s system using a single Excel workbook.

Read More

Study Notes:

Interactive Brokers provides Advisors with the ability to upload multiple client accounts to our system using a single Excel workbook.

We refer to this tool as “Mass Upload”.

To receive this workbook, you can either contact your sales representative or send an email to: and request “Mass Upload”

We will then send you an Excel workbook and a link to helpful reference documentation.

Here is an example of the Individual Excel workbook, which allows you to enter details for multiple client accounts in a single file.

This Excel workbook has been divided into sections to make it easier for you to enter the required information.

Just click on the tabs at the bottom of the workbook to view the different sections, such as Customer Information, W-9, Employment Information and more.

Let’s look at the Customer Information tab. Here you will see an example row. The “Y” below the column header means that this field is required.

When you have completed filling in all of your clients’ information on the different tabs in the Excel workbook, submit it to your Sales Representative or send it to us at the following email address:

Once we finish adding all of your clients’ information into our system, we will send you a secure file listing all of the clients’ new account usernames and passwords.

Have each client sign into their IBKR account, click Login and then Finish an Application.

Each client should change his or her password and complete the next online steps.

Once all customer agreements, disclosures, required identity documents and account funding are completed for each client account, the accounts are approved.

Application guide with full details about the Mass Upload Excel workbook.

Mass Upload User Guide

Disclosure: Interactive Brokers

The analysis in this material is provided for information only and is not and should not be construed as an offer to sell or the solicitation of an offer to buy any security. To the extent that this material discusses general market activity, industry or sector trends or other broad-based economic or political conditions, it should not be construed as research or investment advice. To the extent that it includes references to specific securities, commodities, currencies, or other instruments, those references do not constitute a recommendation by IBKR to buy, sell or hold such investments. This material does not and is not intended to take into account the particular financial conditions, investment objectives or requirements of individual customers. Before acting on this material, you should consider whether it is suitable for your particular circumstances and, as necessary, seek professional advice.

Supporting documentation for any claims and statistical information will be provided upon request.

Any stock, options or futures symbols displayed are for illustrative purposes only and are not intended to portray recommendations.

trading top