Completed

Extract and arrange XML data to CSV

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&amp;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.

Skills: Excel, Data Entry, Data Processing, XML

See more: php extract xml data, accessing xml data files alfresco, spider extract yellow pages data csv formatted file, tools extract data csv files, source extract data csv send csv, output html files xml data, extract pdf data csv, macro copy data csv files folder, extract xml data url page, car data csv files, extract data csv exchange calendar, script will search extract strings xml files, reading csv files contain file data, convert onix xml data csv file, automate csv import google sheets

About the Employer:
( 14 reviews ) Livonsaari, Finland

Project ID: #30215078

Awarded to:

MimiFL

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 in 1 day
(602 Reviews)
7.3

22 freelancers are bidding on average €24 for this job

purplemaestro

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 r More

€20 EUR in 1 day
(22 Reviews)
5.1
tutulsoft

Hi, I can do it now , can deliver you by 1 day, XML parsing expert to CSV or any data format , we can discuss to start

€100 EUR in 1 day
(8 Reviews)
4.6
adnanarifali

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 R More

€30 EUR in 1 day
(6 Reviews)
3.1
pmshilwant9

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 re More

€30 EUR in 1 day
(3 Reviews)
2.0
(8 Reviews)
1.7
worgento

I have gone through your requirement of Extract and arrange XML data to CSV and i am willing to start the work. Thanks and waiting for response.

€30 EUR in 2 days
(1 Review)
1.0
rohitranarajput0

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 More

€8 EUR in 2 days
(1 Review)
0.9
snehamehta525

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 chan More

€15 EUR in 7 days
(2 Reviews)
0.7
KomalArshad11

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

€19 EUR in 7 days
(0 Reviews)
0.0
Mahmoudom

Hello, I am Mahmoud, with experience entering data using the Microsoft Office program. Contact for details

€20 EUR in 2 days
(0 Reviews)
0.0
ahmedsaber123999

I got an Excel course and I can handle the program well and make Excel sheets and print them and I work with you and get this job

€25 EUR in 3 days
(0 Reviews)
0.0
raktim135

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 pr More

€20 EUR in 1 day
(0 Reviews)
0.0
patshivelam

I am Shivam Patel . I can handle this project and I assured you that you are fully satisfied with my work.

€10 EUR in 3 days
(0 Reviews)
0.0
singhsachendra1

I understand XML format and can do it within 1 day but gave delivery time of 2 days to add buffer for review and re-work if required.

€20 EUR in 2 days
(0 Reviews)
0.0
Fouez

the script is ready for your [login to view URL] one click. the script is ready for your [login to view URL] one click.

€12 EUR in 1 day
(0 Reviews)
0.0
anjanimishra912

I have good knowledge of excel, and i everything know about excel. I am very happy work with you and i am going to bid this work for me.

€18 EUR in 7 days
(0 Reviews)
0.0
BikramSingh3

Hii im Bikram , I have to complete Graduation degree & i also complete a diploma in Business accounting course on Computer fundamental, windows, ms office, internet, GST, Tally9. I checked your attachment. I want to wo More

€8 EUR in 3 days
(0 Reviews)
0.0
chandrahas008

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 More

€15 EUR in 1 day
(0 Reviews)
0.0
nitinmandloi26

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

€30 EUR in 1 day
(1 Review)
0.0
DaxChohan

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.

€19 EUR in 4 days
(0 Reviews)
0.0