Import Data into MS Excel

These instructions assume that data was exported using IQSweb Tools/Export Data option as described in the previous section.  The steps outlined assume all export options (Person/Org, Qualifications, Training, Experience, Target Positions, and Task Books) were selected.  In addition, these steps assume the user is proficient using Microsoft Excel 2010.  If you are using an earlier Microsoft Excel version, some steps may be slightly different from what is documented below.  Please reference your MS Access help for exact steps for importing data into Excel.

 

  1. Using Windows explorer, navigate to the location where you saved the export file.  Unzip the downloaded export file from IQSweb.

  2. Start Microsoft Excel with a new blank worksheet.

    1. Go to the "Data" menu and select "From Text."
      Import Text File

    2. In the Import Text File window, navigate to the folder where the zip file was uncompressed.  Select the PersonOrg.csv file and click "Import."

    3. From the Text Import Wizard, select the "Delimited - Characters such as comma or tab separate each field" and select "Next."  
      Text Import Wizard - Delimited

    4. In the Delimiters section, select "Other" and enter the pipe character (l).  This is the vertical shift character on the backslash (\) key on most QWERTY keyboards.

      Text Import Wizard - Other

  3. Click "Next", then click Finish.

  4. The data is imported from the .csv file to a new worksheet.

  5. Repeat steps 2a through 4 for each file contained in your export file.  Each file will be imported into a new worksheet within your excel file.

 

 

 

Related Links