Are there any tools out there that are used to view and examine through large XML files?
I work for a small company as a Data Quality Analyst and a lot of my job is looking through large XML files that our clients send in. Currently I just import the XML data into an Excel spreadsheet and work with it that way. This brings about two problems though. One, Excel really doesn't handle reading in large files really well. It slows Excel down or completely crashes it. Which slows down my process or makes it less accurate because I cannot view all the data at once.
Second being that it really doesn't flatten out the structure of the XML and results in an excel file that is bigger than it should be which is back to problem one.
My boss told me to research and see if there was something out there that can read in XML and allows me to do sorts and filters and can also handle decent size XML files.
The tool will run on Windows 10. We only need one license so if it comes to paying, hopefully no more than $100 (hard limit would be $200).