Csv txt vba jobs

Please Sign Up or Login to see details.

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.

...good we have plenty of GMB work done. If you have citations local for Ireland great mention how many we got (we have easily get 50+ from bright local albeit some not Ireland based but are relevant ie High level directories etc that world wide). Don't waste our time if can't speak good english and must put LOCALSEOIRELAND at top of your bid so we know you read this. We want seo expert to fix robot txt issues, on page high level issues. Then we will moving to great optimised URL strucutre for local seo and national seo to link up to for LOCAL using schema to GMB. Ideal skills for this project include: - Extensive experience in on-page SEO audits and implementation. - A solid understanding of local SEO best practices and techniques. - Proficiency in working with schema ma...

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.

I'm looking for a freelancer who can do .exe app to create a "VPN" on my personal Windows computer. Your task will include creating a tunnel connection to the IP Proxies that I have previously verified. I´ll load IP:port list in txt format and this "VPN" must ping current connection every 1 or 2 seconds to see if still working/connected. If it disconnect, same time "VPN" will try next IP:port from list. Key Requirements: - Familiarity with Windows operating system. - Understanding of basic security VPN setups using standard encryption protocols. Ideal Experience: - Proven track record working with VPNs on a Windows platform. - Experience with IP Proxies. - Understanding of standard encryption protocols in setting up VPNs. Main Purpose ...

I need a knowledgeable Excel VBA specialist, with a background in data manipulation and analysis, to create a custom macro for my spreadsheet. - The macro's primary function is to automate the creation of new rows based on certain numeric values, namely the ones found in columns E to L on a specific sheet in the workbook. - Upon row creation, data from columns A to D should be copied over to the corresponding new row on another sheet. - Additionally, the macro should automate the assignment of values in cells from L to Q based on the count of numbers in rows created. The assignment of values is to be done using a simple addition or subtraction formula. The ideal freelancer should have solid experience in creating advanced Excel VBA macros, and a strong understanding...

...experienced MS Access developer to assist with my form development tasks. The ideal candidate is proficient in VBA (Visual Basic for Applications) coding and has the ability to design and implement forms based on my specifications. Key Responsibilities: - Designing and developing database structures based on my project requirements - Implementing VBA code for basic functionalities such as form submissions and data entry automation - Creating forms in MS Access based on a specific design I have in mind - Ensuring the database and forms meet quality standards and are user-friendly Ideal Skills and Experience: - Proven experience in database design and development using MS Access - Proficiency in VBA coding, particularly for basic functionalities - Previous experienc...

I am interested in creating an Excel VBA macro that will allow me to import PDF invoices into line items and parse them. The objective of this project is to streamline the process of invoice data entry by automating the extraction of key information from incoming PDF invoices, namely Invoice number, Vendor name, Pricelist, and Detail. The successful freelancer for this project should have: - Demonstrated experience in creating VBA macros for Excel - A strong understanding of PDF parsing and data importation - Knowledge of accounting principles is a plus The imported data should ideally be formatted in Excel as: - Each PDF invoice should be translated into a single row - The extracted information should be available in separate columns for each piece of information.

I am looking for an expert to automate my daily incremental SQL scripting to extract multiple tables from my ERP system, and export them to CSV files. Key Requirements: - The system in question is Progress/OpenEdge. - The extraction should include tables such as Customers, Orders, Products, General Ledger detail, Job Costs, Invoicing, and Budgets. - The script should be set to run on a daily basis. I need a freelancer who: - Has a strong grasp of Progress/OpenEdge. - Has experience with automated SQL scripting. - Can efficiently export data to CSV files.

Bigcommerce CSV Format Fix Bigcommerce CSV Format Fix

...SCRAPE THE DATA. PYTHON SCRAPPER DON'T NEED I'm in need of a VBA developer who can help in creating a small code for scraping contact details from a specific website. The task involves creating a button in an Excel file that triggers the scraping process and saves the extracted data back into the same Excel file. Note : Project budget is only 6k because it will take max 2-3 hour for experience developer Key Requirements: - Scrape contact details from - Specifically, scrape Owner Name & Address - Implement a function where a user clicking a button triggers the scraping process - Save the extracted data back into the same Excel file Ideal Skills & Experience: - Proficient in VBA programming - Experience with web scraping - Familiarity with

We require a specialist Excel developer capable of designing an ERP worksheet that can facilitate efficient inventory management. Notably, this will be identified through its ability to: - Track product movements (Received from Dock, Moved to Location, Picked, RTS) - Forecast demand accurately - Calculate reorder points precisely (Flag Products that are low in stock) - Distr...Sequens is Location, Part, QTY) - Ensure daily inventory updates are possible (Inventory has to be LIVE) - Add a dashboard for visual view of KPI's and results The ideal candidate will have proven experience in ERP Excel design, particularly within the field of inventory management. Expertise in IR Scanning layout will be strongly favored. Knowledge needed. - Excel Formula Mastery - Pivots Tables - VBA...

I'm in need of a proficient PowerBI analyst who can effectively connect to different data sources: Excel spreadsheets, SQL database, and CSV files. Your tasks involve creating detailed reports and conducting: - Sales performance analysis - Financial dashboards - Customer segmentation I have a preference for Bar and Pie charts in the visualization of these reports. Ideal applicants should have valuable experience in these fields and have an innate knack for making data comprehensible. Excellence in the mentioned chart formats is paramount. Having a solid background in Excel, SQL and CSV data manipulation will be a plus.

I need a Python developer who can create an automated IME barcode system. The system should handle bulk entries ...can create an automated IME barcode system. The system should handle bulk entries and generate images. Barcode experience is essential for this project. Key Requirements: - Handling of Code 128 and IMEI barcode types - Generating barcode images in PNG format - Capability to handle bulk entries, preferably through CSV file uploads The ideal candidate should have: - Proficiency in Python - Experience with barcode generation and handling of bulk data - Familiarity with handling CSV files in Python This project is suited for someone who is detail-oriented and has a strong understanding of automation and barcode systems. Please apply if you have the required skill...

I'm in need of an intermediate level automated meeting minutes solution on Excel 2016. This project requires expertise in Excel and VBA and knowledge of data categorization. Key requirements include: - **Template Generation**: The tool should be able to generate a meeting minutes template automatically. - **Categorization**: Information in the meeting minutes should be categorized by attendee. Date Task owners Points discussed New Ideas generation' related System Process People Technology others Ideal skill set for this project includes: - Proficiency in Excel, particularly Excel 2016 - Experience in VBA/Macros for Excel - Previous work with data categorization and template generation Looking for someone who can deliver a robust, user-friendly solution that s...

When importing customers via CSV file in ASTPP version 6.0, both postpaid and prepaid customers balance always uploads 0. The task is to find the corresponding php file/path on the server and correct it, so that the balance uploads correctly when uploading the customers on the ASTPP both for prepaid and postpaid customers. Positive balance must upload as positive balance. Negative balance must upload correspondingly. 0 uploads 0. You need to make a detailed document how to do that on any ASTPP server, so that someone without technical knowledge takes the document, follows it and gets the same working on the other ASTPP server. Example of the document: Someone from our side will try to upload customers on the provided server to make

Please Sign Up or Login to see details.

I am seeking a technically proficient freelancer to help streamline the process of importing products - including their names, descriptions, and prices - from Shoptet (XML format) t...to help streamline the process of importing products - including their names, descriptions, and prices - from Shoptet (XML format) to our current Shopify site. The project will also entail exporting data (comprising of product name, SKU, price, descriptions, image URLs, category, and quantity) from the website in CSV format. Key tasks include: - Mapping shoptet fields to those on Shopify to facilitate a seamless bulk import. Ideal Freelancer Profile: * Proficiency in XML and CSV formats * Expertise with Shopify's data organization * Experience with Shoptet data handling * Mastery of da...

I just need a list of employees from Linkedin Recruiter.. I will get in a google-meet or zoom meet with you, and I give instructions. _We ne...or zoom meet with you, and I give instructions. _We need to find the list of 'Open to Work' People from a particular Company in India. The reason for doing that is, We want to look for employees, who are considering Job switch from this company. _we will together log into your Linkedin Recruiter account _We will look for 'open to work' candidates _we will export the list (around 313 people) in CSV or Excel or PDF format. _If exporting the list is costly, in that case, I will simply take screenshots of the List (of candidates), and will later convert that into excel sheet. **The Task will take maximum of 10-15 minute ...

I am seeking a proficient specialist in Excel 2010, with extensive experience in the creation of VBA Macros, designing data entry sheets, automating tasks, and generating reports. Key responsibilities include: - Design and develop efficient VBA Macros - Design accessible and streamlined data entry sheets - Automate various Excel tasks for increased productivity - Generate comprehensive and insightful reports Ideally, you have advanced knowledge of Excel and VBA Macro programming, demonstrating a proven track record in dealing with complex Excel projects. A strong understanding of spreadsheet automation and report generation is fundamental to execute this project successfully.

Please Sign Up or Login to see details.

I'm in need of an experienced PowerShell script writer, specifically for Power BI associated data management tasks. As part of the project, code will be required to execute the following tasks: - Data extr...in need of an experienced PowerShell script writer, specifically for Power BI associated data management tasks. As part of the project, code will be required to execute the following tasks: - Data extraction from Excel files, CSV files, and SQL databases - Transformation of data, including extraction and update of parameter values from Data Models in each Workspace Ideally, the freelancer would carry a strong understanding and hands-on experience with PowerShell scripting, Power BI, data transformation techniques, and working with database source files like Excel, CSV...

I need a professional to scrape data from the URL provided and deliver the extracted details in a CSV format. - The specific data elements required are the agent name and phone number. The scraping process does not require any filters or search criteria as it's a one-time extraction. The data should be organised and easily readable in a CSV document for further analysis. Ideal skills for this project would include: - Proficient in web scraping with experience in extracting data from similar websites - Strong expertise in delivering data in structured formats (CSV, Excel) - Attention to detail to ensure accuracy in the extracted data

I require an experienced professional to obtain text and images from a blog and store them in a CSV file. The ideal candidate should: - Have experience in scraping content from websites - Be adept at data management, specifically CSV files - Be proficient in handling both texts and images and store in easy way to manage and retrieve A strong track record of similar projects will be a plus. This job requires accuracy and attention to detail. I look forward to seeing your bids.

I'm looking for an Ex...from the NSE options chain. - Educational Focus: The content presented should be geared towards explaining the basic concepts of options trading in a clear and easy-to-understand manner. - Excel Proficiency: The ideal candidate should have a strong command over Excel and be able to integrate real-time data sources effectively. Ideal Skills and Experience: - Advanced Excel Skills: Proficiency in VBA and data connections is a must. - NSE Data Integration: Prior experience working with NSE data feeds would be advantageous. - Educational Content Creation: Experience in simplifying complex financial concepts into easily digestible content would be a plus. Looking forward to working with a professional who can deliver a top-notch, educational Excel NSE opt...

I'm in need of an Excel expert who can help me automate data entry and formatting tasks. I also need assistance in creating a macro to generate daily status reports. Key Tasks: - Automate data entry tasks - Automate formatting tasks - Create a daily status report macro Requirements: - Proficiency in Excel and VBA macro creation - Experience in automating data entry and formatting - Previous history of generating reports using VBA - Strong communication skills and ability to understand and translate my requirements efficiently.

...various types of media files. The ideal freelancer for this project would have a solid understanding of Python, machine learning, NLP, and experience with BERT models. Features of the Python Script: - Process text queries obtained from a CSV file (example CSV attached) - Detect entities such as: - Persons - Places - Events (e.g., weddings) - Dates - Number of individuals visible - Media type (Image, Video, Audio, Text) - Detailed type (Interview, Landscape, Close Up, Group, etc.) - Length - Content - Retraining should be based on a provided CSV file containing Sentence, Entity, and IOB Tagging training data. The model does not need to be trained - only provide the capability. I am looking for a detailed and accurate script that can efficiently...

I need a skilled Excel VBA Macro expert to develop a VBA macro that can automate reports, specifically with numerical data. Your task will revolve mainly around creating a function that streamlines the reporting process, making it efficient and error-free. Ideal Skills: - Extensive knowledge in Excel VBA - Strong background in automated reporting using Excel - Familiarity with handling numerical data Experience required: - Prior experience developing Excel VBA macros - Proven track record in creating automated reports .

I need a skilled Prestashop 1.7 expert for my project. I am specifically interested in customizing my product catalog. The main task will be: I need to add Display Condition on Product Page by default i use csv. I need to add extra product condition thats it 2 small works

...program to upload and save attachments Description: I created a program that uses HTML, CSS, and Javascript to enable patients to fill out their information, including the option to attach files. Upon submission, a PHP script is triggered to email the data to me as a CSV file. The attachments (typically JPEG’s or PDF’s) uploaded by the patients are not being included in the email. Objective: Adjust program to upload and transmit attachments with .csv Deliverables: - Updated program with ability to transmit attachments in csv - Documentation of all changes with code (unrestricted) - Format attachments as: o Insurance-patient’s last name-patient’s first name o ID- patient’s last name-patient’s first name Attachments: The HTML,...

i need menus extracted from a webpage the most important columns (data points) will be category name product name, product price, product description.

I need a professional to scrape specific details from a website directory for a one-time project. - Specifics: The data of interest includes the company names, their URLs, and their expertise. This information is laid out in rows on the website. - I wish for the freelancer to carefully extract this data, ensuring no errors or omissions are made. - The final output is essential to be in a CSV file format. I require this scraping to be done just once, and I do not foresee a need for ongoing scraping after this initial task. As the data is crucial for my business development, I am seeking someone who can deliver accurate and complete results in a timely fashion. Prior experience with web scraping and proficiency in data management are highly desirable.

I need a PowerBI specialist for uninterrupted data extraction, processing, and visualization for our existing business operations. I expect you to be proficient in dealing with CSV files, Microsoft Excel, and Tally, as these are the main data sources in our operation. Core responsibilities will be: - Setting up PowerBI to pull data from these sources - Creating meaningful data visualizations that help us make informed business decisions. While we're not yet sure how frequently we'll need data refreshes in PowerBI, you should be prepared to advise us on best practices based on our data volume and usage trends. Thus, familiarity with handling versatile data flow frequency is a must-have. Experience in similar projects and excellent communication skills will be hugely ben...

Please Sign Up or Login to see details.

I've been assigned the task of building a web application where users can input company names, and any public...initially explored utilizing an [API from ](), I encountered difficulties with downloading data or obtaining an API key, possibly due to issues with their website. but was able to find [this csv file on kaggle]() containing information of companies from 1857-2020. My initial approach is to use appwrite for backend and react for frontend. populate the appwrite db with information from the csv file. then build the react frontend. however I can't help but wonder that there must be an easier way to do this. How would you make this?

I'm looking for an Excel and VBA expert to help streamline my workflow and boost productivity. You'll be responsible for: - Automating repetitive tasks: I need you to develop efficient scripts that will handle routine operations in the spreadsheets, eliminating the need for manual intervention and enhancing the overall efficiency. - Crafting custom functions: The custom functions I require are complex and involve external data sources. Your role will involve creating these functions effectively, ensuring they are accurate and function seamlessly within the Excel environment. The ideal candidate will have extensive experience in Excel, VBA, and creating complex custom functions. Solid understanding of data analysis and automation is crucial for this role. Your mai...

✔Project Overview: We are seeking to develop a program that reads QR codes from multi-page PDF files and image files provided by our clients and extracts that data into CSV files. Due to format differences, existing AZURE OCR API have not met our requirements, necessitating a custom solution. ✔Specific Requirements: 1. Ability to read QR codes from multi-page PDF files, multiple PDF files, and image files such as JPGs and PNGs. 2. Capability to analyze the data within the QR codes and format it into CSV files. 3. Development must be done in either Python or JavaScript. ✔Skills Required: -Experience in development with Python or JavaScript. -Knowledge of OCR technologies and QR code reading techniques. -Experience in handling PDF and image processing. ✔Project Goals: The go...

Here is a list of zip files on a US Govt website. You must write a Python program that uses a network library to download each zip file on this site, then find each .csv file in the zip archive, and copy each .csv file in each zip archive to a hard drive directory on the local windows machine. The directory will be "C:/MedicareDownloadFiles". The files cover the years 2017 to 2024. You may not hardcode file names ... you must extract the filenames from the above https URL. The fee for this will be $30. You must have it done within 60 minutes. Thanks for participating!

Here is a list of zip files on a US Govt website. You must write a Python program that uses a network library to download each zip file on this site, then find each .csv file in the zip archive, and copy each .csv file in each zip archive to a hard drive directory on the local windows machine. The directory will be "C:/MedicareDownloadFiles". The files cover the years 2017 to 2024. The fee for this will be $30. You must have it done within 60 minutes. Thanks for participating!

My project requires the assistance of an experienced data analyst or data miner. I'm working on a market research project, which requires the extraction of text data from a specified website. Here are the specific details: - Task: Extracting text data from a website for data analy...experienced data analyst or data miner. I'm working on a market research project, which requires the extraction of text data from a specified website. Here are the specific details: - Task: Extracting text data from a website for data analysis - Output: All extracted text data should be provided in a CSV file Given the nature of this project, prior experience in web scraping, data extraction, or data mining is highly desirable. The ability to accurately extract data and transfer it into a ...

I'm urgently in need of a VBA expert to help tune an existing Word VBA that's not performing as expected. Even though it runs, it's not accomplishing the task it was meant for. Key objectives for this project are: - Identification and resolution of current issues with the VBA to align with its original purpose - Modification of the VBA to extract Word OLEs, while entirely bypassing PDF files (skipping them). The ideal freelancer for this task will have: - Extensive experience in VBA coding and troubleshooting - Experience with OLE extraction from Word - Proven track record in meeting deadlines. The timeline for this project is within a month. If you think you're the right fit for this project, I'd like to hear how you can hel...

...Generating CSV or Text files: The extracted data should be organized and formatted into CSV or TXT files. Each property in the system should have its own file containing the relevant data. - Uploading to FTP: The generated files should then be uploaded into our FTP as individual files for each property. Ideal Skills and Experience: - Proficiency in API integration: Prior experience with integrating various API’s is crucial for this task. Particularly, experience with Tehama, Cereniti, and Inovonics API’s would be highly beneficial (documentation for the reading systems in question is available for reference if you are not familiar). - Data handling expertise: Strong understanding of data processing and manipulation is necessary for organizing and for...