Bulk Google Sheets to Excel Transfer -- 2

₹12500-37500 INR

Posted 1 minute ago

•

Ends in 6 days

₹12500-37500 INR

Paid on delivery

I need help pulling data out of a large collection of Google Sheets and dropping it into Excel just once, no ongoing sync required. There are many individual Sheets scattered across my Drive; each belongs to a specific topic or lives inside a themed folder. Your task is to fetch every Sheet, group them by that topic or folder, and then merge the rows for each group into a single .xlsx workbook. In the end I should receive one Excel file per topic/folder, each reflecting the full, current content of its matching Google Sheets. You are free to use the Google Sheets API, Apps Script, Python, Power Query, or any other reliable method—as long as the final Excel workbooks open cleanly in the latest desktop version of Microsoft Excel with formulas converted to values where needed. Deliverables • One Excel file for every identified topic/folder, fully populated and saved locally • A short note explaining the method you used so I can repeat it later if necessary If this sounds clear and straightforward, let me know your estimated turnaround and any access you’ll need. Bid only eligible client. Thanks.

Project ID: 40811216

About the project

5 proposals

Open for bidding

Remote project

Active 3 secs ago

Place your bid

Bid amount Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

It's free to sign up and bid on jobs

5 freelancers are bidding on average ₹17,500 INR for this job

User Avatar
Flag of INDIA

Merging your scattered Google Sheets into one Excel workbook per topic/folder, delivered once with no ongoing sync — that is exactly what I do here. My execution plan: Sheet Discovery: I will authenticate against your Drive using the Google Drive API to enumerate every Sheet automatically, grouping by folder structure so nothing is missed and no manual hunting is needed. Data Extraction: I will pull each Sheet's full content via gspread and Pandas. I am choosing gspread specifically because it handles quota limits gracefully across large Drive collections — a common failure point when pulling many Sheets in one pass. Workbook Assembly: I will write each topic-grouped dataset into its own .xlsx using openpyxl, with formulas converted to static values so nothing breaks when you open the files in desktop Excel. Repeatability Guide: A short plain-English note documenting the exact method and credentials needed so you can repeat this yourself later. One problem worth flagging: if any Sheets contain cross-sheet formula references pulling from outside their own folder group, converting to values will silently drop that linked data. I will flag every instance before finalising. Delivery in 3 days. One question: are all the Sheets accessible under a single Google account, or will some require separate access grants from different owners?

User Avatar
Flag of VIETNAM

Hello, Van Hieu here One important point: Google Sheets can contain formulas, formatting, and hidden tabs that may not transfer correctly through a basic export. Handling these consistently prevents missing data and unreliable Excel files. How I would do it: 1. Map Drive folders and identify every relevant Google Sheet. 2. Group files by topic and folder structure. 3. Extract all tabs while preserving row and column alignment. 4. Merge matching data and convert formulas into values. 5. Validate record counts and check each Excel workbook. You get one complete, clean .xlsx file per topic, plus a short guide explaining how to repeat the process. I have 10 years of experience and 100+ completed projects. My data processing and automation experience helps me handle large collections efficiently while reducing manual errors. I can start with one folder as a first milestone so you can check the results before proceeding with the full transfer. Approximately how many Google Sheets are in your Drive, and are any of them restricted by individual sharing permissions? I am looking forward to working with you.

User Avatar
Flag of GERMANY

One Excel workbook per Drive folder, with every Sheet in that folder merged in and formulas turned into plain values, is what you'd get back. I'd read the folders through the Drive and Sheets API with view-only access, so nothing in your Drive gets changed. Each merged workbook gets a source column with the original Sheet name, so any row can be traced back. I then compare row counts and column totals against the originals and check that the files open cleanly in desktop Excel. A short step-by-step note comes with it so you can repeat the process later. Quick question: do the Sheets inside a folder share the same column layout, or do some differ? And roughly how many Sheets and rows are we talking about? For access, view-only sharing of the top folder with a Google account I'll send you is enough. I'm happy to run one folder first as a sample. Moritz

User Avatar
Flag of SERBIA

Hello, "Bulk Google Sheets to Excel Transfer" - you need a clean, one-time migration that preserves the folder and topic structure while combining related spreadsheets into usable Excel workbooks. I'll use Python and the Google Sheets API or an authorized export method to identify the source sheets, group them by their Drive folders or topics, and merge their data into separate .xlsx files. I'll also check column consistency, handle formulas appropriately, preserve useful formatting where possible, and validate that each workbook opens correctly in desktop Excel. I'll manage the extraction, consolidation, and final checks personally. Can you provide access to the relevant Google Drive folders, and should sheets with different column structures be merged using a unified set of columns? Looking forward to working with you. Aleksandar Nastic

User Avatar
Flag of INDIA

can start right now I have checked the details. I can write a quick Python script using the Google Sheets API to recursively scan your Drive, group the scattered sheets by their parent folder structure, merge the rows, and export clean .xlsx files with formulas converted to values. Quick question: are the folder structures nested deeply, or is it just one parent folder containing the topic subfolders? I can have all the topic workbooks delivered to you along with the brief documentation note by tomorrow. Let's do it.

内容来自 Freelancer News,版权归原作者所有。

阅读原文 ↗

把喜欢的内容,留在你的新标签页。

打开我的订阅