Export Pages by Language

### 1. **Export via WordPress Tools**
– Go to **Tools** > **Export** in the WordPress admin panel.
– Select the **Pages** option.
– If you're using a multilingual plugin:
– Some plugins allow filtering by language on this screen.
– Choose the desired language from the filter dropdown (if available).
– Click **Download Export File** to get an XML file containing pages in the selected language.

—

### 2. **Export via Multilingual Plugin**
If you're using a plugin like WPML or Polylang, these plugins provide additional tools for exporting language-specific content:

**For WPML**:
– Navigate to **WPML** > **Translation Management**.
– Use filters to narrow down pages by language.
– Export translations or specific language content via the available tools.

**For Polylang**:
– Ensure you have a language selector in the admin list of pages (typically added by Polylang).
– Filter pages by the desired language.
– Use the WordPress export tool to export only filtered results.

—

### 3. **Using a Plugin for CSV Export**
Plugins like **WP All Export** allow for more granular exports:
– Install and activate **WP All Export**.
– Go to **All Export** > **New Export**.
– Select **Pages** as the post type.
– Add a filter for the desired language (if using WPML or Polylang, you can filter by language meta key).
– Export data to a CSV or XML file.

—

### 4. **Custom Query with SQL**
If you're comfortable running SQL queries on your WordPress database:
– Identify the language meta key or taxonomy used by your plugin (e.g., `language_code` for WPML or `pll_language` for Polylang).
– Run a query to fetch pages for the specific language. Example:

SELECT * 
     FROM wp_posts p
     INNER JOIN wp_postmeta pm ON p.ID = pm.post_id
     WHERE p.post_type = 'page' 
       AND pm.meta_key = 'language_code' 
       AND pm.meta_value = 'en'; -- Replace 'en' with the desired language code

– Export the query results to your desired format (CSV or SQL).

Would you like detailed steps for any specific plugin or method?