You are here: Integrations > Bulk Loader > Downloading a Source File and Opening it For Editing

Downloading a Source File and Opening it For Editing

To download a Bulk Loader Source File from LearnCenter and open it in Microsoft® Excel for editing:

On the Control Panel:

Click on the Integrations menu to expand it.
Click Bulk Data Loader.
On the Bulk Loader Page, click the hyperlink for the Source File type you want to create. A Text file (.TXT) opens in a browser window.
Save the file to a location on your hard drive or network drive.
Open the file using Microsoft® Excel.

Open Microsoft® Excel.
Click File > Open.
Navigate to your saved file and click Open. The Text Import Wizard window opens.

Select Delimited and click Next.

Select Tab as the Delimiter and click Next.

Select General as the Column data format, and then click Finish.

The spreadsheet opens with the appropriate column headings already pre-populated. Treat each row on the spreadsheet as a separate ILT event or Enrollment. The first column is the name of the event. All columns are named exactly like their matching fields in LearnCenter so that you know precisely what information goes where.

See Requirements for Bulk Loader Source Files for additional information about inputting your data.