I have a large (160MB) and complex Excel spreadsheet, too large to open in Excel Online. I would like to sync the values (not formulae) from this spreadsheet to an identical Google Sheet on a regular basis. Looking for suggestions about how to do this efficiently please. Can I upload it to Pabbly for example?
-
Instructions to Ask a Question
Click on the "Ask a Question" button and select the application for which you would like to ask questions.
We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.
The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!
🚀🚀Exclusive Discount Offer
Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) - View offer
🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer
-
Sync a large Excel file with Google Sheets
- Thread starter GaryT
- Start date
Hello @GaryT,
To assist you better, could you please confirm your requirement:
To assist you better, could you please confirm your requirement:
- Do you want to transfer all the data from the Excel file to Google Sheets each time?
OR - Would you like to only sync the new rows added to the Excel file into Google Sheets going forward?
Hi Preeti, thanks for seeking confirmation. I would like to update all the NEW data. On some tabs this is only the new rows, but on other tabs the new data may be anywhere in the sheet.
For context, I currently have an API sync between Google Sheets and Active Campaign CRM which is working well. Currently I'm importing all my contact and transaction data from various sources into Excel and have formulae that produce totals and other contact personalisation information in other tabs. I then copy/paste these calculated sheets into Google Sheets so that it syncs to my CRM. This copy/paste process is laborious and liable to human error, so I'm looking for a way to automate this. I appreciate any suggestions or potential solutions.
For context, I currently have an API sync between Google Sheets and Active Campaign CRM which is working well. Currently I'm importing all my contact and transaction data from various sources into Excel and have formulae that produce totals and other contact personalisation information in other tabs. I then copy/paste these calculated sheets into Google Sheets so that it syncs to my CRM. This copy/paste process is laborious and liable to human error, so I'm looking for a way to automate this. I appreciate any suggestions or potential solutions.
Please check out the video shared below:
