# Request from a non profit to create interface to export selected questions from Excel to word

**URL:** https://aikyam.discourse.group/t/request-from-a-non-profit-to-create-interface-to-export-selected-questions-from-excel-to-word/790
**Category:** docs
**Tags:** open-source, free
**Created:** [July 23, 2023, 6:11pm UTC](https://aikyam.discourse.group/t/request-from-a-non-profit-to-create-interface-to-export-selected-questions-from-excel-to-word/790 "2023-07-23T18:11:26Z")
**Posts on this page:** 9
**Page:** 1

<div class="post-metadata">

### Author: ![Pav321](https://avatars.discourse-cdn.com/v4/letter/p/d78d45/32.png) [@Pav321](https://aikyam.discourse.group/u/Pav321)
#### Post date: [July 23, 2023, 6:11pm UTC](https://aikyam.discourse.group/t/request-from-a-non-profit-to-create-interface-to-export-selected-questions-from-excel-to-word/790/1 "2023-07-23T18:11:26Z")

</div>

The science question bank created for the teachers are categorized based on sub concepts. The question bank will be made available to everyone. The teachers should be able to select their sub concepts of interest in Excel and later should be able to export it into a worksheet in MS word. Need help to create an interface for such an endeavour. Please help!

---

<div class="post-metadata">

### Author: ![GXCO](https://avatars.discourse-cdn.com/v4/letter/g/ee59a6/32.png) [@GXCO](https://aikyam.discourse.group/u/GXCO)
#### Post date: [July 23, 2023, 6:35pm UTC](https://aikyam.discourse.group/t/request-from-a-non-profit-to-create-interface-to-export-selected-questions-from-excel-to-word/790/2 "2023-07-23T18:35:07Z")

</div>

Hi,  
I think Mail merge feature should work. Depends if questions are fixed and if there are multiple types of questions. If questionnaire is complicated, VBA might be needed. If questions can be uploaded as a google sheet, then pdf can be created from questionnaire. Again, if questions are complicated in terms of type of answers, then AppScript can be used to create pdf documents. Let me know if I can be of help.

---

<div class="post-metadata">

### Author: ![Pav321](https://avatars.discourse-cdn.com/v4/letter/p/d78d45/32.png) [@Pav321](https://aikyam.discourse.group/u/Pav321)
#### Post date: [July 24, 2023, 7:24am UTC](https://aikyam.discourse.group/t/request-from-a-non-profit-to-create-interface-to-export-selected-questions-from-excel-to-word/790/3 "2023-07-24T07:24:49Z")

</div>

Thank you, we are starting off with multiple choice questions to begin with. But some of these questions have diagrams

---

<div class="post-metadata">

### Author: ![Pav321](https://avatars.discourse-cdn.com/v4/letter/p/d78d45/32.png) [@Pav321](https://aikyam.discourse.group/u/Pav321)
#### Post date: [July 24, 2023, 9:26am UTC](https://aikyam.discourse.group/t/request-from-a-non-profit-to-create-interface-to-export-selected-questions-from-excel-to-word/790/4 "2023-07-24T09:26:27Z")

</div>

Hi  
Here is the link for reference  
[https://docs.google.com/spreadsheets/d/1djQZpJ5sDqhixAtb2Wh2dIYVLXcPffYq/edit?usp=drivesdk&ouid=115216249178285861069&rtpof=true&sd=true](https://docs.google.com/spreadsheets/d/1djQZpJ5sDqhixAtb2Wh2dIYVLXcPffYq/edit?usp=drivesdk&ouid=115216249178285861069&rtpof=true&sd=true)

---

<div class="post-metadata">

### Author: ![GXCO](https://avatars.discourse-cdn.com/v4/letter/g/ee59a6/32.png) [@GXCO](https://aikyam.discourse.group/u/GXCO)
#### Post date: [July 24, 2023, 10:36am UTC](https://aikyam.discourse.group/t/request-from-a-non-profit-to-create-interface-to-export-selected-questions-from-excel-to-word/790/5 "2023-07-24T10:36:18Z")

</div>

Requested for access.

---

<div class="post-metadata">

### Author: ![answerquest](https://yyz2.discourse-cdn.com/free1/user_avatar/aikyam.discourse.group/answerquest/32/23_2.png) [@answerquest](https://aikyam.discourse.group/u/answerquest)
#### Post date: [July 24, 2023, 2:13pm UTC](https://aikyam.discourse.group/t/request-from-a-non-profit-to-create-interface-to-export-selected-questions-from-excel-to-word/790/6 "2023-07-24T14:13:43Z")

</div>

Hi Pavana, instead of Excel as the place where your user chooses the subtopics/questions, Would you be ok with a webpage having a table very similar to excel? See examples on: [https://tabulator.info/](https://tabulator.info/)

Why: Because that will shift the coding place and language from a more complicated Excel / google sheets, over to a proper web application backend where it’s much simpler to generate the desired output - word doc or PDF or other.

With this shift, you would also become free to bring lot more varieties to your questions’ structures. By hosting this on a web link, it’ll become possible for your target audience to access and use even if they don’t have paid version of MS Office, or do it from phone devices. You can keep updating and curating your question bank in the backend and they won’t have to re-download a new excel on every update.

---

<div class="post-metadata">

### Author: ![answerquest](https://yyz2.discourse-cdn.com/free1/user_avatar/aikyam.discourse.group/answerquest/32/23_2.png) [@answerquest](https://aikyam.discourse.group/u/answerquest)
#### Post date: [July 24, 2023, 2:16pm UTC](https://aikyam.discourse.group/t/request-from-a-non-profit-to-create-interface-to-export-selected-questions-from-excel-to-word/790/7 "2023-07-24T14:16:11Z")

</div>

separate alert: this is what this question page is looking like in the browser to me:

 ![image](https://global.discourse-cdn.com/free1/uploads/t4glabs/original/1X/e707b00de042dac4a2f4559c354737be123da8d9.jpeg)

Is it same for others? I’m not seeing this in other posts on this site, just here. Would it be possible to remove this image background or put some color background behind the text elements so one can read them?

---

<div class="post-metadata">

### Author: ![Pav321](https://avatars.discourse-cdn.com/v4/letter/p/d78d45/32.png) [@Pav321](https://aikyam.discourse.group/u/Pav321)
#### Post date: [July 24, 2023, 3:30pm UTC](https://aikyam.discourse.group/t/request-from-a-non-profit-to-create-interface-to-export-selected-questions-from-excel-to-word/790/8 "2023-07-24T15:30:07Z")

</div>

Hi  
Thank you for your reply. Can you help us set it up? Is it possible to get on a call.  
And sorry for the background. I didn’t select any, don’t know why it’s there and have no clue how to remove it.  
Thanks and regards  
Pavana

---

<div class="post-metadata">

### Author: ![answerquest](https://yyz2.discourse-cdn.com/free1/user_avatar/aikyam.discourse.group/answerquest/32/23_2.png) [@answerquest](https://aikyam.discourse.group/u/answerquest)
#### Post date: [July 26, 2023, 6:08pm UTC](https://aikyam.discourse.group/t/request-from-a-non-profit-to-create-interface-to-export-selected-questions-from-excel-to-word/790/9 "2023-07-26T18:08:26Z")

</div>

Hi Pavana. sure, you can reach me on nikhil (dot) js (at) gmail .
