In this tutorial, you’ll learn how to export and import Media Library categories in WordPress.
With the Media Library Categories plugin you can add a category system to your WordPress Media Library. You can categorize your media library files and better organize your site.
However, you can’t download your media library categories in a CSV file, nor can you bulk update media file categories by importing a CSV file.
Fortunately, the WP Sheet Editor – Media Library plugin allows you to edit and manage your media files in an intuitive table.
It’s like using an Excel spreadsheet or Google Sheets to manage your WordPress files.
And in this guide it will allow you to export and import categories.
You can download the plugin here: Download Media Library Spreadsheet Plugin - or - Check the features
Once you install and activate the plugin, you can proceed to export your media library categories to a CSV file.
How to export media library categories
You can export the media library categories by using the Export tool form WP Sheet Editor.
Once you open the Export tool, you need to select the following values:
- What columns do you want to export: You can select all the columns, the active columns only, or specific columns to export.
- Which rows do you want to export: You can export all the rows, the rows that you filtered using the “Search” tool, or the rows you manually select in the spreadsheet.
- What app will you use to edit this file: You can select Excel, Google Sheets, or other apps.
- Click on Start new export.
Once the export process is complete, a CSV file will be downloaded to your computer.
Here’s our CSV file containing our media library categories in Excel.
We can apply changes, add new files, add new categories separating them with comas, etc.
How to import media library categories
Besides exporting a CSV file, you can import media library categories with a few clicks.
This is a good way of assigning new categories to your library files, or editing the existing categories on your media library files.
Just click on Import on the top toolbar.
Now you need to configure the import process by adding the CSV file you will upload to WordPress:
- Source: CSV file from my computer
- CSV file: Click on Choose file and find the CSV on your computer
- Click on Next
Now click on Import all the columns.
Now you need to match the values in the CSV file with the values in WordPress.
- Select record_id in CSV Field.
- Select ID in WordPress Field.
- Click on Next.
Finally, you’ll see a preview of what the info will look once it’s imported.
If everything is OK, click on The preview is fine, start import.
Now the import process will execute and all your media library categories will be updated on the Media Library Spreadsheet.
Here’s a tutorial where you can learn how to bulk edit media library categories.
You can download the plugin here: Download Media Library Spreadsheet Plugin - or - Check the features