Table Data
Overview
The Table Data tab displays your study results in an Excel-like tabular interface. Every response is captured in real time — as participants answer each question, their data appears in the table immediately. You don't need to wait for a participant to complete the full study to see their responses.
This is your primary view for browsing, filtering, exporting, and enriching your raw data.
Loading Data
When you first open the Table Data tab, not all data will be visible. You need to click Load All to pull all rows into the view.
This is intentional. For large studies with hundreds or thousands of participants, loading all data at once can consume significant browser memory and potentially crash the tab. The Load All button lets you control when the full dataset renders.
Tip: For very large datasets, consider using the export or live Google Sheets connection instead of browsing all data in the browser.
Browsing the Data
Table Structure
Each row represents a participant (or a session, in the case of diary studies). Each column represents a question or data field. The table includes participant identifier and contact details, timestamps (when the participant started and when each response was submitted), survey responses (coded values), open text responses (full text), AI interview responses (full text of each AI-generated question and participant response), voice note and video transcriptions, media file URLs (clickable links to original files), translated responses (if multi-language is enabled, translated versions appear in separate columns), and enrichment data (any additional participant data you've uploaded).
Sorting
Click the up/down arrow on any column header to sort the data by that field. Sort by start date to see the most recent participants first, by completion status to group completed and in-progress participants, or by a specific question response to cluster similar answers together.
Reordering & Hiding Columns
Drag columns to reorder them in the view. Remove columns from the view entirely to focus on the data that matters most. These changes affect your current view only — the underlying data is not modified.
Filtering
Column Filters
Click on any column header to apply a filter. You can filter on any data field — question responses, dates, completion status, or enrichment data.
Example filters: show only participants who selected "Very confident" on question 1, show only participants who started in March 2025, or show only participants from a specific demographic segment.
Combining Filters
Add multiple filters to narrow your data further. Filters are applied cumulatively — each additional filter narrows the dataset. For example, filtering on confidence level = "Very confident" might show 158 participants, then adding a filter on start date = March 2025 narrows that to 4 participants.
Clearing Filters
Clear all filters at once to reset the view to the full dataset.
Completion Status
Live Data vs. Complete Data
Because Yazi captures data in real time at the individual question level, the table shows both completed participants (those who have answered every question) and in-progress participants (those who have started but not yet finished). This means you can see partial data as it comes in, but your table will include incomplete rows.
Filtering by Status
Use the completion status tabs to toggle between All (everyone who has started the study), Completed (only participants who have finished the entire study), and In Progress (only participants who are currently partway through).
Tip: When exporting data for analysis, decide whether you want completed responses only or all responses including partial completions. For most quantitative analysis, filter to completed only. For early fieldwork monitoring, view all.
Exporting Data
Export Formats
Click the export button to download your data as Excel (.xlsx) or CSV (.csv).
Export Options
When exporting, you can choose Completed only (export only participants who finished the full study) or Completed + In Progress (export all participants, including those with partial responses).
Live Connections
For ongoing studies where you need real-time data access without manual downloads:
Google Sheets — Connect your results to a live Google Sheet that updates automatically as new responses come in.
Microsoft Excel (via SharePoint) — Connect to a live Excel file via SharePoint for automatic syncing.
Refreshing Data
Click the Refresh button to pull the latest responses into the table. This is useful during active fieldwork when new responses are arriving continuously.
Translating Responses
If your study is set up with multi-language support, responses submitted in other languages can be translated directly in the table view. Click the Translate button to translate all non-primary-language responses into your primary language. Translated text appears in a separate column alongside the original response. Voice note and video transcriptions are also translated.
Enriching Data
What Is Enrichment?
Data enrichment allows you to upload additional participant information — data you already have from other sources — and merge it with your study results.
How It Works
Click the Enrich button.
Upload a CSV or Excel file containing your additional data.
The file must include a phone number column — this is the matching key used to link the uploaded data to the correct participant.
Yazi matches each row in your uploaded file to the corresponding participant in the study.
The enrichment data appears as additional columns on the right side of the table.
Common Use Cases
Recruitment screener — Upload demographics, behavioural data, or segment classification to avoid re-asking questions participants already answered during screening.
CRM export — Upload customer tier, purchase history, or account status to cross-analyse survey responses against existing customer data.
Panel provider — Upload participant ID, panel classification, or incentive status to match panel data to study responses for reconciliation.
Previous study — Upload responses from an earlier wave to track changes in attitudes or behaviour over time.
Important: The phone number field is required for matching. Ensure phone numbers in your enrichment file use the same format (including country code) as the numbers in your study data.
Viewing Progress
Click Actions → View Progress to see a summary of each participant's completion status: percentage complete, current position (which question or activity they're on), with page size toggles and sortable columns.
This view is particularly useful for identifying participants who are stuck or have dropped off, deciding when to send reminder broadcasts, and monitoring overall fieldwork progress against targets.
Known Limitations
Load All required — Data does not render fully until you click Load All. For very large studies, this may take a moment and consume significant browser memory.
Browser performance — Extremely large datasets (10,000+ rows) may cause slow rendering in the browser. Use exports or live connections for heavy analysis.
Enrichment matching — Matching is based on phone number only. If phone number formats differ between your study data and enrichment file (e.g., missing country codes), matches will fail. Standardise formats before uploading.
Column changes are view-only — Reordering or hiding columns affects your current session only. Changes are not saved permanently.
Last updated