how open xml file on libreoffice
anyone know how to open xml file ? maybe with libreoffice ?
If I use libreoffice I just see only the text format of xml, with all tags and so on.
libreoffice xml
add a comment |
anyone know how to open xml file ? maybe with libreoffice ?
If I use libreoffice I just see only the text format of xml, with all tags and so on.
libreoffice xml
1
Hi do you wish to edit the file or just view it? You can use gedit help.ubuntu.com/community/gedit ubuntu's build in text editor.
– gman
Feb 25 '14 at 12:07
XML files are text files, so any text editor can open it. But if you want to perform XML validation on it, then you need some XML editor that will also load the XSD file related to the XML and perform the validation (check that you enter the correct tag with the correct value type).
– Benoit
Mar 14 '14 at 14:42
1
And what exactly were you expecting? It's an XML file!
– terdon♦
Mar 15 '14 at 21:08
add a comment |
anyone know how to open xml file ? maybe with libreoffice ?
If I use libreoffice I just see only the text format of xml, with all tags and so on.
libreoffice xml
anyone know how to open xml file ? maybe with libreoffice ?
If I use libreoffice I just see only the text format of xml, with all tags and so on.
libreoffice xml
libreoffice xml
asked Feb 25 '14 at 11:57
LuigiLuigi
192138
192138
1
Hi do you wish to edit the file or just view it? You can use gedit help.ubuntu.com/community/gedit ubuntu's build in text editor.
– gman
Feb 25 '14 at 12:07
XML files are text files, so any text editor can open it. But if you want to perform XML validation on it, then you need some XML editor that will also load the XSD file related to the XML and perform the validation (check that you enter the correct tag with the correct value type).
– Benoit
Mar 14 '14 at 14:42
1
And what exactly were you expecting? It's an XML file!
– terdon♦
Mar 15 '14 at 21:08
add a comment |
1
Hi do you wish to edit the file or just view it? You can use gedit help.ubuntu.com/community/gedit ubuntu's build in text editor.
– gman
Feb 25 '14 at 12:07
XML files are text files, so any text editor can open it. But if you want to perform XML validation on it, then you need some XML editor that will also load the XSD file related to the XML and perform the validation (check that you enter the correct tag with the correct value type).
– Benoit
Mar 14 '14 at 14:42
1
And what exactly were you expecting? It's an XML file!
– terdon♦
Mar 15 '14 at 21:08
1
1
Hi do you wish to edit the file or just view it? You can use gedit help.ubuntu.com/community/gedit ubuntu's build in text editor.
– gman
Feb 25 '14 at 12:07
Hi do you wish to edit the file or just view it? You can use gedit help.ubuntu.com/community/gedit ubuntu's build in text editor.
– gman
Feb 25 '14 at 12:07
XML files are text files, so any text editor can open it. But if you want to perform XML validation on it, then you need some XML editor that will also load the XSD file related to the XML and perform the validation (check that you enter the correct tag with the correct value type).
– Benoit
Mar 14 '14 at 14:42
XML files are text files, so any text editor can open it. But if you want to perform XML validation on it, then you need some XML editor that will also load the XSD file related to the XML and perform the validation (check that you enter the correct tag with the correct value type).
– Benoit
Mar 14 '14 at 14:42
1
1
And what exactly were you expecting? It's an XML file!
– terdon♦
Mar 15 '14 at 21:08
And what exactly were you expecting? It's an XML file!
– terdon♦
Mar 15 '14 at 21:08
add a comment |
6 Answers
6
active
oldest
votes
If the file is an XML table, you can open it in LibreOffice Calc through the Data > XML Source menu. Inside it, you just need to open the XML file, point to the table you're importing on the left column and specify a destination in your sheet in the right text field. Example:

What is an "xml table"? How do I find out if my file is one or has one? When I open a file like that, I see nothing in the "Map to document" window, though I see "<s:Table> lines in it. It comes from SOE Software's Clarity Election Night Reporting tool, e.g. the detail.xls file zipped inside results.enr.clarityelections.com/CO/63746/183083/reports/…
– nealmcb
Nov 12 '16 at 15:13
Cool, this works in LibreOffice Calc 5.1 with sitemap.xml from a sitemap generator service. I can choose which column to be shown in the sheet. Thanks Waldir.
– Ade Malsasa Akbar
May 3 '18 at 8:28
Quite, what is an XML table? Is it a collection of repeated nodes all of which have the same set of attributes in a two- or three-level structure? Is it converted to a table with each row corresponding to one of the first-level nodes?
– PJTraill
2 hours ago
When I try this (in LibreOffice Calc 6.1.3.2 on Open Suse Leap), XML source is greyed out in the Data menu – do I have to do something else first?
– PJTraill
2 hours ago
Some documentation at wiki.documentfoundation.org/Development/Calc/XMLSource , as referenced in the Help (but it says nothing about ungreying the menu entry).
– PJTraill
2 hours ago
|
show 2 more comments
You can also use basex from the software center.
sudo apt-get install basex
BaseX is a very fast and light-weight, yet powerful XML database and XPath/XQuery processor, including support for the latest W3C Full Text and Update Recommendations. It supports large XML instances and offers a highly interactive front-end (basexgui).
I don't have it installed but it has really high ratings from the software center.
Practical and ugly ;)
– A.B.
Apr 28 '15 at 14:58
add a comment |
The default Gedit text editor is capable of opening the file - I also suggest you try Bluefish, which can do XML as well HTML and other languages. It also does auto-completion, and highlighting.
Here are examples of the above editors based on this:

N.B. With Gedit, you have to add some of the above by changing a few settings and activating a few plugins.
add a comment |
XML Copy Editor is a fast, free, validating XML editor. It features DTD/XML Schema/RELAX NG validation, XSLT, XPath, pretty-printing, syntax highlighting, folding, tag completion/locking, and a spelling/style check. XML Copy Editor can be installed from the Ubuntu Software Center.
XML Copy Editor debugger (xmlcopyeditor-dbg) is an optional add-on for XML Copy Editor that can also be installed from the Ubuntu Software Center.

add a comment |
In case you don't succeed with LibreOffice, try using SoftMaker FreeOffice. This free office suite has much better import and export filters that let you run Microsoft Office formats faithfully. The whole office suite is feature-packed, but needs only 58MB. It's well coded, very fast and reliable. Here's the link where to get it:
www.freeoffice.com
Kingsoft Office is also worth a try: wpscommunity.org
– s3lph
Mar 14 '14 at 15:52
add a comment |
You may find XMLStarlet useful, if you are familiar with XPATH concepts (or prepared to learn them).
This is a command-line tool which can select data from an XML file on the basis of the types of elements and the values of their attributes or those of related elements. I am not sure if it is easy to generate a CSV file or other suitable for loading into LibreOffice (if that is your aim), or whether you would need to transform it a little first. (I shall try to remember to update this if I find out more.)
The examples given in the Wikipedia article (link above) show the command as xml (e.g. xml sel for a selection), but in my case (OpenSuse Leap) it is xmlstarlet, which is also the package to install; I do not know what the situation is for Ubuntu.
New contributor
PJTraill is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "89"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f426009%2fhow-open-xml-file-on-libreoffice%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
6 Answers
6
active
oldest
votes
6 Answers
6
active
oldest
votes
active
oldest
votes
active
oldest
votes
If the file is an XML table, you can open it in LibreOffice Calc through the Data > XML Source menu. Inside it, you just need to open the XML file, point to the table you're importing on the left column and specify a destination in your sheet in the right text field. Example:

What is an "xml table"? How do I find out if my file is one or has one? When I open a file like that, I see nothing in the "Map to document" window, though I see "<s:Table> lines in it. It comes from SOE Software's Clarity Election Night Reporting tool, e.g. the detail.xls file zipped inside results.enr.clarityelections.com/CO/63746/183083/reports/…
– nealmcb
Nov 12 '16 at 15:13
Cool, this works in LibreOffice Calc 5.1 with sitemap.xml from a sitemap generator service. I can choose which column to be shown in the sheet. Thanks Waldir.
– Ade Malsasa Akbar
May 3 '18 at 8:28
Quite, what is an XML table? Is it a collection of repeated nodes all of which have the same set of attributes in a two- or three-level structure? Is it converted to a table with each row corresponding to one of the first-level nodes?
– PJTraill
2 hours ago
When I try this (in LibreOffice Calc 6.1.3.2 on Open Suse Leap), XML source is greyed out in the Data menu – do I have to do something else first?
– PJTraill
2 hours ago
Some documentation at wiki.documentfoundation.org/Development/Calc/XMLSource , as referenced in the Help (but it says nothing about ungreying the menu entry).
– PJTraill
2 hours ago
|
show 2 more comments
If the file is an XML table, you can open it in LibreOffice Calc through the Data > XML Source menu. Inside it, you just need to open the XML file, point to the table you're importing on the left column and specify a destination in your sheet in the right text field. Example:

What is an "xml table"? How do I find out if my file is one or has one? When I open a file like that, I see nothing in the "Map to document" window, though I see "<s:Table> lines in it. It comes from SOE Software's Clarity Election Night Reporting tool, e.g. the detail.xls file zipped inside results.enr.clarityelections.com/CO/63746/183083/reports/…
– nealmcb
Nov 12 '16 at 15:13
Cool, this works in LibreOffice Calc 5.1 with sitemap.xml from a sitemap generator service. I can choose which column to be shown in the sheet. Thanks Waldir.
– Ade Malsasa Akbar
May 3 '18 at 8:28
Quite, what is an XML table? Is it a collection of repeated nodes all of which have the same set of attributes in a two- or three-level structure? Is it converted to a table with each row corresponding to one of the first-level nodes?
– PJTraill
2 hours ago
When I try this (in LibreOffice Calc 6.1.3.2 on Open Suse Leap), XML source is greyed out in the Data menu – do I have to do something else first?
– PJTraill
2 hours ago
Some documentation at wiki.documentfoundation.org/Development/Calc/XMLSource , as referenced in the Help (but it says nothing about ungreying the menu entry).
– PJTraill
2 hours ago
|
show 2 more comments
If the file is an XML table, you can open it in LibreOffice Calc through the Data > XML Source menu. Inside it, you just need to open the XML file, point to the table you're importing on the left column and specify a destination in your sheet in the right text field. Example:

If the file is an XML table, you can open it in LibreOffice Calc through the Data > XML Source menu. Inside it, you just need to open the XML file, point to the table you're importing on the left column and specify a destination in your sheet in the right text field. Example:

edited Apr 28 '15 at 15:01
answered Apr 28 '15 at 14:46
Waldir LeoncioWaldir Leoncio
1,64042138
1,64042138
What is an "xml table"? How do I find out if my file is one or has one? When I open a file like that, I see nothing in the "Map to document" window, though I see "<s:Table> lines in it. It comes from SOE Software's Clarity Election Night Reporting tool, e.g. the detail.xls file zipped inside results.enr.clarityelections.com/CO/63746/183083/reports/…
– nealmcb
Nov 12 '16 at 15:13
Cool, this works in LibreOffice Calc 5.1 with sitemap.xml from a sitemap generator service. I can choose which column to be shown in the sheet. Thanks Waldir.
– Ade Malsasa Akbar
May 3 '18 at 8:28
Quite, what is an XML table? Is it a collection of repeated nodes all of which have the same set of attributes in a two- or three-level structure? Is it converted to a table with each row corresponding to one of the first-level nodes?
– PJTraill
2 hours ago
When I try this (in LibreOffice Calc 6.1.3.2 on Open Suse Leap), XML source is greyed out in the Data menu – do I have to do something else first?
– PJTraill
2 hours ago
Some documentation at wiki.documentfoundation.org/Development/Calc/XMLSource , as referenced in the Help (but it says nothing about ungreying the menu entry).
– PJTraill
2 hours ago
|
show 2 more comments
What is an "xml table"? How do I find out if my file is one or has one? When I open a file like that, I see nothing in the "Map to document" window, though I see "<s:Table> lines in it. It comes from SOE Software's Clarity Election Night Reporting tool, e.g. the detail.xls file zipped inside results.enr.clarityelections.com/CO/63746/183083/reports/…
– nealmcb
Nov 12 '16 at 15:13
Cool, this works in LibreOffice Calc 5.1 with sitemap.xml from a sitemap generator service. I can choose which column to be shown in the sheet. Thanks Waldir.
– Ade Malsasa Akbar
May 3 '18 at 8:28
Quite, what is an XML table? Is it a collection of repeated nodes all of which have the same set of attributes in a two- or three-level structure? Is it converted to a table with each row corresponding to one of the first-level nodes?
– PJTraill
2 hours ago
When I try this (in LibreOffice Calc 6.1.3.2 on Open Suse Leap), XML source is greyed out in the Data menu – do I have to do something else first?
– PJTraill
2 hours ago
Some documentation at wiki.documentfoundation.org/Development/Calc/XMLSource , as referenced in the Help (but it says nothing about ungreying the menu entry).
– PJTraill
2 hours ago
What is an "xml table"? How do I find out if my file is one or has one? When I open a file like that, I see nothing in the "Map to document" window, though I see "<s:Table> lines in it. It comes from SOE Software's Clarity Election Night Reporting tool, e.g. the detail.xls file zipped inside results.enr.clarityelections.com/CO/63746/183083/reports/…
– nealmcb
Nov 12 '16 at 15:13
What is an "xml table"? How do I find out if my file is one or has one? When I open a file like that, I see nothing in the "Map to document" window, though I see "<s:Table> lines in it. It comes from SOE Software's Clarity Election Night Reporting tool, e.g. the detail.xls file zipped inside results.enr.clarityelections.com/CO/63746/183083/reports/…
– nealmcb
Nov 12 '16 at 15:13
Cool, this works in LibreOffice Calc 5.1 with sitemap.xml from a sitemap generator service. I can choose which column to be shown in the sheet. Thanks Waldir.
– Ade Malsasa Akbar
May 3 '18 at 8:28
Cool, this works in LibreOffice Calc 5.1 with sitemap.xml from a sitemap generator service. I can choose which column to be shown in the sheet. Thanks Waldir.
– Ade Malsasa Akbar
May 3 '18 at 8:28
Quite, what is an XML table? Is it a collection of repeated nodes all of which have the same set of attributes in a two- or three-level structure? Is it converted to a table with each row corresponding to one of the first-level nodes?
– PJTraill
2 hours ago
Quite, what is an XML table? Is it a collection of repeated nodes all of which have the same set of attributes in a two- or three-level structure? Is it converted to a table with each row corresponding to one of the first-level nodes?
– PJTraill
2 hours ago
When I try this (in LibreOffice Calc 6.1.3.2 on Open Suse Leap), XML source is greyed out in the Data menu – do I have to do something else first?
– PJTraill
2 hours ago
When I try this (in LibreOffice Calc 6.1.3.2 on Open Suse Leap), XML source is greyed out in the Data menu – do I have to do something else first?
– PJTraill
2 hours ago
Some documentation at wiki.documentfoundation.org/Development/Calc/XMLSource , as referenced in the Help (but it says nothing about ungreying the menu entry).
– PJTraill
2 hours ago
Some documentation at wiki.documentfoundation.org/Development/Calc/XMLSource , as referenced in the Help (but it says nothing about ungreying the menu entry).
– PJTraill
2 hours ago
|
show 2 more comments
You can also use basex from the software center.
sudo apt-get install basex
BaseX is a very fast and light-weight, yet powerful XML database and XPath/XQuery processor, including support for the latest W3C Full Text and Update Recommendations. It supports large XML instances and offers a highly interactive front-end (basexgui).
I don't have it installed but it has really high ratings from the software center.
Practical and ugly ;)
– A.B.
Apr 28 '15 at 14:58
add a comment |
You can also use basex from the software center.
sudo apt-get install basex
BaseX is a very fast and light-weight, yet powerful XML database and XPath/XQuery processor, including support for the latest W3C Full Text and Update Recommendations. It supports large XML instances and offers a highly interactive front-end (basexgui).
I don't have it installed but it has really high ratings from the software center.
Practical and ugly ;)
– A.B.
Apr 28 '15 at 14:58
add a comment |
You can also use basex from the software center.
sudo apt-get install basex
BaseX is a very fast and light-weight, yet powerful XML database and XPath/XQuery processor, including support for the latest W3C Full Text and Update Recommendations. It supports large XML instances and offers a highly interactive front-end (basexgui).
I don't have it installed but it has really high ratings from the software center.
You can also use basex from the software center.
sudo apt-get install basex
BaseX is a very fast and light-weight, yet powerful XML database and XPath/XQuery processor, including support for the latest W3C Full Text and Update Recommendations. It supports large XML instances and offers a highly interactive front-end (basexgui).
I don't have it installed but it has really high ratings from the software center.
answered Mar 14 '14 at 16:55
PartoParto
9,5841967105
9,5841967105
Practical and ugly ;)
– A.B.
Apr 28 '15 at 14:58
add a comment |
Practical and ugly ;)
– A.B.
Apr 28 '15 at 14:58
Practical and ugly ;)
– A.B.
Apr 28 '15 at 14:58
Practical and ugly ;)
– A.B.
Apr 28 '15 at 14:58
add a comment |
The default Gedit text editor is capable of opening the file - I also suggest you try Bluefish, which can do XML as well HTML and other languages. It also does auto-completion, and highlighting.
Here are examples of the above editors based on this:

N.B. With Gedit, you have to add some of the above by changing a few settings and activating a few plugins.
add a comment |
The default Gedit text editor is capable of opening the file - I also suggest you try Bluefish, which can do XML as well HTML and other languages. It also does auto-completion, and highlighting.
Here are examples of the above editors based on this:

N.B. With Gedit, you have to add some of the above by changing a few settings and activating a few plugins.
add a comment |
The default Gedit text editor is capable of opening the file - I also suggest you try Bluefish, which can do XML as well HTML and other languages. It also does auto-completion, and highlighting.
Here are examples of the above editors based on this:

N.B. With Gedit, you have to add some of the above by changing a few settings and activating a few plugins.
The default Gedit text editor is capable of opening the file - I also suggest you try Bluefish, which can do XML as well HTML and other languages. It also does auto-completion, and highlighting.
Here are examples of the above editors based on this:

N.B. With Gedit, you have to add some of the above by changing a few settings and activating a few plugins.
edited Feb 25 '14 at 13:07
answered Feb 25 '14 at 13:00
WilfWilf
21.8k1167131
21.8k1167131
add a comment |
add a comment |
XML Copy Editor is a fast, free, validating XML editor. It features DTD/XML Schema/RELAX NG validation, XSLT, XPath, pretty-printing, syntax highlighting, folding, tag completion/locking, and a spelling/style check. XML Copy Editor can be installed from the Ubuntu Software Center.
XML Copy Editor debugger (xmlcopyeditor-dbg) is an optional add-on for XML Copy Editor that can also be installed from the Ubuntu Software Center.

add a comment |
XML Copy Editor is a fast, free, validating XML editor. It features DTD/XML Schema/RELAX NG validation, XSLT, XPath, pretty-printing, syntax highlighting, folding, tag completion/locking, and a spelling/style check. XML Copy Editor can be installed from the Ubuntu Software Center.
XML Copy Editor debugger (xmlcopyeditor-dbg) is an optional add-on for XML Copy Editor that can also be installed from the Ubuntu Software Center.

add a comment |
XML Copy Editor is a fast, free, validating XML editor. It features DTD/XML Schema/RELAX NG validation, XSLT, XPath, pretty-printing, syntax highlighting, folding, tag completion/locking, and a spelling/style check. XML Copy Editor can be installed from the Ubuntu Software Center.
XML Copy Editor debugger (xmlcopyeditor-dbg) is an optional add-on for XML Copy Editor that can also be installed from the Ubuntu Software Center.

XML Copy Editor is a fast, free, validating XML editor. It features DTD/XML Schema/RELAX NG validation, XSLT, XPath, pretty-printing, syntax highlighting, folding, tag completion/locking, and a spelling/style check. XML Copy Editor can be installed from the Ubuntu Software Center.
XML Copy Editor debugger (xmlcopyeditor-dbg) is an optional add-on for XML Copy Editor that can also be installed from the Ubuntu Software Center.

edited Apr 30 '15 at 14:11
answered Apr 30 '15 at 13:47
karelkarel
60.6k13132155
60.6k13132155
add a comment |
add a comment |
In case you don't succeed with LibreOffice, try using SoftMaker FreeOffice. This free office suite has much better import and export filters that let you run Microsoft Office formats faithfully. The whole office suite is feature-packed, but needs only 58MB. It's well coded, very fast and reliable. Here's the link where to get it:
www.freeoffice.com
Kingsoft Office is also worth a try: wpscommunity.org
– s3lph
Mar 14 '14 at 15:52
add a comment |
In case you don't succeed with LibreOffice, try using SoftMaker FreeOffice. This free office suite has much better import and export filters that let you run Microsoft Office formats faithfully. The whole office suite is feature-packed, but needs only 58MB. It's well coded, very fast and reliable. Here's the link where to get it:
www.freeoffice.com
Kingsoft Office is also worth a try: wpscommunity.org
– s3lph
Mar 14 '14 at 15:52
add a comment |
In case you don't succeed with LibreOffice, try using SoftMaker FreeOffice. This free office suite has much better import and export filters that let you run Microsoft Office formats faithfully. The whole office suite is feature-packed, but needs only 58MB. It's well coded, very fast and reliable. Here's the link where to get it:
www.freeoffice.com
In case you don't succeed with LibreOffice, try using SoftMaker FreeOffice. This free office suite has much better import and export filters that let you run Microsoft Office formats faithfully. The whole office suite is feature-packed, but needs only 58MB. It's well coded, very fast and reliable. Here's the link where to get it:
www.freeoffice.com
answered Mar 14 '14 at 14:32
user258232user258232
1
1
Kingsoft Office is also worth a try: wpscommunity.org
– s3lph
Mar 14 '14 at 15:52
add a comment |
Kingsoft Office is also worth a try: wpscommunity.org
– s3lph
Mar 14 '14 at 15:52
Kingsoft Office is also worth a try: wpscommunity.org
– s3lph
Mar 14 '14 at 15:52
Kingsoft Office is also worth a try: wpscommunity.org
– s3lph
Mar 14 '14 at 15:52
add a comment |
You may find XMLStarlet useful, if you are familiar with XPATH concepts (or prepared to learn them).
This is a command-line tool which can select data from an XML file on the basis of the types of elements and the values of their attributes or those of related elements. I am not sure if it is easy to generate a CSV file or other suitable for loading into LibreOffice (if that is your aim), or whether you would need to transform it a little first. (I shall try to remember to update this if I find out more.)
The examples given in the Wikipedia article (link above) show the command as xml (e.g. xml sel for a selection), but in my case (OpenSuse Leap) it is xmlstarlet, which is also the package to install; I do not know what the situation is for Ubuntu.
New contributor
PJTraill is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
You may find XMLStarlet useful, if you are familiar with XPATH concepts (or prepared to learn them).
This is a command-line tool which can select data from an XML file on the basis of the types of elements and the values of their attributes or those of related elements. I am not sure if it is easy to generate a CSV file or other suitable for loading into LibreOffice (if that is your aim), or whether you would need to transform it a little first. (I shall try to remember to update this if I find out more.)
The examples given in the Wikipedia article (link above) show the command as xml (e.g. xml sel for a selection), but in my case (OpenSuse Leap) it is xmlstarlet, which is also the package to install; I do not know what the situation is for Ubuntu.
New contributor
PJTraill is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
You may find XMLStarlet useful, if you are familiar with XPATH concepts (or prepared to learn them).
This is a command-line tool which can select data from an XML file on the basis of the types of elements and the values of their attributes or those of related elements. I am not sure if it is easy to generate a CSV file or other suitable for loading into LibreOffice (if that is your aim), or whether you would need to transform it a little first. (I shall try to remember to update this if I find out more.)
The examples given in the Wikipedia article (link above) show the command as xml (e.g. xml sel for a selection), but in my case (OpenSuse Leap) it is xmlstarlet, which is also the package to install; I do not know what the situation is for Ubuntu.
New contributor
PJTraill is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
You may find XMLStarlet useful, if you are familiar with XPATH concepts (or prepared to learn them).
This is a command-line tool which can select data from an XML file on the basis of the types of elements and the values of their attributes or those of related elements. I am not sure if it is easy to generate a CSV file or other suitable for loading into LibreOffice (if that is your aim), or whether you would need to transform it a little first. (I shall try to remember to update this if I find out more.)
The examples given in the Wikipedia article (link above) show the command as xml (e.g. xml sel for a selection), but in my case (OpenSuse Leap) it is xmlstarlet, which is also the package to install; I do not know what the situation is for Ubuntu.
New contributor
PJTraill is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
PJTraill is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered 9 mins ago
PJTraillPJTraill
1013
1013
New contributor
PJTraill is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
PJTraill is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
PJTraill is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
Thanks for contributing an answer to Ask Ubuntu!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f426009%2fhow-open-xml-file-on-libreoffice%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
Hi do you wish to edit the file or just view it? You can use gedit help.ubuntu.com/community/gedit ubuntu's build in text editor.
– gman
Feb 25 '14 at 12:07
XML files are text files, so any text editor can open it. But if you want to perform XML validation on it, then you need some XML editor that will also load the XSD file related to the XML and perform the validation (check that you enter the correct tag with the correct value type).
– Benoit
Mar 14 '14 at 14:42
1
And what exactly were you expecting? It's an XML file!
– terdon♦
Mar 15 '14 at 21:08