Solved

Viewing XML as a table on a Mac

Posted on 2016-09-13
3
453 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
 
LVL 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
 
LVL 1

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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

617 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