XLSPlay: edit & preview XLSforms in one browser tab

Hi everyone :wave:

First time poster but long-time admirer of the ODK project here!

Sharing my summer (winter here really) side project to make editing XLSForms easier. It's a web app where you can edit and preview forms in one tab, with:

  • Ability to upload an existing .xlsx, and download back to .xlsx when done
  • A menu to add questions / groups / repeats if you forgot their syntax
  • Autocomplete for question types & question names
  • Colour highlighting for groups and repeats

See video demo below:

Try it at https://xlsplay.rapha.dev/. It's a first prototype, would be happy to get candid feedback from yall.

Thanks!

5 Likes

That is super! Are there any limitations, eg select from csv, media.

It would really help speed up form authoring, finding errors/previewing rapidly and not doing a bunch of editing and then uploading over and over fixing one validate error at a time

1 Like

Thanks for the kind words!

Yes indeed, the main limitation is that it doesn't support attachments, be it media files or external csv/xml choices.

I'm using the Enketo /preview endpoint, which I think doesn't support attachments (@LN can correct me if wrong), so this would be tricky to add.

1 Like

This is so cool, I have been dreaming about something like this :heart:

Few ideas / wishlist:

  • Can you make it auto reload the preview when user make changes to the Form?
  • Add another preview button to preview the Form with latest Web Forms
  • I see you are using handsontable, its license seams quite restrictive to me. If you could replace it with something with more liberal licence like Jspreadsheet-ce then this thing can become something big down the road. Maybe becomes part of Central - not promising anything but I would love this to be inside Central and primary way to design/edit Forms.
1 Like

Not to hijack this thread but I really liked this project and decided to build something similar but more "document" oriented. It is a less powerful/complete version of this that i use for quick prototyping when offline. Still a WIP but publicly hosted at https://forms.rsearch.dev/ if anyone wants to try it out

1 Like