search
☰
Using Mixtable
Shopify

Product Management

Add product category
Bulk edit Google Shopping fields
Bulk import or add products
Bulk edit product descriptions
Bulk add, update, and remove tags
Bulk update product status
Using the Shopify sidebar
Publish or unpublish products in bulk
Delete a product
Edit Shopify product descriptions with rich text editor
Enable inventory tracking for multiple products
Bulk delete products
View product data history
Update SEO Title and SEO Description
Load the products of a single vendor into a worksheet
Product Theme Template

Inventory Management

Manage and track inventory
Adjust inventory quantity
Update inventory across multiple locations
Manage and track inventory

Variants

Add variants to your products in bulk
Change variant display order
Bulk delete product variants

Collections

Add products to collections

Pricing

Set international pricing for products
Shopify Markets Compare At Price
Bulk change product prices
Increase prices in bulk
Cost per item
Bulk change Compare At prices
View product price history

Blogs and Pages

Bulk edit blog posts
Bulk edit Pages

Metafields

Bulk edit metafields

Customers

Bulk edit customers
Bulk import or add customers
Bulk delete customers
Building a Shopify store CRM

Import and Export

Export blog posts
Export Pages
Export store data to CSV
Export store data to Excel
Export orders with metafields
Export orders data
Export products with metafields
Export products data
Export products with collections

Product Images

Manage product images
Manage variant images
Set image ALT tag

Orders

Bulk delete orders
Analytics

Collection Analytics

Collection Analytics

Sales Analytics

Analyze store sales
Net Sales Analytics
Shopify Analytics Last 30 Days
Gross Sales Analytics
Gross Quantity (Units) Sold
Net Quantity (Units) Sold
Product Variant Analytics
Sales for last 30 days
Sales for Last Month
Sales for Last Year
Customer Country Analytics
Product Sales Metrics
Sales by Product Variant
Collection Sales
Sales by Customer

Customer Analytics

Customer Analytics
Customer Segment Analytics

Refund Analytics

Export refunds data
Percent of Orders Refunded Analytics
Refund Count Analytics
Total Refund Amount Analytics
Refunds for Last 30 days
Refunds for Last month
Refunds for Last Year

Order Analytics

Orders Count Analytics
Orders for Last 30 days
Orders for Last Month
Orders Net Profit Analytics
Orders for Last Year

Discount Analytics

Total Discount Amount Analytics
Play

Exporting Shopify data to Excel .xlsx file

Easily export your entire workbook to an Excel .xlsx file whenever you want. All your data, including raw values, formulas, images, and formatting, will be retained seamlessly in the transition from Mixtable to Excel.

To do this:

  1. Click the “Export” menu item located at the top of your screen
  2. Choose the “Export to Excel” option.
  3. A prompt will then guide you to select a save location for your file.

Exporting Shopify data to Excel .xlsx file



Well done!

Mixtable Excel and CSV Export is an Excel-like app that is built to sync data with Shopify. It looks, feels, and behaves like Excel (including formulas), but runs in your browser. Find here:

Mixtable is an online spreadsheet, designed from the ground up to bulk edit and analyze Shopify data.

Got a question? We're here to help! Reach out at [email protected], and we'll get back to you promptly.
Product
Resources