How to create a tickers list in Microsoft Excel

Importing a list of tickers from Microsoft Excel is simple. Only one column needs to be used and the first cell must be named Ticker.

Beneath it, the list of tickers that you want to import can be typed out in each cell. When adding an international ticker to your file, type it out as Ticker space Country abbreviation (Figure 1):

Figure 1 Tickers

When you're ready to import your Excel file, you can choose to create a new Watchlist or add to an existing Watchlist (Figure 2):

Figure 2 Import options

Once ready, you can drag and drop the file into the importer or you can upload the file from your desktop (Figure 3):

Figure 3 Import Your Portfolio