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
Remote Screen-based Eye Tracking BAr

Remote Screen-based Eye Tracking Bars

This mini screen-based remote eye tracking bar provides gaze position, dwell time, blink rate, pupil size, and more. Use with an AcqKnowledge Eye Tracking Integration License (ACK100W-EYE) to access valuable eye tracking metrics: Gaze Path, Gaze Plot, Heat Map, and Attention Map. Create user-defined Areas of Interest (AOI) and select Scarf Plot, String Plot, Pie Chart, […]

View All
Latest News

New Citations | Using Wireless Technology to Support Psych Research

Solving Physical Stress Issues for Surgeons Physical stress in the operating room is common for surgeons, considering how much time they spend in an upright standing position during surgical procedures. With procedures that require standing for several hours and average reported working times of 60-80 hours a week, surgeons seem to be at risk for musculoskeletal […]

New Eye Tracking Glasses Bring Real-world Data to Academic Research

BIOPAC combines eye tracking with mobile data logging and physiology data collection to run experiments in the lab or in the real world BIOPAC Systems, Inc. is pleased to announce new eye tracking integration for researchers who conduct experiments from mobile participants in diverse locations. ETVision (EYE-ETV) eye tracking glasses now integrate with BIOPAC wireless systems and software, […]

Read All
Request a Demonstration
Request a Demonstration