Google Sheets supports exporting data to a bunch of formats such as CSV, Excel, and PDF.  However, it doesn't support exporting data to JSON.

While the most popular and widely used data export format is CSV, there are some platforms that don't support it.

This use case actually came up from a customer of our Shopify data export app, EZ Exporter, where they wanted to export a custom product catalog of their Shopify product data to use with Klaviyo …

If you have a spreadsheet that has a column with a comma-separated list of values (like URLs), you can easily combine them and create a separate row for each one in Google Sheets using a formula like this:

=TRANSPOSE(SPLIT(JOIN(",", Sheet1!B2:B), ","))

The formula above references column B of Sheet1, where each row's Column B is a comma-separated list of URLs for each product on a Shopify store.

Here's what the formula does:

1. JOIN(",", Sheet1!B2:B): This part of the formula combines all …

Google Sheets has an IMPORTRANGE function that allows you to import a range of cells from another spreadsheet and requires you to enter the spreadsheet's URL.

But what if you just want to reference data from another sheet within the same spreadsheet?

A simpler approach is to use the QUERY function instead.

A Quick Example

We can use this formula to pull the values from columns A and B of Sheet1:

=QUERY(Sheet1!A:B)

Here's the data in Sheet1:

We'll enter the formula in …

Google Sheets has an INDIRECT function that lets users use relative row references in formulas.

For example, instead of using a formula like =A2+B2, you can replace the row numbers with a variable referencing the current row.  This way, you don't have to worry about whether the references for the current row are correct if your formula only deals with data in the current row.

This is particularly useful if you're pushing the formula to …

A QR code (short for Quick Response code) is a two-dimensional barcode that allows you store a lot more data compared to standard UPC barcodes.

You can easily scan it with your smartphone's camera and because almost everyone now has a smartphone, it's becoming more and more popular.

Because QR codes can store more data, this also allows for many more use cases.  They're especially very helpful as a shortcut for entering long texts where it's easy to make …