Spreadsheet import and export

Go to Resources > Import & Export.

Export

Click Download spreadsheet to get every resource as a CSV file that opens in Excel, Numbers, or Google Sheets. It is also a good backup.

Import

1. Click Download a template, or start from an export.
2. Fill in your spreadsheet and save it as CSV. In Excel use File > Save As; in Google Sheets use File > Download.
3. Upload it and click Preview import.
4. Review what will happen: how many rows are new, updated, or skipped, and why any were skipped.
5. Click Import.

Rows match existing resources by ID first, then by exact Name. Anything else becomes a new resource.

By default, blank cells keep existing values, so you can update just a few columns. Check Blank cells clear existing values to clear them instead.

Column formats

Column	Format
Monday to Sunday	09:00-17:00, 9am-5pm, closed, or 24 hours. Leave blank if unknown.
Categories	Separate several with |. Use > for subcategories, like Food > Food Pantries. Missing categories are created.
Features	Names separated by |, like Free | Walk-ins welcome
Languages	Separated by commas
Confidential location	yes hides the street, ZIP, and map pin publicly. Blank keeps the current setting.
Status	publish, draft, or pending. New rows are published if blank.
Last verified	Any date, like 2026-10-01 or October 1 2026

Columns can be in any order, and you can leave out ones you do not need. Only Name is required for new resources.

From the command line

wp opendoor-pro export resources.csv
wp opendoor-pro import resources.csv --dry-run
wp opendoor-pro import resources.csv