Spreadsheet Projects
Looking for freelance Spreadsheet jobs and project work? PeoplePerHour has you covered.
Help with chatgpt
I am an intermediate user of chatgpt but would like to learn more. I have just purchased the paid version and want to utilise it as much as possible, so need someone to teach me to, for example, do various reports, excel spreadsheets, and automate my email responses. set it up so that it sounds more human, know how to use all of the ad ons.
3 days ago13 proposalsRemotepre-funded
French speaking Belgian rental property availability by phone
Please check the availability of my pre-selected Belgian rental properties, who speaks French by phone and help me to arrange a meeting with the landlord. I have a google sheet (excel spreadsheet) with contact details for 10 items. I already have live French-speaking help for local communication.
2 days ago8 proposalsRemoteopportunity
Simple Desktop Application
I need a desktop application which is based on the attached Excel sheet. Our business supplies temporary labour to the UK railway industry and we charge the client an agreed rate per hour. We pay our staff an agreed rate and the difference between the two is our profit. The spreadsheet is very basic and has been adequate for my needs so far but I would like a bespoke application which is easy to use and speeds up the data entry. The number of weekly jobs and number of staff are about to increase significantly so I really need a basic app that I can use. I will need to be able to produce a basic summary of all the jobs and also a summary of the wages sheet. I would also need to export the wages sheet to a .csv file so that I can easily import it into my payroll software. If you could please review the sheet and let me know if you could help that would be most appreciated. Hopefully you can follow my spreadsheet but please let me know if you have any questions and also let me know an estimate of your costs. Kind regards, Kieran
11 days ago57 proposalsRemoteData 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
a month ago70 proposalsRemote4 hrs trial: appointment setting for B2B SaaS sales
We're looking for someone to qualify leads and set appointments with interested parties for our web based 3D virtual floorplan software. Initial trial period will be 4 hrs, and then afterwards we'll look at paying you for a set number of hours with milestones. We currently have hundreds of contact details which need to be worked. Competitive rates will be prioritised. Skills needed: Good conversational English Preferably neutral accent Ability to evangelise a product Competent with telephone sales Duties include: Cold calling from a spreadsheet of prospects Work using a script as guidelines Pitching our product to prospects over the phone Conversationally move a prospect to a booked meeting with our Sales Director There is also commission available which will be discussed after the trial period if you're successful. NO RECRUITMENT AGENCIES - WE ARE NOT HIRING STAFF - WE ARE ONLY INTERESTED IN A SERVICE
a day ago15 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.
a month ago20 proposalsRemoteBusiness Administrator 5-10 / week
We are a small, personable team seeking an administrative assistant to support our Managing Director and Operations Manager in the daily operations of the company. Responsibilities include, but are not limited to, making follow-up phone calls regarding previous quotes, sending reminder emails, and accurately updating various spreadsheets and documents. The ideal candidate will be well-organised, detail-oriented, a native English speaker, confident, and possess excellent customer service skills. The initial commitment is approximately 5-10 hours per week, with the potential for increased hours in the future. You must be a self-employed contractor available during normal business hours, capable of working independently, and providing quick turnaround. Full training will be provided. UK Based only.
2 days ago20 proposalsRemoteQuickbooks Product Setup
I’m hoping someone can help. I’m after some quickbooks advice regarding tracking stock for an antique business I’ve just started. I've got myself into a bit of a pickle and need some help. I added an eBay sync app to import orders etc from eBay, however I don’t think I played enough attention when setting it up and I’m now a bit confused about how to deal with all the products it has created in QB, as none of them have a cost price. I know I can manually go through each and add a cost price, but this seems long winded, especially as each item is a one off. I have a detailed spreadsheet of items purchased with selling prices etc, would it be possible to wipe my QB data and import the spreadsheet data and then start afresh with a new system to track everything? Ideally some kind of simple system, as some lots I buy have hundreds of individual items in them, so I’d like to avoid making 1000’s of products in QB and then listing each one on eBay/our website. Maybe I’ve overcomplicated the whole situation? Would I be better off recording the overall stock value manually once a month like a stocktake rather than trying to track each individual item in QB? Clearly I’m lost and starting to ramble…. I’m keen to get a solution sorted out sooner rather than later so I don’t make the problem larger by buying and selling more items. Is this something you could help me with?
17 days ago22 proposalsRemoteopportunity
Netsuite - Development
We use Netsuite now for our CRM and need some help with setting up the below list in the system. • Integrate website leads into NetSuite ( with allocation permission remaining with the Sales Manager) our website is on a Shopify platform. • Manual entry of leads received from a direct call. • Visibility of the lead/deal journey • Ability to highlight hot jobs for the month over a certain $$ value. • Reporting matrix ( Spend less time reconciling spreadsheets and more time strategizing) • Set up templates for standard proposals, so that the sales team can add items out of the system and send out of the system.
16 days ago21 proposalsRemoteVirtual Assistant & Linkedin Management for Photography
My company, Gaia Visual, specialises in photography, video and training for organisations addressing environmental, social and humanitarian issues. I am looking for an organised and efficient person to help me: Essential: * Build my network on Linkedin - researching and connecting with target markets, interacting with them, posting my content etc. You need knowledge of Sales Navigator, Linkedin algorithm, excellent written English, and an understanding of sustainability and the issues Gaia Visual engages with. Desirable: * design posts and resources in Canva * create email automations * help me create processes and systems to increase efficiency * book-keeping admin including creating and updating spreadsheets * other ad-hoc admin Basically, I'm a creative person, and want to free up my time to do the things I'm good at, with the support of someone who 'gets' me, can help me stay organised and focussed, and has a passion and knowledge of for environmental and social issues Gaia Visual engages with. Thank you!
6 days ago17 proposalsRemotepre-funded
Search coverage of my work to look for most viral content
I would like someone to search Google and social media to capture the top examples of my work going viral. You'll need to look for not just people sharing the work from my account / website but also when the press writes stories about it and those go viral. Delivery will be links to the top coverage along with the key numbers in a spreadsheet, and a folder of screenshots of the examples showing the success (i.e. tweets which show the stats at the bottom). The aim is to prove that the public and press pick up my work and then the reach it has. I can supply the top ten pieces of work/stories to look for. I am expecting this to be a full day of work, and I'd like you to start soon after we confirm. Please put "I read the full ad" at the top of your reply or I'll assume it's bot-generated auto-apply and report it as spam (PPH is infested with AI bots!).
19 days ago23 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.
a month ago45 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
23 days ago72 proposalsRemoteopportunity
Develop a simple carbon caculator
Good morning , We are looking for a developer to develop a carbon caculator. The work is a fast turnaround and should be completed by 20th May. We have spreadsheets with back end data and formulas. It should be easily updated with new data available on the free data on Government website. This is just for scope one and two of caculator which is quite simple. The below link shows an example of what we need developing. We want to provide free access like Greenly. The final page can reveal the result. https://greenly.earth/en-gb?utm_term=carbon%20calculator&utm_campaign=1:+SN+%7C+2:+Acquisition+%7C+3:+Search+Generic+Carbon+UK+google+%7C+4:+UK&utm_source=adwords&utm_medium=ppc&hsa_acc=8929442750&hsa_cam=15453379597&hsa_grp=135745822249&hsa_ad=580573821047&hsa_src=g&hsa_tgt=aud-1962306165324:kwd-298447716438&hsa_kw=carbon%20calculator&hsa_mt=b&hsa_net=adwords&hsa_ver=3&gad_source=1&gclid=CjwKCAjwrvyxBhAbEiwAEg_KgnSACrRF3uny2vlBuN356Qmh-dECqos_KMuiSpCceY3wXEu1QQsJ-hoCoSoQAvD_BwE Here is a second example although we want it to look like Greenly. https://www.carbonfootprint.com/calculator.aspx The carbon caculator should be easily updated with new data published each year. This is the new data on the excel https://www.gov.uk/government/publications/greenhouse-gas-reporting-conversion-factors-2023 We can provide formulas. We need passwords and access when project is complete. Thanks, Luke
12 days ago45 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.
a month ago55 proposalsRemote
Past "Spreadsheet" Projects
opportunity
Scrape a Website for Products and populate spreadsheet
I need all the products scraping from the below categories in this site: https://www.jesuk.com/coffee-and-tea/coffee-brewing.html https://www.jesuk.com/coffee-and-tea/brewing-at-home.html https://www.jesuk.com/coffee-and-tea/teas-brewing.html https://www.jesuk.com/coffee-and-tea/hot-chocolate.html https://www.jesuk.com/coffee-and-tea/machines-grinders/bravilor-beverage-machines.html https://www.jesuk.com/coffee-and-tea/machines-grinders/grinders.html https://www.jesuk.com/coffee-and-tea/barista-kit.html https://www.jesuk.com/coffee-and-tea/cafe-essentials.html I also need all the products in the shop here: https://www.blueicecreammachine.co.uk/shop-online/ I have attached a spreadsheet with the fields I require populating: These fields are: SKU Product Section Display Name Description Google ID (Merchant Centre) RRP
Complete and File Company accounts to HMRC
Hi, I am looking for an accountant to complete my annual company accounts. I have an income and expenses spreadsheet ready. The accountant needs to have their own accounting software to file accounts. UK based accountants only. Many thanks, Anthony
urgent
Labor rate time log
I need a designer who can create an Excel spreadsheet based off of the labor rate sheet that I have attached. Using the same color scheme, logo and information I hand sketched something simple to give you an idea of what I'm looking for I need this project completed today.
opportunity
Power BI replication of excel spreadsheet
I need a replication of the attached xls into Power BI (columns K:AD). I would also like that the data feed will be automatic into Power BI from web query (https://www.youtube.com/watch?v=o5y0m4zF6VU) via a dynamic stock quote, I will scrape via Yahoo Finance. Thus, the data and statistic analysis will update for whichever stocks I maintain in the backtable/xls. In DoR worksheet, all cells in yellow will feed from the above scraping, the orange cells need to be calculated in the query. For the visual in BI, something close to layout in columns (K:AD) is needed - which includes some statistical calculations (formula shown in xls). Ideally I would be able to toggle between the 3 data sets within the same sheet i.e. calculated for i) close-close returns, ii)high-low returns and iii) open-close returns.
pre-funded
Simple DATA ENTRY on schools in Dubai
Hello. This is a pretty straightforward data-entry project. You will go a list of schools in Dubai, click on each school, open a Summary Report for the school like this one: https://web.khda.gov.ae/en/Education-Directory/Schools/School-Details?Id=273&CenterID=115 You will enter information about the total number of students, the number of Emirati children, and a couple of other categories. ...and also gather information about name of school, neighborhood, ranking, and a few other things about the school, all of which is readily available on the khda.gov.ae website for the school. You will enter this data on a total of about 110 schools into a Google Sheets spreadsheet that I will send you. I estimate the job will take about 4–5 hours. Before you start, I'll send you the spreadsheet and answer any questions you have. Thanks, Ryan