Google Sheets Tip: Generate JSON Data from Rows and Columns

You may encounter a scenario where you need to convert data from your Google Sheets spreadsheet to JSON format.  You may need this to use as input to another app or system.

For example, our EZ Exporter app supports a function that takes a raw JSON string that can be used for looking up values (like a lookup table).

JSON data can have complex nested structure but a typical format you'll see is an array that looks like this:

["Alice", "Bob", "Eve", …
Read more

Google Sheets Tip: Generate a Comma-Separated List of Values From a Column

Using a comma-separated list of values is a fairly common format when entering multiple values as input to a form. You might have already encountered this while managing an ad campain where you can enter a list of keywords or when needing to send a marketing email to multiple recipients.

If you already have a spreadsheet where you maintain these types of data as rows in a column, you may be wondering whether there's an easy way to convert rows …

Read more

How to Create a CSV or Excel Direct Download Link in Google Sheets

As a Google Sheets user, you've probably already used the option to download the entire spreadsheet into an Excel file or a specific sheet/tab as a CSV/TSV file (under File > Download).

Did you know that you can actually create a URL that will do this for you automatically?  This way, you can share this direct download URL with others or just create a shortcut on your browser that you can click so you can auto-export the data to CSV/TSV or Excel without having …

Read more