Formulas & actions

Action columns bulk add or remove Shopify product tags, update manual collections, and upload images, all from your spreadsheet in a single click.

Filter Shopify products, orders, and customers by text, number, and date criteria, so your spreadsheet shows exactly the rows you need.

Set up a Conditional Worksheet that loads only the Shopify data you need. Filter products, orders, or customers by vendor, tag, date, or your own criteria.

Sort your Shopify store data in ascending or descending order. Arrange products, orders, or customers by any column in a couple of clicks.

Press Ctrl+F to search your Shopify data. Find any value across a worksheet fast and jump between matching cells as you go.

Pull related Shopify data into Orders, Products, Customers, and Media Images worksheets. Show vendors, SKUs, tracking numbers, inventory value, and more, without formulas.

Preview every Shopify change before it syncs. Review each pending edit, row, field, and value in one dialog, so nothing reaches your store by accident.

Format the columns in your Shopify spreadsheet. Apply currency, date, number, percentage, text, or dropdown formatting to keep your data tidy and readable.

Restore rows you deleted from a worksheet by accident. Fill Missing Worksheet Data repopulates any Shopify data that is gone, without overwriting what is there.

Clean up empty rows in a worksheet using the automatic Empty rows detected notice, or the Remove Empty Rows command in the Worksheet menu.

Update Shopify data fast with bulk actions. Find and replace text, bulk update numbers by amount or percentage, and add or remove tags across many records.

Find and replace text across your Shopify store in bulk. Update product descriptions, SEO fields, tags, and option values everywhere with a single action.