Troubleshooting

Formatting the line breaks in Excel exports

Excel exports inherit their formatting from the Content Library, so the formatting you see reflects the line breaks stored in your Content Library answers. If your paragraphs currently run together but you want a blank line between them, we recommend applying the proper formatting to the Content Library answers themselves before exporting your content rather than editing each Excel manually file after export.

As a best practice, update a small amount of Q&A pairs then export the sample to Excel to ensure you get the desired result. If so, apply to the remaining content; if not, adjust and retest.

1. Do one of the following:

   • If only a few answers are affected you can edit them individually:

     1. Go to the Content Library and open the Q&A pair.

     2. In the answer editor, place your cursor at the end of each paragraph where a single return currently sits.

     3. Add a second return so there is one blank line between paragraphs, then save the Q&A pair.

   • If many answers across your library are affected, use the Bulk Format tool:

     1. Go to the Content Library and select the Q&A pairs you want to update.

     2. Use the Format Text tool from the Content Library menu to apply the second return formatting change in bulk, then save the changes.

2. Turn on Wrap Text in Excel (Home > Alignment > Wrap Text) so the blank line between paragraphs is visible.

3. Re-export to Excel and confirm the blank line now appears between paragraphs (with Wrap Text on).

The Keep Source Formatting option adds bullet points when copy and pasting tables from Word documents

When pasting a table or other content from the Content Library into Word documents, the edits may not take since the Keep Source Formatting behavior is controlled by the local Microsoft Word paste configuration setting on your machine, not Responsive. To resolve this:

• Check your Word paste settings by going to File > Options > Advanced > Cut, copy, and paste, set then change the Pasting between documents and Pasting from other programs options to Keep Source Formatting, then click OK and retry your paste.

• If bullet points are still being added, you can use Ctrl+V instead, or use the Apply Answer option in LookUp (the icon next to the Copy option) — both insert the table correctly and serve as reliable workarounds. Since this behavior is controlled at the Word/desktop level, we also recommend raising it with your internal IT team so they can review the Word paste settings and any organization-level Office policies.