Home Who's Reisner? Journalism Florida International University Other Stuff
Database & Public Records Reporting/JOU3121 | News Workshop/JOU 3113

 

 

Importing Data

Downloading data from the Internet and importing that data into Excel or Access is the critical first step for many analytical stories.

 

At right you'll find two handouts describing the process as well as several files.

 

Please import each file into Excel or Access as indicated. Paste the first few dozen rows of each file on a Word document and turn it in.

Handouts

 

Importing HTML Tables into Excel

 

Getting data from the Web for Excel

 

 

Data

These three files, each in a different format, contain the same list of individuals living in or around Chicago who are behind on child-support payments.

 

debtcsv.txt: comma-separated value

 

debtfix.txt: fixed-field data; columns line up with spaces filling out when data is narrower than column.

 

debthtm.htm: htm data, what you'll find in a formatted table on the web.

 

 

Census Data

These files live on the U.S. Census Bureau's web site and are a little more challenging than those above.

 

National Business Patterns/2004

The Census collects economic data to learn what kinds of jobs and businesses exist in every county in the country. This CSV table consolidates the entire country. If you want to know what the headers mean, go here.

 

County Population Estimates/Florida

This fixed-width Census table contains year-by-year population estimates for Florida and its counties from 1990 to 2000. There are multiple tables on the page which you'd have to import one at a time. Remember to use the "Start Import at Row" function in Excel's import wizard.

 

 

 

 

 

Home | Who's Reisner? | Journalism | Florida International University | Other Stuff