Windows Utility: Append 2+ CSVs to Excel
$30-250 USD
Płatność przy odbiorze
Build a Windows PC local utility to:
1. Back up the Excel Spreadsheet by making a copy, keeping the last 10 copies
2. Automatically append the contents of 1-2 CSV files found in a folder to an excel spreadsheet
3. Move processed files into a COMPLETE folder
4. Log the results in a local text file.
Full story:
My software exports 2 CSV files daily to a local computer. These CSVs show the products that have been sold and the quantities of each product sold for that day. We need to add these rows of data to a master Excel sheet, and it should be done automatically when a new file is detected, OR at a specific time each day.
The fields would be
Date Sold, Erply ID, UPC, Internal ID, Description, Qty Sold
The CSV files would be
[login to view URL]
[login to view URL]
The Excel Spreadsheet would be called [login to view URL]
Automation does NOT have to be built into the app, and instead we can use a scheduled task to complete the automation.
Skills required for the job are:
- Proficiency in programming languages suited for Windows applications
- Experience with Excel spreadsheet operations
- Knowledge in handling large CSV files
- Ability to create a straightforward and friendly UI
Moreover, the utility should be easily operable and user-friendly, promptly executing the task without causing a system slow down. Please include examples of similar work in your proposal. The ability to deliver efficient code and meet deadlines is essential. Prompt, friendly, and clear communication is greatly valued.
Numer ID Projektu: #37870591
O projekcie
Przyznany użytkownikowi:
Hello I can create an automation in python that runs daily and does all the four steps you have listed above. I have understood the project and would be glad to work on it as soon as possible. Feel free to reach out Więcej
23 freelancerów złożyło ofertę za $121 w tym projekcie
Hi, I am interested to work on this task, I am an expert developer with vast experience. Kindly discuss/share details. Thanks and regards. Khalid
Hello there, I have great experience with Excel, Windows Desktop, Visual Basic for Apps, Software Architecture and Visual Basic. I am sure i can help u as i have experience with doing similar jobs. You can have a look Więcej
Hi there, I am a Data Scientist and am a professional responsible for extracting actionable insights and knowledge from large volumes of Data Visualization. I have over 12-plus years of experience with Power BI, PowerA Więcej
Hey, I would be happy to work on your job immediately. If you want fast accurate and timely delivery to your task just ping me. I am here and ready to help you. Send me a quick message and we can figure out if we are Więcej
Hi, ------SCRAPING, AUTOMATION EXPERT------- Please check my portfolio, I have scraped and created automation script for tons of websites. Visual Basic for Apps, Visual Basic, Software Architecture, Windows Desktop and Więcej
Hey Neal S., I just finished reading the job description and I see you are looking for someone experienced in Excel, Software Architecture, Visual Basic, Windows Desktop and Visual Basic for Apps. This is something I Więcej
Hi, I have read your project description very well and I am interested to do the work with you as I have sound knowledge about MS Word & MS Excel. I have more than 10 years experience in the similar jobs. If you hire m Więcej
We can do it in a few hours by starting working on it right now. Message us for a quick chat and lets start it. For more information, you can pay heed to our profiles here: https://www.freelancer.com/u/ProfessorxCorp h Więcej
I specialize in developing Windows utilities to automate tasks like Excel backups and CSV data append operations. With expertise in Windows programming languages, Excel operations, large CSV file handling, and user-fri Więcej
Hi, I have carefully read the project description for the "Windows Utility: Append 2+ CSVs to Excel" role, and I am confident that I can deliver exactly what you are looking for. I have prior experience in building de Więcej