Excel Script to Process CSV Data

@livegoodlife

Hello there, I can build a very easy windows software using python to convert the data to your desired format. I am experienced in web scraping and building scripts or a Windows desktop application using python. I am also experienced in large data scraping from a given website, bypassing IP, Captcha, and anti-bot or cloud flair protection. Please message me to discuss more regarding this project. Best Regards

@saqibmunir55

Hi I can write scprit in python or c# that will take data from csv and then generate excel file according to your requirements.

@MimiFL

Hi, this is definitely possible and i've done Excel vba scripts like this many times before without a single problem. If you are interested, feel free to message me and if you can please share sample input csv file as well as desired output excel file (only couple of rows is enough). I am available right now and would be happy to help. Thanks, Milan

@karigor

Hi there, I will write a PHP script which will take a csv file and collects data from this csv file with Client Name, client type, year end columns and final output csv file will have two additional columns (target start and deadline), these additional column data will be calculated from the other existing columns. My questions: - How those additional two column's (target start and deadline) data will be generated? I just need a formula or instruction on how to populate these two extra column's data. For example: deadline column's data can be collected from year_end column? - My php script will show a PHP form, in this form you will be able to upload the csv file and after processing the data, my script will give you a downloadable file with all the additional columns with data. Is this approach okay? Best Regards, Jahirul

@vano101

Hello I have several years of experience with Excel Macros and Visual Basic for Applications it's easy task I can complete in 1-2 hours of working time

@AccountantArman

"""""""""""""""""""ADVANCE EXCEL VBA EXPERT"""""""""""""""""""""""" ""Sir, EXCEL is my specialty and I can perform any complex task in EXCEL. I am an EXCEL VBA and CODING, AUTOMATION, TEMPLATE, REPORTS, FORMULA'S, DASHBOARD in EXCEL Advanced Level Expert. This is my field and I can complete this project with added quality. About me I am a Chartered Accountant with more than 7 years of experience including 4 years from the worlds leading Accountancy and auditing firm ""PWC"" and 1 year working at managerial level in Multination company and 2 years as freelancer. I can handle this task very efficiently and you can expect 100% accuracy from me. I am Microsoft Excel, accounting, auditing, financial statements, Form Creation in Excel through VBA and in Google Sheet, QuickBooks, and Sage expert. I have been working as a freelancer from the last 2 years and I have 330+ 5 stars reviews here. I am not new to work. I know how to meet strict deadlines without compromising the quality of the work. I will also be available for any query after the job is done as I am building my clients. please be my client and get any type of accountancy, Excel, QuickBooks, and auditing-related work with quality, efficiency, and at reduced rates. Note. The price is negotiable. I will be available for any query round the clock even if the project is completed. Regards Arman Kakar "

@rabbiawebjuggler

With over a decade in data processing, analysis, and web scraping, I'm the perfect candidate for your Excel scripting project. I understand your need for extracting and manipulating data from CSV files, selecting specific columns, filtering by date and even adding additional columns; all significant tasks that I've been doing splendidly in my career. Drawing on my skills in MS Excel, MS Access, and PHP, I can provide you with a powerful custom script designed to be used effortlessly. But that's not all. I also possess an uncommon blend of skills when it comes to transforming raw data into actionable insights. That’s what sets me apart from other candidates. My deep knowledge of Excel functions combined with my experience with MS Project management tool prepares me to do more than just process your CSV data - it sets me up to optimize your project strategy by designing the script to deliver it ready for import into MS Project. Ultimately, I'm here to save you time and effort while ensuring accuracy and reliability in data processing tasks. By entrusting your project to me, you won’t just be getting a skilled freelancer but a reliable partner who takes ownership. So if you're looking for excellence in executing this highly detailed task while meeting strict deadlines, look no further. With my expertise in hand, consider this job done!

@kolosibalint

Dear Sir/Madam, I can find a solution for this either with VBA scripts or with PowerQuery. With the 10 years experience in Excel automation it shouldn't take more than a few hours. Regards, Balint

@usmanbashir12100

Hi, I can perform any sort of operations in Excel and Word. It can be macros, complex computations and statistics. May it be complete template and VBA design and programming. All sort of work can be done. COMPLETE EXCEL & WORD AUTOMATION -- Turnkey solutions -- After Sales Support Guaranteed Excel Automation, to run your daily tasks on auto pilot. Word Automation, to export or import any data, forms and templates. Formulas used in Excel and spreadsheet Formatting for any kind of word document and making auto fill forms and documents Word to pdf or Excel to pdf conversions email automation from excel or word, generate automatic emails Designing any sort of templates in Microsoft Word and Microsoft Excel Data mining and data analysis Scripting in visual basic, VBA, macros Microsoft VBA Macro or script writing to automate daily Microsoft excel or Microsoft word tasks Visual Basic Forms, for user interface designing and dashboards Visual Basic for Applications Google sheets Data Entry with automated process charts, pivot tables, userforms, cell functions, formulas, mail merge, template design

@AnjaliMehta

Hi There! I have understood the requirements for the task. I have 8+ years of experience in performing Data Analytics, Automation and various other calculations and analysis using VBA, Macro, Power Queries, Pivot tables, and excel based formulas. My expertise is broad and versatile and includes: *Microsoft Excel- Advance formulas -Python -VBA/Macros -Dashboard -Data Analysis -Web-Scraping and Data Entry. *Adobe Acrobat-Fillable forms -Editing and Scripting. *Google Sheets-Advance formulas -Custom Scripts -Dashboard I am Proficient in Microsoft Excel, Adobe CS & CC Photoshop, Illustrator, InDesign, Adobe Acrobat and Google Sheets, and Wordpress I am waiting for a response from your side. Thanks Anjali

@GdevDataSceince

With over 14 years of extensive experience in Python, ML, and Automated scraping, I have become highly proficient in data processing and Excel manipulation - a perfect match for your project. In addition to my robust background in Python which is indispensable for creating complex and powerful Excel scripts, I'm also very conversant with Microsoft applications including Excel VBA, Macros, and Spreadsheets. Moreover, my experience as a data scientist gives me an edge when it comes to understanding and implementing your specific requirements. I can efficiently select the necessary columns from CSV, add two more based on dates (using the MM/DD/YYYY format for all date columns), filter the data as per the given range and save the file properly formatted for MS Project import. The end-results will be an organized dataset enriched with relevant additional columns tailored to meet your specific needs. I pride myself in delivering work that's second-to-none. My solutions are not just limited to addressing the current challenge at hand but designed to propel your business forward even after my engagement. Furthermore, my knowledge of Machine Learning particularly complements this project as it involves maximizing efficiency through automation - precisely what I do every day! With that said, let's get started!

@muradeltaher

The Code Is Ready Please Send Me The CSV File As a mechanical engineer, my skill set extends beyond just Excel and data processing. I have the knowledge and capability to build custom solutions, including for complex data management tasks such as this. My deep understanding of Excel, coupled with my ability to program in PHP would be a great advantage for your project. I assure you that I will ensure that your CSV data is processed accurately, that the specified columns are selected, and that all date formats are consistently in MM/DD/YYYY. Send Me a CSV File Please My proficiency in handling large-scale data sets and creating automated systems ensures you will receive exactly what you need: an error-free Excel script with added columns based on the required dates. Given that you also need the output file to be import-ready for MS Project, I'd make sure that it adheres to those specifications as well. To summarize, if you want a meticulous, deadline-oriented professional who is not only limited to mundane data entry but can build dynamic custom solutions, then I'm exactly who you're looking for. Let's discuss more about your task details so we can plan our timeline better and get started!

@pablomontoro040

As an accomplished Excel expert with a strong background in data processing, I am confident that I have the necessary skills to execute your project effectively. I have extensive experience in using Excel's scripting capabilities to navigate, manipulate, and format data to suit specific needs, which is precisely what your project demands. My repertoire includes leveraging formulas and functions to perform complex calculations on data, automating choices and lookups using functions, and creating comprehensive yet comprehensible spreadsheets among other skills. These attributes equip me with the ability to efficiently select the required columns from your CSV file (i.e., Client Name, Client Type, and Year End) and add the additional columns (Target Start and Deadline) according to your specifications. Furthermore, my deep understanding of data analysis enables me to present information in a user-friendly manner – an indispensable trait when preparing your file for MS Project import. And while my immediate knowledge of MS Project is somewhat limited, I'm confident in my capacity to adapt quickly and provide exemplary results. Let me utilize my skill set to meticulously meet all your requirements while ensuring high-quality work on schedule.

@hossamsoliuman4

As an experienced backend developer with a strong proficiency in data processing and PHP, I believe I am the ideal candidate for your Excel script project. Over the years, I have been perfecting the art of converting complex data structures into meaningful information that is readily usable for further analysis, just as you require. My extensive experience in Laravel and MySQL queries gives me an edge in designing and developing the necessary software for this task. In my career, I have frequently faced challenges that demanded intricate logic and powerful problem-solving skills; qualities that align perfectly with your project requirements. Additionally, my deep understanding of scripting languages enables me to deliver optimized code that's fast and efficient. These capabilities are crucial for handling bulk CSV files like yours without compromising on performance or quality. Importantly, I am committed to your satisfaction and always ensure my deliverables adhere to industry-best practices. If given the opportunity, I will not only meet but exceed your expectations at every step of the way, producing an Excel script exactly tailored to your needs and ready for smooth import into MS Project. Let's get started on this journey together!

@kingxanda

Hey, Thanks for your post. I'v read your description carefully. I have relevant experience I can help. some of my skills are: Visual Basic for Apps, Visual Basic, Data Processing, Excel and PHP Hope you're having a nice day my friend :)

@samra53

Hello, Hope you doing good. I have gone through your project details and found interesting to me. I am capable to do your project and ready to start. I can provide you quality assurance with 100 percent accuracy in your required time frame. Looking forward to hear from you. Thank you.

@TERODA

Hi! I'm Meili, and with over 11 years in programming, I specialize in backend automation and scripting, making your custom Excel script project an ideal match for my skills. I can craft a solution that seamlessly: - Extracts specific columns (Client Name, client type, year end) from your CSV, - Adds 'target start' and 'deadline' columns with precise MM/DD/YYYY formatting, - Filters data by date to ensure it's ready for MS Project import. I suggest implementing a dynamic script that automates these tasks, enhancing efficiency and accuracy. Leveraging Agile methodology, we’ll iteratively refine the script, ensuring it meets your evolving needs and integrates smoothly with MS Project. Our stages include: 1. **Planning** - Define script requirements and scope. 2. **Design** - Outline logic for data extraction and transformation. 3. **Development** - Write and test the Excel script, ensuring functionality. 4. **Testing** - Validate data accuracy and script performance. 5. **Deployment** - Deliver the final script for usage. 6. **Post-Launch Support** - Provide 6 months of assistance for any adjustments or enhancements. With expertise in Swift (VIPER architecture) and backend automation, I assure high-quality delivery and robust post-project support. Looking forward to optimizing your data processing tasks! Best regards, Meili

@rajat23091969

Hello misterp1905, Having worked on a variety of complex data processing projects, I am confident in my ability to deliver a custom Excel script that meets your specific requirements. With my expertise in Excel scripting, I can easily select the necessary columns from the CSV file, apply date filters, and add the required additional columns. My experience with MS Project further ensures that the final output will be seamlessly compatible for import. I understand the importance of accuracy and efficiency in data processing, and I am dedicated to providing a solution that exceeds your expectations. I am keen to discuss the project further and explore how I can help you achieve your goals. Let's connect and create a tailored solution together. Looking forward to hearing from you, rajat23091969

@DigitalBakerz

Hello, I can develop a custom Excel script that will take data from the CSV file. The script will select specified columns, export the data to excel, and filter the columns by date. It will also add some additional columns based on the dates, and save the file ready for import into MS Project. I assure you of excellent results. Please open the chat box so that we can discuss this project in more detail.