{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/2b892519352542b3b407c239cb035b1f\" frameborder=\"0\" width=\"1920\" height=\"1440\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1440,"width":1920,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1440,"thumbnail_width":1920,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/2b892519352542b3b407c239cb035b1f-ca9c2a045756830d.gif","duration":1051.928,"title":"How to Convert ZIP to County","description":"In this video, I walk you through the process of organizing our Outscraper and MH Bay lists, focusing on filtering for Illinois data and creating a new Zip to County sheet. I emphasize the importance of having county information for our GIS mapping and explain how to use VLOOKUP to match postal codes with counties. I also demonstrate how to utilize ChatGPT to streamline this process, ensuring accuracy in our data. Please make sure to follow along and replicate these steps for your own data management. Let me know if you have any questions or need assistance!"}