How can I convert a CSV file to XML?
Is there any software for Ubuntu?
Ubuntu – How to convert a CSV file to XML
conversioncsvxml
Related Solutions
If the file is an XML table, you can open it in LibreOffice Calc through the Data > XML Source menu1. 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:
This feature is documented in the Help for LibreOffice Calc and at https://wiki.documentfoundation.org/Development/Calc/XMLSource .
1 Since this is an experimental feature (at least in V 6.1.3.2), it may be unreliable and the menu entry will be greyed out unless experimental features are enabled with Tools – Options – LibreOffice – Advanced – Enable experimental features.
I would do it in this way:
cat myfile.xml | sed '/<!--.*-->/d' | sed '/<!--/,/-->/d' > cleaned.xml
Or:
awk 'in_comment&&/-->/{sub(/([^-]|-[^-])*--+>/,"");in_comment=0}
in_comment{next}
{gsub(/<!--+([^-]|-[^-])*--+>/,"");
in_comment=sub(/<!--+.*/,"");
print}'
Or:
xmlstarlet ed -d '//comment()' file.xml
Related Question
- Ubuntu – How to one open an XML file with LibreOffice
- Ubuntu – How to remove comments from an XML file
- Ubuntu – How to convert yaml to csv file format
- Ubuntu – Converting numbers in a CSV file to their corresponding URLs
- Ubuntu – From XML to CSV with command line
- Ubuntu – Convert a .txt file in a .csv with a row every 3 lines
Best Answer
On the community website on converting there is a link to a command line tool called csv2xml. Since it is unmaintained you might want to choose another option.
There is also mention of a java tool called csv2xml (warning: website is in German) and a command line tool called ff-extractor.
The link also has references to Python, Perl, PHP, XSLT but that means you need to code the converter yourself.