Create book of abstracts from spreadsheet / google forms

Lately a friend of mine complained about interoperability of abstract submissions from numerous applicants. Having the Book of Abstracts is crucial and we faced similar problem organising #NGSchool events.

Note, you’ll need to be somewhat familiar with LaTeX in order to edit the main.tex file to your liking. If you are not afraid of that, the way to proceed is as follows:

  1. Create google form to collect necessary info, such at this one
  2. Create a new spreadsheet to accumulate responses: Responses > Create new spreadsheet
  3. Download responses spreadsheet as Abstracts.xlsx
  4. Clone abstracts repository
  5. git clone
    cd abstracts
    # install dependencies
    sudo apt install texlive-base texlive-latex-recommended texlive-fonts-recommended texlive-latex-extra make
  6. Edit main.tex to your liking
  7. Copy Abstracts.xlsx to the repository
  8. Create pdf
  9. # prepare abstracts.tex
    # create main.pdf
    make all
    # in the case of problems, just run again this point, but first remove the clutter
    rm main.{aux,blg,log,out,toc,pdf}

    You’ll find the abstract book in main.pdf.

3 thoughts on “Create book of abstracts from spreadsheet / google forms

  1. Hi,

    This looks like exactly what I need! But, I get this error when I try to run the sudo line: Unable to locate an executable at “/Library/Java/JavaVirtualMachines/jdk-10.0.1.jdk/Contents/Home/bin/apt” (-1)

    Any ideas?


    • Hi Camile, are you on Debian-based Linux (Debian, Ubuntu, Mint etc)?
      Aaa, you’re on MacOS… This guide if for Linux users 🙂
      Then you’ll need to install LaTeX by yourself. Note, there are quite a few dependencies covered nicely by aptitude in packages such as texlive-fonts-recommended and texlive-latex-extra. You’ll need to install them by hand in MacOS.
      Let me know if it worked!
      btw, and sorry for late response…

Leave a Reply

Your email address will not be published. Required fields are marked *