# Form Component keeps crashing

**URL:** <https://discourse.psychopy.org/t/form-component-keeps-crashing/29897>\
**Category:** Builder\
**Created:** [July 7, 2022, 9:37am UTC](https://discourse.psychopy.org/t/form-component-keeps-crashing/29897 "2022-07-07T09:37:27Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![umb](https://avatars.discourse-cdn.com/v4/letter/u/cc9497/32.png) [@umb](https://discourse.psychopy.org/u/umb)\
**Post date:** [July 7, 2022, 9:37am UTC](https://discourse.psychopy.org/t/form-component-keeps-crashing/29897/1 "2022-07-07T09:37:27Z")

</div>

Win10  
PsychoPy V2022.2.1  
Standalone

Hi guys,  
is it just me or did the form component somehow stop working?

When using the builder:  
1 routine

…containing…

1 key response  
1 form component

Form options:

![image](https://us1.discourse-cdn.com/flex002/uploads/psychopy/original/3X/9/f/9fdc197e88058f85b017a3a1a919214603a46472.png)

Contents of the form.xlsx:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/psychopy/original/3X/4/3/43d6b5a8f265057dd6cba9e7ad52537708d2f1fc.png)

The experiment crashes right after launching it. This is the error msg:

> ValueError: Item -12349872349873in items file ‘C:\Users\ … \formItems1.xlsx’ is missing a required value for its response type. Permitted types are {‘free text’, ‘heading’, ‘description’, ‘radio’, ‘rating’, ‘slider’, ‘choice’}.

What is causing this error?  
Clearly the response type is set to “choice”.  
Adding options (yes/no) to the xlsx did nothing.  
Saving the form as CSV did not change anything as well.

Thanks in advance!

---

<div class="post-metadata">

**Author:** ![umb](https://avatars.discourse-cdn.com/v4/letter/u/cc9497/32.png) [@umb](https://discourse.psychopy.org/u/umb)\
**Post date:** [July 7, 2022, 9:50am UTC](https://discourse.psychopy.org/t/form-component-keeps-crashing/29897/2 "2022-07-07T09:50:17Z")

</div>

Excel, you fooled me once again.

So it turns out PsychoPy does not accept xlsx as a valid format (although the docs say otherwise: [Form Component — PsychoPy v2022.2.1](https://www.psychopy.org/builder/components/form.html)).  
CSV is the way to go. But excel is using a semicolon as delimiter instead of a comma if you have the “wrong” locale. So just use libreoffice…