Top 500 US Companies – Excel Spreadsheet

Top 500 US Companies - Excel Spreadsheet cover

Spreadsheet: Top 500 US Companies – Excel file of the Top 500 public listed American companies

Browse, filter, and use data easily on the Top 500 companies listed in the United States.

Description

365体育竞猜This Excel spreadsheet contains all the details on the top 500 public listed companies by market capitalization in the United States, constituents of the S&P 500 Index, together with business, financial and digital information. Companies and their related data can be browsed and filtered very easily for your specific purposes: grouping by sectors, ranking by market capitalization, sorting websites, etc.

sorting S&P 500 Companies

The main spreadsheet contains the Top 500 American companies, S&P 500 constituents, quoted either on the Nasdaq or the New York Stock Exchange and their related data. Five companies are referenced twice in this spreadsheet, as they have two types of shares listed, namely, Alphabet Inc (Google), Discovery Inc., Fox Corporation, News Corp. and Under Armour.

Updated and expanded for 2020!

All data included in the companies spreadsheet have been updated for 2020.

The new additional spreadsheet focuses on the stock price of all the top 500 companies for 2018 and 2019. With the prices of each S&P 500 stock at the end of each month between December 2017 and December 2019, it will greatly help you assess the financial health and evolution of each company. This spreadsheet will allow you to go much further in data analysis, calculate correlations between stocks, estimate seasonality, cross analyze stocks by industry, sector, or even arbitrary batches.

Benefits of using these 2 spreadsheets on the Top 500 US Companies

  • Quickly browse and filter the companies’ information in a single convenient workbook for multiple purposes, including:
    • searching and filtering companies for informed lead generation
    • corporate benchmarking
    • cross-stocks evolution, statistics, and machine learning for financial analysis for investment insights
    • reaching websites and online presence of each company
  • Keep all the information readily available on your computer at any time, even offline.
  • Easily use this companies database in other applications and programs thanks to a standard Excel file.
  • Save tens of hours of companies’ data search, collection and formatting in one convenient Excel workbook!

Sample data

Top 500 US Companies spreadshseet sampleTo let you know exactly what the Top 500 US Companies spreadsheet contains, you can here download a sample. This extract includes extracts of both spreadsheets with all the data of the first 10 companies, together with the explanatory notes of the description spreadsheet. For more information about each column data, please see below.


Interested in more than American companies?

1280 Top Anglo-Saxon CompaniesCheck our other download “1280 Top Anglo-Saxon Companies365体育竞猜” which regroups four best-selling spreadsheets of American, British, Canadian and Australian companies, and much more, in a single Excel file.

Save $14.70 compared to the price of the four individual files!


Companies spreadsheet data

Here are the details of the data included in each column of the S&P 500 Companies spreadsheet. The data can be sorted and filtered according to each column, through the filter button present in the right of the columns headings cells.

Top companies of Southeast Asia - XLS spreadsheet laptop 3D

All data included in the main spreadsheet are updated as of Friday, February 7, 2020.

▪ Company

Official company name. In these cells are also detailed the two types of shares of the five companies with dual securities.

▪ Sector

365体育竞猜Main sector of the company, according to the Global Industry Classification Standard for sectors.

▪ Sub-industry

Main sub-industry or sub-industries of the company, according to the Global Industry Classification Standard for sub-industries.

▪ Employees

Total number of employees in the company, when available.

▪ Website

365体育竞猜URL of the company’s main corporate website with a direct link.

▪ Founded

Year of the foundation of the company. Some companies have another year in parenthesis: the main year then marks the founding of this daughter company while the year of the founding of the mother company is displayed in parenthesis.

▪ Headquarters

Location of the company’s main headquarters with the city and state for companies based in the US, and the city and country for companies headquartered abroad.

▪ Symbol

365体育竞猜Stock symbol of the company.

▪ Market Cap.

Market capitalization of the company in Million US $, as of effective close on Friday, February 7, 2020. Companies with two securities quoted may present a discrepancy between their valuation according to each security.

▪ Stock info

URL of the company’s security information with a direct link to the website of the stock exchange on which it is listed: New York Stock Exchange, Nasdaq, or CBOE for Cboe Global Markets.

▪ Date first added

Date of the first inclusion of the company as a constituent of the S&P 500 index, when available.

▪ Dow Jones

365体育竞猜All the companies included are constituents of the S&P 500 index; companies that are also a constituent of the Dow Jones Industrial Average index are signaled in this column with a tick.

▪ SEC filings

Link to the company’s filings on the Securities Exchange Commission website.

▪ CIK

Central Index Key number given by the United States Securities and Exchange Commission. This number is used to identify a company’s filings in several online databases, including EDGAR.

▪ Wikipedia URL

URL with a direct link to the company’s main page on Wikipedia.

▪ Description

Succinct description of the company’s activities, retrieved from the introduction of the Wikipedia page of the company.

File details

  • XLS iconType: XLS file
  • Size: 429 Ko
  • Sheets: 3
    • 1 sheet containing the Top 500 US Companies updated data with filters
    • 1 sheet containing the Top 500 US Companies stock prices at the end of each month for 2018 and 2019
    • 1 sheet with the description of the data
  • Author/Editor: Disfold