Getting data into Excel

  • Event: 2016 CAR Conference
  • Speaker: Helena Bengtsson of Sveriges Television
  • Date/Time: Friday, Mar. 11 at 10:15am
  • Location: Denver I
  • Audio file: No audio file available.

Don't give up if your data isn't presented in a neat Excel file. This session will teach you how to clean and format data to get it into Excel. We will look at how to import text files, how to get a table on a web page into Excel, and what to consider when cutting and pasting data from the internet.

Speaker Bios

  • Helena Bengtsson is Editor for Data Journalism at Sveriges Television, Sweden’s national television broadcaster. She previously worked as Editor, Data Projects at the Guardian, UK, between 2014-2017. In 2006 and 2007, she was Database Editor at the Center for Public Integrity in Washington, D.C. She was awarded Stora Journalistpriset (The Swedish Grand Prize for Journalism) in Sweden twice, in 2010 for and in 2016 for innovator of the year. @HelenaBengtsson

Related Tipsheets

No tipsheets have yet been uploaded for this event.