I have some 1700 small XML files that contain information I would like to extract and format as CSV file that I can import to Google Sheets. Anyone with some basic scripting skills could do this.
Here's a sample of the file content:
<SSLMetadata>
<Name>Milan</Name>
<Artist>Karsh Kale</Artist>
<Album>Liberation</Album>
<Genre>#FLO</Genre>
<Length>08:54.31</Length>
<Size>0.0MB</Size>
<ByteSize>0</ByteSize>
<Bitrate>320kbps</Bitrate>
<Samplerate>44.1k</Samplerate>
<BPM>82.50</BPM>
<Comments>Tablas, Indian vibe, fast D&B ending</Comments>
<Grouping>3</Grouping>
<Remixer/>
...
And this should be exported as:
Filename, Track, Artist, Album, Genre, Grouping, Comment
2644543, Milan, Karsh Kale, Liberation, #FLO, 3,"Tablas, Indian vibe, fast D&B ending"
All the ~1700 entries are to be combined in one single file.
Example of the original XML file is attached.
Hello, i believe i can code this for you. This is relatively simple VBA code and i am able to code this in ~1h. If you are interested, feel free to message me. I also need couple more xml files.
Thanks, Milan
€25 EUR em 1 dia
5,0 (641 avaliações)
7,3
7,3
21 freelancers estão ofertando em média €24 EUR for esse trabalho
Hi. Hope you are doing well. I have high level expertise in scripting. I can create a script for your extract data from your XML files and convert it into CSV. Will provide you top quality work for sure. I can start right now.
Hello, I have a experience of about 5+ year in Advanced Excel work and I am currently working for many projects based on Advanced Excel work. You can check my profile also there are sample images of my work. I can change your xml file to csv files according to your requirement.
So I can provide you accurate and efficient work according to your requirement and I can easily handle your project and provide you accurate work according to your need.
I am ready to work on a Sample file also if required. So please initiate the chat and give me Sample work to check my working knowledge and I assure you to provide 100% accurate work.
Thanks
Hi there,
I would like to work and complete your project in just €30 EUR with further details.
My portfolio is all to say about my work, Kindly refer to below mention link:
https://www.freelancer.com/u/adnanarifali
Regards,
Adnan Ali.
Hi,
I would like you to work on your project. I am having around 13+ years of experience in this domain. will develop a excel Macro that will take care of this task.
I am an automation Specialist in BI domain (BI reporting, Automation and Visualization). Can do programming in multiple languages including (MS Excel, MS Access, SAS, SQL, SSIS, VBA, VB.NET and R) and analyze large data set with visualization (Tableau, QlikView and Power BI).
Thank you!
hello...
I checked your attachment. I want to work on this project. I'll provide you fast work with 100% accuracy. I have lots of experience in this field. Send me a message for further discussion.
If you need demo of my work then I'll provide you.
thanks
Hey there, I am willing to do this job as I have great knowledge of data entry from XML. I am a Compter science student.
Looking forward to work with you.
Regards,
Komal
Hello there, hope you are doing well. I have understand all of your requirements and I can do it for you. I have also checked your attached XML file. Please drop a message for further discussion. I will complete the project within 2 hours.
Hoping to talk soon,
Regards,
Raktim Bikash Gogoi
Dear Sir/Madam,
my name is Chandrahas Minajigi experienced data scientist and certified Data scientist from IBM and have good programming skills. I have experience in extracting useful data from raw data. I can finish this task within 1 day. You can google about me to know more.
Thank you
Hello
XML to CSV, It is very interesting job and ready to start work immediately.
I can do you job easily.
I am waiting for your reply.
Thanks
Nitin Mandloi
I have already done a lot of projects like this before, not having any kind of trouble at all doing this, I am qualified enough to do your project, hope you'll me cause i really need that.