I have a small project. I have many files, each file has 20-25 multiple choice test questions. I need these to be put into spreadsheets (google sheets) . For each spreadsheet I need 10 questions from different files to be placed in the spreadsheet. The project will take around 55-60 hours.
Here is a video of what I need done specifically.
[login to view URL]
Here are the steps need to be completed.
-Open all "changed" files from one set (B1),(B2),(B3),(I1), (I2), (I3), (A1)
Open "Template Spreadsheet" in Google Sheets
Cut and Paste the question name/title “MCQuestionBankB1_3(1)” to the QuestionID cell in the google sheets
Cut and paste the question into the cell titled "Question1"
Cut and Paste the answer choices to the cells in the columns titled Answer A 1, Answer B 1, Answer C 1, Answer D 1
Open another "changed" file from the set and repeat the process
Cut and Paste the question ID, question and answers into the cells in the columns titled QuestionID 2, Question 2, Answer A 2, Answer B 2, Answer C 2, Answer D 2
Repeat this process for 10 questions. Each question should be from a different "changed" file
When finished, change the spreadsheet name to "Final+FileSetName+1". For example "FinalB1_1", FinalB1_2", "FinalB1_3", ect.
Download the spreadsheet as a CSV file
After you finish all the spreadsheets (around 120) go to [login to view URL]
In Step 1: Click "Choose File" and select the CSV file you saved from Google Sheets
In Step 5: go to "Save your result" and add the name of the CSV file, (FinalB1_1)
Go to the button "Download Result", click it and download the new json file
Do this for all CSV files
Hello sir, As we have discussed all things on chat. Please award this project to me and i will deliver on time and in budget all files. Thanks Ruchi
134 pekerja bebas membida secara purata $136 untuk pekerjaan ini
Hi there, I am highly interested for this project, I am expert in data entry work, I can put questions & options into spreadsheets. Can we talk??? thanks
Hello Sir Im excel VBA macro and formula Expert im familiar in google sheet and i love doing data entry like this project Sir please ping me for discuss mroe and im able to start working right now Thank you Galih
Hi! I read the project and understand it, I have watched video as well and I am sure I can do it with 100% accuracy, I can give you quick sample too, Looking forward for your positive response. Thanks.
Understood, Need to enter multiple choice questions into the spreadsheet and convert into json file. Can start immediately and get this done with complete attention to details.
Hey there, I am data entry and data scraping expert. I am ready to start now and ready to give you sample file. Look forward to hearing from you. Thanks
Hello, I've watched the tutorial video and totally understood the project requirement. My bid is final cost of this project. Feel free to contact. Thanks! Junaid U