Remote Web Development Job In IT And Programming

Extract data from Google Sheet to Excel workbook

Find more Web Development remote jobs posted recently Worldwide

We have a Google Sheet that contains 4 sheets of data.
We need the data on the 4 sheets to be exported to an Excel workbook when required

For this project we require
An Excel workbook to be created that can access a Google Sheet
A button created with appropriate routines to export data from a series of Sheets.
That exported data is to be placed on to an Excel sheet in the Excel workbook.

It is expected that we will be able to specify somewhere in the Excel workbook the following
The Sheet ID for the google Sheet
The names of the Sheets in the Google sheet to copy data from

Please only respond to this job if you have some skill and knowledge with regards to the processing that will be required to implement the Google Oauth 2 code that can enable the access to the Google Sheet.

During the interview stage for this job I will provide a test Google Sheet so that you can assess where the data will be sourced from for the extract.
About the recuiter
Member since Sep 29, 2017
Ajay B.
from Abu Dhabi, United Arab Emirates

Skills & Expertise Required

Excel VBA Google Docs Google Spreadsheets Microsoft Excel VBA 
Candidate shortlisted and hiredHiring open till - Dec 31, 2021

Work from Anywhere

40 hrs / week

Hourly Type

Remote Job

$12.51

Cost

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions

Similar Projects

Are looking for a car expert who is familiar with the model series of the Audi brand.

Hello dear freelancers,
We need a list of Audi sports models for a sound library. It is important that different generations are involved. It is particularly interesting how the sound of the S5 (etc.) has developed over the years, which is why th...read more

Bali Villa Research (Sales and Rental Prices for Seminyak, Sanur and Canggu)

Through online reseach, provide detailed list of 3, 4 and 5 bedroom villas in Canggu, Seminyak and Sanur that are currently for rental or sale. Provide a detailed list of location, size, bedrooms, bathrooms and more.

Using sources such as A...read more

Recover Unsaved Excel file on my Macbook.

Excel crashed and I am having difficulty recovering the file. All I have is the previous version of the file the day before it crashed. I had done a lot of work since the last saved version. I can give team viewer access.

Executive Assistant to CEO Needed for Growing Brand

Were looking for a remote executive assistant to assist the owner of our company located on the East Coast.

Here are a few examples from the past month that would fall under your role:
- Booking travel for owner (hotels and flights)read more

Create a revenue dashboard in Google Data Studio using first interaction model from GA

Hello

Im struggling to create a dashboard in GDS with the revenue from paid search but with model first interaction (last is by default).

I would be glad if you show me the solution :)