Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Supported by

Source to File

edited July 2016 in OpenSesame

How does one use an excel spreadsheet to define variables in a loop?

While I was reading the web page on looping and independent variables I noticed that it should be possible to import variables from excel by change the 'source to file.' However as of yet I have not been able to find any source option. It seems like the interface has changes slightly from when the screenshot on the site were taken and I was wondering is setting source to file still an option; if so how can I find it?

If it helps I am running 3.1.1 Jazzy James and I am using OS X El Capitan 10.11.2

Thanks in advance for any Help!

Comments

  • edited 12:56PM

    Hi Alexander,

    Well, one possibility is to just select everything in your excel sheet and to copy-paste it into your loop item. Or do you need this to be done automatically with, say, some variance between subjects?

    Cheers

    Josh

  • edited 12:56PM

    Hi Alexander,

    If you are trying the new import function of the loop items, you should save your excel table to a .csv file (comma separated value) file first. I don't think OpenSesame can read excel formats (yet).

    When you are in a loop item and change source from table to file, the file selection box and button should pop up right below it. There you can enter the file you want to use .

    Buy Me A Coffee

Sign In or Register to comment.