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

How to Extract Specific Product Details From the Shopify Product Description Using EZ Exporter

As a Shopify merchant, you probably already know that when you perform a CSV export of your products via the Shopify Admin, the product description will include all the HTML tags in the data. Our EZ Exporter app can easily strip these out.

However, there may be more complex cases where you need to go even a step further, where you need to extract specific product attributes that were entered directly in the HTML product description in Shopify. You …

Read more

Automatically Replace Multiple Characters in Your Shopify Data Export With EZ Exporter

When generating a CSV/Excel export of your Shopify data to be sent to third parties such as a supplier or another platform, the recipient may require the content of certain fields to be formatted in a certain way.

For example, some systems may require fields such as the shipping address to include only official abbreviations. There may also be cases where the system receiving the data only supports ASCII characters and if your customer base is global, you'll most likely …

Read more

Google Analytics and You

By this point in time we should all have conceded to the fact that Google in almost any form is exceedingly helpful when trying to run an online business. Whether it’s helping us determine the trends we may want to use or helping us with our site’s search engine optimization, Google can do no wrong. In fact, it’s always right and to not take advantage of Google and its tools would be folly. There are countless tools that you …

Read more