Census Advanced Search: https://factfinder.census.gov/faces/nav/jsf/pages/index.xhtml
Census Report: S1903
Dataset: 2017 ACS 5-year estimates
Product Type: Subject Table
People: Income & Earnings – Income/Earnings (Households)
All Places within Michigan
In Select Geographies click Name and you can select Townships
MS Excel Steps
Delet 1st Row
Delete Columns D, E, F, G
Delet Column E
Insert 4 columns to the left of B
Column Names: ID, MunID, StateFIPS, MunFIPSCode, FiscalYear, ID2, Geography, MedianIncomeHouseholds
In C2 enter: “=LEFT(F2,2)” and copy down
In D2 enter: "=RIGHT(F2,5)" and copy down
Populate Column E with the Fiscal Year Downloaded