Skip to main content
Solved

Scheduling an export as a CSV or Excel Workbook


davidM265
Top Contributor
Forum|alt.badge.img+1

Hello everyone,

 

I have been scheduling exports at my workplace but they are sent as text files to my colleagues. How can I change this so that people receive a CSV or an Excel workbook instead?  

Best answer by Pooja Bernice

Hi @davidM265 ,

Welcome to the Freshworks Community!

I understand you would like your data to be sent out as excel sheets, ideally, Freshdesk allows scheduled exports from Reports and Analytics.

If this is scheduled in the Reports section, you will be receiving them as a text file, but if you want to download your reports, you can navigate to each individual metric and share this data with your agents.

Please refer to this short video to extract this file -

https://share.vidyard.com/watch/fi8q4KDoCDT6HNbdrFtYGF?

We also recommend using the Data Export option to send our .csv files to your agents, this is available from the Pro Plan in Freshdesk. But this allows you to export only the Ticket properties.

This support article may come in handy in exploring this - https://support.freshdesk.com/en/support/solutions/articles/226461-export-ticket-properties-from-your-helpdesk

In the case of Analytics, you can only schedule .csv data from your widgets as shown in the below video, if this is set up at a Report level, you will only receive this in the pdf format -

https://share.vidyard.com/watch/jpACwCYrMLcBLPkQFHRdUX?

Do let us know if this helps.

Cheers!

View original
Did this topic help you find an answer to your question?

5 replies

Forum|alt.badge.img+1
  • Contributor
  • 3 replies
  • April 6, 2022

Hi David,

 

Unfortunately I don’t have a solution but am also having a similar issue so just jumping on the thread should anyone answer!

 

Thank you


Pooja Bernice
Community Debut
Forum|alt.badge.img+6
  • Community Debut
  • 73 replies
  • Answer
  • May 4, 2022

Hi @davidM265 ,

Welcome to the Freshworks Community!

I understand you would like your data to be sent out as excel sheets, ideally, Freshdesk allows scheduled exports from Reports and Analytics.

If this is scheduled in the Reports section, you will be receiving them as a text file, but if you want to download your reports, you can navigate to each individual metric and share this data with your agents.

Please refer to this short video to extract this file -

https://share.vidyard.com/watch/fi8q4KDoCDT6HNbdrFtYGF?

We also recommend using the Data Export option to send our .csv files to your agents, this is available from the Pro Plan in Freshdesk. But this allows you to export only the Ticket properties.

This support article may come in handy in exploring this - https://support.freshdesk.com/en/support/solutions/articles/226461-export-ticket-properties-from-your-helpdesk

In the case of Analytics, you can only schedule .csv data from your widgets as shown in the below video, if this is set up at a Report level, you will only receive this in the pdf format -

https://share.vidyard.com/watch/jpACwCYrMLcBLPkQFHRdUX?

Do let us know if this helps.

Cheers!


davidM265
Top Contributor
Forum|alt.badge.img+1
  • Author
  • Top Contributor
  • 4 replies
  • May 10, 2022

Thank you very much. Your inputs have helped me out and it has worked.


Amrit Mishra
Community Manager
Forum|alt.badge.img+7
  • Community Manager
  • 135 replies
  • July 8, 2024

@davidM265 The ability to support Excel format in widget exports is on our current roadmap and will be available in an upcoming release.


Amrit Mishra
Community Manager
Forum|alt.badge.img+7
  • Community Manager
  • 135 replies
  • January 10, 2025

You can now download widgets in Excel format (XLSX) by selecting the option ‘XLSX of tabular data’ in the Download menu. Please see the screenshot below.

 


Reply