Can I extract H1 and H2 data from product pages in bulk edit?

Store Design

Topic summary

A user wants to extract H1 and H2 heading data from product pages to review alongside SEO fields in bulk, similar to how they can view SEO information in Shopify’s bulk editor.

Proposed Solutions:

  • CSV Export Method: Export product data via Shopify admin (Products > All products > Export), selecting relevant fields including “Body (HTML)”. Open the CSV in a spreadsheet program and use filtering/search functions to locate H1 tags and other HTML elements within the “Body (HTML)” column.

  • Third-Party Tool: Use Apify’s Simple SEO Data Extractor app to automatically extract the desired SEO data from product pages.

Status: The original poster confirmed the CSV export solution works well for their needs.

Summarized with AI on October 27. AI used: claude-sonnet-4-5-20250929.
2

  1. Export your product data: Shopify provides the ability to export your product information in a CSV (Comma Separated Values) file format. To export your product data, go to your Shopify admin panel and navigate to “Products” > “All products.” Then, click on the “Export” button to generate a CSV file containing your product information. Make sure to select the relevant fields, such as “Title,” “Body (HTML),” or any other fields you need for analysis.

  2. Open the CSV file: Once you’ve exported the CSV file, open it using a spreadsheet program like Microsoft Excel, Google Sheets, or any other tool that supports CSV file formats.

  3. Analyze the HTML data: In the CSV file, you’ll find the product data for each product, including the title, description, and other fields. Look for the “Body (HTML)” field, which contains the HTML content of the product description. In this field, you can search for the H1 tags or any other SEO-related elements you’re interested in.

  4. Use filtering or search functions: To identify the H1 tags or other SEO fields, you can use the filtering or search functions available in your spreadsheet program. For example, you can filter the “Body (HTML)” column to display only the rows containing specific HTML elements or use the search function to find instances of specific tags.