Solved

Viewing XML as a table on a Mac

Posted on 2016-09-13
3
129 Views
Last Modified: 2016-09-16
I am looking fo a way to view XML files in a table the way Excel shows them on WIndows, but am on OSX.  From what I understand Office Does not Support the XML table view on OSX.  Is there a XML viewer that will parse the XML files the way Excel does in Windows?   I can work around this by connecting to a Server that has Excel on it and viewing the files through there, but it would be more convenient to be able to do this from my own machine.   I have not seen much that shows whether this is easy to do or not, and if I have to go and run the files through a converter of some kind Before viewing it doesn't save my any time and I can just go through the virtual desktop I can access.  I guess I am just wondering if that is my best solution or if there is a viewer that is native in OSx.

Thanks
Jason
0
Comment
Question by:JrayPatten
  • 2
3 Comments
 
LVL 9

Accepted Solution

by:
Tim Lapin earned 500 total points
ID: 41796143
It seems that there is no simple solution to this one that is native to the mac, as you have pointed out in your question.  The closest I've come is to use an editor like TextWrangler, which allows for colour coding of various items based on types.

The result is not as clean as a table but it can be legible with the right colour choices.  The defaults aren't bad but they can be changed.  There are xml specific colour codes and the rest seem to be under the "HTML" text colour settings in the Preferences.

Xcode is another option but I find that unwieldy and possibly not generic enough for your purposes.  Other apps are either commercial or are overkill for your stated task.

Give the ones I suggested a try.  If they don't work for you, then you have the server based copy of Excel as a great fallback.
1
 

Author Comment

by:JrayPatten
ID: 41796288
Thanks for the reply, and I DO have  textwrangler available already.  Just the various files I am trying to view the table view would make it easy to very quickly scan for the specific types of error I am looking for.
It looks like it will be using the server for viewing.
0
 

Author Closing Comment

by:JrayPatten
ID: 41801641
Thanks for the reply, I kind of figured that was the way it was going to work.
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Need to Obtain or Remove Password Protection From an Excel 2000 Workbook 6 54
Thoughts on PC Doctor 11 47
Excel Question 17 15
Why do my Excel files become huge? 27 32
Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Many times as a report developer I've been asked to display normalized data such as three rows with values Jack, Joe, and Bob as a single comma-separated string such as 'Jack, Joe, Bob', and vice versa.  Here's how to do it. 
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question