This guide walks you through how to locate your website content within an exported WordPress zip file. You’ll learn where posts, pages, media, themes, and plugins are stored so you can back up, migrate, or restore your site with confidence.
Key Takeaways
- WordPress exports come in two main types: XML (content-only) and full-site zip (includes files and database).
- Your posts and pages live in the XML file inside the zip, not in the folders.
- Media files like images and videos are stored in the wp-content/uploads folder.
- Themes and plugins are found in wp-content/themes and wp-content/plugins respectively.
- The database.sql file contains all dynamic content if you’ve exported a full backup.
- Always extract the zip first before trying to access any files.
- Use a text editor or import tool to read XML files—don’t double-click them.
Introduction: Why You Might Need to Find Content in a WordPress Zip
Whether you’re migrating your WordPress site to a new host, restoring from a backup, or just curious about how your site is structured, you’ve probably downloaded an exported WordPress zip file. But once you have that file, you might be wondering: Where is my content actually stored?
WordPress exports can be confusing because they come in different formats. Some only include your posts and pages. Others contain your entire website—files, database, themes, and all. This guide will help you navigate your exported WordPress zip file with confidence, so you can find exactly what you’re looking for—whether it’s a blog post, an image, or your custom theme.
By the end of this guide, you’ll know how to extract, explore, and understand the structure of your WordPress backup. Let’s get started!
Step 1: Understand the Two Types of WordPress Exports
Before diving into the zip file, it’s important to know what kind of export you have. There are two main types:
Visual guide about Where to Find Website Content Within Exported WordPress Zip
Image source: cdn.sstatic.net
1. Content-Only Export (XML File)
This is created using WordPress’s built-in Tools > Export feature. It generates a single .xml file that contains your posts, pages, comments, categories, tags, and custom fields. This file does not include your images, themes, plugins, or database settings.
This type of export is lightweight and ideal for moving content between sites or backing up your written content. However, it won’t help you restore your full site design or media library.
2. Full-Site Backup (Zip with Files and Database)
This is a complete backup created by a plugin like UpdraftPlus, Duplicator, or All-in-One WP Migration. It includes:
- Your entire WordPress file structure (themes, plugins, uploads, etc.)
- A database export (usually a .sql file)
- Configuration files like wp-config.php
This type of zip is what you need if you want to fully restore or migrate your site. It contains everything—your content, design, settings, and media.
Tip: Always check the file size. A full-site backup is usually several megabytes or even gigabytes, while a content-only XML file is often under 1 MB.
Step 2: Extract the Zip File
You can’t browse the contents of a zip file without extracting it first. Here’s how:
On Windows
- Right-click the zip file and select “Extract All…”
- Choose a destination folder (e.g., Desktop or Documents)
- Click Extract
On Mac
- Double-click the zip file
- It will automatically extract to the same location
Using Third-Party Tools
If you’re dealing with a large or corrupted zip, tools like 7-Zip (Windows) or The Unarchiver (Mac) can help. They support more formats and handle errors better.
Important: Always extract to a new folder to avoid overwriting existing files.
Step 3: Locate Your Website Content
Now that your files are extracted, let’s find your content. The structure will vary slightly depending on the export type, but here’s what to look for.
Finding Posts and Pages (XML Export)
If you used WordPress’s built-in export tool, you’ll see a file named something like wordpress.xml or export.xml.
- This file contains all your posts, pages, and metadata in XML format.
- You can’t read it like a normal document—it’s structured for machines.
- To view it, open it in a text editor like Notepad (Windows) or TextEdit (Mac).
- Or better yet, use a code editor like VS Code or Sublime Text for syntax highlighting.
Example: Search for <item> tags—each one represents a post or page. Inside, you’ll see titles, content, dates, and categories.
Pro Tip: Don’t double-click the XML file—it might open in a browser and look messy. Always use a text editor.
Finding Posts and Pages (Full Backup)
In a full backup, your posts and pages are stored in the database.sql file, not in individual files.
- Look for a file named database.sql, backup.sql, or similar.
- This file contains all your site’s data in SQL format—structured for MySQL.
- You can open it in a text editor, but it’s best viewed with a database tool like phpMyAdmin or Adminer.
Note: The actual content (like blog text) is stored in the wp_posts table within the SQL file. You’ll need to import this into a database to read it properly.
Finding Media Files (Images, Videos, Documents)
Your uploaded media—like photos, PDFs, and videos—are stored in the wp-content/uploads folder.
- Navigate to: extracted-folder > wp-content > uploads
- Inside, you’ll see folders organized by year and month (e.g., 2024/06)
- Each folder contains the files uploaded during that time
Example: If you uploaded a photo in June 2024, it will be in uploads/2024/06/photo.jpg.
Tip: These files are ready to use—you can copy them directly to a new site or your computer.
Finding Themes and Plugins
Your website’s design and functionality come from themes and plugins. Here’s where to find them:
Themes
- Location: wp-content > themes
- Each folder represents a theme (e.g., twentytwentyfour, my-custom-theme)
- Inside, you’ll find PHP files, CSS, JavaScript, and template parts
Plugins
- Location: wp-content > plugins
- Each plugin has its own folder (e.g., contact-form-7, woocommerce)
- Contains the plugin’s code, assets, and settings
Note: These folders are essential if you’re rebuilding your site. Just copy them to the corresponding folders on your new WordPress installation.
Finding Configuration Files
Some important files to look for:
- wp-config.php: Contains database credentials and security keys
- .htaccess: Controls URL rewriting and server rules (common on Apache servers)
- wp-content > upgrade: Temporary files from updates (usually safe to ignore)
Warning: Never share your wp-config.php file—it contains sensitive information.
Step 4: How to Use What You’ve Found
Now that you know where everything is, here’s how to use it:
Restoring Content to a New Site
- For XML exports: Use Tools > Import in WordPress and upload the XML file.
- For full backups: Use a migration plugin like Duplicator or All-in-One WP Migration to restore the entire site.
Backing Up Specific Files
- Copy only the uploads folder to save your media.
- Save your themes and plugins folders if you’ve made custom changes.
Editing Content Offline
- Open the XML file in a text editor to review or edit posts.
- Use a tool like WordPress Importer to bring changes back online.
Troubleshooting Common Issues
Even with the best guide, things can go wrong. Here’s how to fix common problems:
“I Can’t Open the XML File”
This usually happens when you double-click it and it opens in a browser. Instead:
- Right-click the file > Open With > Choose a text editor
- Or drag the file into VS Code or Notepad++
“The Zip File Won’t Extract”
This could mean the file is corrupted or incomplete.
- Try downloading it again
- Use a different extraction tool (e.g., 7-Zip)
- Check if the file size matches what was expected
“I Can’t Find My Content”
Double-check the export type:
- If you only see an XML file, you have a content-only export
- If you see folders like wp-content and a .sql file, you have a full backup
- Look for the database.sql file—your posts are in there
“My Media Files Are Missing”
This happens if you only exported content (XML), not the full site. To avoid this:
- Always use a full backup plugin for complete restores
- Or manually download your uploads folder via FTP before exporting
Conclusion: You’re Now a WordPress Zip Expert
Finding your website content inside an exported WordPress zip file doesn’t have to be confusing. Whether you’re dealing with a simple XML export or a full-site backup, knowing where to look saves time and reduces stress.
Remember: Posts and pages live in the XML or database.sql file, media is in wp-content/uploads, and themes/plugins are in their respective folders. Always extract the zip first, and use the right tools to view the files.
With this knowledge, you’re ready to back up, migrate, or restore your WordPress site like a pro. Happy exploring!