How can I import themes from the Gallup Strengths Center?

< Back

For a large number of clients, importing their theme information will save a lot of time, especially if they have all 34 themes. It requires their codes to be managed through your Gallup’s Strengths Center account.

If you purchase the Clifton Strengths codes from the Gallup Strengths Center the results are available in your account. Using the export file, the contents can be directly copied and pasted into Cascade.  This is by far the most accurate and easiest way to import information for several clients and will save a lot of typing. There are three parts to importing the information.

  • Export the file from the Gallup Strengths Center
  • Copy and Paste the information into Cascade
  • Run the Reset Formatting process to clean up the page.
Gallup Strengths Center Export File
  1. Login to
  2. Under My Account, select Code Management.

    strengthsfinder code management Gallup strengths center Cascade
  3. If given the option, choose Clifton Strengths.
  4. Select the name of the group to import to Cascade.
  5. Click on Export Strengths and save the Excel spreadsheet to your computer.
    Gallup export strengths themes excel spreadsheet cascade

  6. Open the saved spreadsheet.
    Gallup strengths theme export file excel spreadsheet cascade

  7. Highlight the names and themes from cell A4 to the right-hand end of the last line, then select Copy (Ctrl+C).
    Tip: Do not be tempted to highlight the rows by sliding the cursor down the left-hand side. Click on cell A4 then drag the cursor to the last theme on the last line.
    Note: From version v2.0r03 (March 2019) onwards, include the column AV on the extreme right to capture the number of Dominant Themes.
    Gallup strengths export file copy excel cascade

  8. Switch to your Cascade spreadsheet, selecting the Theme Table page.
  9. Position the cursor to first available row and column G.
  10. Right-click and select the Paste icon or use Ctrl+V.
    Gallup strengths export file paste excel spreadsheet cascade

  11. To tidy up the page and make all the formatting uniform, click on the Reset Formatting button. This will free any locked cells inherited from another spreadsheet. It also reapplies the formulae for correct operation.

Need help getting the theme information from Gallup Access? Click here for info.