Freeware to convert xml to xls
in [Freeware]
|
From: Johnw on 23 Oct 2009 18:27 Diabolic Preacher laid this down on his screen : > Thanks to everyone who replied. I'll also individually reply the follow-up > queries. I need to get a table of data in xml format converted to mediawiki > code. but i know of a good excel to wiki converter but no xml to wiki > converter, so i was searching for xml to xls/csv converter and the xml file > is pretty simple format. it won't even need too complex a xsl i think. though > am zero knowledged about it. Ypu can try to you hearts content, by doing a copy of the original file & putting it in a seperate folder, that way the original is safe. Here is some extra info. If you've ever needed to convert a file from one format to another and didn't have the necessary software, you may find these two sites handy: http://freegeographytools.com/2007/free-online-file-conversion Zamzar – Probably the best-known free online file conversion site. Converts more than 100 file formats (document, spreadsheet, video, audio, graphic) from one to another. Biggest drawback is that you have to upload the file to Zamzar, then wait for an email that sends you a download link for the converted file. I use this a lot for converting Excel files to CSV and back, converting PDF documents to Word files, and converting documents to PDF format on computers that don't have PDFCreator installed. But there are lots more conversions available. iConv – Not as many conversions as Zamzar, but has some specialized ones that Zamzar lacks, and you also get your file right away (no wait for an email). Useful conversions include: # Unix2Dos, Dos2Unix, Mac2Unix – Makes end-of-line characters compatible # Convert Excel .xls to CSV # Fixed record format to tab-delimited data conversion – You enter the record lengths, and it does the conversion # Convert tab-delimited file to a fixed record format # Convert CSV file to a delimited format Scroll down on this page. http://www.cometdocs.com/csv2delimited.htm This may also do the job. Exportizer http://www.softpedia.com/get/Internet/Servers/Database-Utils/Exportizer.shtml http://www.softpedia.com/progScreenshots/Exportizer-Screenshot-13522.html http://www.softplatz.net/Downloads/Business/Databases-Tools/Exportizer.html http://www.vlsoftware.net/exportizer/
From: Diabolic Preacher on 24 Oct 2009 03:54
I just tried out the XML import in excel with a sample cd catalog xml in w3schools that didnt have a schema but it imported properly. For now, I'll go this path, unless things break down at a later point. Thanks people for your time and the links. -- Diabolic Preacher As Is |