SameGoal Special Programs
search
SameGoal Special Programs

Bulk Load Gifted Profiles




Support > Online Guides > State Specific Guide > Ohio > Al Workflows > Bulk Load Gifted Profiles
download

Data loaders are an admin-only tool that allow districts to bulk create/update documents. The data loader can be used specifically to bulk create, populate, and complete Gifted Profiles for students who have been screened/assessed for different areas of giftedness.

Administrative users can download a template CSV to manually populate and load into the system. Otherwise, in order to save time, they can download the results of the report to generate a CSV that is already partially filled out. Once a CSV has been prepped, in can be loaded into SameGoal to bulk load Gifted Profiles.

Use the Template CSV link

If you would like to download a template CSV and manually populate it to be bulk loaded, follow these steps.

Steps
To download a blank template to bulk load Gifted Profiles:

  1. Log in to SameGoal as an administrative user and navigate to > .
  2. Select as the import type.
  3. Click to download the .
  4. Open the template CSV in a spreadsheet (e.g. Excel or Google Sheets).
    • If you are working in Excel, the CSV can be opened directly in Excel.
    • If you are working in Google Sheets, the CSV can be imported into Sheets by going to > .
  5. In the spreadsheet, provide all relevant information. The column is required and must be filled out for each student who needs a new Gifted Profile.
    • Information about allowable values and required formatting for each column can be found by going to > and selecting as the import type. Details will be included under . If you do not use the specified allowable values and required formatting, the import may fail. If there are no specified values or required formatting, the field is free text entry.
    • Do not change the column titles. The file is already in the correct format to be loaded with the data loader.
  6. Once you have populated the spreadsheet with relevant information, save the file as a CSV.
    • You can download the spreadsheet as a CSV in Google Sheets by going to > > .

Use the Report link

The report pulls referral, screening, assessment, and identification information from existing Gifted Profile documents. If you would like to run a report to generate a partially filled out CSV to be bulk loaded, follow these steps.

Steps
To use the Gifted Profile report to bulk load Gifted Profiles:

  1. Navigate to > > .
  2. Run the report to pull profile information from existing Gifted Profiles.
  3. Download the report results and open them in a spreadsheet (e.g. Excel or Google Sheets).
    • If you are working in Excel, the results can be downloaded as an XLSX or CSV and opened directly in Excel.
    • If you are working in Google Sheets, the results can be downloaded as an XLSX or CSV and imported into Sheets by going to > .
  4. In the spreadsheet, update profile information for each relevant student. If they were newly screened, assessed, or identified as gifted in a given area, include that information. Students who do not need a new Gifted Profile can be deleted from the spreadsheet.
    • Information about allowable values and required formatting for each column can be found by going to > and selecting as the import type. Details will be included under . If you do not use the specified allowable values and required formatting, the import may fail. If there are no specified values or required formatting, the field is free text entry.
    • Do not change the column titles. The file is already in the correct format to be loaded with the data loader.
  5. Once you have updated the spreadsheet with relevant information, save the file as a CSV.
    • You can download the spreadsheet as a CSV in Google Sheets by going to > > .

lightbulb Tip
The report pulls from the Gifted Profile that was revised 01/2026 as well as the previous version of the Gifted Profile.

lightbulb Tip
If a student has more than one Gifted Profile, they will all be included in the report. When prepping the CSV for the data load, you can delete older Gifted Profile information and just update the row containing the most recent information.

Bulk Load Gifted Profiles link

Steps
To bulk load Gifted Profiles:

  1. Once a CSV has been prepped, log in to SameGoal as an administrative user and navigate to > .
  2. Select as the import type.
  3. Click and upload the CSV file you prepped from your device.
  4. Before starting the import, click the blue button. If there are any errors that will cause the import to fail or warnings that will cause specific lines in the import to fail, you will see an or table.
  5. Update and fix any issues as necessary. If there are no errors or warnings, you will only see an table with a summary of the changes to be made.
    • You may need to make updates to the file, save your changes, and re-upload the updated file on the page.
  6. Click .

Once the import has run:



info