Human Extended

    How to export WordPress metadata to Excel for inspection

    Why

    • Investigate a copy of the metadata in Excel, which offers sorting, filtering, etc.

    Alternative

    • Alternately, you can export the contents of your website to XML using the built-in Export feature in WordPress. You can then open the XML in a browser to view the metadata. This may be easier than examining the raw metadata, which is in a flat table format. For more information, see How to export WordPress pages to XML for inspection or migration.

    Definitions

    • CSV (Comma Separated Values) is a simple text format for storing tabular data. Each line of the file corresponds to a row in Excel. Within each line, the values are separated by commas or semicolons. These get loaded into the cells of the row.
    • phpMyAdmin is a web application that allows you to connect to your website database and export raw data. Typically, phpMyAdmin is provided by your web hosting provider.

    Steps

    1. Sign into the admin control panel provided by your web hosting service.

      This is not the same as the WordPress admin screen. This is a different admin tool provided by your hosting company to manage the installation of WordPress and its database. The exact location will depend on your hosting provider. Try looking for cPanel or Plesk, two common control panels.

    2. Look for phpMyAdmin and sign in.

      Typically, your web hosting company will provide a way for you to sign into phpMyAdmin. The credentials for phpMyAdmin are not the same as your WordPress credentials. They are different credentials for signing into the database directly outside of WordPress.

    3. Select the wp_postmeta table.

    4. Select the Export tab on top of the screen.

    5. Set the format to CSV or CSV for MS Excel

    6. Tap the Export button and your browser will download the CSV file.

    7. Open the file in Excel.

      If you exported to CSV, open the file directly in Excel. If you exported to CSV for MS Excel, you must first open Excel and then select From Text/CSV under the top Data menu.

    , , ,

    Leave a Reply

    Having trouble?

    We can do this for you.

    We complete tasks for you. Our goal is to offload your technical labor so you can focus on business and innovation.

    $60

    per hour

    Fixed rate for all types of tasks.

    No monthly charges.

    Pay by the minute.

    Schedule a Free Consultation