I have a list, whenever I export the list to a excel file, there are some special characters in the excel file like #, and YES/NO in the original list changes to TRUE/FALSE. In addition, new columns (Item Type and Path) also are added in the excel file. I have to remove those manually.
Could you have a look at screenshots attached and give me some ideas.
Thank you a lot