วีดีโอ

opening a pop-up and yet nothing appearing in it, sounds more like a network issue to me. Pl ensure that you have a strong internet before proceeding. Hope that helps.

@@smitharenny3892 actually net bandwidth and connection strong is enough, but i think that xls file is too complicated to convert for forms. Because of it contains macros. What You think?

@@zafercebeci oh ok... Maybe

Pl tell me sir... I'll try my best to be of help!

Thank you Ruy

then you'll have to add them separately after the firm is created

Thank you... Do reveal your identity on chat 😊

@PhenomenaL so are you too, one of my students? 😁

@@smitharenny3892 Present mam, me too😄

Thank you sir 🙏

When you come to the section on Select pattern, opt for Q&As Then in the sub-section, Type at column, specify your question type...

Thank you Prerna ❤️

Unfortunately Sreelatha, that won't happen. You'll have to redo them process every time you update the Excel sheet :) Hope that helps. Do subscribe👍

Been looking for the same thing :'(

@@RachelPun it's a tansfer that happens with the data available at that moment. So any future changes will not automatically move to the form.

Sorry I couldn't understand your doubt.

I have existing sheet which contains some point and I will check it and update it on daily basis so I will have date column and by using Google form i will update my sheet on daily basis and data will be fillup in date column daily .So pls guide ..

No Amit. Sorry to disappoint you regarding this. No free ad in this regard. If you want to continue, you'll have to actually pay for the subscription..🙏🙏 In fact Google has reduced it to 50 now. Earlier it used to be 80.

That's because now Google has reduced the number of questions that you can freely convert from Excel to Google forms. Earlier you could convert 80 questions in a month freely, now you can convert only 50 questions in a month in the free version. However, with a paid subscription, you can convert more questions. Hope this was helpful to you. 🙏

Thank you so much ma'am for such sharing valuable information

Of course I do! Hope you're doing well!

@@smitharenny3892 👍

Thank you dear

Thank you Sandhya ma'am🙏

Thanks sir🙏🙏

Thank you ma'am🙏

Glad to know that! Do subscribe :)

Do watch my other videos for more helpful knowledge 👍

​@@smitharenny3892 Smitha, I am trying this in very large enrollment classes (200+), and using student ID numbers rather than email addresses. This week was the first class, but I wanted to see if it was working. Student responses are nicely imported into the spreadsheet, but on the tallying sheet, I get only zeroes in column C. My formula is: =SUMPRODUCT(COUNTIF(INDIRECT("'"&A$1:A$14&"'!B$1:B$271"),B1)) Do you have any idea why it might not be working? Thank you in advance for any guidance you can offer.

Hi Rachel will you please mail me the sheet at computersmadeeazy@gmail.com? I'll look into it.

That's strange. Pl try and use Google Chrome for opening Gmail ma'am... Let me know please...

Also what error are you getting?

Are you using a new Gmail id?

@@smitharenny3892 form builder only allows 50 qnos. pl. explain without using form builder

It's s Chrome extension, so please use Google Chrome browser. Hope that helps.

Thank you sir!

For every question paper that you want to create, select the specific questions while creating the Google form. Hope this helps

Since we can't fix images to cells as content of the cell, this method won't support adding images to forms from Excel/G. Sheets. You may have to go individually to each question in order to add an image.

Ok thanks

They do come... I've demonstrated that to you. In case you're not getting, there must be something amiss. Do share the complete issue and maybe I'll be able to help you.

@@smitharenny3892 thank you so much for replying. Explaining the elaborate process here may be difficult. The questions come. But they are not selected as multiple choice despite making an extra column. And nor do the multiple options get registered along with the correct ones. So only the questions get transferred. I tried multiple times, checking- rechecking. Not working out for me :( would have been such a time saver

@@ahanasharma4784 you need to have an extra column which contains the correct option... Not the option number. Maybe that's where is going wrong. Eg. If Trump is the correct answer, ensure that your answer column has the word Trump not the column number or chronology. Also ensure the correct answer you've mentioned is the same text as mentioned in the options(spellings, case etc) I have made several qps in the same manner. I'm sure you will be able to too!

Pl contact the teachers of your class for this.

Thanks Ruby

Thank you ma'am

Thank you sir!