How to read from a spreadsheet in labview

Written by tammy clevenger
  • Share
  • Tweet
  • Share
  • Email

LabVIEW is a graphical programming application distributed by National Instruments. The program is used for designing components and systems in the science and engineering fields. LabVIEW offers compatible versions for all operating systems.LabVIEW provides the user with the ability to perform data visualisation and analysis using datasets. To read data from a spreadsheet in LabVIEW, use the "Read From Spreadsheet File" VI. Convert the spreadsheet to Comma Separated Value (CSV) format and import the data into LabVIEW.

Skill level:


  1. 1

    Open the spreadsheet in its native application. For example, if the spreadsheet is a Microsoft Excel file, open the dataset in Microsoft Excel.

  2. 2

    Click the "File" option from the top navigation bar, or click the Microsoft Office button in Excel 2007, then click "Save As."

  3. 3

    Click "Other Formats," then click the "Save as Type" drop-down box. Select the "CSV Comma Delimited (.csv)" file type, and click "Save." The dataset saves in the CSV format.

  4. 4

    Click the "Functions" option in LabVIEW to open the "Functions" interface.

  5. 5

    Click the "File I/O" icon, then click "Read From Spreadsheet" from the File I/O options.

  6. 6

    Right-click on the "Delimiter Input" option located at the bottom of the window.

  7. 7

    Click "Create," and click "Constant."

  8. 8

    Type a comma (",") in the "String Constant" field. A file navigation window opens.

  9. 9

    Navigate to the spreadsheet file saved in CSV format. Click on the file, and click "Open." The dataset loads into LabVIEW.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.