Excel vba import csv file into worksheetpráce
I am looking for an Excel professional who can assist me with implementing VLookup, HLookup, and X-Lookup functions in my spreadsheets. Key tasks include: - Implementing these lookup functions to streamline data analysis and financial report creation. - Assisting in the update of data across different sheets to ensure all reports are current. The primary report we need to generate is a product costing sheet. Ideal candidates should have: - Extensive experience with Microsoft Excel, particularly with lookup functions. - A strong understanding of financial reporting. - Excellent attention to detail and ability to work with complex data sets.
I'm seeking a Smartsheet professional who can help with automating data synchronization from Excel files into the platform. Ideal Skills and Experience: - Extensive knowledge of Smartsheet and its workflow automation features - Proficiency in Excel and understanding of data synchronization processes - Previous experience working on similar projects - Excellent problem-solving skills to troubleshoot any issues that may arise during the automation process - Ability to understand my specific needs and tailor the solution accordingly.
...Extraction: The AI should be able to extract 'Name' and 'Email' from Instagram, FaceBook, Ticktok, X, Youtube and compile this data into a CSV file. - Email Management: It should check for duplicate entries and manage email campaigns, sorting emails based on their status (with a focus on 'Opened'). It should have the ability to send emails in batches. - Extend data extraction capabilities to include LinkedIn, Twitter, and Pinterest. - Implement advanced filtering options to target specific demographics or interests. Ideal Skills: - Proficiency in AI development - Experience with data scraping - Understanding of email marketing systems - Ability to create and manage CSV files I'm looking for a professional who can deli...
I need help with a mail merge project. I have a Word document that needs to be populated with names and from an Excel file. And then I then I also need one for mailing labels or printing on envelopes. Ideal Skills: - Proficiency in Microsoft Word and Excel - Experience with mail merge - Attention to detail
I need info from a PDF file transferred into an Excel spreadsheet. The PDF is a membership directory. I only need members that are a "Presenting Organization" (which starts about half-way down the directory). I've attached the PDF and a blank xls file with headers to populate. Please provide a bid and an estimate of the numbers of members to be imported so I know you understand the scope.
...Automate Flow for Extracting Data from Wedding Agreement (Adobe Sign) and Updating Excel Hi, I need help in creating a Power Automate flow with the following requirements: Objective: The goal is to extract data from a completed wedding agreement (Adobe Sign) and add the relevant information into an existing Excel file. Depending on specific data in the agreement, I need the flow to either add one or two rows in the Excel file and update those rows with the extracted data. Key Steps: Trigger: When a wedding agreement workflow is successfully completed (signed), the flow should be triggered. Extract Data: Use the Get form field data action to extract the form data from the agreement (preferably in Excel or JSON format). Condition L...
I'm looking for a skilled photo editor who can seamlessly add me into a special event group photo. The background of the original image should remain unchanged, but I need to be inserted into the scene in a way that allows me to blend in naturally with the rest of the group. Key Requirements: - Proficient in Adobe Photoshop - Experience with photo manipulation and retouching - Ability to create realistic edits that are not noticeable - Keen eye for detail to ensure consistency in lighting, shadows, and perspective - Refine the edges of hair to avoid any visible cut-out lines. - Ability to match skin tones to ensure consistency with other group members. The final image should be in standard resolution. The final image should be in web resolution (72 dpi). The client w...
I'm seeking a freelancer to help me extract data from the Livescore app for all football matches over the weekend. The data should be organized into an Excel sheet with separate sheets for each match date. Ideal Skills: - Data Extraction - Excel Proficiency - Attention to Detail Please note, the specific leagues, tournaments, and data points to be extracted have not been determined yet. Therefore, flexibility and good communication skills will be vital for this project. A keen interest in football could also be an advantage. I need all this informations into Excel sheet please check image jointe
More details: Is this project for business or personal use? For an existing business What information should successful freelancers include in their application? Detailed project proposals How soon do you need your project completed? ASAP
Tenho umas tabelas de excel exportadas de um software para as quais precisava de criar Tabelas Dinâmicas e Dashbords para análise dos respectivos dados. Em resumo necessito de um freelancer para me esclarecer e ajudar a desenvolver uma forma de apresentar estes dados e poderem ser analisados por utilizadores muito básicos de excel.
I'm in need of an AI agent that can help me streamline my data extrac...Key Requirements: - Data Extraction: Primarily from Instagram, but also from other platforms like Facebook, TikTok, X, and YouTube. The AI should be capable of extracting 'Name' and 'Email', compiling this data into a CSV file. - Email Management: The AI should check for duplicate entries and manage email campaigns, sorting emails based on their status, with a focus on 'Opened'. It should have the ability to send emails in batches. Ideal Skills: - Proficiency in AI development - Experience with data scraping - Understanding of email marketing systems - Ability to create and manage CSV files I'm looking for a professional who can deliver a system that...
...platforms, not just social media sites but also blogs, forums, and public records and databases. - An exhaustive reach, covering 'everything that's out there'. - Specific tracking on all major social media platforms including Facebook, Twitter, Instagram, and more. - AI-powered analysis to identify and highlight patterns or connections in the gathered data. - Multiple data export options including CSV, PDF, and other formats for easy reporting. - Historical data retrieval to access information that has been deleted or altered. - User-friendly interface that allows investigators to easily navigate and use the software. - Cross-platform compatibility to ensure the tool works on different operating systems. - Anonymity features to conduct research without revealing th...
We are seeking someone to create a .thmx file for us to use across all Microsoft products. Will will use this as the standardizing format package for our business. OUTPUT GOAL Creation of a .thmx file SCOPE OF PROJECT Details: there may be more that goes into it, but my understanding is the 3 main pieces are: 1. Font selection (ideally one that works with online and desktop versions) -- we would love your help curating a few font choices that we can select between. We serve professional and corporate clients, so we'd want this to be easy to read, yet still crisp and not overly stuffy nor too informal 2. 10 theme colors (with gradients) -- I can share our website and the virtual background that we use for video calls. I imagine you might be able to extract a ...
I'm in need of a data entry specialist. The task involves transcribing customer information from paper documents into a database. Ideal skills and experience include: - Excellent attention to detail - Prior experience with data entry - Proficiency in database management - Ability to work independently and meet deadlines Key responsibilities: - Accurately transcribing customer information from paper documents - Ensuring all data is correctly entered into the database Your role is crucial in helping me organize and manage customer information effectively.
I need an SQL expert to help me export specific query results from my SQL database into a CSV file. - Database Type: SQL - Export Format: CSV - Data to Export: Custom query results Ideal skills and experience for the job: - Proficiency in SQL with experience in data extraction. - Familiarity with exporting data to CSV format. - Ability to understand and execute custom queries. - Attention to detail to ensure data is accurately exported. No additional data processing or transformation is required before exporting the data. The data needs to be exported at scheduled intervals. The data needs to be exported daily at scheduled intervals.
I'm looking for an Excel expert who can help me create a file that meets specific conditions. Here's the situation: - I have an Excel sheet with 4 columns: address (A), city (B), state (C), and zip code (D). I want in column E to automatically display the word "IMAGE". However, this word should function as a trigger: when hovering over it, a photo corresponding to the location will pop up as a note. This needs to work for every cell in that column. - There is address list - I need this to be done in an automated way. Requirements: 1. I want to be able to understand the solution, so I need you to explain it to me via video call. 2. I have experience with Excel but have hit a roadblock, so a fresh perspective is needed. 3. I don't need...
I have an excel sheet consisting of about 5000 lines and about 15 columns. The data is a bit random and requires advanced logic to organize. Due to company restrictions, I can't share the excel sheet directly, but I can provide snapshots and detailed descriptions of the tasks and formulas required. Key Responsibilities: - Utilize advanced Excel formula logic to sort data into specific categories. - Implement conditional calculations, data aggregation, and advanced filtering as per the project needs. Ideal Skills and Experience: - Proficiency in advanced Excel is a must. - Prior experience in data sorting and organization. - Strong analytical skills to understand and apply the required logic.
Dear [Client's Name], I am excited to apply for this data entry project. With experience in handling various data types, including text and numerical information, I can ensure accurate and efficient entry from Excel, Word, and PDF files into designated platforms. I have a strong eye for detail, excellent typing speed, and proficiency in Microsoft Office tools, ensuring high-quality and error-free data processing. My commitment to accuracy and efficiency makes me confident in delivering results that meet your expectations. I look forward to the opportunity to assist you. Let’s discuss how I can contribute to your project. Best regards, Wan Zakwan Fitri
I'm looking for someone to help me create a line chart in a spreadsheet to display comparable equipment data. This chart will need to compare more than 3 sets of data. Ideal Skills: - Proficiency in spreadsheet software (Excel, Google Sheets) - Experience in data visualization - Strong analytical skills - Attention to detail Please provide examples of similar work you have done in the past.
I have a set of last year's ticket sale data that needs to be entered into Excel. - Data Entry: The tickets are currently in Excel 10, and I need someone to accurately input all relevant data. - Excel Skills: Proficiency in Excel 10 is crucial, as the data will be entered into this software. - No Analysis Required: At this stage, I do not require any data analysis or reports generated from the entered data. However, a keen eye for detail will be beneficial to ensure accurate data entry.
I'm looking for a professional data entry expert to help me input mixed data from various digital files. Key Responsibilities: - Accurately enter mixed data (text and numerical) from various digital sources into designated platforms. - The data source will primarily consist of digital files such as Excel, Word, and PDF. - Ensure all data is entered correctly and efficiently. Ideal Skills and Experience: - Proven experience in data entry, particularly with mixed data types. - Proficiency in handling and navigating through Excel, Word, and PDF files. - Attention to detail and ability to maintain accuracy under pressure. - Excellent typing speed and computer skills.
THIS IS NOT AI GENRATED POST>>> PLEASE READ PROPERLY to APPLY IF YOU ARE CONFIDENT TO DO JOB Need quick help in Wordpress product migration from Non Wordpress site Concern: We are able to download product CSV file from Non Wordpress site but when we are uploading in our current wordpress development site which is not supporting. I hired scarpper also who scrapped product data from Non wordpress site and build custom CSV file for wordpress site, you need to validate and see if everything is good to import. if not then scrapper can also help you get desire CSV file. Need someone who already have experience in this and available immediate to start. Your expertise in this area is crucial for a smooth and swift transition. Thank ...
I'm looking for a professional with data scraping experience to help me export descriptions from active eBay listings. Key Requirements: - Extracting descriptions from various sellers' active listings on eBay - Exporting the data to a CSV file - Identifying listings by specific seller usernames Ideal Skills and Experience: - Proficient in data scraping tools and techniques - Familiarity with eBay's platform and its listing structure - Experience in creating and managing CSV files
Job Description: We are seeking an experienced Microsoft Excel specialist to develop a dynamic and automated spreadsheet to monitor the status of a loan contract. The spreadsheet should efficiently track loan payments, calculate interest, and provide a structured yearly overview of the loan’s status, including the available credit line. The final solution must be compatible with both Microsoft Excel for Windows and Microsoft Excel for Mac. Project Requirements: Input Data: Loan start and end date Interest rate (%) Maximum loan amount (credit limit) Loan payment records (date and amount) Core Calculations: Interest calculation for each loan payment Cumulative interest tracking Available credit line (credit limit minus utilized loan amount) Yearly Overview Section...
I need immediate help from an Excel expert to identify why my total on one financial sheet doesn't align with the revenue summary on another sheet. The task needs to be completed within 15 minutes. Ideal Skills: - Proficient in Excel - Quick analytical skills - Able to deliver under time pressure
I need a proficient Excel expert who can create a comprehensive profit and loss sheet for my agricultural business. Key Requirements: - The spreadsheet should be able to track profits and losses on an individual job basis. - The design of the sheet should be intuitive and user-friendly, with clear delineation of different sections. Ideal Skills: - Proficiency in Excel and data analysis. - Experience in creating financial tracking tools. - Understanding of the agriculture industry. Please provide a portfolio of similar projects you've completed, as well as any relevant industry experience.
I require assistance in entering numerical data sourced from various online platforms. The final output should be neatly organized in a database. Key Responsibilities: - Efficiently sourcing and entering numerical data from online sources into a database. - Ensuring accuracy and consistency in data entry. Ideal Skills and Experience: - Prior experience in data entry, particularly with numerical data. - Familiarity with online data sourcing. - Proficiency in handling databases. - Strong attention to detail and accuracy.
I need assistance with decoding a cache file. The cache file is in a binary format and contains metadata. The textual data within the cache file is encoded in UTF-8. Ideal freelancers for this project should have: - Proficiency in handling binary files - Experience with metadata analysis - Strong skills in UTF-8 data decoding
...and better structure their financial documents. Core business: Invoice centralization EcoBill offers an online platform where companies can easily store, organize and retrieve their invoices. Key features - Centralized invoice storage - Easy import via file or photo - Organization and tracking for improved accounting management - Fast, structured access to facilitate financial management Automation technology is being developed to improve invoice processing, including automatic document recognition (OCR) and other tools to facilitate invoice import and classification. EcoBill also offers a loyalty option that enables businesses to reward their customers. With this feature, when a customer makes a payment at a business that has chosen this option, they accumul...
Convert 30 pages handwriting in Excel. Convert 30 pages handwriting in Excel. Convert 30 pages handwriting in Excel. Convert 30 pages handwriting in Excel.
I have a spreadsheet that requires some help with data formatting, particularly with date and time entries. I need someone who can fix the incorrect date/time entries so that the spreadsheet is accurate and usable. Ideal skills for the job include: - Proficiency in Excel or similar spreadsheet software - Strong attention to detail - Experience with data formatting and troubleshooting
Need to extract all emails from magento mysql database file I have the file
I'm seeking a professional who can craft a compelling financial presentation for institutional investors, primarily aimed at securing investments. The presentation, approximately 20 pages in length, will need to be in French and include 5-7 pages of Excel sheets, featuring repetitive content. Key Aspects of the Project: - The most critical element of the presentation will be highlighting the company's growth potential. - The Excel sheets will be provided, so there will be no need for complex data analysis, but attention to detail and ability to present the data clearly will be essential. - Strong French language skills are a must, as is experience with financial presentations. Ideal Skills and Experience: - Proficiency in French, particularly in a business conte...
Need to analysis current select columns using ChatGPT API
Hello, I am wanting someone to review and fix my log viewer page on my automotive website. It needs to be able to accept uploaded files (such as a csv file with data in it) which will then display the results into a graph. Unfortunately this isn't fully functional and I require someone to fix the errors. I have attached a csv file for you to upload it into the website link above and see how it all works. There is a CSV file which gets created from a automotive software called RossTech. This CSV file contains data that gets logged from the car sensors. Every column is a different sensor. When uploading the CSV file into my log viewer page, it needs to translate from numbers to a graph. At the m...
I need someone to convert my InDesign file from version 20.0 to 18.0. The file contains both text and images. It's not clear if any custom fonts are used, but standard fonts are definitely present. All text styling can be simplified, as standard text styling is acceptable. Ideal skills and experience for the job: - Proficiency in Adobe InDesign - Experience with file version conversion - Attention to detail - Good understanding of text and image handling in InDesign Please exclude any custom fonts during the conversion.
I am a data analyst in need of assistance with creating a sales report in MS Excel. Ideal skills for this project: - Expertise in MS Excel - Strong data analysis skills - Experience in sales report creation Looking forward to your bids.
I'm looking for a skilled data scraper who can extract all available information from a specific e-commerce website. This includes, but is not limited to, product details, customer reviews, and pricing information. I need all available informati...to, product details, customer reviews, and pricing information. I need all available information. Please consider that there are also product variants. Work needs to be done today! The ideal candidate should: - Have a strong background in data scraping - Be proficient in using data extraction tools - Have experience dealing with e-commerce websites. The scraped data should be delivered in an Excel format. Please note, this is a one-time project, I do not require ongoing data scraping. If you read everything, please write "DA...
...models for retail businesses 1. Input Sheet – Costing Details This sheet will capture all cost elements associated with multiple SKUs (up to 10 items initially, with the flexibility to expand). The key components include: Product Details (Item Name, SKU, Category, Supplier, Country of Origin) Cost Elements: Ex-Works Price (Price per unit from manufacturer) Shipping Costs (Freight, customs duties, import taxes) Handling Costs (Loading/unloading, warehouse labor, packaging) Storage Costs (Warehousing rent, temperature control, security) Company Overheads (Fixed and variable overheads such as admin costs, sales team, operational expenses) Sales & Distribution Costs (Marketing, commissions, last-mile delivery, retailer margins) Minimum Order Quantity (MOQ) (As per manufac...
I need a skilled data analyst and visualization expert to create an interactive dashboard to track and analyze my online sales data. The dashboard should connect to a variety of data sources, primarily my sales database. Key Responsibilities: - Use complex parameters to drill down in the worksheet and customize using filters and slicers. - Create connections, join new tables, and perform calculations to manipulate data and enable user-driven parameters for visualizations. - Use different types of customized visualizations (bar chart, pie chart, donut chart, clustered bar chart, scatter chart, line chart, area chart, map, slicer, etc.) The primary purpose of this dashboard is to track sales performance. Therefore, it is crucial to include and highlight the following sales metrics: ...
? Job Advertisement: Developer Needed for Automated HTM to CSV Converter ( Data) ? ? Project Overview: I am looking for a skilled software developer to create an automated system that converts large HTM files (100MB+) into multiple CSV files (each under 8MB). This software will be installed locally on my laptop and should efficiently process backtest results for analysis. ? Key Requirements: ✅ Automated HTM to CSV Conversion – Extract structured data (trades, timestamps, profit/loss, balance, etc.). ✅ File Splitting Logic – Ensure each CSV file remains under 8MB while preserving data integrity. ✅ Standardized CSV Format – Make sure the output files are structured for easy merging and analysis. ✅ User-Friendly Interfa...
...marketing and content execution. Please ensure to track social media engagement as a key performance indicator. We are looking for candidates with mid-level experience. We are looking for entry-level candidates. The content should primarily be promotional. The company focuses on the technology sector. The primary goal for the digital marketing efforts is to increase brand awareness. Applicants should excel in content creation. Remote candidates are welcome to apply. educational products and services Expertise in social media management is highly preferred....
Clean home page: slider, attractive promotions, well-organised categories, no duplication. Footer with appropriate links, no words in English. Clean product and category pages (advanced filters, appropriate images). Optimised shopping basket and payment. Mass import of products via Excel file. ATUM confirmed for stock management. Delivery methods configured (zones and extensions). Site ready to inspire confidence and sell.
Clean home page: slider, attractive promotions, well-organised categories, no duplication. Footer with appropriate links, no words in English. Clean product and category pages (advanced filters, appropriate images). Optimised shopping basket and payment. Mass import of products via Excel file. ATUM confirmed for stock management. Delivery methods configured (zones and extensions). Site ready to inspire confidence and sell.
I'm seeking assistance in extracting numerical data from individual stock pages on a website and storing it in an Excel file in a specific format for multiple stocks. This needs to be done monthly. - Data Points: The data points to be extracted include various metrics like annual sales, operating profit margin (OPM), net profit, and others. - Excel Formatting: The extracted data needs to be stored in a particular format in Excel. Ideal Skills: - Proficiency in Excel - Experience with web data extraction - Attention to detail to ensure data is accurately captured and formatted. Please note, I need this to be set up for monthly updates.
I am looking for a data operator to assist with a complex data entry project. The ideal candidate should have experience in data entry from digital files, specifically using Microsoft Excel. The work involves significant formatting and clean-up of the data. Skills and experience required: - Proficiency in Microsoft Excel - Strong attention to detail - Ability to handle complex data entry tasks - Experience in formatting and cleaning up data If you are meticulous, experienced in data entry, and proficient in Microsoft Excel, please apply for this project.
Clean home page: slider, attractive promotions, well-organised categories, no duplication. Footer with appropriate links, no words in English. Clean product and category pages (advanced filters, appropriate images). Optimised shopping basket and payment. Mass import of products via Excel file. ATUM confirmed for stock management. Delivery methods configured (zones and extensions). Site ready to inspire confidence and sell.
Hello everyone we looking for 50 freelancers who can help us to translate from English into Spanish.
I'm looking for a highly skilled tutor in Excel and KoboToolBox to teach me data collection/visualization/evaluation. Excel: - Help me improve my data analysis skills - Explain complex concepts in an easy-to-understand manner, provide practical examples, and guide me through various data analysis tasks KoboToolBox: - Creating surveys - Teach me how to collect, visualize, and evaluate data Ideal Candidate: - Strong background in data analysis, proficient in Excel, and highly experienced in using KoboToolBox for data collection. - Excellent teaching skills, patience, and the ability to adapt to my learning pace.
