Sabine   |   Search   |   Reference   |   Library   |   Virtual School

Instructions for copying data from DOE report and importing into Excel

Most DOE reports (i.e., ENROLLMENT DATA VERIFICATION REPORT and DISCIPLINE DATA VERIFICATION REPORT) reports contain data that may be used for various school/district planning and EOY evaluations.  Our procedure for obtaining DOE reports via the secure DOE browser (VPN):  Open each HTML report (not download) and copy and paste report into a MS Word template.  To manipulate (compute) the data in Excel requires converting the data ONLY to text file and importing into excel.

Saving data in Plain Text format
  1. Open the DOE report saved in MS Word Document Template.
  2. Open a second Document Template and Copy ONLY the data from the report into the new Document Template (landscape Courier New 9pt). 
  3. After pasting ONLY the data into template, assure alignment is correct by pressing Ctrl-A to select all text and select Courier New and 9pt font.
  4. Click on File and Save AS.  Change the Word Document file to Plain Text.  The Wizard window (right) appears.  Use settings shown right and save file to target folder.

See Example of DOE report

 
Import Text File into Excel
  1. Open Excel
  2. Click on File and Open
  3. At bottom of the Open File window choose All Files (not the default Excel), locate the folder and Plain Text file and Open.
  4. The Text Import Wizard appears.  Use default Fixed width and click Next.
The next screen Wizard window appears, click Finish.

If you have created a template with formulas and format, open the template and copy and paste the data.

See Excel Template

MS Word Template

Create a word template that is Landscape with margins of .3 on all sides and Courier New 9 point text.  Save as a Document Template (example of template name might be cour9pt).