How To Download SEC Financial Data into Excel Spreadsheets
There are two ways to pull financial data in Excel format from the SEC site
(http://www.sec.gov/edgar.shtml), depending on how recent the information is.
OPTION 1: For filings that are a year or two old
•
Go to www.sec.gov.
o In the Filings & Forms box, click on Search for Company Filings.
o Then click on Company or fund name, ticker symbol, CIK (Central Index Key), file
number, state, country, or SIC (Standard Industrial Classification).
o Enter either a company name or ticker symbol into the appropriate box. (Note: I find it
easier to use a ticker symbol because this guarantees you have the right company.)
Choose Find Companies.
o On the next screen, select the appropriate filing or filter by filing type (10-K).
o Newer filings have two button options: Documents and Interactive Data. Select
Interactive Data if that is an option.
o Once in Interactive Data, select financial statements. A drop-down box will appear in the
left-hand column. Select the statement that you want. Then click View Excel Document
above the left-hand column.
OPTION 2: For older filings
•
Follow the steps in Option 1 to get to the company filing screen. Since Interactive Data will not
be available, click on Documents.
o There will be several options. Find the link containing the full filing. This is usually the
first link but not always. For a 10-K filing look for a link titled 10-K.
•
Open Excel. Click on the Data tab in the ribbon and select From Web, the second icon from the
left.
o A web browser will open up. Copy the link from the company 10-K and insert it into the
New Web Query browser that opened up. Click Go to be taken to the filing. (Note: The
browser sometimes runs slow.)
o Find the financial tables you wish to import. Above the tables you should see a yellow
box with a black arrow pointing to the right. Click on each box corresponding with each
financial table that you wish to import. The box will turn green with a check mark.
o Once all desired tables are selected, click the Import button at the bottom right of the
web browser.
o You will be taken back into the Excel spreadsheet with an Import Data box open. To
import the data, select either a cell in the existing worksheet or New Worksheet and
click OK.
o Data will be uploaded into Excel. Please note that this process does a poor job of
formatting the tables. Brackets indicating negativity and currency symbols are often
placed in adjacent cells, necessitating manual entry. For year-over-year analysis across
multiple filings be careful to ensure that financial sheet items line up with one another.
New
Web
Query
@®
A a
Bh
BE
options
Address:
|http://iwwy.
sec.
gov
/archives/edgar
idata/3201
93/000104746907009340/a21
61030210.
htm
Glick
[BE]
next
to
the
tables
you
want
te
select,
then
click
Import
As
of
September
29,
2007
and
September
30,
2006,
the
significant
components
of
the
Company's
defeared
tax
assets
and
liabilities
were
(in
millions)
#
2007
206
Deferred
tax
assets:
Accrued
liabilities
and
other
reserves
§
679
§
485
Taxlosses
and
credits
$
55
Basis
of
capital
assets
and
investments
146
14
Accounts
receivable
and
inventory
reserves
64 45
(Other
161 3
Total
deferred
tax
assets
1,058
739
Less
valuation
allowance
5 5
Net
deferred
tax
assets
1,053
734
s
Deferred
tax
liabilities
Unremitted
eamings
of
subsidiaries
803
Sit
Total
deferred
tax
abilities
803
Sit
st
deferred
tax
asset
8
250
20
As
of
September
29,
2007, the
Company
has
tat
loss
and
credit
camyforwards
in
the
tax
effected
amount
of
$8
million.
As
of
September
29,
2007
and
September
30,
2006,
2
valuation
allowance
of
$5
million
was
recorded
against
the
deftared
tax
asset
for
the
benefits
of
state
operating
losses
that
may
not
be
realized.
Management
believes
it
is
move
likely
than
not
that
forecasted
income,
including
income
that
may
be
generated
as
a
result
of
certain
tax
planning
strategies,
together
with
the
tax
effects
of
the deferred
tax
liahilitiac
sill
ha
onfFiniant
tn
filly
earner
tha
remaining
daforrad
tay
acsate
[Dene
Rees
Address:
[https
//www.sec.gov/Archives/edgar/data/320199/000104746907009340/42181030210-K.htm
@
O/B
A
BL
&
antions.
Click
[¥]
next
to
the
tables
you
want
to
select,
then
click
Import.
e
As
of Segtember
29,
2007
and
September
30,
2006,
the
significant
components
of
the
Company's
deferred
tax
assets
and
liabilities
were
(in
millions):
w
2007
2006
Deferred
tax
assets:
‘Accrued
liabilities
and
other
reserves
s
oS
485
Taslosses
and
credits 8
35
Basis
of
capital
assets
and
investments
146
ry
Accounts
receivable
and
inventory
reserves
ot
45
Other
161
30
Total
deferred
tax
assets
1058
739
Less
valuation
allowance
3 3
Net
deferred
tax
assets
1053
Tt
s
Deferred
tax
abilities:
Unremitted
eamings
of
subsidiasies
803
si
Total
defered
tas
liabilities
803
Sis
Net
deferred
tax
asset
s 250
S200
As
of Segtember
29,
2007,
the
Company
hastas
loss
and
credit
canyforwards
in
the
tax
effected
amoun?
of
$8
million.
As
of
September
29,
2007
and
September
30,
2006,
a
‘valuation
allowance
of
$5
million
was
recorded
against
the
deferred
tax
asset
for
the
benefits
of
state
operating
losses
that
may
not
be
sealized.
Management
believes
itis
more
likely
than
not
that
forecasted
income,
including
income
that
may
be
generated
as
a
result
of
certain
tax
planning
strategies,
together
with
the
tax
effects
of
the
deferred
tax
Tiahilitiec
sill
he
cnficient
tn
fil
renaver
the
remaining
deferred
tay
accets
Done
