
Spreadsheets Projects
Looking for freelance Spreadsheets jobs and project work? PeoplePerHour has you covered.
Spreadsheet Creation
Spreadsheet Creation: Create a comprehensive spreadsheet to calculate profitability on a project, including cost price, sale price, fees, and financing costs based on a fixed percentage.
10 days ago39 proposalsRemoteCreation of a logo and spreadsheet templates to sell on Etsy
This is an exciting opportunity to blend design, develop Excel skills, and launch an Etsy store! Create a unique logo, design engaging spreadsheets for sale, and handle occasional support tasks in a flexible, creative long-term role. I’m starting a business selling Excel spreadsheet templates on Etsy and am seeking an enthusiastic person to help bring this vision to life. This role is perfect for someone who loves design, wants to sharpen their Excel skills, and enjoys creating functional, visually stunning documents. While the focus is on creative projects, the role also includes managing the Etsy store, assisting with other Excel tasks and handling administrative and occasional ad-hoc support tasks as needed. What You'll Do: Create a logo and contribute to the brand identity for an Etsy shop Design promotional materials to showcase digital products Design and optimize Excel templates for professional clarity and user experience Develop layouts to make complex information visually appealing and easy to understand Add user-friendly instructions to enhance template functionality Self-learn the basics of the Etsy marketplace and product optimization Manage the Etsy store as required Assist with other tasks in Google Sheets and Excel as required Other admin tasks can be done remotely such as research. Straightforward and easy to manage, based on availability. I'm not sure how to price this, but I'm happy to start with a set of agreed-upon deliverables for $100 USD. If that goes well, we can transition to an hourly contract. Please include your preferred hourly rate in your proposal.
4 days ago8 proposalsRemoteDigital Filing and Spreadsheet Updating
I run a company where many documents are photographed or scanned onto Whatsapp. They are downloaded from WhatsApp, checked for quality, renamed, and uploaded to specific file on Google Drive. A spreadsheet is then updated to reflect that the document has been uploaded. If a document is rejected, then a message is sent to the uploader, so they can correct the error. The job is a regular one and will require 1-2 hours of work per day.
24 days ago61 proposalsRemoteEmail multiple contacts from a spreadsheet
Hi, I have an email address associated to my domain. e.g. user@domain.com. I need recipients to receive an email from this address. I have tried to do this by using a 'mail merge', referencing a google spreadsheet and it works, but I need to be able to do this using my domain's email address being the sender. I'll need guidance with a method you suggest and can share my screen over a video call.
a month ago11 proposalsRemoteCompanies house data extraction
Dear PPH community, On behalf of my employer (a London accounting company), I'm currently looking for a freelancer who is firm with Companies House Rest API. However, it is not necessarily our goal to create a link between Companies House and one of our systems. Instead, it is mainly our interest to create databases of companies in the form of Excel spreadsheets. In case it helps you understand the request better: The purpose of this project is to generate overviews of UK businesses for us to understand markets so that can strategise better in our marketing. Should you have more questions, please let me know. Looking forward to working with you! Joel
2 days ago35 proposalsRemotePowerBI report - LinkedIn Ads, organic social, Google Analytics
I need to create a Power BI report that brings in Google Analytics, Organic Socials, LinkedIn Pages, Threads, Instagram, and the most important LinkedIn Advertising reporting. This all needs to be combined in to one report that is filterable via dates and campaigns. There is also an additional spreadsheet hosted on SharePoint that we need to pull data from.
13 days ago27 proposalsRemoteopportunity
Website for watch raffles.
Raffle website, requires tickets to be brought on the site. Contact information and ticket numbers to be sent to a excel spreadsheet.
23 days ago57 proposalsRemoteBot developer / support / maintenance
I am looking for a bot developer to initially fix a bot that I have but to also develop new ones as and when they are needed. The bot that needs fixing has stopped working due to a Chrome update so needs to be edited to work with the latest version of Chrome. Obviously this happens from time to time, so the successful applicant will be expected to offer maintenance / fixes as and when required Skills needed: Python Selenium Chrome Stealth Anti-detect browsers Proxies VPNs You must be able to speak English and be available during UK working hours. The bots are for gambling sites so please do not apply if you have any reasons for not wanting to work on such a project. The bots will need to run on windows 11. The bots will take data from a spreadsheet that I provide. Error handling is also very important to get right Please note: gambling sites have top notch security so the ability to make the bot undetectable is paramount.
11 days ago20 proposalsRemoteBook Keeping Help Needed
Freelance Bookkeeper Needed – Bank Statement Correlation & Expense Tracking We are looking for a detail-oriented bookkeeper to help us with a short-term project. The job involves reviewing bank statements from the past three months for three different projects and organising the data into a spreadsheet. This will allow us to clearly see and track our expenses over this period. Requirements: • Experience in bookkeeping and financial record-keeping • Proficiency in Excel or Google Sheets • Strong attention to detail and accuracy • Ability to work independently and meet deadlines If you have the necessary skills and availability, please get in touch with details of your experience and your rates. We look forward to hearing from you!
17 days ago76 proposalsRemoteExcel sheet reconciliation
Automating weekly Excel report reconciliation through effective formula usage. The core task involves reconciling numbers across spreadsheets on a weekly basis through manual data entry and calculations. The goal is to enhance efficiency and reduce redundancies by leveraging Excel's powerful functionalities like SUMIF, COUNTIF, VLOOKUP etc. Experience with advanced formulas, Pivot Tables and automation through Macros is required. Bidders should detail process of analyzing current manual steps and improving it through formula-driven approach to automatically fetch, calculate and reconcile data with minimal human intervention weekly. Knowledge of best practices for task repetition and automation in Excel will be an added advantage. Important note is that my laptop is protected by company so I cannot use Copilot in my laptop.
12 days ago52 proposalsRemoteResearch & Verify Contacts for Portfolio Companis & PE Investors
I need a freelancer to research portfolio companies and their private equity (PE) investors. The task involves: Identifying key executives e.g CEO, VP Sales, CFO. Collecting their contact details (name, title, LinkedIn URL, email, phone number). Summarizing recent news about these companies. I need their verified phone numbers and emails, I recommend you using this tools like hunter.io or ZoomInfo The final deliverable will be a completed spreadsheet with all the information organized and verified. I have attached the list of portfolio companies and PE investors for reference. This project needs to be completed and delivered by Thursday. Thank you
a month ago43 proposalsRemoteopportunity
Looking for Google Looker Studio Expert to Develop BI Dashboard
Job Overview: I am looking for a skilled Google Looker Studio expert to create a custom Business Intelligence (BI) dashboard to track and visualize key performance indicators (KPIs) for my Online Yoga & Pilates Lesson Planner and Card Deck business. My current tracking method is an outdated Excel spreadsheet, and I want a more automated, live-data-driven solution. The BI dashboard should integrate with WordPress (WP eMember membership plugin), WooCommerce, Google Analytics, Google Search Console, and other relevant tools while providing clear insights into my business performance. I will show you the excel spreadsheet I currently use (via screenshare), so you'll need to speak English. Key Responsibilities: Develop a Google Looker Studio dashboard that connects to live data sources, eliminating manual data entry. Integrate with WordPress (WP eMember for membership data), WooCommerce (online shop data), Google Analytics, and Google Search Console. Track SaaS metrics such as: New members Cancellations Renewals Churn rate Lifetime value (LTV) per member Active members Membership growth trends Gross and net income Track website performance, including: Live blog post list with keywords used Traffic per blog post Last updated date for each post Track WooCommerce KPIs such as: Total sales Income Conversion rates Top-performing products Automate membership renewal reminders (sent 7 days before renewal date) using Google Sheets + Zapier or other automation tools. Provide a section for logging business activities (e.g., blog updates, plugin installations, marketing actions, etc.). Generate visual reports and bar charts showing the frequency of business activities. Additional KPIs & Automation Ideas: SEO Performance Tracking: Connect to Google Search Console to monitor keyword rankings and traffic sources. Content Engagement Metrics: Measure time spent on blog pages and conversion rates from blog posts. Email Marketing Integration: Track email open rates and conversion rates from email campaigns. Customer Support Metrics: Track response time and number of support requests. Automation Ideas: Auto-generate reports on key metrics weekly/monthly in Looker Studio. Send automated Slack/email notifications for significant KPI changes. Implement AI-driven recommendations for content updates based on traffic patterns. Automate data syncing from WP eMember, WooCommerce, and Google Analytics into Google Sheets for smoother Looker Studio integration. Ideal Candidate: Extensive experience using Google Looker Studio to create custom dashboards. Strong knowledge of WordPress, WooCommerce, Google Analytics, Google Search Console, and data visualization. Ability to set up API connections and automation with tools like Zapier, Google Apps Script, or Make (Integromat). Prior experience working with small businesses or SaaS-based platforms. Ability to develop cost-effective solutions that fit within a small business budget. Budget & Timeline: As a small business owner, I have a limited budget, so I am looking for an affordable solution. Open to suggestions on using other BI tools with custom integration vs. building a solution from scratch. Looking for a solution that can be delivered within 1-2 months. If you have experience creating Google Looker Studio dashboards and can help me automate and visualize my business data, please apply with examples of how you've helped similar businesses like mine.
4 days ago22 proposalsRemoteSet Up Self Hosted CRM
Experience Level: Expert We run an online membership subscription program. Been around for a decade, solid sales, but no CRM in place. Looking for somebody who can help us set up a CRM solution. Technology: 1) System runs on Wordpress and Memberpress for memberships. 2) Payments via Stripe and Paypal. 3) E-mail leads collected by Sendy (self hosted e-mail platform). 4) Courses delivered via Learndash (showing data on actual use of lessons) 5) Details about customer collected via ThriveLeads quizzes. Funnel: 1) Largest lead magnet is free trial for a subscription. Collects e-mails first, then credit card info for trial. 2) Second is collecting e-mails for getting a free basic course. Both free trial and free basic course get follow up e-mail automated via Sendy. Analytics: 1) In depth analytics via GTM, lookerstudio, Google Analytics for funnel performance. 2) Manually tracking free trial conversions. 3) Manually tracking lead engagement with the platform: use of courses and customer details from ThriveLeads quizzes. Used in some cases for manual e-mails to convert leads. Current "CRM": Spreadsheets tracking leads, trials, conversions. Everything is done manual, aside from above systems. Goal: Automate as much of above as possible. Would love to see leads show up in CRM, ideally if possible also sales (though can do manually whatever isn't possible initially in a time / cost effective way). Want to track leads and conversions, customer interactions. Ideally self hosted solution. Want to control our data, and not be locked into a subscription - if possible. Is This You? 1) Very briefly, which CRM would you choose and why. 2) India / Pakistan based providers not considered for this project. 3) COPY-PASTE and GPT submissions will not be considered. 4) Timely correspondence is key. We always reply in 24 hours or less and are here to make sure you're not waiting. Looking for forward to finding you, get some great CRM solution in place!
6 days ago32 proposalsRemoteExecutive Virtual Assistant
I’m looking for a highly experienced, proactive Virtual Assistant to support me across multiple areas, including podcast management, event coordination, strategic research, and personal assistance. The ideal candidate is a self-starter who thinks critically, spots gaps, and leads tasks from start to finish with minimal oversight. Strong organizational skills, excellent written English, and independent problem-solving are essential. Since you will interact with high-net-worth individuals, investors, and senior stakeholders, professional communication, reliability, and discretion are crucial. ________________________________________ Key Responsibilities Podcast & Content Management • Manage bookings (scheduling, follow-ups, collecting materials) • Support episode preparation (research, transcripts, content summaries) Event & Travel Coordination • Assist with event planning & logistics (speaker coordination, scheduling, agendas) • Research & book travel (flights, accommodation, logistics) • Maintain guest lists & follow-ups Strategic Research & Data Management • Conduct targeted research (e.g., industry insights, investor databases) • Organize and maintain spreadsheets, databases, and CRM systems • Research and coordinate the development of a personal website Personal Assistance & Operations • Source & book personal shopping items (clothing, home decor, gifts) • Oversee inbox, calendar, and scheduling General Admin & Process Optimization • Track & organize expenses, invoices, and tax-related documents • Maintain & improve digital workflows (Google Drive, Notion, LinkedIn outreach) • Identify inefficiencies & proactively suggest process improvements ________________________________________ Requirements - Minimum 5 years of experience as an Executive VA or Operations Manager - Impeccable written English (Must be able to draft professional emails for VIP clients) - Strong project management skills (Able to take a task from start to finish independently) - Tech-savvy (Proficient in Notion, Google Drive, LinkedIn, Zoom, and email automation tools) - High attention to detail & ability to work autonomously
a day ago21 proposalsRemoteDownload and upload videos car&traffic related
hi i need to download from youtube or other platform videos with car related, traffic and accidents ,or bad driving , good driving and more than that. All the videos MUST be : - NO compilations, individual traffic videos - ONLY form UK , preferably around London - ONLY 1080p - WITHOUT watermark or logo - WITH the corresponding car number plate as a title for each video ( we re showcasing the wrong/good driving, so the title for each video is the car performing the wrong/good action in that video) This is an ongoing job , for a few weeks , few thousands vids or more. The job consists from downloading from youtube or other OPEN SOURCES , cars and traffic related videos to create a library of bad and good drivers (and more than this) I will give you the credentials to our website ( worst-drivers.london ) as an author and you will upload them there one by one , each with its number plate and the short description that you ll take it from the original website where you downloaded from and the upload source mentioned on the bottom (youtube have descriptions , i don t know abt the others). Alternatively you can forward them to me with number-plates and descriptions on a spreadsheet and i will upload them in to the servers , but i prefer you to take care of everything and us, just to approve them from the console. The videos you might find them in a compilation and you need to cut them (the actual single event from one video might be 30 second or 2 minutes) , or to eliminate their logo(better find vid without logo).. so consider all this for all 100 video. Their quality have to be 1080p, good resolution and not just upscaled, your videos should have the same quality and description as you can see already there.
a month ago13 proposalsRemote
Past "Spreadsheets" Projects
Website review to Excel spreadsheet
Hello, I’m doing research on an industry, i have a website that I require all products taken off, added to an excel spreadsheet, this will include; product name, product link and product price. I have an example of what the excel needs to look like. There over 400 products to go into the excel
Populate a spreadsheet with data
I am looking for someone to populate a spreadsheet with exhibitor details from the Top Drawer website. Your task will be to click through each listing and extract the relevant company information, including: • Company Name • Founder/CEO Name • Email Address • Website Address • Phone Number • Instagram Handle I will supply an example spreadsheet for you to use as a template. The data is readily available on the website; it’s simply a matter of clicking through and inputting the details accurately. I need this completed within the next few days. If you’re available and able to assist, please let me know. Please can you complete 2 entries into the spreadsheet attached so I can see that you understand what we need to do here Many thanks Carol https://www.topdrawer.co.uk/top-drawer-s-s25-exhibitor-list?&page=3&searchgroup=0983C266-a-z-brands-
Spreadsheet review and research
I have a spreadsheet. you need to go through the spreadsheet and outline who the 'service providers' are you then need to find where they are based in terms of zip code and location and make this in the the column then you need to see how they are rated on google, and put the number of stars they have on the spreadhseet too there's 1,000 results
Data collecting from certain websites and specific data
I am looking for someone who can collect some data in a spreadsheet from the web. It is from Rightmove.com. You will need to click on specific estate agent on rightmove, click on their listings, click epc and collect the addresses from the epc charts and add to a spreadsheet ensuring no duplicates are created. Video attached as example