# summary.csv

<div data-with-frame="true"><figure><img src="https://4216107837-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FeYTtd7c0A325muFr5lMW%2Fuploads%2FYprF0AgLHoaNeSyccexg%2Fimage.png?alt=media&#x26;token=cafee442-1984-43c3-b27a-cc0b7f0c9f2e" alt=""><figcaption><p>Example of a few rows and columns in a <em>summary.csv</em> file. Visualized in a spreadsheet editor like Microsoft Excel.</p></figcaption></figure></div>

💾 Typical file size **10–100 KiB**

💽  Media type `text/csv`&#x20;

💻 Typical software [Microsoft Excel](https://en.wikipedia.org/wiki/Microsoft_Excel) or [LibreOffice Calc](https://en.wikipedia.org/wiki/LibreOffice_Calc)

{% content-ref url="../access/pages/download-summary" %}
[download-summary](https://help.sbtinstruments.com/encyclopedia/software/access/pages/download-summary)
{% endcontent-ref %}

{% hint style="success" %}

## Open the *summary.csv* file in Microsoft Excel

<img src="https://4216107837-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FeYTtd7c0A325muFr5lMW%2Fuploads%2FKKINKE7UKkynnrB35Yrk%2Fimage.png?alt=media&#x26;token=ab540c7d-bbcd-47e3-8375-d2b5f5d23def" alt="" data-size="line"> Use Microsoft Excel to open the CSV file. Excel automatically arranges the tabular data in a spreadsheet.

The *Format as table* feature under the *Styles* pane works well for sorting data. Save the file in the XLSX format to make persistent changes.
{% endhint %}

## Rows

There is one row for each program (*Measure*, *Empty*, *Clean*, etc.) started on your BactoBox®. This reflects what you see in the:

* [History screen](https://help.sbtinstruments.com/encyclopedia/user-interface/menu-system#history) in the [Dash](https://help.sbtinstruments.com/encyclopedia/software/user-interface) user interface
* Measurements page in the [Access](https://help.sbtinstruments.com/encyclopedia/software/access) user interface

We sort the rows by the *Start time* column. The newest row comes first.

## Columns

The columns include (non-exhaustive list):

<table><thead><tr><th width="306">Column name</th><th>Description</th></tr></thead><tbody><tr><td>Program</td><td>Program name. E.g., <em>Measure</em>, <em>Empty</em>, <em>Clean</em>, etc.</td></tr><tr><td>Start time (YYYY-MM-DD hh:mm)</td><td>Format: YYYY-MM-DD hh:mm<br><strong>Uses the time zone of your BactoBox®.</strong></td></tr><tr><td>Measurement ID</td><td>Mnemonic measurement ID. E.g., A03 or F98.<br><strong>Rolls over at Z99 to A00.</strong><br>Blank for some utility programs.</td></tr><tr><td>Device ID</td><td>The unique ID of your BactoBox® device. E.g., <em>bb2241039</em>.</td></tr><tr><td>Software version</td><td>Version of the BactoBox® software used <em>when the program started</em>. E.g., <em>2026.01</em>.</td></tr><tr><td>Flow cell ID</td><td>Unique ID for the flow used for the measurement. E.g., <em>2D8B16T</em>.</td></tr><tr><td>Cells/mL</td><td>Measured cells/mL concentration.<br><strong>May show, e.g., "&#x3C;30000" including the </strong><em><strong>less-than</strong></em><strong> sign.</strong><br>Blank for some utility programs.</td></tr><tr><td>Total/mL</td><td>Measured total/mL concentration.<br><strong>May show, e.g., "&#x3C;30000" including the </strong><em><strong>less-than</strong></em><strong> sign.</strong><br>Blank for some utility programs.</td></tr><tr><td>Total/mL - Cells/mL</td><td>Measured other/mL concentration.<br><strong>May show, e.g., "&#x3C;30000" including the </strong><em><strong>less-than</strong></em><strong> sign.</strong><br>Blank for some utility programs.</td></tr><tr><td>Conductivity [uS/cm]</td><td>The electrical conductivity in µS/cm of the measured sample liquid.<br>Blank for some utility programs.</td></tr><tr><td>Errors</td><td><a href="../error-codes">Error code</a> and explanation. E.g., "1200: The conductivity is lower than 1600 uS/cm".<br>Blank if there are no errors.</td></tr><tr><td>ECC factor</td><td>Empirical concentration correction (ECC) factor. BactoBox® adjusts the intact cell concentration based on the ECC.<br>Part of gating settings defined the CRS file.<br>Blank for some utility programs.</td></tr><tr><td>Classification filename</td><td>File name of the CRS file that defines the gating settings. E.g., <code>BacTotal_v2024-02.crs.json</code>.<br>Blank for some utility programs.</td></tr><tr><td>Classification limits</td><td>Phase and amplitude “gates” that BactoBox® uses to  classify the objects in your sample vial.<br>Part of gating settings defined the CRS file.<br>Blank for some utility programs.</td></tr></tbody></table>

{% hint style="info" %}

## Missing some columns?

Try to [update-bactobox-r-software](https://help.sbtinstruments.com/protocols/best-practices/update-bactobox-r-software "mention"). We added columns throughout the years based on user demand.
{% endhint %}

## Short-form and long-form

The *summary.csv* file exists in two forms:

<table><thead><tr><th width="100">Form</th><th width="100">Row limit</th><th>Notes</th></tr></thead><tbody><tr><td>Short</td><td>200</td><td>Found in the <em>USB drive</em> that appears when you connect your BactoBox® to your computer.</td></tr><tr><td>Long</td><td>∞</td><td><a href="../access/pages/download-summary">Download via Access</a>.</td></tr></tbody></table>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://help.sbtinstruments.com/encyclopedia/software/file-formats/download-your-data.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.