# Download data beta

You can download Project data from the PhotosynQ Desktop application or the PhotosynQ website. For the best experience exploring and downloading data, we recommend PhotosynQ Desktop.

# PhotosynQ Desktop (recommended)

Sign in and open Projects → My Projects.
Select the Project, then Explore Project Data.
Wait for the data to load, then open Spreadsheet.
Choose the protocol and data to include. Use More to add available metadata columns.
Select Save → Comma separated (csv) or Tab separated (txt), then choose where to save the file.

Review the selected data, filters, and columns before export. Keep an unchanged source export alongside the analysis files.

Desktop Spreadsheet with the Save button for exporting the selected data

# Website and other download options

The web download tools remain available. You can:

Download a filtered dataset as a .csv from the spreadsheet in the data viewer
Download the complete dataset from the Project page as a spreadsheet (.xlsx)
Download the data as a JSON formatted file (.json)
Use the Python or R libraries (external libraries) to import the Project dataset as a data-frame

Note

We are strongly recommending you view your data in the data viewer and flag data if necessary before downloading the dataset. This will ensure the highest quality and best results for your subsequent analysis.

# Availability

Downloads are restricted to authorized Project-team members with the required role. You must be signed in and have access to the Project data.

# Web Data Explorer

When viewing Project data on the website, you can save your current selection from the spreadsheet as a .csv. The Desktop Explorer also supports spreadsheet export. See The Spreadsheet.

# Website XLSX download

The spreadsheet is structured the same way, it is in the data viewer. If you use multiple protocols, you will have multiple sheets. Each sheet will have the name of the protocol.

# Website JSON download

When you download the data as a JSON you will receive more information than included in the spreadsheet. It contains the processed data, not the original, so certain fields, like the data_raw (raw trace) are not included. If you require this data, please use one of the external libraries.

[
    {
        "api_version": "3",             // Used API version
        "app_device": "x86-64",         // Device to record measurement
        "app_name": "PhotosynQ",        // App name
        "app_os": "mac",                // App OS
        "app_version": "0.3.2",         // App version
        "custom": {                     // Custom data (if imported)
            ...
        },
        "datum_id": 271164,             // Unique data point ID
        "datum_url": "https://...",     // Link to measurement
        "device_id": "82",              // Instrument ID
        "firmware_version": "0.47",     // Instrument firmware version
        "location": [                   // Attached location
            42.7369792,                 // longitude
            -84.4838654                 // latitude
        ],
        "status": "submitted",          // Measurement status (submitted/flagged)
        "time": 1463001730187,          // Unix timestamp in ms (UTC)
        "time_offset": 240,             // timezone offset in min (optional)
        "user_answers": {               // user answers to Project Questions
            "11292": "red"
        },
        "user_id": 7,                   // User ID (took measurement)
        "sample": [                     // Results from measurement protocol
            {
                "time": 1463001730225,  // Unix timestamp in ms (UTC)
                "protocol_id": "475",   // Protocol ID
                ...
            },
            ...
        ]
    },
    ...
]

# External libraries

Just select External Libraries from the download options on the Project page. This will bring up a modal dialog with code examples for Python and R. Simply copy the code into your script to generate a data-frame.

Dialog with code snippet to import the Project data into a data-frame

For more information, see External Libraries and the maintained package installation instructions.

← Sessions External Libraries →