[url removed, login to view] xml format from an excel file


I am using [url removed, login to view] to upload customer info and print shipping labels. All our customer information is in an excel file. [url removed, login to view] supports batch uploading using their own xml format. What we need is to automatically (or just press one button) export the excel data into the [url removed, login to view] xml format, which can be uploaded into [url removed, login to view] software directly.

The technical difficulties (for me) are :

1) the xml file needs to have data which is defined as "list of lists" by excel. List of lists is not exportable to xml by excel.

2) automatically generate the xml file from the excel file. This could be achieved by a macro or a visual basic button? I already have one "print invoices" button with the excel file, I like to append the new function of generating the xml file to it. So at the end, I only need to click one button, all invoice will be printed (current existing function) AND the ready-to-use xml file will be created (to be done).

Thank you

Skills: Excel, XML

See more: excel xml list lists export, excel file exportable, what is macro in excel, xml export, xml excel, Visual Basic Excel, macro to upload, export from excel, excel visual basic, excel function, xml invoice, xml excel format, batch batch excel file, 2013 excel visual basic, xml quot, excel 2013 visual, excel 2013 macro, xml file excel, excel macro upload data, visual basic 2013, visual basic excel 2013, visual basic shipping, use print invoice, stamps uploading xml, excel 2013 visual basic

Project ID: #4323527

7 freelancers are bidding on average $155 for this job


What version of Excel would that be? Thx.

$250 USD in 3 days
(50 Reviews)

pls chk pmb

$200 USD in 3 days
(57 Reviews)

I can help in your project, please check PMB and our ratings/reviews to get idea of our experience. Please let me know if you have any queries.

$150 USD in 3 days
(26 Reviews)

I have great experience in dveloping macros to export XML data through Excel VBA...See sample attached in messagebox.

$120 USD in 2 days
(70 Reviews)

More than 10 years experience in Excel and VBA.

$175 USD in 3 days
(6 Reviews)

Good evening, just need the excel file and the xml format and I can get your excel data in the xml format for stamps.com. I would use a c#.net approach where you would pick the file you want to convert and push a sing More

$100 USD in 3 days
(0 Reviews)

I have very good experience in converting excel file to XML formats and also made utility for my clients(InvestMentor Securities Limited) which can convert EXCEL data to XML file. Just want your xls and XML file to com More

$90 USD in 1 day
(0 Reviews)