Reports - Download all fields not working & Columns are Duplicated

Kristan Stolze August 29, 2016

I have used the report download into Excel with all fields for months now. Today when I used it, not all of the fields get downloaded (Epic Link, most importantly) & columns headers are duplicated so you don't know which one is accurate.

Screen shot of duplicate column names.  

2 answers

0 votes
Kristan Stolze August 29, 2016

You are correct. The HTML All Fields version works however, I need the data in an Excel format. I don't think HTML can be converted into Excel?!

Deleted user August 29, 2016

Actually - yes it can, I do it all the time. Try this...

  1. Save the file somewhere.
  2. Do an "Open with..." and choose Excel
  3. Then save as an excel sheet
  4. DONE!      smile
Kristan Stolze August 29, 2016

Thanks for the tip. My problem is that Excel is not an option to open the file with as I use Office 365 (web version). I guess you have to have Excel downloaded on your PC in order for it to be an option?!

 

Deleted user August 29, 2016

Ok, not a problem, just copy the file to your one-drive and open it from there.

And yes, I downloaded Excel, I thought that was an option for everyone with Office 365.

0 votes
Deleted user August 29, 2016

You might want to change the export type to the HTML version. It seems to work better.

Suggest an answer

Log in or Sign up to answer