I created a simple, free plugin, called Flat Meta Data, that flattens post and user meta data into a CSV that can more easily be used for reporting and analysis. In the process it creates tables in your database ([:prefix]postmeta_flat and [:prefix]usermeta_flat) that contain the same information and can be used in more complex queries. The plugin is pretty raw, but gets the job done. I hope it helps.

I created a simple, free plugin, called Flat Meta Data, that flattens post and user meta data into a CSV that can more easily be used for reporting and analysis. In the process it creates tables in your database ([:prefix]postmeta_flat and [:prefix]usermeta_flat) that contain the same information and can be used in more complex queries. These tables have one row per post or user and one column per data point (meta_key) containing the meta values (meta_value).

After installing and activating the plugin (in wp-content/plugins/flat-table), it is accessible through a link in the main menu of the admin panel, called Flat Meta Data. You can then click on either the "Download post meta data" or "Download user meta data" button to generate the table and download the CSV containing all of the data in spreadsheet form.

A few notes:

1. This plugin is provided free of charge. Use at your own risk.
2. CREATE TABLE privileges are required. This shouldn't be an issue, but could be if you've restricted access to the WordPress database user.
3. Generating and downloading a complete set of meta data can negatively impact system performance. Please do so only during off-hours or, better yet, on a sandbox populated with your live data.

Please let me know if you have any questions. Thanks.

I created a simple, free plugin, called Flat Meta Data, that flattens post and user meta data into a CSV that can more easily be used for reporting and analysis. In the process it creates tables in your database ([:prefix]postmeta_flat and [:prefix]usermeta_flat) that contain the same information and can be used in more complex queries. The plugin is pretty raw, but gets the job done. I hope it helps.

I created a simple, free plugin, called Flat Meta Data, that flattens post and user meta data into a CSV that can more easily be used for reporting and analysis. In the process it creates tables in your database ([:prefix]postmeta_flat and [:prefix]usermeta_flat) that contain the same information and can be used in more complex queries. The plugin is pretty raw, but gets the job done. I hope it helps.