Importing reviews

Any platform without a public API (Trustpilot, TripAdvisor, Booking.com, Airbnb, Houzz, an old plugin, a spreadsheet) comes in through CSV or JSON import. Import once, display forever; there is no lock-in in either direction, since export is always available too.

Importing

Range Trust → Tools → Import reviews:

Pick the source the reviews belong to (create an Imported source first if needed).
Optionally set a platform label (e.g. tripadvisor); it becomes the badge on cards for rows that don't specify their own.
Paste CSV/JSON, or upload a .csv/.json file, and click Import.

Duplicate detection is automatic: re-importing the same file skips existing reviews rather than doubling them.

Recognised columns

The importer matches column names loosely, so most exports work unedited. Canonical names and their accepted aliases:

Field	Accepted column names
reviewer	`reviewer`, `name`, `author`, `reviewer_name`, `customer`, `customer_name`, `display_name`
reviewer_avatar	`reviewer_avatar`, `avatar`, `photo`, `profile_photo_url`, `image`
rating	`rating`, `stars`, `star_rating`, `score`, `review_rating`
title	`title`, `headline`, `summary`
content	`content`, `text`, `review`, `review_text`, `body`, `comment`, `message`
reviewed_at	`reviewed_at`, `date`, `created_at`, `time`, `review_date`, `published_at`
platform	`platform`, `source`, `site`, `channel`
language	`language`, `lang`, `locale`
url	`url`, `link`, `review_url`, `permalink`
reply	`reply`, `response`, `owner_reply`, `owner_response`
external_id	`external_id`, `id`, `review_id`

Dates accept ISO strings, timestamps and most human formats. A per-row platform column overrides the import's default label, so one file can carry several platforms. JSON accepts a plain array of objects or {"reviews": [...]} using the same keys.

A minimal CSV:

reviewer,rating,content,date,platform
Jane S.,5,Wonderful stay,2026-05-01,booking.com

Exporting

Tools → Download CSV exports every stored review (all statuses) with the canonical column names above, which means a Range Trust export re-imports cleanly.

From the command line

wp range-trust import reviews.csv --source=2 --platform=tripadvisor
wp range-trust export > reviews.csv

See WP-CLI.