topic Re: Zip codes xlsx to ArcGIS Pro and data population in ArcGIS Pro Questions https://community.esri.com/t5/arcgis-pro-questions/zip-codes-xlsx-to-arcgis-pro-and-data-population/m-p/1141883#M51132 I'm not sure if this will work necessarily, but you could try formatting your data in Excel as a table, and specifying the data type for the zip code column explicitly as Text instead of a number, and then importing it into ArcGIS Pro.<BR /><BR />Alternatively, you could add a letter to each field, import it into GIS, and then remove the letter using Calculate Field.<BR /> Tue, 08 Feb 2022 22:30:51 GMT JoshSaad1 2022-02-08T22:30:51Z Zip codes xlsx to ArcGIS Pro and data population https://community.esri.com/t5/arcgis-pro-questions/zip-codes-xlsx-to-arcgis-pro-and-data-population/m-p/1141869#M51131 <P>Hi all. I am bit in a pickle. I have a xlsx file that contains the zip code starting with the number 0, formatted as zip code in each cell. However, when I import the xlsx file onto ArcGIS Pro the attribute table populates the table without the '0' as the starting digit. Is there a way for ArcGIS to recognize the starting '0' in the zip code?&nbsp;</P><P>Additionally, once I have the zipcode in place. How do I populate my attribute table to the map? Please see example below.&nbsp;</P><P>&nbsp;</P><P>Thank you all for your help!&nbsp;</P><P>&nbsp;</P><TABLE border="0" width="448" cellspacing="0" cellpadding="0"><TBODY><TR><TD width="64" height="20">county</TD><TD width="64">agecat</TD><TD width="64">rate</TD><TD width="64">er1719</TD><TD width="64">pop1719</TD><TD width="64">county code</TD><TD width="64">FIPS code</TD></TR><TR><TD height="20">Alameda</TD><TD>1-2 years</TD><TD>277.1</TD><TD>343</TD><TD>123793.9</TD><TD>01</TD><TD>06001</TD></TR><TR><TD height="20">Alameda</TD><TD>10-13 years</TD><TD>138.7</TD><TD>323</TD><TD>232862.8</TD><TD>01</TD><TD>06001</TD></TR><TR><TD height="20">Alameda</TD><TD>14-17 years</TD><TD>183.5</TD><TD>423</TD><TD>230547.5</TD><TD>01</TD><TD>06001</TD></TR><TR><TD height="20">Alameda</TD><TD>18-34 years</TD><TD>559.5</TD><TD>6149</TD><TD>1.1E+10</TD><TD>01</TD><TD>06001</TD></TR><TR><TD height="20">Alameda</TD><TD>3-5 years</TD><TD>293.9</TD><TD>541</TD><TD>184077.8</TD><TD>01</TD><TD>06001</TD></TR><TR><TD height="20">Alameda</TD><TD>35-64 years</TD><TD>366.6</TD><TD>7172</TD><TD>1956263</TD><TD>01</TD><TD>06001</TD></TR><TR><TD height="20">Alameda</TD><TD>6-9 years</TD><TD>268.9</TD><TD>620</TD><TD>230542.2</TD><TD>01</TD><TD>06001</TD></TR><TR><TD height="20">Alameda</TD><TD>65-100 years</TD><TD>211.7</TD><TD>1442</TD><TD>681063.4</TD><TD>01</TD><TD>06001</TD></TR><TR><TD height="20">Alameda</TD><TD>&lt;1 year</TD><TD>183.4</TD><TD>114</TD><TD>62147.6</TD><TD>01</TD><TD>06001</TD></TR><TR><TD height="20">Alameda</TD><TD>All ages</TD><TD>356.8</TD><TD>17127</TD><TD>4800400</TD><TD>01</TD><TD>06001</TD></TR><TR><TD height="20">Alpine</TD><TD>1-2 years</TD><TD>0</TD><TD>0</TD><TD>51.5</TD><TD>02</TD><TD>06002</TD></TR></TBODY></TABLE> Tue, 08 Feb 2022 22:19:19 GMT https://community.esri.com/t5/arcgis-pro-questions/zip-codes-xlsx-to-arcgis-pro-and-data-population/m-p/1141869#M51131 chagithebear 2022-02-08T22:19:19Z Re: Zip codes xlsx to ArcGIS Pro and data population https://community.esri.com/t5/arcgis-pro-questions/zip-codes-xlsx-to-arcgis-pro-and-data-population/m-p/1141883#M51132 I'm not sure if this will work necessarily, but you could try formatting your data in Excel as a table, and specifying the data type for the zip code column explicitly as Text instead of a number, and then importing it into ArcGIS Pro.<BR /><BR />Alternatively, you could add a letter to each field, import it into GIS, and then remove the letter using Calculate Field.<BR /> Tue, 08 Feb 2022 22:30:51 GMT https://community.esri.com/t5/arcgis-pro-questions/zip-codes-xlsx-to-arcgis-pro-and-data-population/m-p/1141883#M51132 JoshSaad1 2022-02-08T22:30:51Z