--- title: "Separate Secondary Questions within Request Data Export" slug: "separate-secondary-questions-within-request-data-export" description: "Learn how to export and format secondary questions from request categories into separate columns using Excel." updated: 2026-04-06T16:38:22Z published: 2026-04-06T16:38:22Z canonical: "www.civicplus.help/separate-secondary-questions-within-request-data-export" --- > ## Documentation Index > Fetch the complete documentation index at: https://www.civicplus.help/llms.txt > Use this file to discover all available pages before exploring further. # Separate Secondary Questions within Request Data Export For categories with more than one secondary question, the export report combines them into one row. You can now separate the secondary questions in the report to make them easier to read. ## Instructions 1. [Sign in to your site](https://civicplus.us.document360.io/seeclickfix/docs/sign-in-to-seeclickfix-311-crm) if you have not done so already 2. Navigate to the **Requests** tab:![The CRM home page, with the Requests Tab highlighted.](https://cdn.us.document360.io/17dc564a-8310-4f61-b929-1bd73b36e158/Images/Documentation/Requests%20Tab%20-%20SCF.png?sv=2026-02-06&spr=https&st=2026-11-22T13%3A40%3A55Z&se=2026-11-22T14%3A40%3A55Z&sr=b&sp=r&sig=ksrv3ogbpubstSVPA%2FHzRScIm5f8AEsdtwO0hM88gBs%3D) 3. Navigate to the **Categories** field and select one **category** to view:![The Categories field of the Requests Tab.](https://cdn.us.document360.io/17dc564a-8310-4f61-b929-1bd73b36e158/Images/Documentation/Requests%20Tab%20Categories%20Field%20-%20SCF.png?sv=2026-02-06&spr=https&st=2026-11-22T13%3A40%3A55Z&se=2026-11-22T14%3A40%3A55Z&sr=b&sp=r&sig=yHlOB%2BeMPCQsF2A2DtIn8HbZVW4gagVnt2t0hU%2BKaqE%3D) 4. Select the **Export Requests** tab:![The home screen with the Export Requests button highlighted.](https://cdn.us.document360.io/17dc564a-8310-4f61-b929-1bd73b36e158/Images/Documentation/Export%20Requests%20-%20SCF.png?sv=2026-02-06&spr=https&st=2026-11-22T13%3A40%3A55Z&se=2026-11-22T14%3A40%3A55Z&sr=b&sp=r&sig=nRo5Yhg6VBsKn7dXPDuP9udfZn1hWWr4uNHH9qJTxc4%3D) 5. Select **Confirm**:![The Report Completion confirmation pop-up with the Confirm button highlighted.](https://cdn.us.document360.io/17dc564a-8310-4f61-b929-1bd73b36e158/Images/Documentation/Complete Report Confirmation Pop-up Confirm Button - SCF.png?sv=2026-02-06&spr=https&st=2026-11-22T13%3A40%3A55Z&se=2026-11-22T14%3A40%3A55Z&sr=b&sp=r&sig=1z3xLdwrIinb5XFBF3rlJeY0K5xum%2B4Z6%2B5Va%2BlHRZg%3D) 6. Select **Excel format (.XLSX)**, then click **Continue**:![The Exporting Data pop-up window with the Excel format (.xlsx) link and the Continue button highlighted.](https://cdn.us.document360.io/17dc564a-8310-4f61-b929-1bd73b36e158/Images/Documentation/Exporting%20Data%20Excel%20Format%20Continue%20Button%20-%20SCF.png?sv=2026-02-06&spr=https&st=2026-11-22T13%3A40%3A55Z&se=2026-11-22T14%3A40%3A55Z&sr=b&sp=r&sig=N44%2FeqgrbmP4tIFfDXwJ%2F0NbRj6wUwhHJslJuDh0R3U%3D) 7. Within the Excel spreadsheet, select **Find & Select**, then choose **Replace**:![An Excel spreadsheet with the Find & Select icon expanded and the Replace option highlighted.](https://cdn.us.document360.io/17dc564a-8310-4f61-b929-1bd73b36e158/Images/Documentation/Find%20and%20Select%20and%20Replace%20-%20SCF.png?sv=2026-02-06&spr=https&st=2026-11-22T13%3A40%3A55Z&se=2026-11-22T14%3A40%3A55Z&sr=b&sp=r&sig=bt4XRoz4MtKLig9IYo%2BchTCmvDnApInhjy0ptCutAeU%3D) 8. Search "**Q:**" and replace it with "**:**" then click **Replace All**:![The Find and Replace Screen with Q: being replaced by : and the Replace All button highlighted.](https://cdn.us.document360.io/17dc564a-8310-4f61-b929-1bd73b36e158/Images/Documentation/Find%20and%20Replace%20Q%20Replace%20All%20-%20SCF.png?sv=2026-02-06&spr=https&st=2026-11-22T13%3A40%3A55Z&se=2026-11-22T14%3A40%3A55Z&sr=b&sp=r&sig=5isAqKVxrrkdZDYKg3qnfN9wVA3Sy6Ay0GlEv8ghT4M%3D) 9. Search "**A:**" and replace it with "**:**" and then click **Replace All**:![The Find and Replace Screen with A: being replaced by : and the Replace All button highlighted.](https://cdn.us.document360.io/17dc564a-8310-4f61-b929-1bd73b36e158/Images/Documentation/Find%20and%20Replace%20A%20Replace%20All%20-%20SCF.png?sv=2026-02-06&spr=https&st=2026-11-22T13%3A40%3A55Z&se=2026-11-22T14%3A40%3A55Z&sr=b&sp=r&sig=LIETIjXTZ2ObDeDJu5myPX87QDKUIjrXeY3cku6HoLs%3D) 10. Highlight the **Secondary Questions** column (row R):![An Excel spreadsheet with the 'Secondary Questions' column (column R) highlighted.](https://cdn.us.document360.io/17dc564a-8310-4f61-b929-1bd73b36e158/Images/Documentation/Highlight%20Secondary%20Questions%20-%20SCF.png?sv=2026-02-06&spr=https&st=2026-11-22T13%3A40%3A55Z&se=2026-11-22T14%3A40%3A55Z&sr=b&sp=r&sig=xurIDVQiw55vad8ybesp2iuYyT7oFZ5ZwxLiHc6hHJA%3D) 11. Select the **Data** tab:![The Secondary Questions column selected and the Data tab highlighted.](https://cdn.us.document360.io/17dc564a-8310-4f61-b929-1bd73b36e158/Images/Documentation/Secondary%20Questions%20Data%20Tab%20-%20SCF.png?sv=2026-02-06&spr=https&st=2026-11-22T13%3A40%3A55Z&se=2026-11-22T14%3A40%3A55Z&sr=b&sp=r&sig=QPJNK4pIZLEJAfTUN4dG3KKtJ%2FgrEfrxN%2FmV0c2XKww%3D) 12. Click **Text to Columns**:![The Secondary Questions column (column R) selected, on the Data tab with the Text to Columns button highlighted.](https://cdn.us.document360.io/17dc564a-8310-4f61-b929-1bd73b36e158/Images/Documentation/Secondary%20Questions%20Text%20to%20Columns%20-%20SCF.png?sv=2026-02-06&spr=https&st=2026-11-22T13%3A40%3A55Z&se=2026-11-22T14%3A40%3A55Z&sr=b&sp=r&sig=shnAJ%2B4Pyag0XERDdpsZ%2FYtRCW32DBfductjcOVb5YQ%3D) 13. Select the **Delimited** option, then click **Next**:![The Text to Columns pop-up window with the Delimited option and the Next button highlighted.](https://cdn.us.document360.io/17dc564a-8310-4f61-b929-1bd73b36e158/Images/Documentation/Text%20to%20Columns%20Delimited%20Next%20-%20SCF.png?sv=2026-02-06&spr=https&st=2026-11-22T13%3A40%3A55Z&se=2026-11-22T14%3A40%3A55Z&sr=b&sp=r&sig=QbhyycJ803mUPW3vPkmMcm5VDzxULVpjGhto4qMSOb0%3D) 14. Select the "**Other**" option under Delimiter and enter "**:**" in the blank space, then click **Next**:![An Excel spreadsheet in the Convert Text to Columns Wizard pop-up window with the Other option selected and a : filled in.](https://cdn.us.document360.io/17dc564a-8310-4f61-b929-1bd73b36e158/Images/Documentation/Delimiter%20Other%20Next%20-%20SCF.png?sv=2026-02-06&spr=https&st=2026-11-22T13%3A40%3A55Z&se=2026-11-22T14%3A40%3A55Z&sr=b&sp=r&sig=NLhz7qT4zbtLY2x5CBrqmpS0nJt7njS3GZ4aU%2BAxiBc%3D) > [!WARNING] > Note: > > This will write over any columns to the right of the column you are working in, so be sure you are okay with that data being cleared. If not, move the Column to the last column to the right so it's all blank fields that it writes over. 15. Click **Finish**:![The Convert Text to Columns Wizard pop-up window with the Finish button highlighted.](https://cdn.us.document360.io/17dc564a-8310-4f61-b929-1bd73b36e158/Images/Documentation/Text%20to%20Columns%20Finish%20-%20SCF.png?sv=2026-02-06&spr=https&st=2026-11-22T13%3A40%3A55Z&se=2026-11-22T14%3A40%3A55Z&sr=b&sp=r&sig=Zu%2FBcw%2B1EVt%2FzE%2BMjNg7v8smBtjRTKoN40cSZ5WUVYY%3D) Excel Open XML Format Spreadsheet.