BIOPAC® Systems, Inc. Logo

Data export to spreadsheet

It is extremely rare for there to be a good reason to export all data to a spreadsheet because spreadsheet programs are not designed for the analysis of the types of data normally recorded by BIOPAC systems. Typically, users will want to process data and extract particular statistics into a spreadsheet.

For those rare occasions when all data is to be exported:

    1. Choose “File > Save As…”
    2. In the dialog box that is generated, change the “Save as type” to spreadsheet
    3. Click “Save”
Excel Export Dialog box

This mechanism is limited to an older Excel file specification, preventing the saving of more than 65535 rows of data. This means every channel to be saved must have fewer than that many sample points.

A more typical application would be, for instance, to extract the average heart rate for the thirty seconds following each stimulus presentation. For any such processing where statistics are to be pulled from segments of the data matching some particular criteria, “Analysis > Find Cycle” provides the tools necessary for extracting these statistics automatically.

The BIOPAC website has several “Find Cycle” tutorial videos that demonstrate the use of “Find Cycle” —the key to using that tool in this context is to first set up some relevant measurements, such as:

Measurements

and then under the Find Cycle “Output” tab, indicate that these values should be sent to a spreadsheet:

Find Cycle Output tab

last modified 01-19-2015

Spotlight On
free BIOPAC webinar

One Tool for Stimulus Presentation, Eye Tracking & Physiology Data

BIOPAC shows you how physiological data is seamlessly synchronized with eye tracking and stimulus presentation in one integrated solution. The talk focuses on optimizing setup, highlighting the benefits of a fully-integrated solution, and how to extract eye tracking and physiology metrics from key points, such as the cumulative average skin conductance level while a participant is focused on areas of interest.

What you will learn:
• Hardware setup
• Stimulus presentation creation
• Setting up Areas of Interest (AOI)
• Recording participant data
• Analysis and reporting

Watch On-Demand

Register Now
Latest News

New Citations | BIOPAC in Stimulus Presentation Studies

BIOPAC provides software and hardware that allows research teams to study stimulus presentation data. Here are a few notable studies using BIOPAC equipment for research on stimuli’s effects using ECG and SCL data. Your Face Scares Me This study addressed the impact of individual differences in social anxiety by examining the effects of perceptual load and stimulus valence when […]

Electrocardiography Guide Now Available

BIOPAC’s comprehensive Introductory ECG Guide addresses fundamental to advanced concerns to optimize electrocardiography data recording and analysis. Topics include: ECG Complex; Electrical and Mechanical Sequence of a Heartbeat; Systole and Diastole; Configurations for Lead I, Lead II, Lead III, 6-lead ECG, 12-lead ECG, precordial leads; Ventricular Late Potentials (VLPs); ECG Measurement Tools; Automated Analysis Routines for extracting, […]

Read All
Request a Demonstration
Request a Demonstration