Top 500 US Companies Database – XLS Spreadsheet

Top 500 US Companies Database cover

Spreadsheet: Top 500 US Companies Database – 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

This ultimate Excel spreadsheet includes a database of the Top 500 public listed companies of the United States, constituents of the S&P500 index, together with complete information. Companies and their relative data can be browsed and filtered very easily to be used for your specific purposes: grouping by sectors, ranking by market capitalization, sorting websites, etc.

sorting S&P500 Companies

The main spreadsheet contains the Top 500 American companies, which constitute the S&P500 Index, and their related data. They are quoted either on the Nasdaq or the New York Stock Exchange. 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.

All data included in the main spreadsheet is retrieved as of September 29, 2019, end of Q3 2019.

Benefits of using this spreadsheet on the Top 500 US Companies

  • Browse and filter the companies’ information in a single convenient file for many purposes: comparisons, information for investment, filtering companies for commercial approach, business evaluations, etc.
  • Keep your companies information readily available on your computer at any time, even offline.
  • Use companies’ data directly and easily in other applications and programs thanks to a standard Excel file.
  • Save tens of hours of companies’ data search, collection and formatting in one cheap and convenient Excel spreadsheet!

Sample data

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

 

Spreadsheet columns data

Here are the details of the data included in each column of the main spreadsheet. Each column can be sorted and filtered according to the data it contains, through the filter button present in the right of the columns headings cells.

Top companies of Southeast Asia - XLS spreadsheet laptop 3D

▪ Company

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

▪ Sector

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.

▪ Website

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

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.

▪ Market Cap.

Market capitalization of the company in Billion US $, as of effective close on Friday, September 27, 2019. Companies with two securities quoted may present a discrepancy between their valuation according to each security.

▪ Symbol

Stock symbol of the company.

▪ 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&P500 index, when available.

▪ Dow Jones

All the companies included are constituents of the S&P500 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 Page

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: 409 Ko
  • Sheets: 2
    • 1 sheet containing the Top 500 US companies with filters
    • 1 sheet with the description of the data
  • Author/Editor: Disfold