WordPress.com Jetpack stats

• 

  topcoder04 · Member · Jan 14, 2020 at 7:21 pm

  • Copy link
  • Add topic to favorites

  Wordpress.com Jetpack stats will break on export to excel when the article name ends with double quotes.

• 

  staff-mckluskey · Staff · Jan 15, 2020 at 10:00 am

  • Copy link

  Hi there!

  It sounds like it might be a bug, however, we’d need some more information about this to be able to report it. Could you please let us know more details?
  You can also contact Jetpack support directly from https://jetpack.com/contact-support/?rel=support

• 

  topcoder04 · Member · Jan 15, 2020 at 11:00 am

  • Copy link

  To reproduce, create a new post with title ending with double quotes (“). For example – Find length of an array in “java”

  Connect the site through Jetpack plugin and view stats on wordpress.com. Then for post and pages, do “Download data as CSV” . On opening the downloaded excel, you’ll see the row corresponding to the above title is merged with the next row.

• 

  staff-zinnia · Staff · Jan 15, 2020 at 2:56 pm

  • Copy link

  To clarify, when you say article name, you mean a post?

• 

  topcoder04 · Member · Jan 15, 2020 at 6:46 pm

  • Copy link

  yes.

• 

  supernovia · Staff · Jan 15, 2020 at 10:41 pm

  • Copy link

  I’ve not been able to duplicate this yet. Just to be sure we’re on the same page, I’m going here:

  https://wordpress.com/stats/day/posts

  I export as a CSV. A few of my posts end in quotes.

  I don’t have Excel, but I’m importing into Google Sheets and that’s working alright.

  Can you send more details? Also, if you import into Sheets do you have the same issue, or is the CSV only breaking for Excel?

• 

  topcoder04 · Member · Jan 16, 2020 at 4:54 am

  • Copy link

  okay, please try with two double quotes like in – Find length of an array in “java”

  You’re using correct url to investigate the issue. I’m using excel but I can see the issue in google sheets as well.

• 

  kokkieh · Staff · Jan 16, 2020 at 7:42 am

  • Copy link

  I’m able to replicate what you’re seeing.

  I’ve reported the issue to the Jetpack team in https://github.com/Automattic/jetpack/issues/14361. You’re welcome to follow along there on any progress. Thanks for reporting this.