[GAS Library] Easy Copy-Paste! A Library to Automatically Parse Addresses in Google Sheets into Country, State, and City

1. Overview

AddressParserLibrary is a Google Apps Script library designed to parse address strings in a Google Sheet into their constituent parts, such as country, city, and postal code. It processes a specified column of addresses in bulk and outputs the results starting from a designated column.

2. Supported Countries

Currently, the library supports the following address formats:

• United Kingdom (UK)
• United States (USA)
• Japan
• China
• Canada

3. Library Information

• Library Name: AddressParserLibrary
• Script ID: 1J2Vy9PJ1d3f2DvvHfbDUJz3j3XPcDZVOlGVnoJ37pUYqZ68wHaVZCysb

4. Provided Functions

parseAddresses(sheetName, inputColumn, startRow, outputColumn)

Parses the address data in a specified sheet and outputs the results to the same sheet.

Parameters

‍

‍

Return Value

‍

‍

How to Use

Step 1: Add the Library

1. Open the Script Editor from your Google Sheet.
2. In the left-hand menu, click the + icon next to "Libraries."
3. In the "Script ID" field, paste the following ID and click "Look up."

1J2Vy9PJ1d3f2DvvHfbDUJz3j3XPcDZVOlGVnoJ37pUYqZ68wHaVZCysb

1. Choose the latest version and ensure the "Identifier" is AddressParserLibrary (you can change it if needed).
2. Click the "Add" button.

‍

Step 2: Execute the Function

Write a script to call the library's function.

Code Example

You can copy and paste the following function into the script editor to get started.

‍

JavaScript
/** * A sample function to parse addresses in a spreadsheet. */
function parseMyAddresses() {  
// --- Parameters ---  
const sheetName = 'sheet1';      
// The name of the sheet containing the addresses  
const inputColumn = 'A';         
// The column where addresses are located  
const startRow = 2;             
// The row where the data begins (assuming row 1 is a header)  
const outputColumn = 'C';        
// The column where the output will start    
// Execute the library 
function  const success = AddressParserLibrary.parseAddresses(sheetName, inputColumn, startRow, outputColumn);    
// Log the result of the execution  
if (success) {    
console.log('Address parsing complete.');  
} else {    
console.log('An error occurred during the process.');  }}

‍

Execution Example

• Before Execution:
  • Addresses from various countries are listed in column A of a sheet named sheet1, starting from the second row.
• After Execution:
  • After running the parseMyAddresses function, the addresses from column A are parsed, and the results (country, city, postal code, etc.) are outputted into columns C, D, E, and so on.

‍