Importing Excel Data to LabVIEW VI

Updated Apr 19, 2019

Reported In


  • LabVIEW
  • LabVIEW Report Generation Toolkit

Issue Details

Are there any examples to import Excel data to LabVIEW? What functions that I can use to import excel data?


Simply, there are two ways to import excel data using LabVIEW whether you own Report Generation Toolkit or not. It is the more convenient way to use Report Generation Toolkit.

With Report Generation Toolkit

If you use LabVIEW Professional edition, you can read the Excel data directly from LabVIEW by using the included Report Generation Toolkit. Please refer to the following page for this example. Reading Excel Data Programmatically Using the Report Generation Toolkit community post 

Note : To view the list of toolkits that are installed, Open the NI MAX software. Then, pull down the My system » software. For further information, please refer to this link. Which Versions of LabVIEW Run-Time Engine Do I Have Installed?

Without Report Generation Toolkit

If you do not have a toolkit, you can use the Read Spreadsheet Read VI or the Read From Measurement File express VI in the LabVIEW built-in functions.
In this case, it is necessary to save the Excel file as a *.csv or *.txt file. Please refer to the following document. Reading Microsoft Excel Numeric Data Into LabVIEW