Optimize Your Microsoft Excel Projects on Upwork

I have paid more than 101k+ USD to freelancers in last few months. I have worked with more than 130 developers here and currently working with 130 developers.

If you know browser automation studio you will be preferred.

Budget is just a placeholder at the moment

We are seeking a skilled Data Extraction Expert to extract data from a sample mobile app. The task involves extracting various data points such as user profiles, transactions, and user activity. The extracted data needs to be organized and delivered in a clean and structured format. The ideal candidate should have experience in data scraping and possess strong technical skills in tools like Python, BeautifulSoup, and Selenium. Attention to detail and the ability to quickly navigate different mobile app interfaces is essential. If you have a proven track record in data extraction and can deliver accurate results within tight deadlines, we would like to hear from you.

Skills: Data Extraction, Microsoft Excel, Data Scraping, Data Entry, Data Mining

We are seeking a detail-oriented freelancer to compile a comprehensive list of booster club contacts, specifically targeting presidents or officers, from public high schools across the United States. The goal is to create a well-organized database that includes names, email addresses, and phone numbers, if available. Experience with data collection and familiarity with educational institutions will be advantageous. Please provide samples of previous similar work when applying. Your attention to detail and accuracy is crucial for this project.

Skills: Data Entry, Microsoft Excel, Lead Generation

We are seeking special new freelancers who are interested in working on easy and simple tips tasks. This is a great opportunity for those who are looking for a flexible and straightforward gig that can be completed in their spare time.

Skills: Data Entry, Email Communication, Microsoft Excel, WordPress, Microsoft Word, Typing

We are seeking a detail-oriented freelancer to convert PDF bank statements into CSV files suitable for uploading into Xero. This is a one-off piece of work for now but possibly more in the future.
The ideal candidate will have experience with data extraction and formatting, ensuring accuracy and attention to detail. Familiarity with Xero is a plus. The project is urgent. If you have the necessary skills and can handle sensitive financial information, please apply with your relevant experience.

Skills: Data Entry, Microsoft Excel, Accuracy Verification, PDF Conversion, Xero

Looking for individuals to provide feedback on our clients' websites. This is a simple 5-minute task requiring no prior experience - instructions will be provided. Qualified applicants will be contacted within minutes of applying, so please monitor your inbox. Don't miss this easy opportunity to share your opinion and get started quickly!

Skills: Data Entry, Administrative Support, Virtual Assistance, Microsoft Excel, Writing, English, Microsoft Word

Description:

We’re looking for an experienced crypto fund accountant (or someone familiar with crypto trading data and fund accounting) to help us prepare a clean, auditable P&L report for 2022.

Scope of Work:

We have 2 exchange accounts: Kraken and Luno

Approximately [insert estimate if known] transactions in total

We need you to:

Consolidate all trading activities across both exchanges

Calculate monthly P&L (realised gains/losses)

Determine cost basis and amount purchased/sold per month

Prepare data in a format that can easily be understood and integrated into our general ledger

Ensure everything is audit-friendly (clear, well-documented methodology)

We will provide raw CSV exports or API access from both exchanges.

This is for our fund’s internal accounting, so accuracy and clarity are key. Our current accountant is not crypto-savvy, so we need this work to be packaged clearly for handover.

Please include examples of similar work you’ve done or describe your experience with crypto accounting.

Skills: Accounting, Bookkeeping, Financial Accounting, Microsoft Excel, Accounting Software, Crypto Exchange Platform, Cryptocurrency

We are seeking a reliable freelancer to assist with data entry and spreadsheet management for our small business. The ideal candidate will be detail-oriented, organized, and able to manage data efficiently. Responsibilities include inputting data, maintaining spreadsheets, and ensuring data accuracy. Experience with Excel or Google Sheets is essential. If you are proactive, have strong attention to detail, and can work independently, we would love to hear from you!

Skills: Data Entry, Microsoft Excel, Google Docs, Administrative Support

We are seeking a skilled freelancer to extract coordinates in WGS 84 format from various areas delineated in a Shape File. Each area has a defined lower altitude. Each area can have maximum 100 coordinates points. The height is defined in a shape text file and in a PDF file. The output of this job is an excel file with 3 columns:
latitude Longitude Lower Limit

Skills: Python, Microsoft Excel, Data Extraction, Data Entry, Data Scraping

We are seeking a skilled Spanish Virtual Assistant to assist with various administrative tasks and data entry. The ideal candidate will have a strong command of the Spanish language and be proficient in data management tools. Responsibilities include managing emails, scheduling appointments, and inputting data into our systems. Attention to detail and strong organizational skills are essential. This role is perfect for someone looking to support a dynamic team in a fast-paced environment.

Skills: Customer Service, Administrative Support, Email Communication, Microsoft Excel, Google Docs, Customer Support, Microsoft Word, Accuracy Verification, Accounting Basics

We are seeking a skilled n8n automation expert to streamline our workflows through automation. The ideal candidate will have hands-on experience with n8n and be able to create, modify, and optimize workflows tailored to our business needs. Responsibilities include understanding current processes, implementing n8n solutions, and ensuring seamless integration with other tools. If you are passionate about automation and have a track record of successful n8n implementations, we would love to hear from you!

Skills: Automation, Lead Generation, Python, Microsoft Excel, JavaScript

Please review the following script and submit your application:

Just state the price to create the following Python script.
Any small talk or attempts to raise the price through questions will be rejected.
(For reference, it was previously done for $10.)

It's a simple Python script, so we expect it to be completed within 5 hours.




-----------

# Cosmetic Product Image Download and Information Extraction Program Requirements

## 1. Project Overview

Purpose: Develop an automation program that processes an Excel file containing cosmetic product data, downloads product images, extracts product information, and updates specific columns in the Excel file.

## 2. Key Functional Requirements

### 2.1 Google Image Search and Image Download
- Search Google images using English product names from column C of the Excel file
- Extract the first and second thumbnail images from search results
- Use AI API to determine which image better represents a product thumbnail
**[AI Usage Point #1]**: AI evaluation to determine which of the two thumbnails is more suitable as a product image
- Download the selected image as JPG format (metadata must be removed)
- Name the downloaded file the same as the product name used for search

### 2.2 Product Information Extraction
- Access the original webpage of the image to extract product information
- Use AI API to determine:
**[AI Usage Point #2]**: Detect and extract product description in English from the original webpage
**[AI Usage Point #3]**: Extract key keywords from the product description
**[AI Usage Point #4]**: Determine the most appropriate product category
- Category options:
- Skincare
- Cleansing
- Makeup
- Sun Care
- Mask/Pack
- Body Care
- Hair Care
- Perfume

### 2.3 Excel Data Update
- Update the following columns in the target Excel file:
- Column G: Product description (in English)
- Column H: Keywords (in English)
- Column I: Category
- Column J: MOQ (calculated based on column F amount)

### 2.4 MOQ Calculation Logic
- Divide column F amount by 1450, then round up to the nearest 100
- Example: 3,000,000 ÷ 1450 = 2068.97... → rounded up to 2100
- If column F is empty, assume 3,000,000 and calculate
- 3,000,000 ÷ 1450 = 2068.97... → 2100

## 3. Detailed AI API Usage Specifications

### 3.1 AI Service Selection and Configuration
- Recommended API: OpenAI GPT-4 or similar LLM API
- API key management: Manage in secure environment variables or configuration files

### 3.2 Image Evaluation API Call (AI Usage Point #1)
- Input: Two image data (base64 encoded or URL)
- Prompt example:
```
You are a cosmetics merchandising director. Between the following two images, determine which one is more suitable as an official product thumbnail for [product name].
Evaluation criteria:
- Clear visibility of the product
- Professional product photography quality
- Focus on the actual product
- Clean background
- Brand visibility

Respond with only 0 or 1. (0: first image, 1: second image)
```
- Output: Index of more suitable image (0 or 1)

### 3.3 Product Description Extraction API Call (AI Usage Point #2)
- Input: Original webpage content text
- Prompt example:
```
You are a cosmetics merchandising director. From the following webpage content, extract a product description for [product name] in English.
The product description should be 3-4 sentences, professional, and suitable for marketing.

Webpage content:
[webpage text]
```
- Output: Product description in English (3-4 sentences)

### 3.4 Keyword Extraction API Call (AI Usage Point #3)
- Input: Product description or webpage content
- Prompt example:
```
You are a cosmetics merchandising director. Based on the following product description, extract 5-7 most relevant keywords for [product name] in English.
Keywords should be comma-separated.

Product description:
[product description text]
```
- Output: Comma-separated list of English keywords

### 3.5 Category Determination API Call (AI Usage Point #4)
- Input: Product name, product description, or webpage content
- Prompt example:
```
You are a cosmetics merchandising director. Based on the following information, determine which category [product name] belongs to.

Choose only one category from the following list:
- Skincare
- Cleansing
- Makeup
- Sun Care
- Mask/Pack
- Body Care
- Hair Care
- Perfume

Product information:
[product information text]
```
- Output: Selected category name

### 3.6 API Response Handling and Exception Scenarios
- Response format: JSON format recommended
- Required processing:
- Response parsing and validation
- API error handling and retry mechanism
- Response timeout settings
- Alternative response preparation:
- Default value logic when API call fails

## 4. File Paths and Data Specifications

### 4.1 Input File
- Target Excel file path:
```
/Users/racoon/Desktop/5월 전체 업로드용 상품리스트/인공지능, 구글 이미지 다운과 상품정보 기입 프로그램/타깃엑셀/2025년 5월 화장품 모든상품 목록 알리바바 업로드 예정 2.xlsx
```
- Columns used:
- Column C: English product name (required)
- Column F: Price information (for MOQ calculation)

### 4.2 Output Data
- Image save path:
```
/Users/racoon/Desktop/5월 전체 업로드용 상품리스트/인공지능, 구글 이미지 다운과 상품정보 기입 프로그램/다운받은 상품 이미지
```
- Excel columns to be updated:
- Column G: Product description
- Column H: Keywords
- Column I: Category
- Column J: MOQ value

## 5. Technical Requirements

### 5.1 Development Environment
- Language: Python
- Required libraries:
- Web crawling: Selenium or similar library
- Excel processing: Pandas, openpyxl, etc.
- Image processing: PIL or similar library
- HTTP requests: requests, etc.
- AI API integration: Library appropriate for the chosen AI service (e.g., openai)

### 5.2 Web Crawling and Automation
- Automate Google image search
- Specific HTML element selectors:
- Google search box: `input id="input" class="truncate" type="search"...`
- Thumbnail images: `img class="YQ4gaf"...`
- Access original webpage and extract content

## 6. Detailed Process Flow

1. Open target Excel file
2. For each product name in column C:
a. Access Google and search for product name images
b. Extract first and second thumbnails
c. **AI API Call #1**: Evaluate two images to select the more appropriate product image
d. Download selected image (remove metadata)
e. Access original link of the image to extract product information
f. **AI API Call #2**: Extract product description and convert to English
g. **AI API Call #3**: Extract keywords from product description
h. **AI API Call #4**: Determine product category
i. Calculate MOQ based on column F amount
j. Update columns G-J with extracted information
3. Save Excel file

## 7. Error Handling and Exception Scenarios

- Response strategy when Google search results are insufficient or nonexistent
- Response strategy when image download fails
- Retry or alternative logic when AI API call fails
- Default values or alternative strategy when product information extraction fails
- Response to Excel file read/write errors

## 8. Performance and Efficiency Considerations

- Set appropriate delay times to avoid Google blocking due to rapid requests
- Optimize AI API calls (considering cost and performance)
- Optimize image download and processing
- Session management and retry mechanisms
- Periodic progress saving (e.g., save Excel every 5 products)

## 9. Additional Notes

- All product descriptions and keywords must be written in English
- AI prompts should apply cosmetics merchandising director persona
- Selected categories must be chosen from the 8 given categories only
- Implement logging functionality to monitor process and results

Please develop the program based on these requirements. If you have any questions or need clarification on any aspects of the implementation, please ask.

Skills: Data Entry, Python, Data Scraping, Microsoft Excel, Data Mining

I need detailed information on how to open a TikTok Shop account in the United States, including the necessary steps, eligibility criteria, and required documentation.

Skills: Data Entry, Data Scraping, Microsoft Office, Google Docs, Virtual Assistance, Google Sheets, Microsoft Excel, Web Scraping, Canva, Web Design, Accuracy Verification, CRM Software, Big Data, TikTok, Ecommerce Site Setup

We are seeking a detail-oriented data entry specialist to assist in identifying and compiling a list of businesses using Google Maps. The ideal candidate will utilize a specific set of criteria to ensure accurate and comprehensive data entry. If you are proficient in navigating Google Maps and have a keen eye for detail, we would love to hear from you!

Skills: Data Entry, Google Docs, Accuracy Verification, Microsoft Excel

We are seeking a skilled procurement supply chain agent to help us find a vendor capable of modifying a small rubber bobcat belt. The task involves cutting the belt to remove a piece, and then re-attaching the ends securely. The ideal candidate will have experience in sourcing reliable suppliers and performing custom modifications with rubber materials. Note: the modification to the belt is for testing purposes and does not need to be strong enough for production needs. Excellent communication skills and the ability to negotiate terms are essential to ensure quality and timely delivery.

Skills: Manufacturing & Construction, Sourcing, Microsoft Excel, Product Development

We are seeking a skilled data scraper to extract cadastre information efficiently. The ideal candidate should have experience in web scraping techniques and be familiar with cadastre databases or similar data types. You will be responsible for gathering accurate and comprehensive information from an Italian webstie with our profile and presenting it in a structured format. Strong attention to detail and the ability to handle large datasets are essential. If you have a proven track record in data scraping projects, we would love to hear from you!

Skills: Data Scraping, Data Mining, Microsoft Excel, Python

We are seeking a skilled freelancer to assist in building KPI dashboards that effectively visualize our company data through engaging graphs and tables. The ideal candidate will have experience in data visualization and dashboard creation, specifically using Google Sheets as the data source. Your expertise will enable us to make data-driven decisions and track our performance metrics clearly and efficiently. If you have a strong background in this area, we would love to hear from you!

Skills: Google Sheets, Microsoft Excel, Looker Studio, Data Visualization

We are seeking a skilled data engineer or research analyst to create a clean and well-documented country-year panel dataset. The ideal candidate should have experience in data collection, cleaning, and structuring for analytical purposes. Attention to detail and proficiency in relevant tools are crucial. Your goal will be to ensure the dataset is comprehensive and user-friendly for further analysis. If you have a strong background in data engineering and a passion for delivering high-quality results, we would love to hear from you.

Skills: Microsoft Excel, Python, R, Autodesk AutoCAD, Data Cleaning, API Integration, Web Scraping

I am looking for a reliable and detail-oriented individual to assist with data entry tasks. This is a short-term project that will require approximately 10+ hours of work. Your primary task will include entering information into spreadsheets, organizing data, and ensuring accuracy. Basic knowledge of Excel or Google Sheets is preferred. The ideal candidate should be able to start immediately and complete tasks within the given time frame. Clear communication and attention to detail are essential.

Skills: Accuracy Verification, Google Docs, Microsoft Word, Customer Service, Data Entry, Microsoft Excel, Administrative Support

You need to make my homework for school. Its an easy financial real estate exercise. You will need to translate for yourself what you need to do.

Skills: Real Estate Financial Model, Microsoft Excel, Financial Analysis, Data Analysis

Want to merge the first tab of work book of like items, then sort by most $ spent on each item, also the % to total purchaseas well as any analytic tool that would show top 20 to 25 items and % of total

Skills: Microsoft Excel

I am working with a language company that sells 1:1 tuition and trips. We have lead and sales data in a google sheet. We have google ads marketing data.

Need to combine everything together for one birds eye view.

And then do some modelling to understand what it takes to reach X rev targets. How much clicks we need, cost, how many leads, cost per lead, sales conversion, etc.

Need to understand cost, lead, sale funnel better. Need to see cost, leads, shows, sales, revenue side‑by‑side per month.

CPAs, ROAS, and ROI update automatically with formulas.

Will likely need 2 x 30m calls.

See attached files.

Nothing too complex - just some simple modelling with someone that understands web analytics, lead gen, etc.

Skills: Financial Modeling, Forecasting, Financial Analysis, Microsoft Excel

We are seeking a highly skilled and innovative Data Engineer with strong web scraping expertise to join our project. The ideal candidate will be responsible for designing and developing robust, efficient, and scalable scraping pipelines to collect and process data from a variety of websites and online sources.

This role is perfect for someone who not only has deep technical skills but also thinks strategically about data quality, ethics, and long-term maintainability.

Skills: Python, Data Scraping, Data Mining, Microsoft Excel

Hello,

we are looking for a Google Ads consultant to work with us on several projects.

Fundamental skills required:
- Be smart and quick learner.
- Be reliable and available.
- Good experience with Google Ads environment (this will be assessed in depth).
- Master excel level.
- Eagerness to learn.
- English fluent.
- Resident in a country in CET time zone +- 2 hours


All the above skills will be assessed in detail.


Looking forward to speak to you!

Skills: Marketing Audit, Competitive Analysis, Search Engine Marketing Strategy, A/B Testing, Google Display Network, Microsoft Excel, English, Google Ads, Google Analytics, Pay Per Click Advertising, Search Engine Marketing, Google Tag Manager, Internet Marketing, SEO Audit, Bing Marketing, PPC Campaign Setup & Management, Campaign Reporting

We're seeking a skilled professional to help us generate high-quality leads, build targeted lists, and accurately enter data into our CRM system. As a Lead Generation, List Building & Data Entry Specialist, you'll play a critical role in driving our sales and marketing efforts.

Responsibilities:
- Research and identify potential clients through various channels
- Build and maintain high-quality lists of potential clients
- Accurately enter data into our CRM system
- Qualify leads based on our company's criteria
- Collaborate with our sales team to ensure seamless handoff of qualified leads

Requirements:
- Proven experience in lead generation, list building, and data entry
- Excellent research and analytical skills
- Strong attention to detail and accuracy
- Proficiency in CRM software and spreadsheet management
- Ability to work independently and meet deadlines

Skills: Data Entry, Data Scraping, Lead Generation, Data Mining, List Building, Microsoft Excel

Description:
We’re a fast-paced event marketing agency looking for a detail-oriented Data Entry Specialist to support our operations team ~10–15 hours per week. You’ll be responsible for moving data from our internal backend systems into client-facing dashboards and third-party portals.

Key Responsibilities:
• Transfer and format data from internal systems into Google Sheets and Excel templates
• Input data into client dashboards, portals, and reporting tools
• Organize and maintain shared documents in Google Drive
• Double-check for accuracy and consistency in reporting
• Communicate status updates and flag issues proactively

Requirements:
• Strong proficiency in Excel and Google Workspace (Docs, Sheets, Drive)
• High attention to detail and accuracy
• Reliable, responsive, and deadline-driven
• Comfortable working with repetitive tasks
• Prior experience in data entry, reporting, or admin support preferred

Nice to Have:
• Familiarity with CRM tools or project management software (e.g. Copper, Airtable, Trello)
• Experience in marketing, events, or CPG industries

We’re looking for a reliable “go-to” person for weekly support with the potential to scale hours as we grow. If this sounds like you, we’d love to hear from you.

Skills: Email Communication, Accuracy Verification, Microsoft Excel, Google Docs, Spreadsheet Software, Administrative Support, Data Entry

Hello,

I am looking for someone to transfer data from Excel cells to Illustrator .AI files. There are 5 columns with 300 rows.

Each row data needs to be exported to it's separate .AI file. I will send you .AI design template in which data should be inserted into predefined text boxes.

Skills: Microsoft Excel, Python, Adobe Illustrator, Data Scraping

Looking for an automation that will log into websites/portals and download reports based on a schedule and date ranges.

Skills: Zapier, Scripting, API Integration, Data Scraping, Automation, Microsoft Excel, Visual Basic for Applications

We are a CA firm based in India looking to streamline and automate our internal workflow for client tax payments, MCA filings, and related government charges using Zoho Forms and Zoho Sheet.

The project involves creating structured Zoho Forms with conditional fields, automated email workflows, and a secondary form to track unmatched bank credits. Some payments are requested before transfer (escrow-style), while others (especially MCA) are paid first and reimbursed. Both cases need to be captured efficiently with form logic and proper tracking.

You will:

Build the main Zoho Form with Section 1 (internal entry) and Section 2 (client update – UTR, proof)

Configure automated email notifications (to client + internal team)

Create a secondary Zoho Form for bank credits received without prior request

Link both forms to Zoho Sheet for basic dashboard or reconciliation view

Apply conditional logic for internal/external initiations, pre/post-payment flows

Provide clean documentation of logic, access, and how to maintain the system

Duration: Setup expected within 2–3 weeks. Remaining time is for testing, refinement, and support.

Level: Intermediate Zoho Forms experience required. Familiarity with Zoho Flow or Google Sheet automation is a bonus.

Budget: Fixed price and can be milestone based.

Clear documentation and testable steps will be provided to get you started.

Skills: Zoho Creator, Automation, Microsoft Excel, Email Automation, Zoho Projects

We are looking for a talented full-stack developer or development team to create a modern, scalable, and secure VAT Reporting System. This platform is designed exclusively for Business and Consultant Accounts, with a focus on ease of use, document intelligence, and professional-grade financial reporting.

The solution should leverage the latest technologies and make smart use of open-source dashboards and libraries to reduce development time and enhance flexibility.

Key Features to Develop:
User Landing Page – Clean and responsive, explaining product features
User Dashboard – View upload history, reports, and quick actions
File Upload Functionality – Supports drag & drop with progress tracking
File Parsing Capabilities – For:
PDF, XLS/XLSX, DOCX, JPG, JPEG, PNG
Role-Based Access Control (RBAC) –
Multi-user login for Organization and Consultancy accounts
Admin, Editor, and Viewer roles
2FA (Two-Factor Authentication) – For added security
Email and SMS Notifications – Via Twilio and SendGrid
OpenAI API – For external system integrations
Tika Server Docker API Integration for Parsing (Available in my docker and github repository)
Ollama AI Integration – For intelligent document parsing and analysis
Results Parsing & Report Generation – Real-time insights extraction
Python Microservice for Reporting – Custom VAT reports
Upload and embed company Logo & Info into reports
Customizable & Multi-format Reports – Export to PDF, Excel, Word
Financial P&L Statement Generation – Auto-calculated, downloadable
Payment Gateway Integration – Stripe, Apple Pay, and Google Pay for seamless billing

Preferred Tech Stack:
Frontend: React.js / Next.js with Tailwind CSS or Material UI
Backend: Python (FastAPI / Django REST Framework)
Dashboard UI: Open-source templates (e.g., Tabler, Shards, React Admin, Notus, etc.)
File Parsing: PyMuPDF, Pandas, python-docx, PIL, openpyxl
Database: PostgreSQL or MongoDB
Authentication: JWT + 2FA
Notifications: Twilio + SendGrid
AI Integration: Ollama (for document intelligence)
Payments: Stripe + Apple Pay + Google Pay
Deployment: Dockerized, Cloud-ready (AWS / GCP / Azure), CI/CD preferred

Deliverables:
Full-featured VAT Reporting Web App
Clean, well-documented and modular codebase
Integration guides and post-delivery deployment support
Admin and user-level dashboards
REST/OpenAPI documentation

Timeline:
Expected delivery within 4–6 weeks

To Apply, Please Include:
Portfolio or links to similar projects
Proposed tech stack and development approach
Any open-source dashboard UI you'd recommend using

Skills: Accounting, Microsoft Excel, Financial Accounting, Bookkeeping, Intuit QuickBooks

Task Description:
I need a professional academic writer to complete a 2000-word economics research report for a university assignment. The topic focuses on evaluating how macroeconomic variables (such as inflation, unemployment, interest rates, exchange rates, exports, and imports) have influenced Australia’s real GDP growth from 2002 to 2024.

You will need to:

Collect and analyze relevant data from credible sources like ABS, RBA, IMF, and World Bank.

Use Microsoft Excel to generate graphs and perform a simple regression analysis.

Interpret the results and provide a clear explanation of economic relationships and policy implications.

Include an executive summary, table of contents, relevant charts/tables, a conclusion with policy recommendations, and a reference list using Harvard (Anglia) style.

Ensure the report is well-structured, plagiarism-free, and follows an academic tone.

Deadline: Must be completed within 48 hours after the task is assigned.

Skills: Economics, Academic Writing, English, Writing

Looking for an expert to simplify my work.
I am having purchase and store date in separate excel. I need to automate it

Skills: Data Entry, Google Sheets, Microsoft Excel