Spreadsheet Projects
Looking for freelance Spreadsheet jobs and project work? PeoplePerHour has you covered.
Data Entry
I work as part of an accountancy firm and we require someone who has good knowledge of using excel & tax calc. we require 2 excel spreadsheets to be transferred from excel to tax calc. these spreadsheets include customer name contact details Etc. the outcome we expect is that all information from the excel spreadsheets is transferred onto tax calc. the deadline we have for this is 2 weeks. we will pay a fixed fee of £102
9 days ago49 proposalsRemoteWeb Scraping
I need the following company information filled in on attached spreadsheet; 1) Email address (verified) 2) Phone number 3) Business owners name Required on or around 7/5/2024
2 days ago40 proposalsRemoteOperational Metrics Dashboard Design
I'm looking for an expert in analytics to create a compelling dashboard that pulls data from Excel spreadsheets. You would be focussing primarily on reflecting operational stats in a clear and concise way. Key duties: • Integration of Excel spreadsheet data into the dashboard • Showcasing operational metrics, specifically focusing on account monitoring status on a daily basis like inspection due date Perfect for someone who: • Has experience with data integration from Excel spreadsheets • Understands operational metrics and how to present them effectively • Can deliver a user-friendly dashboard for easy understanding of data • Has a keen eye for details and accuracy.
11 days ago20 proposalsRemoteopportunity
Excel analysis and spreadsheet template tracking sheets needed
Excel analysis and spreadsheet template tracking sheets needed for student results data. I require the spreadsheets that I have and some formulas already provided to work how I want them to do that results can be input and student data can be tracked and analysed easily. I need this work done asap.
20 days ago58 proposalsRemoteWeb scraping
I am looking at Web scraping software, based on input; to produce a spreadsheet of URL, email address and phone numbers extracted from the contact us pages,using legitimate methods. A URL scrapper will also need to be built into the application. To be able to facilitate the above process.
18 days ago31 proposalsRemoteopportunity
Companies House API
I am looking to pull data from companies house using their api. (https://developer-specs.company-information.service.gov.uk/companies-house-public-data-api/reference) I would like the script to look up the company name in column A of this gsheet https://docs.google.com/spreadsheets/d/15rRpXZMmf0wUXl0hfQy05HBGifTCAAHl19q_gqzZJNg/edit#gid=0 and return the company number, director and persons of significant control. I would preferably like the script to work in Appscript within the gsheet if possible? It does require an API token so it will require you to register to create a token.
8 days ago44 proposalsRemoteWeb Scraping
I have a series of projects whereby we would like to take the contact data of travel agents from membership directory websites. An example of this, is this site. https://www.abta.com/abta-member-search/results?search=London Another example is this site. https://www.etoa.org/member-search/?term=&type=&country=United+Kingdom&v_s_m=&d_s=&p_s=&c_r_l=&y_e=&c_a_p_s=&c= We need directory data extracted and ideally we would like the data to be in a spreadsheet with name, email address, telephone number, Company name etc. We have 11 websites we would like the data from. And multiple ofther projects too. Kind regards, Nicola
4 days ago69 proposalsRemoteEntering receipts in Excel
I need UK based person for entering receipts on a spreadsheets for bookkeeping purposes. each time this needs doing the batch of receipts will be sent to you and on completion will be randomly checked for accuracy. there will be roughly around 500-700 receipts. Each receipt will require about 8-9 fields e.g. Date, supplier, Desc. Nett amount, VAT, total, method of payment This can be done in the next 2-3 weeks but will have to give a time at before excepting the job my budget is 10p/ entry
13 days ago65 proposalsRemoteNeed 250 Lines Of Copy Writing to excel
I Need A Copy Writer To Copy My Flooring Price List From My suppliers, to a Pre-formatted Excel worksheet, I will Send the different Price list via email and you must transfer to a Pre-Formatted Excel spreadsheet
a month ago129 proposalsRemoteOnline Administrative Assistant
We seek an experienced online administrative professional to seamlessly support our virtual business operations. Remote collaboration and multitasking acumen are necessities for managing communications across channels, compiling research, entering financial data, creating presentations and spreadsheets, scheduling conferences, assisting customers, and performing general tasks as assigned. An organized self-starter proficient in Microsoft and Google Suites who reliably meets deadlines is ideal. Applicants should demonstrate proven experience in virtual roles with strong communications and organization/time management capabilities. Bachelor's degree or comparable experience preferred. Prioritization of client service and digital literacy are highly valued.
10 days ago39 proposalsRemoteopportunity
Research for Smartphone stores USA
THE BUDGET IS FIXED I need someone to research and find the names of all independent smartphone/cell/mobile phones in USA. These are phone repair stores or phone accessories stores or just phone stores. Okay so we need all the independent stores. We do not want the stores like Apple Centres or Sony or T Mobile or Orange or Vodafone or 3 etc. We want the smaller stores. So you’ll need to check. We need them all neatly put into an excel spreadsheet We also need the emails to be put into a folder. We need the store name, address, facebook page, website (if they have one) and email address. There are about 170,000 stores in total. All States of the USA required. Data can be found on Google, Facebook, Linkedin and other data resources.
18 days ago29 proposalsRemoteopportunity
Write a year's worth of filler social content
I need to fill 2024's social media calendar with filler content. Sundays - Product Promotions Mondays - Motivation Mondays Tuesdays - Blog Promotions Wednesday - Rewards, Referrals, Newsletter Promos Thursdays - Resource Promotion Fridays - Fun Fact Fridays Saturdays - Product Promotions You can definitely use AI to create them, but want to make sure they're formatted for a US audience and on-brand for us. We're a label printing company. Key highlights are sustainability and eco-friendly, VIP customer service, easy online ordering, etc. If hired, I'll send you all of the links for CTAs, etc and provide a spreadsheet for posts to be logged into. NOTE: You will not need to create any images. This is purely copywriting.
18 days ago40 proposalsRemoteResearch for list of smartphone stores in France and Australia
I need someone to research and find the names of all independent smartphone/cell/mobile phones in both France and Australia. These are phone repair stores or phone accessories stores or just phone stores. Okay so we need all the independent stores. We do not want the stores like Apple Centres or Sony or T Mobile or Orange or Vodafone etc. We want the smaller stores. So you’ll need to check. We need them all neatly put into an excel spreadsheet We also need the emails to be put into a folder. We need the store name, address, facebook page, website (if they have one) and email address. There are about 5,000 stores in France. There are about 1,500 stores in Australia. Here are the regions to search. These can be found on Google, Facebook, Linkedin and other data resources. You will be provided with all the areas to search,
19 days ago35 proposalsRemoteGuest Posts Needed
I need guest posts promoting a new crypto DAO/DeFi project on various websites (check the link): https://docs.google.com/spreadsheets/d/1HJwI7zXAJ3KaQz9RNW3fpqnju1PtEH1VibRwgmGvFjo/ - The posts must be PERMANENT with DOFOLLOW links - Work must be accomplished within 4-6 days - I will provide you the content (copy including 500+ words, 1 or 2 anchor texts, banner images, URL, etc.) The budget is fixed. Apply only if you have delivered similar jobs previously. Thank you.
a month ago31 proposalsRemote20 PAGE ONPAGE SEO OPTIMIZATION KEYWORD
Hello, Straight forward project as i do not have the paid tools such as SEMRUSH / AHREFS / SCREAMING FROG / MOZ / LINKWHISPER / OTHERS 20 url. Need everything from site audit/analysis/ competitor SPYFU/keyword planning/content seo and technical seo. Excel file for job requirements. https://docs.google.com/spreadsheets/d/1lMut4pGMJ8KAPt-sbWF5IQObPDCwMk7LXaGnvq77kYg/edit?usp=sharing For reference only. SEO audit. https://docs.google.com/document/d/13YbdtXqbqEyQlHu_RBd2D16pj1wgja-vep0K2fmy1gs/edit?usp=sharing 7 Days to complete 20 On-Page SEO. Wordpress + Rank Math Pro Please tell me what software you will use to complete these tasks.
24 days ago30 proposalsRemoteLooking for a content updating expert with SEO skills
I have several clients that have out of date content. For example, the content may reference 2022 stats rather than 2024. I'm looking to create a process to keep content updated and gradually update my clients content. For each page, I would like someone to help me with the following process: Requirements: - Assess the existing content rankings - Add bullet point summaries to the top - Identify additional subheadings based on rankings and propose content - Identify and implement EEAT suggestions to improve the quality of the content (I will provide) - Update any out of date stats, data, research and information or add this if there is none currently. - Adapt the language to be more conversational where possible. If possible: - Create a custom image to add to the page (could be made on Canva according to client branding) Notes on process - We will have a joint spreadsheet in which we’ll both work from. I’ll add a list of pages to review (could be between 10-30 pages per month) with a deadline and cost per page. Do let me know if this is something that you can help with!
a month ago30 proposalsRemoteExperienced SEO required (3 years minimum experience)
Our marketing agency is expanding, and we're in need of an SEO Specialist to focus on our flagship e-commerce client. This client has a 20-year old domain and has recently seen a 20% increase in organic traffic over the past three months compared to the same period last year. You'll be working solely with this client, using your SEO skills to keep up and improve this growth. Responsibilities: - Work closely with our Performance Marketing Director to set and meet KPIs for the client. - Create a detailed SEO strategy that includes on-page SEO, content creation, technical SEO, and link building. - Coordinate with our team, including content writers and technical staff, to make sure your strategy is implemented effectively. - Carry out thorough keyword research and analysis. - Conduct detailed SERP analysis. - Decide on the best content strategies for the client, figuring out not just the keywords to target but also the type of content that should be created and how to rank it. - Prepare and share reports with the client, showing progress and plans. We prefer using Data Studio, but we’re open to other tools if you have a better option. - Forecast the work needed and plan resources with the project manager for both current and upcoming client needs. - Be the go-to person for SEO within our team, providing guidance and pushing the client's SEO forward. Requirements: - Proven track record in SEO, showing your ability to develop and execute successful strategies. - Strong skills in keyword research, SERP analysis, and creating SEO strategies. - Experience in creating and presenting SEO reports. - Good at working with spreadsheets for planning and strategy development. - Able to work independently and manage your workload to meet deadlines. - Strong communication skills, comfortable explaining complex ideas in a simple way. Please send your proposals. Price is a placeholder.
a month ago54 proposalsRemoteEducation Admin support
We are a small team of Healthcare Professionals offering a 1-yr Certificate Programme in Psychedelic Practice. This is aimed at Healthcare Professionals worldwide. We will likely be expanding to offer other courses over the coming years(s) Website: https://www.psyedu.co.uk/ Our current Education Admin Lead is leaving in May. We need someone to work flexibly around 3-6 hrs a week (10-20hrs per month) doing basic administrative tasks for our Education Organisation. It will be very busy between June and September (more like 6hrs per week) then will calm down a bit at other times in the year. We are a small start-up in our second year, just beginning to settle into our rhythm and we now need reliable low-level input which will likely slowly increase in workload over the next 3-5yrs. Job Description Skills/knowledge: MUST HAVE: Excellent written and spoken English, Organisational Skills +++, Microsoft office, excellent written and spoken communication skills, an understanding of the course we offer or a willingness to learn about it DESIRABLE: some knowledge of healthcare and how psychedelic practice is starting to be used in healthcare Qualities: flexibility Experience: any role which demonstrates the capacities outlined below Hours: 10-20hrs per month, ideally 1-2hrs on Mon, Wed and Fri each week Job Description: Key Responsibilities: 1. Communication Management: o Serve as a primary point of contact for internal and external communications. o Handle incoming emails, and redirect them as appropriate. o Draft and distribute notices, tutorials, open events and announcements. 2. Administrative Support: o Assist in scheduling appointments, and meetings for management and staff. o Maintain and update company databases, records, and filing systems. o Prepare and distribute documents as required. o Liaising with different organisations 3. Documentation and Recordkeeping: o Ensure accuracy and completeness of documents, contracts, and agreements. o Maintain confidentiality of sensitive information and handle it with discretion. o Organize and archive records in accordance with company policies and regulatory requirements. 4. Team Collaboration: o Collaborate with colleagues and departments to support cross-functional projects and initiatives. o Provide administrative assistance to various teams as needed. o Foster a positive and cooperative work environment through effective communication and teamwork. o Attending meetings once every two weeks 5. Problem Solving and Decision Making: o Identify issues or challenges in administrative processes and propose solutions for improvement. o Prioritize tasks and manage time effectively to meet deadlines and goals. Qualifications and Skills: · Proven experience as an Administrator or similar role. · Proficiency in office software applications, including word processing, spreadsheets, and presentation software. · Strong organizational and multitasking skills with attention to detail. · Excellent verbal and written communication abilities. · Ability to work independently and collaboratively in a fast-paced environment. · Discretion and professionalism when handling confidential information. · Problem-solving and decision-making skills. · Flexibility and adaptability to changing priorities and tasks.
16 days ago39 proposalsRemote
Past "Spreadsheet" Projects
opportunity
Copying details onto a spreadsheet.
I have a database of company names and employee counts on 1 tab and on the 2nd tab the company names but with contact details. Tab 1 is split into 2 colour groups. What I need is someone to copy company line 1 and see if it appears in tab 2, if it does change that line into yellow or green to match that line in tab 1 and on the line in tab 2 add a new column 'URL with their website address from tab 1 . There are lots of lines. how long will this take you please?
I need a Google Drive Spreadsheet Template Built to Track Deals
Hi all I require a Google Excel sheet created that features a main data page which will have a number of fields populated. One of those fields will have a drop down list with various members of staff displayed. When a member of staff is selected then that row needs to appear in a separate tab that is only for that member of staff to see. As they progress that deal and add notes, those notes are then updated on the main sheet that I am able to view. If I change the member of staff allocated to that record then all details need to transfer over to the new member of staff and be removed from the old member of staff. Ideally I would need a data sheet where I can list members of staff to make it easier to update as staff join or leave the company.