Scheduled Report - Excel Attachement

Options
mberkeley
mberkeley Contributor
edited December 2023 in Dashboard Ideas

Allow scheduled reports to attach the data in excel format rather than csv. CSV files don't keep special characters in the data, so accented characters are messed up in the CSV.

Tagged:
35
35 votes

Implemented · Last Updated

Thanks for this feedback, this has been implemented in Pivot and Mega tables where formatting is kept when exporting to Excel.

Comments

  • spodnar
    spodnar Member
    Options

    My customers are also requesting Excel be available for scheduled report attachments. We have the same problem with special characters in CSV.

  • Moose
    Moose Member
    Options

    Bumping this again as pivot tables lose their formatting as well when sent as .csv in scheduled reporting attachments.

  • JerryB
    JerryB Member
    Options

    We need the option to send scheduled reports in Excel format (rather than CSV) in order to maintain formatted header rows and conditional formatting within the data table.

  • DashboardDude
    DashboardDude Coach
    Options

    Hi @mberkeley, @spodnar, @Moose, @JerryB.

    So if you want to send datasets as excel files, you could use this push connector:

    image.png

    HOWEVER, it's just a dataset that is pushed into someone's sFTP. Sounds like you all just want an attachment as excel and not a csv which I don't think is possible at the moment. Regardless if you sent an excel or csv from domo, you would lose conditional formatting unfortunately.

    One other trick is to allow your clients to use the excel add in where they can select a dataset and just download that into their excel. I have an article on that here: https://www.dashboarddudes.com/blog/microsoft-to-domo-tricks

    I know, not the right answers you want to hear, but trying to give you something to work with.

    Circle.png

    John Le

    You're only one dashboard away.

    Click here for more video solutions: https://www.dashboarddudes.com/pantry

  • KimC
    KimC Member
    Options

    This is needed for data accuracy. My company has data with special symbols, non-English language characters, and numbers with leading zeroes. All are stripped when a report consumer opens the csv format attachment on Domo scheduled reports. I'm curious why this is such a big challenge for an innovative organization like Domo?

  • ckwright
    ckwright Contributor
    Options
    https://community-forums.domo.com/main/discussion/comment/61958#Comment_61958

    Thanks for this feedback, this has been implemented in Pivot and Mega tables where formatting is kept when exporting to Excel.

  • Liztello2018
    Liztello2018 Member
    Options

    Would also like to see scheduled reports in Excel vs CSV. The formatting of table cards is completely removed when exported to csv, including rows with subtotals. This makes it difficult for the end user to properly interpret the data that is being sent.

  • jong
    jong Member
    Options

    Just want to confirm if the feature on the schedule report will have Excel format instead of just csv as of right now?

  • Jones01
    Jones01 Contributor
    Options

    I can see this has been marked as implemented but I don't think this is correct. The original post asked for Excel attachments when sending scheduled reports. Currently the only option is CSV.

  • MichelleH
    MichelleH Coach
    Options

    Same here. I still only see CSV files on Scheduled Report attachments.

  • Luka_V
    Luka_V Member
    Options

    Same here, seeing CSV option only on scheduled reports. Would be great to have an Excel option too. Any idea when this option will be added? Thanks

  • mberkeley
    mberkeley Contributor
    Options

    I have this working in my account, but I don't have a choice between CSV and Excel. Excel is automatically used. I believe this is a Domo-managed configuration change for your tenant.

  • Jones01
    Jones01 Contributor
    Options

    @mberkeley so you can receive a native Excel file and definitely not a csv that you use Excel to open ?

  • mberkeley
    mberkeley Contributor
    edited April 22
    Options

    @Jones01 That is correct. I am able to receive card-based scheduled reports as an .XLSX file, keeping all of the UTF-8 characters. I don't have an option to choose XLSX or CSV. It sends an XLSX file for all card-based scheduled reports.

    Snag_3eb81b28.png

  • Jones01
    Jones01 Contributor
    Options

    @mberkeley thanks very much for confirming. This sounds like another feature switch. I have requested this to be switched on for us.

  • Luka_V
    Luka_V Member
    Options

    Would it not be better to give users the option to decide whether they want to receive a csv or a xlsx?

    @Jones01 how can I request the feature switch please? thanks

  • mberkeley
    mberkeley Contributor
    Options

    @Jones01 This was originally built for us. I don't know how far Domo has gone in making this an easily turned-on option for other tenants. Please let others in this thread know if you are successful!

  • mberkeley
    mberkeley Contributor
    Options

    @Luka_V I agree, I would like to have the option as well, but I did get what I needed and haven't pursued this any further.

  • Jones01
    Jones01 Contributor
    Options

    @Luka_V the option would be better but 99% of the time going to Excel is best and then users can go to CSV from that if they really need to

  • Jones01
    Jones01 Contributor
    Options

    @mberkeley @Luka_V I can confirm this is a feature switch and that we've had this enabled on all of our instances. This is a great update for us.

Categories