Data Import

General requirement

In your dataset, make sure that strings exist only in the first row, which becomes the header with the variables names. Otherwise, only numbers are allowed (if a string appears from row 2 onwards, SmartPLS cannot read the dataset). Note: This is in almost all cases the reason when you encounter a problem with the data import in SmartPLS 3.

Data Format

SmartPLS 3 allows you to import data file in the following format:

  • comma separated value files (.csv)
  • text files (.txt), which, for example, use a tab to separate the data points per row

Data Preparation in Excel or SPSS

For the data preparation, use a spreadsheet application such as Microsoft Excel or a statistical software such as SPSS. Spreadsheet applications and statistical software packages offer options to save the data in the .csv or .txt file format. Here, you find some sample data files which you can directly import into a SmartPLS 3 project. You may download and open these files with a text editor program and inspect how the data looks like. Note: When using SPSS, you may need to switch of "labels" before saving the data in the .csv or .txt file format.