Freelance projects

Freelance projects

Macro for Excel or another script for editing XML without changing the structure

Desktop Apps, Python — incorrectly specified categories?

36 USD

Client's review of cooperation with Anton T.

Macro for Excel or another script for editing XML without changing the structure

36 USD

Quality execution, loyal approach, satisfied with the result and the process of cooperation. The task has been solved, all nuances taken into account. Anton provided assistance in testing the script and explaining its functionality (both separately and in the form of a text manual) + helped to consider the pitfalls that could arise in the future.

5.0

Artem Prom

Reciprocal Feedback

4 October 2025

Freelancer's review of cooperation with Artem Prom

Macro for Excel or another script for editing XML without changing the structure

36 USD

The client promptly clarified some points, checked implementation options, and successfully closed the project.

5.0

Anton T.

Reciprocal Feedback

4 October 2025

Project translated automatically. Log in or register, to view the original

Task:
There is an XML file (export of the product catalog from the website).
It is necessary to implement a solution that will allow mass updating of data in this XML (prices and availability statuses of products) without breaking its structure.

What needs to be implemented:

A script / macro / program that:
- opens the XML;
- finds the required products by article number or other reference (similar to VLOOKUP);
- updates the target value (for example, price or availability) according to the Excel file;
- saves the result in the same form, without breaking the XML structure.
The solution should be easy to use (for example, running a macro from Excel, or running a Python script with a double click (.exe)).
As a result, we get a ready-to-use current XML file that can be placed on hosting and distributed via a link.

Desirable:

Implementation in VBA (Excel), but a solution in Python or another language can also be proposed if it is more reliable / simpler and more convenient.
A short user guide.

Submission format:

A ready working file (Excel with a macro, or script).
An example of the updated XML.
Instructions (how to update the data).

Update #1 from 30 September 2025

Task:
There is an XML file (export of the product catalog from the website, with nodes <offer>).
It is necessary to implement a solution that allows for bulk editing of data in this XML (prices, availability statuses, names, descriptions, photos, etc.) without violating the structure of the file.
The output should be an updated XML that can be uploaded to hosting and distributed via a link.

Input Data

XML file.
- One product is located between <offer> … </offer>.
- Product identification is done by one of the nodes (for example, <vendorCode>), but there should be an option to manually specify which node to identify by, meaning it does not always have to be by vendorCode.
- Some data is stored in nodes (for example, <description>, <price>), while others are in the form of attributes (available="true|false" in <offer>).
- There are lists of nodes (for example, <picture>) that can contain any number of elements (several photos for a product, accordingly there are also several <picture> nodes).
Excel file with "instructions" for updating.
Minimum structure:
Identifier (for example vendorCode) New value (name of the node, attribute, or indication that the photo needs to be updated, in the case of photos)
12345 true
67890 false
Additionally:
- For nodes of type <picture>, it is allowed to specify a list of values in the format url1;url2;url3. The program should convert this into a set of nodes:
```
<picture>url1</picture>
<picture>url2</picture>
<picture>url3</picture>
```
- For other nodes or attributes — the new value is recorded directly in the second column.
- For the scenario of adding new nodes: a complete node can be passed in the second column (for example <wholesalePrice>100</wholesalePrice>), accordingly this node will need to be added to the required product.

Functionality

The solution must provide:

Reading the XML file.
Searching for the required products in the file by identifier (for example, by <vendorCode>).
Updating values according to the Excel table:
- Replacing attributes (for example, available="true/false").
- Replacing nodes (<price>, <description>, <name>, etc.).
- Replacing list nodes (<picture>).
- For any scenario - it is sufficient to completely replace old data with new ones. Old data does not need to be retained.
Additional scenario (optional): the ability to bulk add new nodes in <offer> (for example <wholesalePrice>).
Saving the result in a new XML file:
- The structure must remain unchanged.

Solution Format

Possible implementation options:

Excel + VBA (macro):
- Table with instructions in Excel.
- Button to run the macro that reads the XML and performs the update.
- Result — new XML file.
Python (or another language) + .exe:
- Separate script/program that takes XML + Excel with instructions.
- Run by double-clicking.
- Result — new XML file in the same folder.

Usage Requirements

Ease of use for non-technical users.
Short user guide:
1. Prepare Excel with instructions (identifier + new value).
2. Run the script/macro.
3. Receive updated XML.

Editing Scenarios

Updating attributes (for example available="true|false").
Updating value in a node (for example <price>, <description>).
Updating list nodes (for example <picture>). Old elements are removed, new ones are added.
(Optional) Adding new nodes to the product.

Submission Format

Ready working file (Excel with macro or .exe/script).
Example of updated XML after changes.
User instructions (how to run, how to prepare Excel).

Proposals 18 Withdrawn 1

Vitalii Zhovnirchyk

100 0

Budget: 2000 UAH Deadline: 1 day

Using a VBA macro is very inconvenient for building XML structure and editing data because for VBA, XML is just a text file with indentation.
I can implement it in Python. I already have a ready script that forms the XML structure for promo. I can easily add editing through Excel.

It will work approximately like this: you run a script that reads the XML and forms an Excel table. In this table, you change the data and run the script that will change this data in the XML.
This will be the simplest and fastest solution to your task.

p.s. with the help of a Python script, you can automatically update prices and availability from Google Sheets and immediately upload them to hosting for distribution via a link. You won't need to do this manually.

Ihor Doronin

9 0

Budget: 1500 UAH Deadline: 2 days

Good evening, Artem!
In general, the task is clear, but for an accurate response regarding deadlines and pricing, I would like to clarify some questions that arose after analyzing your task.
Please write in private messages – we will discuss the details and your wishes.

Maksym O.

5 0

Budget: 1000 UAH Deadline: 1 day

Hello, I worked on the project "XML Analysis for the Store" – updated 1200 products, automated price changes and availability status while preserving the file structure.

What format of the Excel file do you plan to use for the updates – with product codes in a separate column?

I suggest we get in touch, I will consult you for free on the technical side and we will create a development plan + I will tell you about my team!

Olga Dmytrik

24 3

Budget: 3000 UAH Deadline: 2 days

Hello.
I have experience in completing similar tasks, so I am confident that I can deliver everything with quality and within the agreed deadlines. I am ready to start soon. Let's discuss the details in private messages.

Maksim M.

0 0

Projects -
Rating -
Rating 151

Budget: 1000 UAH Deadline: 1 day

Good day.
I can implement it in VBA. I have a few questions?
1. I need an example of the xml file
2. Where to get the new prices? I also need an example.
The final price and deadline after discussion.

Dmytro Olefirenko

8 0

Budget: 1000 UAH Deadline: 1 day

Hello

I have experience writing similar scripts in Python. I can develop such a program for you as well. I will provide a video instruction on how to use the program.

Sergiy Turenko

11 0

Budget: 2000 UAH Deadline: 2 days

Hello. Technologies: lxml (correct structure preservation), pandas (reading Excel), PyInstaller (build into .exe).
Interface: simple window launcher or console with prompts (choose XML, Excel, columns SKU/price/status).
Advantages: quickly processes large XML (tens to hundreds of MB), stability, easy expansion.

Andrii-Serhii Pavlenko

1 0

Projects -
Rating -
Rating 184

Budget: 1500 UAH Deadline: 1 day

Hello, Artem!

I am a Python developer with experience working with Excel and XML files.
I can write a simple script that will replace the values you need without disrupting the file structure.

Write to me, and we will discuss your project!

Best regards,
Andriy

Stanislav K.

6 0

Budget: 1900 UAH Deadline: 5 days

We can create both an .EXE file and a web solution for cross-platform access. We have extensive experience in similar projects.

Rostyslav Abramiv

12 1

Budget: 2000 UAH Deadline: 3 days

Ready to implement a solution for bulk updating an XML product catalog.
Option 1 — Excel + macro (VBA): I will create a macro that:
opens the XML file;
finds products by SKU (similar to VLOOKUP);
updates prices and stock statuses from the Excel table;
saves the XML without breaking the structure.
Output: a ready Excel file with a launch button, instructions, an example of the updated XML.
If the XML format is complex — I will suggest an alternative in Python:
a script that reads Excel, updates XML, and saves the result;
I can compile it into .exe for double-click execution.

The solution will be easy to use, with instructions for the team. I am ready to adapt to your XML format.

Viktor Piven

18 3

Budget: 1500 UAH Deadline: 1 day

Good evening, Artem. I am working on automation in Python. I can develop a Python script and package it as an exe file for your needs, I will do everything quickly and efficiently. If you are interested - write to me, I will be happy to discuss the details.