How to Import Data Import Data icon

OfficeReports can import 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’.

Import data Popup Form

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)
  •  

Import data in the OfficeReports Ribbon Tab

After choosing a file, the following window will appear:

Data Import Form

  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 Editor', where you can recode your variables if necessary.

Note: If you import a SPSS sav file containing ‘Multiple Response Sets’ OfficeReports will automatically import each of these sets as derived variables and will hide the original variables contained in the groups.

 

Different Data Formats

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..