This post will be visible to other SurveyGizmo users. Please do not include personal information you do not want public on the Community. If you wish to contact SurveyGizmo Support directly, please click “Email a Support Hero” on the right.
Hi Anita, thanks for your help, but that’s not the question I’m asking. Let me be more clear:
- I’ve set up data exports to be emailed to myself, since it’s tedious to have to go into each survey (I have 100+) and click around to download reports (really should be a report template and download all option).
- I’m not sure exactly what is going to be sent to me, but when I click on the link within the data export report, it downloads as a csv, but I need the files to be xls – and I don’t want to have to convert myself, since this will mean opening and “saving as” 100+ files.
Seems pretty logical that there would be an option to have files generated as xls as default?
I stumbled upon this post because I had the same question myself. I don’t know if there has been an update since this post, but it is possible to download directly as an xls, for anyone who finds this post one day in the future.
Set up a normal export as if you were exporting a csv file from the exports page, finish customizing your report, and once the report is done, you have 2 options. There is “download export to csv” and “start excel report.”
Latter option does what you need. Downloads as an xls file. helpful for surveys with accents in them that come out wonky on csv files.
You can totally do this when you are saving your file. If you go to file and SAVE, you will see a SAVE AS option. Use that drop down menu and select xls option. Easy peasy lemon squeezy.
Oh! I found this little article that gives you some screen shots, except you just follow the process to switch it around to an xls. https://www.completecampaigns.com/webhelp/Management/Imports/How_to_convert_an_existing_Excel_file_into_a_csv_format.htm
I hope this helps you.