Automatic processing of Excel/CSV file with data on car rims.
16 USD Technical task
Task: Automatic processing of an Excel/CSV file with data on automotive wheels.
Input data
- A file in CSV or Excel format, where:
• The first row (row 1) contains a list of parameters separated by the | symbol.
• Each subsequent row contains information about one product in the same sequence of parameters as in the first row.
File processing requirements
1. Distribution of parameters into columns
It is necessary for all parameters from the first row to be separated into individual columns. That is, instead of data in one cell with |, each parameter should go into its own column.
2. Order of columns
It is necessary to keep ONLY the required columns in the following order:
id | article_id | factory_number | availability | price | price_4 | avg_price | rvo_price | expected_delivery_date | manufacturer | type | type_color | type_design | number_of_holes | hole_circle | hole_circle2 | hole_circle3 | width | diameter | offset_from | offset_till | centre_bore | centre_bore_type | image_link_1 | description | description_2
3. Uniqueness of products
It is necessary to keep only unique products by the factory_number parameter. If there are multiple rows for one factory_number – keep the one with the lowest value in the price column.
4. Output file format
• Save the result in CSV format (separator 😉.
• Encoding – UTF-8.
5. Automation
The script/instruction should allow performing the above actions on a daily basis. The solution can be implemented as an Excel macro, or Google Sheets Script, or your solution.
Expected result
- CSV file with clean data in the specified order of columns.
- All products have a unique factory_number.
- For duplicates, only the record with the lowest price is kept.
Applications 1
-
1 day22 USD
1 day22 USD
Good day. I can immediately provide a ready solution.
Feel free to contact me, I will provide you with a tool that will allow you to convert the files you need into a clean format.
And this could be!
https://content.freelancehunt.com/text-attachment/project-board/784434df-2793-4217-8aa7-6cfabf83cd70/2263154/Screenshot%202025-09-17%20at%2010.53.12.png
-
1 day16 USD
1 day16 USD
Good day. I am ready to implement, I have already dealt with something similar. We need to discuss the details regarding the usage. I will be happy to collaborate.
-
1 day22 USD
1562 7 0 1 day22 USD
Good day!
My name is Roman, and I am among the top 5 developers in the "Artificial Intelligence and Machine Learning" category out of ~1600 specialists on the platform.
I guarantee:
- Fast and quality task execution
- Strict adherence to deadlines
- Regular communication throughout the entire process
I would be happy to discuss the details of your project in private messages.
-
2 days45 USD
591 22 0 2 days45 USD
Good evening, I will make a Php script or Excel macro by morning - your choice.
-
1 day16 USD
667 5 0 1 day16 USD
Hello! I am interested in your project. I have extensive experience in:
📊 Data processing: Openpyxl, JSON, MySQL, MongoDB, Google Sheets API
🔍 OCR and text search: Tesseract, FuzzyWuzzy
🖥 GUI implementation: HTML-webview, Tkinter, DearPyGui, React
I will complete the work quickly and efficiently. I propose to implement it as a desktop script/tool/application. Contact me to discuss the details and deadlines for the project!
-
2 days18 USD
412 2 days18 USD
Good day! 👋
I can create a Python script that will automatically process your CSV/Excel files: it will split the columns, keep only the necessary ones in the specified order, remove duplicates by factory_number with the lowest price, and save the result in UTF-8 CSV.
The script can be configured for daily processing.
-
1 day16 USD
853 48 0 1 day16 USD
Hello!
I am interested in your project and ready to complete it.
I have been working with Google Sheets for over 5 years and have significant experience in:
• developing custom solutions,
• creating templates,
• automating processes,
• integrating with third-party services,
… • developing complex formulas and scripts (Google Apps Script).
I am ready to discuss the details and find the best solution for your task. Let's communicate :)
-
2 days22 USD
4028 11 0 2 2 days22 USD
Implement automatic processing of Excel/CSV files with disks:
Parsing the first line with | → splitting into columns.
Saving only the required columns in the specified order.
Uniqueness by factory_number, selecting the row with the minimum price.
Output file: CSV (separator ;, UTF-8).
…
Automation (Python script, Google Sheets or Excel macro) for daily execution.
-
1 day16 USD
2257 35 0 1 day16 USD
Good day, I am ready to help. I have extensive experience in similar solutions. I will propose an optimal quick solution, feel free to reach out.
-
2 days78 USD
95670 1272 1 10 2 days78 USD
Hello. I am ready to implement a script in Python. Feel free to contact me.
-
2 days27 USD
9340 20 0 1 2 days27 USD
Good day!
I understood your task — I am ready to implement automatic processing of Excel/CSV files according to the described rules: splitting parameters into columns, keeping only the required fields in the specified order, uniqueness by factory_number with the minimum price, and exporting to CSV with UTF-8 encoding.
I have sent you details regarding the solution format and automation in private messages.
-
1 day22 USD
2114 6 0 1 day22 USD
Here you can view the work
The first sheet is what you provided
The second sheet is automatically redone
https:// docs. google.com/spreadsheets/d/1wK8nv7bxdzbsSV8P2n480fB31d0EriT_C--hb9Hu6Y0/edit?usp=sharing remove two spaces
-
1 day16 USD
2991 73 4 2 1 day16 USD
Hello! I can complete your task today, as I have VERY extensive experience working with spreadsheets!!!!!!! Feel free to contact me!!!!
-
1 day16 USD
5883 345 0 1 day16 USD
I can do it in Excel/Google Sheets, with a Python script or a compact EXE in other programming languages...
-
2 days16 USD
631 5 0 2 days16 USD
Good day
I am ready to quickly and efficiently complete your task
----------------------------------
-
1 day16 USD
1048 7 1 1 day16 USD
Hello! I have experience in developing scripts for automating the processing of CSV and Excel files with trading data, particularly for online auto parts stores.
I will create a Python script using the pandas library that automates the complete data processing cycle: parsing delimited | values, filtering the required columns in the specified order, removing duplicates by factory_number (keeping the record with the lowest price), and exporting the result to CSV with the required delimiter and encoding. The solution will be flexible enough for daily use.
I am ready to start working immediately.
-
1 day22 USD
669 8 0 1 day22 USD
Good day.
I have extensive experience in automating Excel / CSV files.
Write to discuss the details.
-
1 day22 USD
4611 52 1 1 day22 USD
Good day, I work in Python, I will complete your task, I can start immediately. Write to me - we will discuss the details. The price is 1000 UAH, everything will be ready by today.
-
2 days22 USD
656 9 0 2 days22 USD
Good morning, Vlad!
Overall, 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.
-
4 days33 USD
3387 84 0 4 days33 USD
Ready to take it on. But I can only implement it with a script in Python (console application, not a macro). Need to clarify the details of the order, write to me! I use Python, uv, GitHub, Docker.
-
А яка OS у вас? Вот так може бути
-
Ось приклад виконання
https://docs.google.com/spreadsheets/d/1wK8nv7bxdzbsSV8P2n480fB31d0EriT_C--hb9Hu6Y0/edit?usp=sharing
-
Current freelance projects in the category Databases & SQL
Refinement of 1C UT 11 for Zebra TSD (RDP): different sound signals when scanning
22 USD
Configuration: 1C UT 11 Address warehouse Zebra TC26 TSD Work via RDP Product scanning is performed in receiving, placement, picking documents, and other warehouse operations. Current problem: Warehouse workers operate through the Zebra TSD. When scanning, they do not always… C#, Databases & SQL ∙ 9 hours 7 minutes back ∙ 2 proposals |
Heal the 1C configuration
111 USD
Configuration of CRM & ERP SmartCeiling (2.8.26.0) Protection via Registration Code. Registered until the end of the year. Databases & SQL ∙ 1 day back ∙ 7 proposals |
Need a 1C specialist for refinements and development.I am looking for a 1C specialist for freelance collaboration. I am currently working with a contractor who provides support and maintenance for the 1C system. However, due to the contractor's workload, there is a need for prompt execution of additional tasks, improvements, and… Databases & SQL ∙ 5 days 23 hours back ∙ 11 proposals |
Restoring Instagram after a banOn March 3, 2026, my Instagram was blocked due to a violation of rules. I believe there has been some mistake, as the page was personal with photos and videos of my personal trips. I did not post any comments anywhere. I have sent several appeals. I cannot download my files… Databases & SQL, Web Programming ∙ 6 days 10 hours back ∙ 6 proposals |
Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:
45 USD
Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into… System & Network Administration, Databases & SQL ∙ 9 days 17 hours back ∙ 16 proposals |
Ukraine