https://web.alsde.edu/PublicDataReports/Default.aspx
Data Center, Public Data Reports
Free Lunch by System and School
Select Year, System Name: All, View All Schools Detail: No
Export to CSV
Insert 6 Columns to the left of Column A
Name columns before G as: MunID, MunType, NumCode, TextDistrictCode, CodesLength, SadYear
Rename: DistrictName, SadEnrollment, I = Free, J = PercentFree, K = Reduced, M = FreeReduced, P = BuildingEnrollment, Q = BuildingFree, S = BuildingReduced , U = BuildingFreeReduced, X = StateFree, Z = StateReduced
Put a filter on column G and delete all rows where G is blank (ethnicity data)
Populate Year column with year of data downloaded
Enter this formula in E and paste down: =FIND(" ",G2,1)-1
Enter this formula in D and paste down: =TEXT(LEFT(G2,FIND(" ",G2,1)-1),"000")