Open CSV file in MS Excel

For Cities (with Townships)

1.  Save as XLXS file "[StateCode] Cities Townships Census.xlsx".

2.  Delete 1st row

3.  Insert 3 columns to the left of Column B

4.  rename the 1st row: "Id, MunID, StateFIPS, MunFIPSCode, Id2, Geography, Population2010Census, Population2010Estimate, Population2010, Population2011, Population2012, Population2013, Population2014, Population2015, Population2016, Population2017, Population2018"

5.  In C2 enter: “=LEFT(E2,2)” and copy down

6.  In D2 enter: "=RIGHT(E2,5)" and copy down

For Cities (without Townships)

Save as XLXS file "[StateCode] Cities Census.xlsx" or "[StateCode] Counties Census.xlsx"

Delete 1st row

Insert 3 columns to the left of Column B

rename the 1st row columns: "Id, MunID, CountyFIPS, MunFIPSCode, Id2, Geography, Population2010Census, Population2010Estimate, Population2010, Population2011, Population2012, Population2014, Population2014"

In D2 enter: "=RIGHT(E2,5)" and copy down

For Counties

Save as XLXS file "[StateCode] Cities Townships Census.xlsx".

Delete First row.

Insert three columns to the left of B.

rename the 1st row: "Id, MunID, StateFIPS, MunFIPSCode, Id2, Geography, Population2010Census, Population2010Estimate, Population2010, Population2011, Population2012, Population2013, Population2014, Population2015".

In C2 enter: “=LEFT(E2,2)” and copy down

In D2 enter: "=RIGHT(E2,3)" and copy down

Figure 28: Sample of County Census after MS Excel steps complete