Can't Export Responses

%3CLINGO-SUB%20id%3D%22lingo-sub-1430768%22%20slang%3D%22en-US%22%3ECan't%20Export%20Responses%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1430768%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20survey%20with%20several%20thousand%20responses%2C%20and%20I%20am%20unable%20to%20export%20them%20to%20excel.%20I%20can%20filter%20by%20one%20day%20and%20export%20that%20way%2C%20but%20there%20is%20still%20one%20day%20with%20so%20many%20that%20they%20will%20not%20export.%20Has%20anyone%20encountered%20this%20issue%20before%20%2F%20found%20a%20solution%3F%20When%20I%20try%20to%20export%2C%20the%20screen%20turns%20gray%20for%20a%20time%20like%20normal%20and%20then%20goes%20back%20to%20normal%20without%20downloading%20anything.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1430768%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eexport%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELarge%20Survey%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EResponses%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1430841%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20Export%20Responses%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1430841%22%20slang%3D%22en-US%22%3ERaw%20data%20from%20survey%20responses%20can%20be%20exported%20as%20csv%2C%20native%20SPSS%2C%20and%20csv%20compatible%20SPSS%20(some%20plan%20limits%20apply).%20This%20user%20guide%20demonstrates%20the%20steps%20taken%20to%20export%20survey%20response%20data%20from%20your%20Checkbox%20account.%3CBR%20%2F%3E%3CBR%20%2F%3E1.%20From%20the%20survey%20dashboard%20or%20survey%20editor%2C%20click%20the%20Analyze%20-%26gt%3B%20Responses%20-%26gt%3B%20Export%20Responses.%3CBR%20%2F%3E%3CBR%20%2F%3ENOTE%3A%20You%20can%20also%20choose%20Quick%20Export%2C%20which%20will%20bypass%20all%20the%20following%20steps%20by%20using%20your%20default%20export%20settings%20found%20under%20System%20Settings%20-%26gt%3B%20Report%20Settings%20-%26gt%3B%20Response%20Export.%20You%20can%20use%20this%20one-click%20export%20method%20if%20you%20don%E2%80%99t%20need%20to%20change%20any%20of%20the%20options%20that%20are%20described%20in%20the%20following%20steps.%3CBR%20%2F%3E%3CBR%20%2F%3EExport%20Survey%20Responses%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E2.%20Choose%20your%20export%20options.%3CBR%20%2F%3E%3CBR%20%2F%3EExport%20Mode%3A%20Choose%20between%20Standard%20CSV%20(can%20be%20opened%20in%20Excel)%2C%20SPSS%20Compatible%20CSV%2C%20or%20SPSS%20Native%20Format.%20Max%20Diff%20CSV%20will%20be%20required%20only%20if%20you%20included%20a%20Max%20Diff%20question%20in%20your%20survey.%3CBR%20%2F%3EStart%20and%20End%20Date%3A%20Filter%20response%20data%20by%20response%20date%20or%20time%20frame.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E3.%20Choose%20the%20information%20you%20want%20to%20include%20in%20your%20export.%20The%20options%20shown%20below%20apply%20to%20the%20csv%20output%20format.%20SPSS%20has%20fewer%20options.%3CBR%20%2F%3E%3CBR%20%2F%3EDetailed%20Response%20Info%3A%20Enable%20this%20option%20to%20export%20information%20about%20the%20survey%20response%2C%20including%20the%20response%20ID%2C%20response%20GUID%2C%20start%20and%20end%20date%2Ftime%2C%20total%20time%2C%20last%20edit%20date%2Ftime%2C%20IP%20address%2C%20language%2C%20username%2C%20invitee.%3CBR%20%2F%3EDetailed%20User%20Info%3A%20Enable%20this%20option%20to%20export%20user%20profile%20properties%20such%20as%20email%20address%2C%20first%20name%2C%20last%20name%2C%20etc.%20NOTE%3A%20this%20option%20is%20only%20applicable%20for%20known%2C%20registered%20users%20of%20Checkbox.%3CBR%20%2F%3EMerge%20Checkbox%20Results%3A%20If%20your%20survey%20contains%20checkbox%20question%20items%2C%20enable%20this%20setting%20to%20display%20the%20answer%20options%20in%20a%20single%20cell%2C%20separated%20by%20commas.%20If%20you%20leave%20this%20unchecked%2C%20checkbox%20items%20will%20be%20displayed%20as%20one%20answer%20per%20column%20in%20your%20export%20file.%3CBR%20%2F%3EExport%20Open-Ended%20Results%3A%20If%20your%20survey%20contains%20any%20Open%20Ended%20Text%20items%2C%20enable%20this%20option%20to%20include%20these.%3CBR%20%2F%3EExport%20With%20Aliases%3A%20If%20you%20created%20any%20question%20or%20answer%20aliases%20in%20this%20survey%2C%20enable%20this%20option%20to%20display%20the%20alias%20text%20in%20place%20of%20the%20original%20survey%20text.%3CBR%20%2F%3EExport%20Hidden%20Items%3A%20If%20you%20created%20Hidden%20items%20for%20this%20survey%2C%20enable%20this%20option%20to%20export%20them.%3CBR%20%2F%3EExport%20Incomplete%20Responses%3A%20Enable%20this%20option%20to%20include%20the%20data%20from%20unfinished%20survey%20responses%20in%20your%20export.%3CBR%20%2F%3EStrip%20HTML%20tags%20from%20answers%3A%20If%20your%20survey%20allows%20respondents%20to%20format%20the%20text%20of%20open%20responses%2C%20enable%20this%20option%20to%20remove%20formatting%20in%20your%20export%20for%20a%20cleaner%20look.%3CBR%20%2F%3EExport%20rank%20order%20points%3A%20If%20your%20survey%20has%20rank%20order%20items%20this%20option%20will%20invert%20the%20results%2C%20showing%20the%20score%20of%20the%20answer%20rather%20than%20the%20rank%20position.%3CBR%20%2F%3EInclude%20test%20responses%3A%20If%20your%20survey%20has%20test%20responses%20you%20can%20choose%20to%20export%20these.%3CBR%20%2F%3EDetailed%20Score%20Info%3A%20Includes%20score%20by%20page%20and%20possible%20score%20by%20page%20in%20your%20export%2C%20in%20addition%20to%20total%20survey%20score.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1430897%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20Export%20Responses%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1430897%22%20slang%3D%22en-US%22%3E%3CP%3ESorry%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F493704%22%20target%3D%22_blank%22%3E%40Lewis-H%3C%2FA%3E%26nbsp%3B%20but%20I%20don't%20see%20the%20relevance%20of%20your%20response%3A%20the%20question%20was%20about%20Microsoft%20Forms%2C%20not%20Checkbox%20so%20your%20lengthy%20answer%20doesn't%20solve%20the%20original%20poster's%20problem.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23333399%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1432963%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20Export%20Responses%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1432963%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F683362%22%20target%3D%22_blank%22%3E%40laurendibo%3C%2FA%3E%26nbsp%3Bare%20you%20able%20to%20open%20the%20built-in%20Excel%20Spreadsheet%20that%20Forms%20saves%20the%20responses%20to%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23333399%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1433082%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20Export%20Responses%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1433082%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3BI%20don't%20think%20so%3F%20Is%20that%20the%20%22Export%20All%22%20button%20when%20you%20go%20into%20the%20response%20detail%3F%20That's%20what%20I'm%20trying%20to%20do%2C%20and%20it%20tries%20to%20export%20but%20ultimately%20nothing%20happens.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1433095%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20Export%20Responses%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1433095%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F683362%22%20target%3D%22_blank%22%3E%40laurendibo%3C%2FA%3E%26nbsp%3BNo%2C%20it's%20the%20Open%20in%20Excel%20link%20on%20the%20Responses%20page%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22Open-in-Excel.png%22%20style%3D%22width%3A%20829px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F195894i55B96B2A18756156%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Open-in-Excel.png%22%20alt%3D%22Open-in-Excel.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23333399%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I have a survey with several thousand responses, and I am unable to export them to excel. I can filter by one day and export that way, but there is still one day with so many that they will not export. Has anyone encountered this issue before / found a solution? When I try to export, the screen turns gray for a time like normal and then goes back to normal without downloading anything.

5 Replies
Highlighted
Raw data from survey responses can be exported as csv, native SPSS, and csv compatible SPSS (some plan limits apply). This user guide demonstrates the steps taken to export survey response data from your Checkbox account.

1. From the survey dashboard or survey editor, click the Analyze -> Responses -> Export Responses.

NOTE: You can also choose Quick Export, which will bypass all the following steps by using your default export settings found under System Settings -> Report Settings -> Response Export. You can use this one-click export method if you don’t need to change any of the options that are described in the following steps.

Export Survey Responses



2. Choose your export options.

Export Mode: Choose between Standard CSV (can be opened in Excel), SPSS Compatible CSV, or SPSS Native Format. Max Diff CSV will be required only if you included a Max Diff question in your survey.
Start and End Date: Filter response data by response date or time frame.




3. Choose the information you want to include in your export. The options shown below apply to the csv output format. SPSS has fewer options.

Detailed Response Info: Enable this option to export information about the survey response, including the response ID, response GUID, start and end date/time, total time, last edit date/time, IP address, language, username, invitee.
Detailed User Info: Enable this option to export user profile properties such as email address, first name, last name, etc. NOTE: this option is only applicable for known, registered users of Checkbox.
Merge Checkbox Results: If your survey contains checkbox question items, enable this setting to display the answer options in a single cell, separated by commas. If you leave this unchecked, checkbox items will be displayed as one answer per column in your export file.
Export Open-Ended Results: If your survey contains any Open Ended Text items, enable this option to include these.
Export With Aliases: If you created any question or answer aliases in this survey, enable this option to display the alias text in place of the original survey text.
Export Hidden Items: If you created Hidden items for this survey, enable this option to export them.
Export Incomplete Responses: Enable this option to include the data from unfinished survey responses in your export.
Strip HTML tags from answers: If your survey allows respondents to format the text of open responses, enable this option to remove formatting in your export for a cleaner look.
Export rank order points: If your survey has rank order items this option will invert the results, showing the score of the answer rather than the rank position.
Include test responses: If your survey has test responses you can choose to export these.
Detailed Score Info: Includes score by page and possible score by page in your export, in addition to total survey score.
Highlighted

Sorry @Lewis-H  but I don't see the relevance of your response: the question was about Microsoft Forms, not Checkbox so your lengthy answer doesn't solve the original poster's problem.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

Highlighted

@laurendibo are you able to open the built-in Excel Spreadsheet that Forms saves the responses to?

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

Highlighted

@Rob Elliott I don't think so? Is that the "Export All" button when you go into the response detail? That's what I'm trying to do, and it tries to export but ultimately nothing happens.

Highlighted

@laurendibo No, it's the Open in Excel link on the Responses page:

Open-in-Excel.png

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User