Skip to content

Download data: Table structure

The table structure is a simple format with rows and columns, ideal for spreadsheets and statistical analysis.

When to use table structure

Table structure is ideal when you need:

  • Spreadsheet-ready data — Opens directly in Excel or Google Sheets
  • Form response data — Each participant's responses in a single row
  • Statistical analysis — Ready for SPSS, Stata, or R analysis

For more complex nested data, use the Tree structure. For per-stimulus annotations, use Annotations.

Compatible file types

Table structure data is currently available in the CSV and JSON file types.

Structure

Data for the Dynamic Form task can be structured as a table, with the columns corresponding to selected fields in the task's parameters. A column called pid is added with the participant IDs. Each row represents one participation.

Loading table data

Open the CSV file directly in Microsoft Excel or Google Sheets:

  1. Use File → Open or File → Import
  2. Select the .csv file
  3. Use pivot tables for analysis:
    • In Excel: Insert → PivotTable
    • In Sheets: Insert → Pivot table
  4. Use filters to explore the data:
    • In Excel: Data → Filter
    • In Sheets: Data → Create a filter
import pandas as pd

# Load the table CSV file
data = pd.read_csv('Meadows_myStudy_table.csv')

# Display the first few rows
print(data.head())

# Get summary statistics
print(data.describe())

# Group by a categorical variable
grouped = data.groupby('country').size()
print(grouped)

# Load the table CSV file
data <- read.csv('Meadows_myStudy_table.csv')

# Display the first few rows
head(data)

# Get summary
summary(data)

# Group by a categorical variable
table(data$country)

Example

Table with 4 participants' data for a Dynamic Form task with fields avatar, country, gender, handedness, language and race:

pid avatar country gender handedness language race
59844b014eae351467ba73dc jasper_square.jpg NL m r nl IC1
597b191f4eae355335012612 AF m r aa IC1
59789bd24eae3553337f112a FL_selfie.jpeg GB f r en IC1
5971a8b94eae355332f9e447 CA m r fr IC1