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

 

 

Know What to Do with Records When You Get Them

Once you've gotten your data, well, what then? If it's not already an Excel or Access file, you're going to have to import it. Here's how.

 

Getting data from the Web for Excel: A quick guideto importing by Debbie Wolf of the St. Pete Times, in PDF format. Open the file by clicking on the link; download it by right-clicking and choosing "Save Target As" or "Save Link As."

 

Importing Offline: A series of exercises showing how to import various sorts of text files. Download and print the exercise and save these files to your hard drive or flash drive: debtfix.txt, debtcsv.txt and debthtm.htm. If you want to try something on your own after doing the exercise, try pets.csv.

 

Importing Online: Download and print this exercise to learn how to Excel's "web query" tool lets you import data in HTML format directly from the web. Here's a handout that shows another way to do it.

 

 

 

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