20 practical workflows

Merge the exports you actually use

Choose a workflow below for recommended match fields, merge mode, matching rules, common pitfalls and a direct path into MergeStudio. These pages assume you already exported Excel or CSV files; MergeStudio does not connect to third-party accounts.

Software-to-software workflows

Combine exports from common ecommerce, CRM, email, payment and accounting platforms.

Software workflow

Merge Shopify CSV with QuickBooks Data

Combine Shopify customer or order exports with QuickBooks data by email, customer reference, or another shared field—without VLOOKUP formulas.

Software workflow

Merge Shopify Orders with Stripe Payments

Join Shopify order exports with Stripe payment or customer exports using a shared reference, customer email, or stored Stripe customer ID.

Software workflow

Merge Shopify Orders with PayPal Transactions

Match Shopify order data with PayPal transaction exports using a shared transaction reference, order reference, or customer email.

Software workflow

Merge Shopify Customers with Klaviyo Profiles

Combine Shopify customer exports with Klaviyo profile data by email, phone, or a shared external customer ID.

Software workflow

Merge Shopify Customers with Mailchimp Contacts

Join Shopify customer exports with Mailchimp contact exports by email to compare buyers, subscribers, and customer attributes.

Software workflow

Merge HubSpot Contacts with Stripe Customers

Combine HubSpot contact exports with Stripe customer data by email or a shared external customer ID for revenue and lifecycle analysis.

Software workflow

Merge HubSpot Contacts with Mailchimp Contacts

Match HubSpot contacts with Mailchimp contacts by email to compare list coverage, CRM fields, and marketing status.

Software workflow

Merge HubSpot Contacts with Shopify Customers

Join HubSpot CRM contacts with Shopify customer exports using email, phone, or a shared customer ID.

Software workflow

Merge Salesforce Contacts with Stripe Customers

Combine Salesforce contact exports with Stripe customer data using email or a shared external customer ID.

Software workflow

Merge WooCommerce Orders with QuickBooks Data

Join WooCommerce order exports with QuickBooks customer, invoice, or transaction data using a shared reference or customer field.

Software workflow

Merge Square Transactions with QuickBooks Data

Compare Square transaction exports with QuickBooks data using a shared reference or carefully chosen compound key.

Software workflow

Merge Xero Contacts with Stripe Customers

Join Xero contact exports with Stripe customer data using email or an external customer reference.

Common spreadsheet workflows

Use these when the task matters more than the software that produced the files.

Normal spreadsheet jobs are processed locally in your browser.

Your spreadsheet contents are not sent to a MergeStudio backend during normal local processing. Oversized jobs are stopped rather than silently uploaded.

Don’t see your exact workflow?

If both exports share a stable ID, email, SKU, order reference or other key—or if they are recurring files with the same headers—MergeStudio can usually combine them.

Try your files →

Third-party product names belong to their respective owners. MergeStudio is not affiliated with or endorsed by those providers.