# How to upload bulk question answers?
**URL:** https://meta.discourse.org/t/how-to-upload-bulk-question-answers/104396
**Category:** Support
**Created:** [12월 16, 2018, 4:13오전 UTC](https://meta.discourse.org/t/how-to-upload-bulk-question-answers/104396 "2018-12-16T04:13:37Z")
**Posts on this page:** 12
**Page:** 1
### Author:  [@ProThoughts](https://meta.discourse.org/u/ProThoughts)
#### Post date: [12월 16, 2018, 4:13오전 UTC](https://meta.discourse.org/t/how-to-upload-bulk-question-answers/104396/1 "2018-12-16T04:13:38Z")
I do have questions and answers in xls, how to upload this to newly setup forum?
thanks!
---
### Author:  [@chumstick](https://meta.discourse.org/u/chumstick)
#### Post date: [12월 16, 2018, 4:26오전 UTC](https://meta.discourse.org/t/how-to-upload-bulk-question-answers/104396/2 "2018-12-16T04:26:18Z")
What do you mean upload them?
Do you mean upload them to a post? If so, are you trying to attach them, or make the contents of the XLS the contents of the post?
Are you trying to make them the FAQ section of the site?
I have a feeling whatever you’re wanting to do would be fairly simple but I just don’t understand what your desired result is.
---
### Author:  [@ProThoughts](https://meta.discourse.org/u/ProThoughts)
#### Post date: [12월 16, 2018, 5:14오전 UTC](https://meta.discourse.org/t/how-to-upload-bulk-question-answers/104396/3 "2018-12-16T05:14:43Z")
Lucas, Thanks for the quick reply. I wrote 2000 question and answer in xls and would like to post those on my discourse forum, please let me know if there any ways to import.
If visitor comes to my forum they will at least see these 2k posts on sites.
---
### Author:  [@chumstick](https://meta.discourse.org/u/chumstick)
#### Post date: [12월 16, 2018, 5:22오전 UTC](https://meta.discourse.org/t/how-to-upload-bulk-question-answers/104396/4 "2018-12-16T05:22:10Z")
Oh. You’d like to import these Q/A’s as separate _topics_? Or post them to a single, very long, general Q/A topic? Can you provide a sample row or two from your spreadsheet?
---
### Author:  [@ProThoughts](https://meta.discourse.org/u/ProThoughts)
#### Post date: [12월 16, 2018, 5:58오전 UTC](https://meta.discourse.org/t/how-to-upload-bulk-question-answers/104396/5 "2018-12-16T05:58:59Z")
Yes, I would like to import these Q&A as a separate topics.
example:
question: What is cloud server?
Answer: A _cloud server_ is a virtual server (rather than a physical server) running in a cloud computing environment. It is built, hosted and delivered via a cloud computing platform via the internet, and can be accessed remotely. They are also known as virtual servers.
Question: What is Amazon AWS?
Answer: _Amazon Web Services_ . _Amazon Web Services_ ( _AWS_ ) is a secure cloud services platform, offering compute power, database storage, content delivery and other functionality to help businesses scale and grow.
---
### Author:  [@chumstick](https://meta.discourse.org/u/chumstick)
#### Post date: [12월 16, 2018, 6:07오전 UTC](https://meta.discourse.org/t/how-to-upload-bulk-question-answers/104396/6 "2018-12-16T06:07:41Z")
I’ll keep my personal thoughts regarding how having 2000+ individual topics dedicated to single questions may be a bad idea to myself for now.
I see two possible ways of accomplishing your goal. One would be to convert your spreadsheet to a CSV and then use the API and some shell scripting to loop through the file creating a new post for every line.
Another way could be to set up “Allow posting from email” and then use Excel’s “Mail Merge” feature to email every q/A to Discourse, creating a new topic.
---
### Author:  [@ProThoughts](https://meta.discourse.org/u/ProThoughts)
#### Post date: [12월 16, 2018, 6:11오전 UTC](https://meta.discourse.org/t/how-to-upload-bulk-question-answers/104396/7 "2018-12-16T06:11:18Z")
Ok, could you please point me to API documentation for posting.
---
### Author:  [@chumstick](https://meta.discourse.org/u/chumstick)
#### Post date: [12월 16, 2018, 6:13오전 UTC](https://meta.discourse.org/t/how-to-upload-bulk-question-answers/104396/8 "2018-12-16T06:13:30Z")
> **[Discourse API Docs](https://docs.discourse.org)**
Here you go! Best of luck!
---
### Author:  [@ProThoughts](https://meta.discourse.org/u/ProThoughts)
#### Post date: [12월 16, 2018, 6:23오전 UTC](https://meta.discourse.org/t/how-to-upload-bulk-question-answers/104396/9 "2018-12-16T06:23:13Z")
thank you! appreciate you help.
---
### Author:  [@Remah](https://meta.discourse.org/u/Remah)
#### Post date: [12월 16, 2018, 7:39오전 UTC](https://meta.discourse.org/t/how-to-upload-bulk-question-answers/104396/10 "2018-12-16T07:39:55Z")
The idea of preloading a lot of topics has been presented here before. I remember one topic that was particularly relevant but I couldn’t find it so maybe I read it on another website like [Feverbee](https://experts.feverbee.com/latest)
> [@chumstick](#):
>
> I’ll keep my personal thoughts regarding how having 2000+ individual topics dedicated to single questions may be a bad idea to myself for now.
While @chumstick has chosen not to comment, I’d be reluctant to start a new forum with a lot of simple Q&A tpics. Gathering a core group of enthusiastic users would probably be a better option to encourage interaction.
Anyway,you can ignore what I say but I’m also wondering if you’ve read any of the helpful topics on starting a Discourse forum:
Blog posts on building a Discourse community
> **[Building a Discourse Community](https://blog.discourse.org/2014/08/building-a-discourse-community/)**
>
> Sure, anyone can set up their very own Discourse in 30 minutes or less. But how do you get people to go there?
> **[Launching a Successful Discourse Community](https://blog.discourse.org/2018/08/launching-a-successful-discourse-community/)**
>
> While we’ve offered general tips for building a Discourse community, we also get a lot of questions about what specifically you can do to help launch a successful Discourse community.
Other topics on kick-starting and seeding (creating topics and users) a new forum:
> [@How to kick start a community?](https://meta.discourse.org/t/how-to-kick-start-a-community/51295/2):
>
> Here’s the advice we give to customers when they sign up: Here are some tips for launching a successful discussion community: What is the “elevator pitch” for your community? The first thing people will ask: what is this place? How would you describe your community to someone you just met in a 60 second elevator ride? Post that as a topic, then pin it or make it a banner via the wrench menu on the topic. Build some interesting discussions to launch with What comes up often in interna…
> [@Dummy user to create initial content](https://meta.discourse.org/t/dummy-user-to-create-initial-content/83896):
>
> We just installed Discourse in our company and started to show it to people. Of course we need content to convince them to move conversations to Discourse, to do this we need to put more content. My idea was to copy some of the questions I saw today in one of our chatroom to Discourse, but I didn’t want to post them with my user (it will look weird). Is there a way to create a dummy user, like admin or Discobot, and impersonate it to post questions and answers? Anyway we are also using Google…
> [@Seeding a new forum by creating users and content](https://meta.discourse.org/t/seeding-a-new-forum-by-creating-users-and-content/49345):
>
> Hi there Discourse looks amazing. Wow! A big change from my old days using phpbb. In the past, admittedly a long time ago now, I’ve had greater success starting new forums by initially seeding some content. A little social proof does wonders for engagement levels! Would love to know whether it is possible to seed a new discourse forum. What I’d like to do is to create say 200 user accounts and roughly 1000 topics and replies before launching. Is it possible to do this without having either 2…
> [@What Strategy Should I Use To Make My Community Active](https://meta.discourse.org/t/what-strategy-should-i-use-to-make-my-community-active/70415):
>
> I created a forum. People are joining that forum but they are no engaging with the forum. Means they only read post but never reply and due to this forum quality is going off. What strategy should I implement, so that people starts replying of the topics also and start sharing their view regarding this. Forum Topics are - Science,Economics And Politics
---
### Author:  [@ProThoughts](https://meta.discourse.org/u/ProThoughts)
#### Post date: [12월 18, 2018, 3:53오전 UTC](https://meta.discourse.org/t/how-to-upload-bulk-question-answers/104396/11 "2018-12-18T03:53:34Z")
Thanks Remah! I will check all these links
---
### Author:  [@system](https://meta.discourse.org/u/system)
#### Post date: [1월 17, 2019, 3:55오전 UTC](https://meta.discourse.org/t/how-to-upload-bulk-question-answers/104396/12 "2019-01-17T03:55:03Z")
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.