Exporting Data

You can export up to 1 million samples per channel to comma-separated values (.csv) files using the settings on the Export Options dialog box.

If you acquire more than 1 million samples per channel, the last million samples in the files are exported.

To open this dialog box, select Gear icon»Export Data.

Logging Options menu option

When you export a DAQami data file, a .csv file is created for each device and for each input subsystem – analog, digital, and/or counter. Each file has the same root name as the source data file, but with a suffix added to it to indicate the device, the type of data in the file, and when the data was acquired.

For example, if you export a file that contains analog, digital, and counter data acquired by a USB-2408-2AO, and digital and counter data acquired by a USB-1608GX, the following five files are created by the export for each device and subsystem:

Export Options Dialog Box
Export PathClick Browse to navigate to the location where you want to export the .csv data file(s). Data is exported by default to the \Users\<current user>\Documents\Measurement Computing\DAQami folder.
Options
  • Data Precision (Decimal Places): Enter the number of decimal places to include in the exported data
  • Use Relative Time: Select this checkbox to export the data with the relative time that the data was acquired. Leave this checkbox unchecked to export the absolute time that data was acquired.
  • Limit Range: Select this checkbox to export a subset of the data based on a time range. You can specify the range using Absolute Time or Relative Time. Each range updates based on changes to the other.
  • Decimal Format: Click on the down arrow and select the decimal format to use when exporting to a .csv file:
    • Windows Setting: Use the Decimal symbol specified in the Control Panel»Region and Language setting.
    • Dot: Use a dot (.) as the decimal symbol.
    • Comma: Use a comma (,) as the decimal symbol.
  • Separator: Click on the down arrow and select the symbol to use to separate each column of data when exporting to a .csv file:
    • Windows Setting: Use the List separator symbol specified in the Control Panel»Region and Language setting to separate each column of data.
    • Tab: Use a tab to separate each column of data.
    • Semicolon: Use a semicolon (;) to separate each column of data.
    • Comma: Use a comma (,) to separate each column of data.
  • Double Quotation Marks Around Values: Select this checkbox to use double quotation marks to designate text values when exporting to a .csv file.

    When this checkbox is clear, no character is used to designate text values.
PreviewClick this button to show the exported data without creating the .csv file yet. Examples of each type of data in the Preview dialog box are shown here:

Analog tab

Analog .csv data preview

Digital tab

Digital .csv data preview

Counter tab

Counter .csv data preview

Click the Export to file button to export the data to a .csv file, or click Cancel to close the window without exporting the data.
Export to fileClick this button to export the acquired data to a .csv file. The file is stored in the location specified in the Export Path field.

Examples of each .csv file previewed above are shown opened in Microsoft Excel:

Analog data
csv analog data opened in Excel

Digital data
csv digital data opened in Excel

Counter data
csv counter data opened in Excel

See Also

Viewing and Logging Data

Configuring Logging Options

Strip Display

Scalar Display

Block Display