How to Transfer data from Excel to Google Sheets || How to connect Excel and Google Sheet
HTML-код
- Опубликовано: 16 июл 2024
- How to Transfer data from Excel to Google Sheets: 8 Simple steps
Welcome to Tech Sessions!
Need to move your data from Excel to Google Sheets? In this video, we’ll guide you through the process of transferring data seamlessly between these two popular spreadsheet tools.
Key Learnings:
How to transfer data from Excel to Google Sheet
Prerequisites
Importing Excel data into Google Sheets
Formatting tips for a smooth transfer
Maintaining data integrity during the transfer
Troubleshooting common issues
Timestamps:
0:00 Introduction
0:20 Prerequisites
0:41 Step 1 - Add reference
1:11 Step 2 - Creating VBA Userform
3:58 Step 3 - Create Google Sheet
4:53 Step 4 - Create Google Form
7:48 Step 5 - Link Google Form and Google Sheet
9:08 Step 6 - Get Prefilled Link
10:11 Step 7 - Modify Prefilled Link
11:26 Step 8 - Create Macro
Download File:
Version 1:
drive.google.com/file/d/1goRY...
Version 2. It includes code to check Internet Connection first.
drive.google.com/file/d/1tTsW...
How to create VBA User Form (Part-1):
• VBA Session - Creating...
How to create VBA User Form (Part-2):
• VBA Session #7 - User...
Subscribe for more Excel tutorials and tips:
ruclips.net/user/excelsessio...
Follow us for updates:
Facebook: profile.php?...
Linked-In: / saurabhjain-it
Support us:
If you found this tutorial helpful, please like, share, and subscribe for more practical Excel insights!
Questions or suggestions?
Drop them in the comments below. We're here to help!
Thank you for watching, and happy Excel-ing!
Sir salute you and i am happy that god gives me a teacher like you..❤
Thanks a lot. Your words made my day.
@@SessionsbySaurabh welcome sir always.🙏
@@SessionsbySaurabh sir aapse sikhkr maine isme aur kuch bhi add kiya hai. Jab hum data add krte hai to sath me excel file ke TABLE RANGE me bhi data add hota hai many time people scared about data loss, thats why i added the thing for data maintain. Bs ab UPDATE AND DELETE function add krna hai so aur bhi acha perform kr sake ye process.
valuable information. Thank you sir
Thanks
Thanks bro
Excellent!!!!
Thanks
Excellent! a very good tutorial indeed!!
Thanks Rashid.
Nice
Thanks Om.
sir I have an excel sheet which import data from another database I want it to automatically get submitted to Google sheet as soon as excel sync with database how can I
sir please how to only sync excel sheet to google sheet
Hi sir I tried same as you shown but I am getting error in username=.txtusername
It's showing object required
Thanks, i want you show how edit a single line
Hi Yaw, thanks for your comment. Please elaborate your query.
@@SessionsbySaurabhAfter import from excel, i want stay on excel and Select a row in google sheets and modify from excel
If the Internet gets disconnect while updating n entry will the entry will be updated to Google sheet as soon as the internet is connected
Haven't faced this issue but as per me it would not update.
How to transfer without user form
Is there a way to directly transmit any letter or word that I write in any cell?
Instead of using User form field name, use Excel Cell reference. Check below.
name = Sheets("Sheet1").Range("B2")
desig = Sheets("Sheet1").Range("B3")
URL_firstpart = "docs.google.com/forms/d/e/1FAIpQLSdI_se_iGLg8ezTVAKt7rqKWDzdJ2Bp0ep7nXgaTbDsLyYRhw/formResponse?ifq"
url_secpart = "&entry.1629020134=" & name & "&entry.385413323=" & desig & "&submit=Submit"
Hello Sir, is it workable in android mobile?
Hi Auntor, I haven't checked on Android. Any observation from your side ?
how to transfer data excel to googlesheet not used VBA...??? thanks
We used power query in this video. From excel to Google Sheets we have to use Google API.
Sir , without internet the code debug , please solved this . I would be very grateful if you could solve this problem please.
Are you saying the code go into debug mode?
I have uploaded another file which checks the Internet Connection first. Download the file from : drive.google.com/file/d/1tTsWJTr8v8kbzT9g_iMPPPW0pERlEYN6/view?usp=sharing
How to automatically update Google sheet form Excel sheet data
I haven't tried but you can check Google sheets API to update data.
What do you think is causing that Excel sends the info to Google Sheets but when I check in Google Sheets all the boxes are blank except for the timestamp box?
Don't worry. I got it. I missed the dots in the "With frmProductSurvey" entries.
Great. Thanks for confirming.
why give me ( CHECK INTERNET CONNECTION ) ? WHAT'S RONG
Need to check the code. Email your sheet if you can.
Now code working but the MSG box check internet connection showing data is not entering please help
Hi Kailash, can you please share the sheet.
@@SessionsbySaurabh sir now it's working fine due to some mistakes it was not working but i corrected that mistakes after watching video carefully
Thanks you again
@@kailashsoni676 great.
@@SessionsbySaurabh 😊