Search for Shopify information

Mixtable’s worksheet search helps you find text, numbers, SKUs, customer details, and other values in the active worksheet. It shows every matching cell, lets you move through the results, and keeps track of which match you are viewing.

Open worksheet search

Press Ctrl+F on Windows or Cmd+F on a Mac while working in a Mixtable worksheet. The search panel opens on the right side of the worksheet and places your cursor in the Search cells… box.

Search the active worksheet

1. Type the value you want to find in Search cells…
2. Wait briefly while Mixtable searches the active worksheet
3. Review the match counter, such as 1 of 12, to see your current result and the total number of matches
4. Click Prev or Next to move backward or forward through the matching cells
5. Click any item under Matches to jump directly to that result

Each result shows the column, worksheet row, and matching cell content. Mixtable highlights the matching text in the results list and selects the corresponding cell in the worksheet.

If there are no results, the panel displays No matches found. Try a shorter or different search term.

Search a different worksheet

Search works on the active worksheet. If you switch to another worksheet while the search panel is open, Mixtable reruns the same search against the newly selected worksheet.

To close search, click the X, press Escape, or use the keyboard shortcut again.

You're ready!

Mixtable is an online spreadsheet designed to sync data with Shopify. It looks, feels, and behaves like Excel (including formulas), but runs in your browser. With Mixtable you can:

• Bulk add products to collections, edit metafields, add or remove tags;
• Change product prices, including international prices, and review price history;
• Manage customers with a spreadsheet CRM for Shopify;
• Use Excel features like sort ascending or descending, find-replace, filter, and more.

Best of all, you can sync changes back to Shopify with a single click. Find out more about the Mixtable suite of products here.