Data extraction from Excel FTP and generation of a Price List

Hello Sir, This whole process can be automated by using a background service which shall run without any user intervention and perform the 4 steps on a given time every day. I have delivered similar solution for various other clients. Please invite for discussion via chat. Thank you, Usman

Hey Good evening , Just finished reading the brief details . I see you have been looking for someone who has experience with these tech stacks Software Architecture, Excel, Data Processing, C# Programming and Data Entry. I will request you to review my profile, skills, projects and customer feedbacks to confirm that I will be good fit for this job. I would like you to start the chat so we can discuss the project in detail and we will see how it goes. Questions: 1. These are all the requirements? If not, Please share more detailed requirements. 2. Do you currently have anything done for the job or it has to be done from scratch? 3. What is the timeline to get this done? Why Choose Me? 1. I have done more than 250 major projects only on freelancer.com. 2. I have not received a single bad feedback since last 5-6 years. 3. You will find 5 star feedback on last 100+ major projects which shows my clients are happy with my work. Portfolio: https://www.freelancer.com/u/AwaisChaudhry Timings: 9am - 9pm Eastern Time (I work as a full time freelancer) Thanks and regards, Awais

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion. Thank you Sandeep

Hello there, I am experienced in web scraping and to build script or a windows desktop application by using python. I am also experienced in large data scraping from the given website, by pass IP, Captcha, and anti bot or cloud flair protection. Please message me to discuss more regarding this project. Best Regards

Hi there, I am proficient in creating automated data handling solutions and can develop an Excel system that meets your specific requirements. Using advanced Excel functions and VBA scripts, I will create FILE A to automatically extract data from FILE B located on an FTP server. FILE A will include dynamic filters, such as Brand and Price, to selectively process data. The processed data will then be output to FILE C in CSV format containing SKU, Quantity, and Price columns. Additionally, I will automate the saving of FILE C to another FTP folder and schedule this entire process to run daily at a specified time without manual intervention. Sincerely, Mir Niyazuddin

Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the project. Thanks. ..

Hello, It will be a lot easier if FILE A is a Google Sheet instead of Excel file to input the filter parameters. Then I can write a Python script to be executed in AWS Lambda, which can be scheduled to run at regular intervals using AWS CloudWatch Events. That way everything will run in the cloud. The other option is to use Excel and automate the process with a VBA macro - download, filter, and upload the data to the FTP. For the daily updates, we can use the Windows Task Scheduler, but the PC has to be running at that time, but everything will be automated. Thank you for your time. -Petko

Hi I have expertise in Excel VBA Programming, and can develop you an Excel sheet, to automatically perform the tasks that you mentioned (from 1 to 4). I'm available to discuss further details in chat and can start right away. Abdul H.

Good day! I understand that you want to extract some data from an Excel file located in an FTP server, create another excel file out of that and finally convert and save that as a CSV file into a different folder in the FTP server. I'd be glad to get this job done for you within a maximum of 4 days time without any issues. I have extensive experience as a programmer, which includes automating Microsoft office applications and related tasks. I'm also very famliar with working with FTP servers. So I believe I'm the best candidate to get this job done for you. And you can rest assured that I'd get your job done perfectly within the 4 days time I've quoted, if I accept to work on this project. (I"ve maintained a 100% on-time project completion record for the 15 years on Freelancer (Please check my profile by clicking on my username for more information). What I need in order to start working on this project: 1) Sample Excel file (File B), and confirm that the structure of this file is fixed 2) How excatly do you currently set the filter in order to extract data and create the structure of the File A? (I can decide what's the best way to do this, if you prefer that) 3) Could "Brand" or "Price" be the only filters? If not, specify all the possible filters. (and confirm that these are fields/columns in the Excel File B) 4) What operating system are you planning on running this script/program you expect to get done? Thank you and I look forward to getting this job done for you!

Hi there I have extensive experience in creating automated Excel files that extract and manipulate data from various sources. I will develop a macro-enabled Excel file (FILE A) that will connect to the FTP folder, extract data from FILE B based on specified filters, and generate FILE C in CSV format with columns for SKU, Quantity, and Price. The process will be scheduled to run automatically at a designated time every day without the need for manual intervention. I am confident in my ability to deliver a reliable and efficient solution to meet your requirements. I can provide links to similar works from my portfolio. Please go through my profile its 15 years old see the work I did over the years. ---> No Win No Fee means that your satisfaction is my utmost priority. <---- Lets discuss the job details. Moreover, I am willing to start the job and perform tasks without even being hired; it is just to show my commitment to this project. Looking forward to hear from you. Regards Shah

I understand that your project requires an efficient and autonomous system to extract data from an Excel file located in an FTP folder and based on customizable filters, generate another Excel file that meets specific formatting requirements. Coming from a diverse technology background encompassing data processing, Excel management and even web scraping, I am confident I possess the skills needed to tackle this project successfully. My expertise in data extraction will be instrumental in creating a seamless process for you. I have ample experience with FTP integration and automation using Excel, ensuring that the daily update of FILE B is automatically pulled into FILE A at the designated time. With thorough understanding of Excel functions, I will implement a flexible filtering mechanism — allowing you to modify parameters like brand or price easily. Your objective of having the final file (FILE C) saved inside another FTP folder is also well within my grasp. Given my familiarity with various IT platforms, navigating such integrations and ensuring smooth operations comes naturally to me. Ultimately, choosing me for this project grants you not only my technical skillset but also a commitment to delivering top-notch work and zeal for customer satisfaction.

Hi, I have read the brief details on the job listing. I am a full stack developer with 6 years of coding experience. I have worked with multiple similar jobs before. I have worked on similar jobs before specially with Software Architecture, C# Programming, Data Processing, Excel and Data Entry. Apart from that I have a good team of developers for doing web based jobs of any kind. You can check my portfolio here: https://www.freelancer.com/u/AITSoft I believe I can do this job. Lets discuss ! Shamshad

Hello, I am able to build an automation task based on your requirements. I will use Python to write a script that will execute all 4 processes you mentioned, it will be executed automatically every day. I am able to start as soon as possible and deliver in 2 days.

Dear Hiring Manager(Albert M), I am excited to submit my proposal for your project. Below is an overview of my plan to accomplish the tasks outlined: 1. I will develop a Python script that connects to the FTP server, locates FILE B, and extracts the necessary data. 2. The script will incorporate user-defined filters, such as Brand or Price, to extract relevant data from FILE B. 3. Using pandas library in Python, I will organize the extracted data into a DataFrame and save it as a .CSV file (FILE C). 4. Finally, the script will upload FILE C to the designated FTP folder automatically. I am confident in my ability to create a robust solution that meets your requirements. Please feel free to reach out with any questions or to discuss further details. Regards, Nadeem S.

Hi there, ★★★ Scrapping / Python / Selenium Expert ★★★ 6+ Years of Experience ★★★ I've read requirements and ready to extract data from Excel FTP and generatea Price List. Some major works we do: ✔️ Product Websites Scraping: eCommerce (Shopify, eBay, Amazon, AliExpress. etc) ✔️ Advertising or Ads posting sites (gumtree, Rightmove, Asian metal. etc) ✔️ Login required websites ✔️ Process Automated Tasks (Automatic download file from any website pdf, CSV, etc) ✔️ Software and Scripts Development ✔️ With Browser load and Without Browser load ✔️ Web research and Data Entry work as well, ✔️ Scrapped Datastore into multiple form SQL server, CSV, Excel any many more like JSON. We use different tools and techniques to scrape the websites depending on the kind of task but mainly Python, C# Desktop Application and Selenium and Html Agility. As the requirements on project are not complete and need discussion so i placed tentative bid. To provide you the best quote, let's have a chat! Best Regards, TechPlus Team

As the head of Einnovention, I am confident in saying that we are the perfect fit for your data extraction project. With our extensive experience in software architecture and command over Excel, creating a tool that can extract data automatically from an FTP folder and generate a custom price list as per your filters is well within our sphere of expertise. Our ability to understand and create custom software tools has been greatly appreciated by our clients over the years. We have a track record of completing complex projects proficiently and on time, as evident from our brilliant scores and positive feedback on Freelancer.com (4.9/5 rating). Furthermore, our team has tackled projects requiring data extraction, sorting, filtering and exporting skills frequently. These experiences have given us a sharp understanding of the technical challenges involved in such tasks and the creativity to devise robust solutions to overcome them smoothly. All the while, we ensure that we provide uninterrupted services post-project delivery by offering unlimited repetitions and free service for over 2 weeks if needed. By working with us, you can be assured of both quality work and dependable service. Don't hesitate- contact us today for your free customized project need assessment!

❇️ I understand you need an automated solution to extract data from FILE B (updated daily in an FTP folder) and create FILE C (a .CSV file with SKU, Quantity, and Price columns) based on filters like Brand or Price. I can create an Excel file (FILE A) that: ✅Retrieves data from FILE B using FTP integration ✅Applies filters to extract relevant data ✅Generates FILE C with the desired columns ✅Saves FILE C to another FTP folder All this will be done automatically at a set time daily, without human intervention. Let's discuss the details and get started! Here are some of my relevant projects: ✅ Automated Data Extractor ✅ FTP Integration Specialist ✅ Filter Application Expert ✅ CSV File Generator ✅ Scheduled Task Creator ✅ Excel File Automation ✅ Data Processing Specialist ✅ FTP Folder Manager ✅ Daily Task Automator

As an experienced engineer with strong proficiency in data processing and Excel, I am uniquely equipped to handle your project. Over my 7+ years of working as a software architect and engineer, I've honed my skills in back end and front end development, specializing in Python and Excel. I can leverage these skills to design and implement a fully automated system that will effortlessly extract and process data from your FTP folder every day at your desired time. One particular advantage you'll have by choosing me is my expertise in web scraping. This skillset would be invaluable for the first part of this task, automatically extracting the relevant data from FILE B into FILE A. Additionally, my aptitude in database management (MySQL/PostgreSQL/MongoDB/DynamoDB) further ensures that the extracted data will be accurately analyzed as per your filter requirements, ultimately producing a .CSV file (FILE C) with the 3 columns (SKU, Quantity, Price). Finally, just as you're seeking a punctual outcome, one of my key strengths lies in consistently meeting deadlines without compromising quality. With the commitments to serve full-time on freelancer and deliver the best results within budget constraints, I ensure you that engaging me for this project is a decision well made. Let's build a successful relationship together starting with the successful completion of this project. Looking forward to working with you!

HI, I am interested to work on this task, I am expert developer with vast experience. Kindly discuss/share details. Thanks and regards. Khalid

As an experienced professional with over 12 years in the field, I assure you my proficiency in C# programming and Software Architecture are an ideal fit for your project. I have a proven track record of developing robust systems which can autonomously handle complex data processing tasks, ensuring accuracy and timeliness. My expertise with Excel specifically entails developing elaborate functions to extract and filter data efficiently, essential for your task at hand. Furthermore, I am adept at integrating FTP functionalities within projects ensuring seamless and secure data transfer between sources. Your project's need for automatic daily updates aligns perfectly with my lcomprehensive understanding of scheduling mechanisms, allowing me to deliver a truly automated solution with no operator intervention. Lastly, I bring along a creative element to problem-solving. Optimal filtering based on changing parameters like brands or prices is a challenge I'm eager to tackle head-on, keeping every aspect of your project customizable and adaptable as per your requirement. With my skills,and technological proficiency coupled with decades of experience, I guarantee the utmost efficacy and excellence going forward with this project.

hello, I have worked on similar projects processing files with different formats such as excel or csv and data from different sources such as ftp. I estimate 3 or 4 days to finish the work. Greetings.