A Google Spreadsheets change affecting TimelineJS users

Google recently changed something about their Sheets service which is causing many people to run into an error when they are making a new timeline.

Note: there should be no impact on existing timelines!

After this change, many of you click on the "preview" and get this message:

An unexpected error occurred trying to read your spreadsheet data [SyntaxError]
Timeline configuration has no events.

timeline_syntax_error

There is a straightforward work-around, but it requires those of you who have been making timelines for a while to change your habits.

It used to be the case that the URL in the Publish to the Web window was usable for "step 3" of the publishing process. As of today, that URL is different from the main spreadsheet URL, and if you use the URL from the Publish to the Web window, you'll get the error above.

spreadsheet_incorrect_url

Instead, disregard that URL, and instead, use the URL from your browser's address bar:

spreadsheet_correct_url

We're sorry for the inconvenience. Unfortunately, sometimes Google changes things on us.

About the author

Joe Germuska

Chief Nerd

Joe runs Knight Lab’s technology, professional staff and student fellows. Before joining us, Joe was on the Chicago Tribune News Apps team. Also, he hosts a weekly radio show on WNUR-FM – Conference of the Birds.

Tagged

Latest Posts

  • How Americans think and feel about gun violence

    A man killed his wife, then himself. I want you to see his face and learn that he enjoyed fishing with his grandchildren. A small-time drug dealer is shot by two men in a parking lot. I find his Facebook profile and a photo shows him striking a playfully irreverent pose, giving the camera the middle finger. The photo’s comments take a mournful turn after a certain date. “Rest easy bro ???” Gun Memorial runs...

    Continue Reading

  • Software developers interested in journalism: Northwestern and The Washington Post want you!

    Northwestern University and The Washington Post are offering a unique opportunity for two talented software developers interested in applying their programming skills in media and journalism. Here’s the proposition: (1) a full-tuition scholarship to earn a master’s degree in journalism at Northwestern University, followed by (2) a six-month paid internship with The Post’s world-class engineering team, with the possibility of subsequent full-time employment. These opportunities are made possible by the John S. and James L....

    Continue Reading

  • What happened when Gun Memorial let anyone contribute directly to victim profiles

    If you’re reporting local or niche news, there’s a good chance that your audience collectively knows more about the story than you do. That’s especially true for us at Gun Memorial, a small publication with a nationwide mission of covering every American who is shot dead. In our latest, mostly successful, experiment, we let readers add to our stories without editor intervention. This article shares some lessons from that experience. Asking for reader contributions A...

    Continue Reading

  • How conversational interfaces make the internet more accessible for everyone

    This story is part of a series on bringing the journalism we produce to as many people as possible, regardless of language, access to technology, or physical capability. Find the series introduction, as well as a list of published stories here. In 2004, human-computer interaction professor Alan Dix published the third edition of Human-Computer Interaction along with his colleagues, Janet Finley, Gregory Abowd, and Russell Beale. In a chapter called “The Interaction,” the authors wrote...

    Continue Reading

  • Three tools to help you make colorblind-friendly graphics

    This story is part of a series on bringing the journalism we produce to as many people as possible, regardless of language, access to technology, or physical capability. Find the series introduction, as well as a list of published stories here. I am one of the 8% of men of Northern European descent who suffers from red-green colorblindness. Specifically, I have a mild case of protanopia (also called protanomaly), which means that my eyes lack...

    Continue Reading

  • Phone stories: How a 100-year-old-technology helped Pop-up Magazine make news convenient for audiences

    This story is part of a series on bringing the journalism we produce to as many people as possible, regardless of language, access to technology, or physical capability. Find the series introduction, as well as a list of published stories here. As news organizations look increasingly to social networks, apps, and other recently-emerged technology to find new audiences, at least one has gone in the completely opposite direction. Pop-Up Magazine this year launched a product...

    Continue Reading

Storytelling Tools

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

View More