Import Data

With OfficeReports Analytics menu in place, you are ready to add data from a number of different sources. The imported data will be saved into an OfficeReports database, which will have the same name as the file you are working with, and with extension ‘.ordb’ added to that.

As soon as you click the OfficeReports menu in Excel the ‘Import Data’ window pops up, and you are ready to add data to your Excel workbook.

At all times, it is possible to click the ‘Add Data’ menu to import data, and import from different sources:

  • SPSS (sav-files) (the recommended format)
  • Excel (xlsx)
  • CSV files
  • Triple-S (xml, sss-files)
  • SurveyMonkey (integration based on SurveyMonkey API)
  • SurveyGizmo (integrated based on SurveyGizmo API)
  • OfficeReports database (db, accdb (old), OfficeReports database files)
  •  

After choosing a file, the following window will appear:

  1. Choose the variables you want to import

  2. Click ‘Start’ to start importing

  3. When the import is completed, OfficeReports will open the 'Data Window', which contains both a 'Variables View' and a 'Data View'.ariables.

  4. If you import a SPSS sav file containing ‘Multiple Response Sets’ OfficeReports will automatically import each of these sets as derived variables.

 

Let us briefly review data imports from each of possible import formats:

 

After importing data, the 'Data Editor' will popup giving you an overview of the imported data. Here you can also recode the variables..