Escrever csv vba jobs
I'm looking for a skilled Data Engineer to assist in a large-scale data project that involves data cleaning and preprocessing. Key Responsibilities: - Integrate and process data from various sources including Databases, CSV files, and APIs - Handle a high volume of data (more than 10GB) efficiently - Implement data cleaning and preprocessing techniques to ensure quality and consistency Ideal Skills: - Proficiency in handling large-scale data sets - Strong experience with integrating and processing data from diverse sources - Expertise in data cleaning and preprocessing techniques - Knowledge of relevant tools and frameworks for data engineering Prior experience in similar large-scale data cleaning projects and proficiency in SQL, Python, and ETL tools would be highly advanta...
I am in need of an individual with skills to assist with the migration of data from FS5 and .IDX files. My project involves: - files in FS5 or .IDXfiles that need to be migrated into a usable, readable CSV format that can be edited a - Handling text data specifically, and ensuring its integrity is maintained throughout the conversion. Potential freelancers need to have: - Knowledge of FS5 /.idx files. - Strong knowledge and understanding of text data management. - Excellent problem-solving aptitude, as the difficulty level can vary across files. I look forward to a thorough demonstration of your ability.
I have a CSV file that I need to be analyzed through visual data analysis in Python. The CSV file has a wide range of data, but the specifics of what data I'm interested in have been left open-ended. I need you to help me identify trends and patterns from this data and provide me with clear, insightful, and informative visualizations. Ideal skills: - Strong background in data analysis. - Proficiency in Python and data visualization libraries. - Experience with analyzing CSV files. - Ability to generate insights from data.
I'm seeking for an expert in Excel VBA with strong debugging and troubleshooting skills along with the ability to optimize the performance of existing macros. The key responsibilities would be: - Debugging and troubleshooting my created Excel VBA Macros - Enhancing the efficiency and performance of these Macros - Inclusion of new features as required - And finally be able to explain the code for each module. What I'd really value is a clear and concise explanation of what each module does, and this requirement would be fulfilled best by providing detailed comments in the code. This project is perfect for anyone with a deep understanding of Excel VBA, Macro functionality, and a passion for clear and enlightening code documentation.
To fill this position, I am looking for a seasoned Tableau Expert who can efficiently create a dashboard that helps in tracking and visualizing Employment Metrics. Key Project Requirements: - Connect and import data from CSV files - Visual representation of data utilizing Line charts, Bar charts, and Geographical maps - All visualizations must be designed to track Employment data pulled from a pre-existing census Ideal Experience: - Proven experience in creating interactive Tableau dashboards - Proficient in handling CSV data within Tableau - Excellent experience with line charts, bar charts, and geographical mapping - Experience in employment data analysis or HR data visualization is a distinct advantage This is a fascinating project that needs advanced skills on Tablea...
...manipulation, data analysis and reporting. The process is already mapped out and can be shared with you. - Using Pulover Macro and AHK, as well as VBA to facilitate the automation process. - Ensuring the automation process involves uploading files to Sharepoint, sending messages on Teams, and emails. The key deliverable for you is not just the completion of the automation process, but a clear and concise explanation of each step once the task is finished. This will be crucial for future troubleshooting and independent management. Ideal skills and experience for this role would include: - Advanced and proven experience in Pulover Macro, AHK and VBA - Proficiency in automating tasks in Microsoft Excel, as well as working with Sharepoint, Microsoft Teams and Email - Excell...
I'm seeking a skilled Drupal expert to help me to export form submissions from the Drupal website to csv More details will share I can able to download as json file. I can able to download as yml file. But only CSV is blocking. So iwant CSV export web form Ideal Skills and Experience: - Proficient in Drupal CMS - Prior experience setting up content management systems - Ability to tailor CMS systems to specific business needs - Good communication skills to ensure our team can effectively use the CMS.
Example link: I require the capture/extraction of 84x numerical values (table comprises of twelve events, seven results p...PDF file as quoted above. There will be 1,000s of unique PDF's, so my guess is I'd copy/paste relevant addresses into an Excel file and a Python script would run from there (?). To my knowledge, PDF file is always four pages in length, relevant table to scrape is always located on page2. Required data is always located in the same position/same column in PDF files. (Possible) example output in CSV/Excel could look like: date | 1H | 21,114,900 | 291,000 | 719,400 | 119,200 | 71,000 | 17,900 | 12,600 That output line (above) would have twelve lines of data per daily PDF file (1H, 2H, 3H etc)
...customer segmentation strategies. As such, the project will require a deep understanding of customer behavior and sales patterns. - **Data Type**: The data provided for this project is structured, primarily in Excel and CSV files. Your ability to effectively manipulate and analyze this data will be crucial. Ideal Skills and Experience: - Proficiency in Azure and strong experience in running ML models on the platform - Proven track record in customer segmentation and sales data analysis - Ability to work with and manipulate structured data effectively, particularly in Excel and CSV formats I'm looking for someone with a solid understanding of sales data and a keen eye for customer segmentation. If you're confident in your ML skills and Azure proficiency, I'...
I am seeking a highly skilled freelancer to undertake a multifaceted project involving the detailed completion and enhancement of a CSV file for upload to Square. This extensive project requires three core competencies: meticulous data extraction from our website, proficient data entry into an Excel form, and the creation of engaging service descriptions using AI tools. The ultimate goal is to craft a CSV file that not only meets but exceeds the requirements for Square's platform, ensuring a seamless upload process. Key Responsibilities: Data Extraction and Accuracy: Initiate the project by extracting data from specific sections of our website. This data must be accurately transcribed into an Excel form, adhering closely to the required fields. Attention to detail is p...
I am looking for a skilled freelancer, adept in ETL (Extract, Transform, Load) operations. In this project, your task will be to extract CSV files from an SFTP server and load them onto a SharePoint Document Library. Key responsibilities: - Source the data from the SFTP server. - Ensure accurate and smooth extraction of CSV files. - Successful Load of the data to SharePoint Document Library. Ideal candidate skills and experience: - Solid background in ETL operations. - Prior experience with SFTP servers. - Proficiency with working CSV files. - Familiarity with SharePoint Document Library.
I'm urgently looking for a web scraping expert who can help me gather information from various medical service p...names, contact information, medical service details, and additional data such as phone numbers, specialties, and participating plans. - The information should be pulled from three specific websites - Website 1, Website 2, and Website 3. Your deliverable: - The scraped data should be compiled into a CSV format for easy analysis and integration into our system. Ideal Skills: - Proficient in web scraping and data extraction - Advanced knowledge in handling and exporting data formats like CSV - Experience in scraping medical websites or similar domains would be a plus. Please bid only if you can start immediately and provide a quick turnaround on this urge...
You are asked to create an Excel file (FILE A) that: 1) Automatically extract data from another Excel file (FILE B) which is located in an FTP folder and which is updated every day. 2) The FILE A must extrapolate the data from the FILE B based on some filters that can be set or changed. For example, a filter could be the Brand or the Price. 3) The output (FILE C) of FILE A must be a .CSV file composed of 3 columns: SKU, Quantity and Price. 4) The final part is that this FILE C is saved inside another FTP folder. This entire 1+2+3+4 process must be done automatically every day at a certain time without the intervention of an operator.
I'm in search of a skilled machine learning developer with expertise in GPT (Generative Pre-trained Transformer). My goal is to have an AI model that can both correct and standardize postal addresses. The addresses will be provided in CSV files and the output of the model should be accessible via an API for integration into our system. Key requirements: - Proficiency in machine learning with a focus on GPT - Experience in addressing data correction and standardization - Ability to work with CSV files - Familiarity with API integration - Strong communication skills for seamless collaboration The ideal candidate will have a proven track record of developing AI models, particularly in the realm of addressing data, and be able to provide a detailed timeline for the complet...
...air pollution modelling using RStudio. The primary tasks for this project include: - Data Collection & Analysis: I need help in collecting relevant data on air pollution and subsequently analyzing it. - Result Visualization & Interpretation: After the data analysis, I require support in visualizing the results and interpreting them. The data that will be provided to you for this task will be in CSV format. Therefore, you should be well-versed in handling and analyzing data in this format. The ideal candidate for this task should have a strong background in data analysis, particularly in the context of environmental science or air pollution. Proficiency in RStudio is a must, as this is the primary tool that will be used for the modelling activities. Your role in thi...
As a client, I'm seeking a seasoned data analyst with expertise in data science who can thoroughly clean, preprocess, and visualize a dataset sourced from CSV files. The chosen candidate: - Should first start with cleaning and preprocessing the data to create a reliable foundation for analysis. - Should then interpret and present that same data through meaningful visuals to explore its intricate properties and characteristics. - Should additionally facilitate statistical analysis to derive patterns and trends otherwise invisible to the naked eye. The hoped-for end-product of this project is not just predictive analytics but insight and data-driven recommendations that will inform future decision-making. Proficient use of Python or R for these tasks is essential, as is familia...
I'm seeking a skilled Drupal expert to help me to export form submissions from the Drupal website to csv More details will share - Implement a user-friendly CMS system with Drupal - Ensure the system is easy to navigate for non-technical staff - Customise the CMS to suit our business needs Ideal Skills and Experience: - Proficient in Drupal CMS - Prior experience setting up content management systems - Ability to tailor CMS systems to specific business needs - Good communication skills to ensure our team can effectively use the CMS.
I need a wide range of details about accommodations on , downloaded for analytical purposes. This data should include r...data should include room availability, pricing, customer reviews, accommodation rate variances, photos, addresses, and phone numbers. - Essential Skills and Experience: 1. A strong understanding of web scraping tactics and data extraction. 2. Proficiency with 's platform and data structures. 3. Data organizing skills to deliver finalized data in CSV format. The outcome I envision is a well-organized CSV file that can further my research and analysis goals. A successful delivery will require attention to detail to ensure all requested information is included. Please bring forward your innovative solutions and reliable data handling methods.
I'm looking for an expert in VBA and macros to help streamline my processes in Excel. Key Requirements: Shifts: Defined two shifts in the "task tap": Morning: 6:00 to 15:30 Afternoon: 14:00 to 22:30 Quality: Updated the agreed-upon columns in the "quality tap." And remove the error code if there is no any number Delays: Ensured delays are reflected as discussed. Task Order: Arranged tasks in the "task tap" from oldest to newest. Please review the file and let me know if you have any questions or require further changes. Requirements: 1- Required an option in this file (Excel) that when the planner change the completion date of any task in column K in the TASKS tap, the color of the cell will be changed to yellow, and a not...
The project involves: 1. Go to an FTP location and get the last 10 csv files. Input example attached as '' 2. Combine those newest 10 files and map to new structure. Mapping example attached as '' 3. Save new file as 'BooksRunImport YYYY-MM-DD ", place in production folder "C:LakesideBooksClientDownloads" as tab delimited .txt, with an additional copy in folder as a backup. Output example attached as '' I would prefer it be written in NodeJS and compatable with v14.16.1 as I am familiar with how to edit the structure and I have other similar scripts running. I will supply FTP location and login as well as folder locations.
I'm looking for a skilled developer to create a one-time scraper for the TruePeopleSearch website. The scraper should focus on extracting addresses and phone numbers, and the output should be in CSV format. Key Requirements: - Develop a scraper for TruePeopleSearch - Extract addresses and phone numbers - Output the data in CSV format Ideal skills and experience for this project: - Proficient in web scraping - Experience with scraping tools and techniques - Proficient in CSV formatting - Understanding of data extraction from websites
...entry freelancer to assist me with an online data migration project. Key Tasks: - The primary task will involve accurately and efficiently transferring data from Excel/CSV files into an online database. - Ensure data integrity and make necessary corrections where needed. Ideal Candidate: - Proficiency in working with online databases and Excel/CSV files. - Attention to detail and accuracy is crucial. - Prior experience handling data migration tasks, preferably in a similar context. - Familiarity with data verification practices. The end goal of this project is to successfully migrate all the data from the provided Excel/CSV files into the online database without any loss or corruption. A successful freelancer will have the ability to work independently, follow ...
Urgently seeking a proficient Microsoft Excel user to help input a mix of numeric and text data into a CSV file. Your skills and experience should encompass: - Mastery of Microsoft Excel - Wide-ranging background in data input - Solid understanding of CSV files - Ability to work quickly and accurately The project is immediate and time-sensitive. Appreciate your prompt attention and swift action. Looking forward to your bids.
If someone is looking for the capacity to enter between 300 and 1000 products, you can use a CSV archive or a manual form. If you propose a catalogue, the objective is to increase the price of each product by 35%, regardless of the initial cost. Also, you need to find quality images for each product and adjust them to a resolution of 500x500 pixels. Similarity, you should add videos for some products. The remuneration offered is 10 Dominican pesos for each combined product. The type of exchange can be consulted to obtain the equivalence on other days. It is important to note that the 35% increase is applied to the purchase price, which means that the selling price will be 35% higher than the original price. Please ensure you explain this point clearly."
I'm in need of an experienced Excel professional to help me build a secure data management system. This system will be used to handle both financial and customer information. Key Requirements: - **Data Security**: A robust system that...customer data. - **User Management**: The system should be designed for 1-10 users, allowing them to access and input data securely. - **User Experience**: While the users are expected to have advanced Excel skills, the system should be designed with clear interfaces and user-friendly features. Ideal Candidate: - Proven experience in designing secure data management systems in Excel - Proficiency in VBA and Excel's advanced features - Strong understanding of data security and privacy - Excellent communication skills to understand and mee...
...an efficient solution regarding data transfers for my HubSpot account. This task requires: - A Zapier workflow configured to transport data from an automated CSV file to my HubSpot account, executed twice daily, ensuring timely and regular data updates - Fine-tuning of the data transfer to include only specific columns from the CSV file, ensuring that only relevant data is procured - Arrangement of the data in the same sequence as it appears in the source CSV file, ensuring a smooth correlation between sources and easing the tracking process All applications are welcome, however, familiarity with Zapier, data transfer protocols, CSV manipulation, and a sound grasp over data continuity would be considered peak assets for this task. If you could get on this i...
I'm looking for an experienced VBA coder who can focus on two main tasks. 1. **Fixing Existing Issues:** - My current VBA code has issues with execution errors and incorrect results. I need solutions to these two problems. 2. **Adding Modifications:** - I'm looking for someone who can add additional features to my existing VBA code. - Good user experience is important too so improvements on the user interface would be very beneficial. Ideal candidates will have an excellent understanding of VBA syntax, debugging, and error handling. Experience with user interface design is also appreciated. The aim here is to produce accurate calculations, formatted data or reports swiftly and easily.
Hello, I am seeking an experienced JavaScript developer with expertise in CesiumJS to optimize an existing aviation visualization project. The application is built using HTML, JavaScript, and CesiumJS, and is designed to display flight data from CSV files in a 3D environment. We have already implemented the capability to handle formation flights and a top-down view of multiple aircraft. However, I need assistance in improving the frame rate and optimizing the updateFlightView function. Project Requirements: -Frame Rate Optimization: Enhance the application to ensure a stable frame rate of over 30 FPS, particularly when visualizing multiple aircraft in formation. -Optimization of Existing Features: The current implementation of formation flights and the top view visualization need...
I am in need of a s...images. - Update Frequency: I require the data to be updated once. This means that the scraper should be designed to pull the data once and not re-visit for updates. - Data Format: The extracted data should be saved in a CSV file. This is the preferred format for the end result of the scraping process. Ideal Skills and Experience: - Proficiency in Python: A strong background in Python programming is essential. - Web Scraping Experience: Previous experience with web scraping tools and techniques is highly desired. - Data Handling: Knowledge of how to handle and store data in CSV format. - Attention to Detail: The ability to make sure that the scraper is collecting all necessary data accurately. - Time Management: The capacity to complete the project in...
I need a freelancer to enter numeric data into Excel from digital sources. Key Requirements: - Proficient in data entry - Expertise in working with Excel - Attention to detail The task is straightforward and simply requires the accurate transfer of numeric information into a pre-existing Excel template. I will provide the data in digital format (Excel, CSV) and expect it to be entered systematically according to the format provided.
I'm looking to hire someone who can create an Excel VBA workbook to seamlessly integrate with my Zoho Desk setup. This workbook should be specifically engineered to perform the following: - Retrieve the required information from Zoho Desk tickets upon pressing a button inside Excel. Specifically, I need someone skilled in Excel VBA programming and API integration work to: - Design a user-friendly interface in the workbook where one can press a button to initiate the retrieval of ticket information. You should be able to retrieve the latest ticket, and then have two more buttons to go to next & previous tickets. - Implement secure API connections to Zoho Desk to enable the retrieval of ticket information usuing oauth. The fields I need are: Subject Account Name: C...
Urgently seeking a proficient Microsoft Excel user to help input a mix of numeric and text data into a CSV file. Your skills and experience should encompass: - Mastery of Microsoft Excel - Wide-ranging background in data input - Solid understanding of CSV files - Ability to work quickly and accurately The project is immediate and time-sensitive. Appreciate your prompt attention and swift action. Looking forward to your bids.
I'm seeking a proficient Excel VBA coder to create a system that automates data entry from Excel files. The task involves: - Creating a VBA function that can input data automatically into my current system. - Implementing a data sorting feature as part of the data entry process to ensure that all data is easily read and interpreted. The ideal freelancer should have the following skills and experience: - Proficiency in Excel VBA - Experience with automated data entry - A solid understanding of data sorting techniques. This project requires precision and attention to detail. It should not only meet the needs listed above but also enhance data accuracy and save time.
...informations See for the actual webshop Language: main language English, other languages needed: German, Italian, Spanish, Portuguese, French, Arabic Reworking of product pictures for to have same appearance of background color Currencies: Euro and USD Shipping global (within EU with various VAT options of the delivery address country, shipping outside EU VAT free) Import products from csv file (about 1500) -reformat description Rework product pictures with uniform background (white) Required plugins (e.g. custom programmed if not available already): Engraving (customization) of our products, visible on the product during purchasing process Up to 3 lines engraving of product visible on the product during the purchasing process. (all available fonts to choose from) Possibili...
I'm seeking an experienced Excel VBA expert to help me automate some basic, repetitive data entry and formatting tasks. Key Requirements: - Automate basic data entry and formatting tasks in Excel - Develop VBA script to ensure automation runs smoothly Ideal Skills and Experience: - Proven experience in developing VBA scripts for Excel - Strong understanding of Excel functions and data formatting - Ability to create automation systems that run seamlessly without user interaction Please note, no user interaction is required for this project. The VBA program should be designed to run automatically once set up. This task is relatively simple but needs to be executed precisely and efficiently. Looking forward to working with a professional who can deliver ...
I'm seeking an expert in Excel and VBA who can work on an an existing financial model. The primary tasks will involve optimizing formulas, macros, and implementing data validation. I am looking for an hourly regular working engagement where the person will sit with me from time to time online and solve for things one at a time. I cant share workbooks as I have some IP related restrictions so person will have to work on my system, remotely. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs
...automating the transfer of information between those departments: linking the data, defining "trigger" events, and processing data from various inputs into "smart" trackers. I have a clear outline of what I want to accomplish - what data I need, who I need it from, and how I want the tracking of the inputs to function. My "coding" ability is a limited working-knowledge of JavaScript PDF and Excel VBA. I need someone to provide council and advise on what is possible, what tools or platform would be best for the end product I want to develop, and to advise on any alternatives. Basically, I am in the early stages of a long development process and I need an expert coder to review my outline and provide advise for the best way to accomplish what I want. ...
We are seeking an experienced developer to integrate OpenAI GPT into our existing database system (Zoho CRM) to enable natural language queries for investor searches. Users on our website will describe their company and transaction details, and the GPT will summarize and request additional information. Based on this, the GPT will score investors using a customizable algorithm and provide a CSV list of the top 100 matches. Users interested in further details must sign an NDA and fee agreement via an automated system, with their information and preferences automatically transferred to our CRM database. Key Project Details: User Interaction on Company Website: Users will describe their company and transaction details on our website using natural language queries. The GPT will genera...
I want a script that allows me to export a Zencart catalog () to CSV in real-time with the following fields: Title Short description Category (x, y, z) Description Image URLs (URL1, URL2, URL3) Price Stock
I am looking for a developer who can design a data uploader for my website. The primary purpose of this tool is to allow me to upload different types of files such as Excel spreadsheets, CSV files and Text files into my website's backend. Key Requirements: - Support for multiple file types: The uploader should be able to accept a variety of file formats, including Excel spreadsheets, CSV files, and Text files. - Basic Data Validation: Before the data is uploaded, I need this tool to perform basic data validation. This would involve checking for field completeness to ensure that all necessary fields are populated before the upload is allowed. Ideal Skills and Experience: - Proficiency in web development: The ideal candidate should have a strong background in web develo...
Please start your proposal by saying "hello MBA student" I am looking for a skilled data scraper who can efficiently extract specific data from a football website (). and one more for average age of squad. Extraction will need to go CSV Key Tasks: - Extracting 'Average Age of Squad' information - Extracting 'Net Spend' data Ideal Skills: - Proficiency in data scraping - Understanding of football statistics - Experience with similar projects or websites is a plus I trust your expertise to advise if additional information is needed for successful execution. Experience and accurate, meticulous work is what this project calls for.
I require a VBA Developer well-versed in automating repetitive tasks in Microsoft Excel. Your primary task is to automate my existing work functions to increase efficiency. Key Responsibilities: * Understand the current Excel operations and identify scope for improvement. * Develop VBA codes to automate basic standard operations. * Test the robustness and accuracy of the automation. * Combining 2 files into 1 pdf. 1st file is pdf and 2nd is excel(with selected sheets, and selected columns within sheets) Desired Skills & Experience: * Proficient in VBA, specifically for Microsoft Excel. * Experience in automating repetitive tasks. * Sharp problem-solving and debugging skills.
Seeking a proficient Excel VBA developer to aid in the centralization and automation of tasks in Excel 2010. Project requirements include: - Expertise in Excel latest version - Strong understanding of EXCEL VBA for automation purposes. Please note, specific tasks and functions to be automated in VBA have yet to be defined. Flexibility and broad knowledge in different Excel functions will be considered an asset.
Urgently seeking a proficient Microsoft Excel user to help input a mix of numeric and text data into a CSV file. Your skills and experience should encompass: - Mastery of Microsoft Excel - Wide-ranging background in data input - Solid understanding of CSV files - Ability to work quickly and accurately The project is immediate and time-sensitive. Appreciate your prompt attention and swift action. Looking forward to your bids.
...essential to be an expert. Anyone with generic database experience (with different databases) can also apply. Skills already acquired from previously doing this work: - Understand database schema - understand database structures - create database tables based on bespoke requirements (training included) - Working with relatively large sets of data - has exporting skills into SQL - Excel and VBA, - Has experience in different querying languages - Proficient in Microsoft SQL Server Management Studio - Familiarity with Windows OS - Experience in handling multiple databases with SQL - Strong troubleshooting skills I currently manage over 11 databases via Microsoft SQL Server Management Studio, and my system operates on Windows. You would be working an 8hr paid day in the Austr...
I'm seeking an expert in Excel and VBA who can work on an an existing financial model. The primary tasks will involve optimizing formulas, macros, and implementing data validation. I am looking for an hourly regular working engagement where the person will sit with me from time to time online and solve for things one at a time. I cant share workbooks as I have some IP related restrictions so person will have to work on my system, remotely. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs
Hi, I'm looking for someone who can write script to automate daily data importing from csv files into a google sheet. We use a new google sheet each week to calculate production for each day, see example here: We have two online platforms that we receive orders through, one for wholesale customers and another for retail customers. For wholesale we use Ordermentum - www.ordermentum.com. To access the production reports we have to: 1. Open the "orders" page 2. Select the relevant delivery date 3. Export the production report for that date This data needs to populate into the relevant date column of the "ORDERMENTUM" tab in the google sheet. See sample production report attached (produc
I'm currently seeking a WooCommerce expert to assist with product management on my online store. The job involves: - Importing products: I have a 2x CSV file with new products that need to be added into my WooCommerce store and set up wpallimport. I have wpallimport licence. - Updating products: Some existing products on the store need to have their details revised to match the new information in the CSV file. The ideal freelancer must have experience with WooCommerce, and should have previously handled similar tasks. I need someone who can complete the job efficiently and accurately. Your familiarity with CSV format and how it can be used to update and add products in WooCommerce is crucial.
