Well in general Plus Codes are kinda intended to be most useful in areas that dont already have a viable postcode code system. So may not be a viable postcode system (just using name postcode for brevity, some places say zipcode)
But seems you want a reverse geocoder. The act of turning a location (be that lat/long directly, or lat/long extracted from plus-code!), into an 'address' (be that a textual address, or simply a postcode!) - is the job for a reverse geocoder. ... powered by huge lookup tables. ie a 'postcode reverse geocoder' - literally needs a database of every postcode and its location. So searches for the nearest postcode to the search location. Not something that can be viably done in a 'spreadsheet' really. Many countries have large numbers of postcodes, and so a function that has worldwide coverage is a big database. A webservice is typically the easiest way, as they have done the 'heavy' lifting of importing the zipcodes, and building a search function. https://www.google.com/search?q=reverse+geocoder+service Or can get databases: https://www.geonames.org/postal-codes/ This also demonstrates in theory one of advantages of plus-codes, ie the location data is* encoded into the code itself. Rather than being 'lookup table' based. * mostly anyway! ironically some types - short plus-codes - still need a geocoder lookup to extract the location!) On Fri, Oct 4, 2019 at 6:22 PM River Mersey <therivermersey....@gmail.com> wrote: > [Just had a quick search or previous threads and couldn't find anything on > this.] > > Does anyone know how to use either lat/long or pluscodes to generate a > postcode for the specified location? > > Possibly a lookup table to be used in a database or spreadsheet? > > Many thanks > > -- > Public site: http://www.openlocationcode.com/ > Github project: https://github.com/google/open-location-code > Demo site: http://plus.codes/ > --- > You received this message because you are subscribed to the Google Groups > "Plus Codes Community Forum" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to open-location-code+unsubscr...@googlegroups.com. > To view this discussion on the web, visit > https://groups.google.com/d/msgid/open-location-code/28d066e4-bebd-403a-aac5-6162f3c85186%40googlegroups.com > <https://groups.google.com/d/msgid/open-location-code/28d066e4-bebd-403a-aac5-6162f3c85186%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- Public site: http://www.openlocationcode.com/ Github project: https://github.com/google/open-location-code Demo site: http://plus.codes/ --- You received this message because you are subscribed to the Google Groups "Plus Codes Community Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to open-location-code+unsubscr...@googlegroups.com. To view this discussion on the web, visit https://groups.google.com/d/msgid/open-location-code/CAJCAUuJdHKuO_56FqpkKERWsC0MM%3DDFk%3DZ-be7%2BjZq7bX2o5mQ%40mail.gmail.com.