A tiny script to rapidly create formR-compatible Excel files for the purpose of large-scale norming studies utilizing a simple Likert scale.
| Before | After |
|---|---|
![]() |
![]() |
To install the prerequisites run pip3 install --user XlsxWriter.
To generate a file:
- Input your words or statements into a text file, separated with new lines. By default, it should be called
words.txtand located in the same folder as the scripts. - Adjust the
configfile to change the labels, pagination, output filename and path, etc. - Run
formRGen.sh.
Take a look at the config file for more information on what can be tinkered with.
The Excel file can be uploaded to formR.org straight away or appended with more questions – like the demographic section – manually.

