Excel exported is not in the same format in Explore

Completed

42 Comments

  • Official comment
    Eugene Orman
    Zendesk Product Manager

    Hi everyone, 

    We have some good news for you. We have released an update for the Excel exports that ensures that the layout of the attributes stay the same in the Excel exports as it is in the UI. For example, if you place Ticket status on columns in the Explore query builder and export this query in Excel format you will get exactly the same layout where Ticket status stays in the table header.

    However, CSV exports will continue using the raw data format where all attributes are moved to the Rows.

    Explore UI

     

    Excel Export

     

    CSV Export




     

  • Tanawat Oonwattana

    Hi,

    I am still waiting for the answer.

    4
  • Eugene Orman
    Zendesk Product Manager

    Hi Tanawat, 

    The fact that the attributes located in the columns are moved to rows in the CSV and Excel exports is expected behaviour. From what I know there are no plans to change it in the nearest future.

    0
  • David Williams

    Hello Eugene

    I'm having the same issue and to be honest it's not very helpful. Can you explain why, when this worked in Good Data but this is no longer the case with the introduction of Explore, that this is 'expected behaviour' please? Why would transposing the row/columns seem like a good idea?

    It makes exporting Zendesk data to be used in conjunction with other sources a problem and is a retrograde step.

    Please re-consider the change plans.

    8
  • John Tieu

    +1

    The way it exports now makes it nearly unusable. GoodData handled exporting well if that functionality can be added to Explore.

    2
  • Thomas Hagins

    Any update as to if/when this feature will work? Makes it quite difficult to run nice reports and now be able to share them or properly review numbers that excel can do. Insights was a great tool but seems to no longer be active as my reporting numbers no longer change.

    2
  • Nick Larrick

    This does make the reporting useless, for even a small company that spends $70,000 a year for your product. I'd think that you can get a developer on this for the 2 hours it would take. This feature works on insights, why go backwards?

    1
  • Eugene Orman
    Zendesk Product Manager

    Everyone, thank you for the feedback on this issue. Explore team will be working on improving the exports functionality during this year. One of the goals is to make sure that attributes placed on columns are not moved to rows in the exports.

    1
  • Sean McKeever

    +1 from me that this needs to get fixed.  I have to do a lot of copying and pasting into other systems for executive reports. Having to export the data to excel (because copying tables out of Explore is awful) and having to remake the report as a pivot table in Excel is painful. Not to mention a big step back from Insights/Good Data.

    2
  • Mike Cunningham

    Any updates on this?  Your requirements do not appear to be user driven: "One of the goals is to make sure that attributes placed on columns are not moved to rows in the exports" .  The only goal we're talking about here from a user point of view is ability to export format along with values.

    1
  • Andrey

    It is strange, we should pay for something but it doesn't work correctly. Waiting for fix

    1
  • Bart

    @...

    @...

    Exporting reports from explore - where you have #Number of tags / ticket topics built per week as columns and tags / topics as rows exports into csv / excel as a single column with same tag / topic repeated with second column showing as numbers. -- Same report in Insights has the columns as per week - as per the query. 

    Metrics are:
    COUNT(TICKETS)

    Column:
    Tickets Solved - Week of year

    Rows:

    Ticket Tags

    Filtered by 2020. 

    Explore report = OK columns showing okay
    Exporting to Excel / csv is not ok.

    This needs to be a priority. -- There is no way that columns in explore become a second column in rows. Insights has the same query as

    What = Solved Tickets
    How = Ticket Tag / Week / year solved

    Each week is it's own column with 1 ticket tag per row - and the number of solved tickets. No issues with Insights excel exporting.

    1
  • Rob Stack
    Zendesk Documentation Team

    Hi @... I do know this is something that's being looked into. Hopefully, we'll have more news soon. Thanks!

    0
  • Richard Heintze

    This is an issue for our reporting as well. In our case, other internal teams request the exports to integrate with other internal data sources. It seems like a reasonable requirement to match the export view to the report view, or to  make this configurable upon export.

    The current behavior discourages adoption of Explore and encourages users to export unformatted data to start the report workflow and formatting in Excel or Google sheets.

    1
  • Bart

    @...

    Thanks for looking into this. I think the issue is in explore you set all of your "columns" as rows - and then it exports everything into a row. But if I need to see tags per week and set the ticket solved per week as a row, because that's how it splits it into columns on the dashboards, then it should also export them into columns. -- Or make it so the columns part of explore actually is a column and splits the by week section per column. 

    One other metric I noticed missing from insights is week solve / year. I know you have time filters - but my boss would like to see every week since 2017 by tag. A large query for sure, but as part of investor meetings - they don't showcase explore dashboards - they do so through other software products to build these based on the numbers. Insights simply had week 15 / year 2018 etc. 

     

    Thanks again for looking into this. 

    0
  • Rob Stack
    Zendesk Documentation Team

    Hi @.... From Eugene's answer above, I do know the engineering team will be doing work during the year and this feedback will be invaluable to them. I can't speak to specific timeframes, but we'll be sure to provide an update when this happens.

    0
  • Elise Pullias

    Any updates on the timeline of when this issue will be resolved?

    3
  • Денис Шпак

    HI everyone!
    +1 Like others, i'm patiently waiting for correct exporting tables into excel. Please, give us a message when it will be released.

    3
  • Viacheslav Parshin

    Hello!

    I would like to add my voice to this post as well. I've recently encountered this shortcoming when trying to export a table report for our finance department and would very much like to see the table export behavior changed.

    3
  • Thomas Hagins

    This subject has been open for over a year now and has been 5 months since any update. With insights going away, this needs to work. How do I explain to upper management that we spend a lot of money on a product that can't even export a report properly? We need an update please.

    3
  • Yvonne Tornow

    That's not possible! Are you introducing a product that does not export correctly? I think Zendesk wants to be a customer-focused company.
    Change this circumstance quickly. In our case this concerns several reports. And an apology should be considered as well.

    2
  • PT Dadlani

    Has this issue been resolved?  It is extremely painful to build these reports and then not be able to export with the same format.  Please advise when this is to be addressed or what the workaround is in Explore and/or Excel?

    3
  • Drey Tee

    Absolutely agree with all people in this topic. 
    When export screws the data you see in report/dashboard - it's really unusable.
    Please raise this issue priority.

    1
  • Nicole

    +1
    I've finally been able to transport all my relevant reports from Insights to Explore, but without this working properly, I'll still have to export my reports from Insights. That seems counterproductive.

    1
  • Richard Nelson

    Looking for updates on this as well.  This is such a basic feature Explore should not have been even released to beta without it.

    0
  • Eugene Orman
    Zendesk Product Manager

    Thank you for the great feedback. 

    Our apologies that we didn't release an update in this area earlier. We are currently working on fixing this issue for Excel exports. Once we will release this update tables exported in Excel format will reflect layout set in the query builder.

    1
  • Amie Brennan

    Hi Eugene,

    Are you able to give us a timeline on when we can expect the issue to be resolved now that the team are working on it?

    Best,

    Amie

    0
  • Mario Amicarelli

    +1 for a quick resolution to this issue, particularly before Insights is retired.

    Thanks for the help!

    1
  • Safwan Hurzuk

    Hey @..., is there a timeframe in which the change is expected to be released? This is a very serious pain point for my entire team. 

    1
  • Tanawat Oonwattana

    Do I need to +1 on my post to make sure that you know that I am still waiting?

    1

Please sign in to leave a comment.

Powered by Zendesk