Solved

Viewing XML as a table on a Mac

Posted on 2016-09-13
3
173 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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

In this article we have discussed about the OS X EI Capitan and how to fix Wi-Fi issue in OS X El Capitan. We have explained how to delete system level preferences and create a new Wi-Fi location to resolve Wi-Fi issue.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

828 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