Spreadsheets bridge gap between developers and reporters

This is my first NICAR, but someone mentioned that NICAR 2012 was “The Year of the Map”, with panels, tutorials, and discussion otherwise centered around new, exciting tools like Mapbox and Leaflet.

We invented new terms like BoyerMaps and used the rest of the year to make some incredible map-based news apps.

If NICAR 2013 has a theme among its divergent, widely varied sessions, it is the resurgence of an antiquated tool: the spreadsheet. From Tasneem Raja's tabletop.js session to Chase Davis's powerful session on exploratory data analysis, which used spreadsheet-compatible data in a csv, many of NICAR's speakers returned to the trusty spreadsheet and found new levels of power within it.

What truly makes the spreadsheet so powerful is how inclusive the use of spreadsheets, especially when done through Google, can be for the newsroom. Reporters with no technical skills understand spreadsheets. Reporters can contribute to spreadsheets. And as Tasneem Raja explained on Friday, spreadsheets are a great tool to explain how the structure of a data-driven news app is constructed.

After participating in their first app construction experience, Raja said, reporters began to understand what was possible for a news app. That is incredibly powerful. When reporters in the newsroom can not only help in the data gathering and reporting process but also contribute to the brainstorm and idea generation process constructively, we have succeeded. We have infected the newsroom. We are creating “inclusive story crafting.”

Among the conference's variance has been a certain divide between beginner-focused sessions focused on training and expert-level theoretical sessions focused on thinking and solving the problems that have arisen from news apps. As a developing developer, I found myself splitting time between both extremes, trying to gather new skills as well as enrich my already established skills. In the beginner sessions, I found myself surrounded by reporters trying to get a handle on something, anything that will help them understand the changes occurring in their industry.

Sisi Wei's Code With Me, Dave Stanton's For Journalism and internal initiatives such as those put on by the Chicago Tribune News Applications Team teach journalists how to code and try to bridge this gap of understanding. These are noble, worthy causes, and ones that can generate incredible impact in the newsroom. They are direct examples of programs that should exist not only at the professional level but also at the journalism school level.

But not every current journalist will learn how to code (though every future journalist *must*). And we need different ways to get them involved. Maybe instead of talking about total code literacy in the newsroom, we should be talking about the more general inclusive story crafting. How can reporters be included in our process, even if they cannot or will not learn how to code?

I am not prescribing the spreadsheet as the catchall solution. There are serious problems with rate limits on Google, and spreadsheet-based data leaves out more innovative ways of exploring data. But it is a *great* way to explain structure and allow reporters to do what they do best — report and research — and let news developers do what they do best — develop, design and iterate. Beyond that, the spreadsheet is accessible enough to everyone that reporters can contribute to the code, and developers can contribute to the reporting. They act as a mediator between two disciplines that have encountered friction. They make collaboration possible. Let's get more people involved with spreadsheets, and I bet we'll find more solutions once we do.

About the author

Tyler Fisher

Undergraduate Fellow

Latest Posts

  • A Big Change That Will Probably Affect Your Storymaps

    A big change is coming to StoryMapJS, and it will affect many, if not most existing storymaps. When making a storymap, one way to set a style and tone for your project is to set the "map type," also known as the "basemap." When we launched StoryMapJS, it included options for a few basemaps created by Stamen Design. These included the "watercolor" style, as well as the default style for new storymaps, "Toner Lite." Stamen...

    Continue Reading

  • Introducing AmyJo Brown, Knight Lab Professional Fellow

    AmyJo Brown, a veteran journalist passionate about supporting and reshaping local political journalism and who it engages, has joined the Knight Lab as a 2022-2023 professional fellow. Her focus is on building The Public Ledger, a data tool structured from local campaign finance data that is designed to track connections and make local political relationships – and their influence – more visible. “Campaign finance data has more stories to tell – if we follow the...

    Continue Reading

  • Interactive Entertainment: How UX Design Shapes Streaming Platforms

    As streaming develops into the latest age of entertainment, how are interfaces and layouts being designed to prioritize user experience and accessibility? The Covid-19 pandemic accelerated streaming services becoming the dominant form of entertainment. There are a handful of new platforms, each with thousands of hours of content, but not much change or differentiation in the user journeys. For the most part, everywhere from Netflix to illegal streaming platforms use similar video streaming UX standards, and...

    Continue Reading

  • Innovation with collaborationExperimenting with AI and investigative journalism in the Americas.

    Lee este artículo en español. How might we use AI technologies to innovate newsgathering and investigative reporting techniques? This was the question we posed to a group of seven newsrooms in Latin America and the US as part of the Americas Cohort during the 2021 JournalismAI Collab Challenges. The Collab is an initiative that brings together media organizations to experiment with AI technologies and journalism. This year,  JournalismAI, a project of Polis, the journalism think-tank at...

    Continue Reading

  • Innovación con colaboraciónCuando el periodismo de investigación experimenta con inteligencia artificial.

    Read this article in English. ¿Cómo podemos usar la inteligencia artificial para innovar las técnicas de reporteo y de periodismo de investigación? Esta es la pregunta que convocó a un grupo de siete organizaciones periodísticas en América Latina y Estados Unidos, el grupo de las Américas del 2021 JournalismAI Collab Challenges. Esta iniciativa de colaboración reúne a medios para experimentar con inteligencia artificial y periodismo. Este año, JournalismAI, un proyecto de Polis, la think-tank de periodismo...

    Continue Reading

  • AI, Automation, and Newsrooms: Finding Fitting Tools for Your Organization

    If you’d like to use technology to make your newsroom more efficient, you’ve come to the right place. Tools exist that can help you find news, manage your work in progress, and distribute your content more effectively than ever before, and we’re here to help you find the ones that are right for you. As part of the Knight Foundation’s AI for Local News program, we worked with the Associated Press to interview dozens of......

    Continue Reading

Storytelling Tools

We build easy-to-use tools that can help you tell better stories.

View More