How to Bulk Import Listings into Listdom

If you already have listing details in a spreadsheet, you can bring them into Listdom in batches instead of retyping every business or property by hand. The built-in CSV importer lets you upload a file, connect its columns to Listdom listing fields, and process the records in batches. A careful sample import first helps catch mismatched fields, categories, or locations before they affect your full directory.

The right workflow depends on where your data lives. Use the built-in CSV importer for a one-time .csv file, the Excel add-on when you need to upload an .xlsx workbook directly, or the CSV add-on’s scheduled feed option when a source file is refreshed regularly. The importer can reduce repetitive entry, but the quality of the result still depends on the accuracy and structure of the source data.

Choose the import method that fits your source

For a one-time import, go to Listdom → Import / Export → CSV. This built-in workflow accepts a .csv file, then gives you a mapping screen where you match spreadsheet columns to Listdom fields. You can use it for listings and, through the relevant import flow, taxonomy data such as categories and locations.

If your working file is an Excel workbook, the Excel add-on adds an Excel import option under Listdom → Import / Export. It accepts .xlsx files and provides a similar field-mapping workflow. If you can export the workbook as CSV and prefer to use the built-in importer, that is another option; keep the original workbook as your editable source.

If an external CSV changes on a regular schedule, the CSV add-on also provides automated feed imports. That is useful when another system maintains the source file and you want Listdom to check it periodically. It is a different workflow from uploading one CSV manually, and it depends on the add-on and a saved mapping. For the recurring setup, timing, and monitoring steps, see how to schedule CSV listing imports in Listdom. For a one-time directory launch, start with the manual importer.

For migrating listings from another directory plugin already installed on the same WordPress site, check whether the Listdom Bridge add-on supports that source. A spreadsheet export is often the better route when the old platform is unavailable or the data has already been consolidated outside WordPress. See the Listdom setup guide’s overview of import and migration options if you are still deciding which route fits.

Prepare the spreadsheet before uploading

The import is only as clean as the data you give it. A short preparation pass can save more time than correcting hundreds of listings after they appear on the site.

Start with a header row and one listing per row. Give columns distinct names such as Business name, Description, Street address, City, Category, Phone, and Price. Avoid merged cells, title rows above the headers, and columns that contain more than one kind of information. For example, keep the phone number separate from the address so each can be mapped and searched appropriately.

Decide which details belong in Listdom’s built-in listing fields, which belong in custom fields, and which are categories or locations. A phone number or opening hours may be a custom field depending on how your directory is configured; categories and locations are taxonomies used to organize listings. If you need help deciding how these pieces should relate, read how listings, categories, and locations work in Listdom and how to plan your directory structure before designing it.

Use consistent names for repeated values. If one row says New York, another says NY, and a third says New York City, decide whether those should be one location or distinct terms before importing. The same applies to categories: spelling variations can create separate terms that fragment browsing and filtering. Listdom can create missing taxonomy terms during import, so inconsistent source values may become inconsistent directory structure.

Keep an unchanged copy of the source file and make a backup of the WordPress site before a large import. Then prepare a small sample file with representative cases: a typical listing, a listing with several taxonomy values, a row with optional data left blank, and any unusual entries. Testing a few different shapes is more informative than testing several identical rows.

Map the columns to Listdom fields

In WordPress, open Listdom → Import / Export → CSV, choose the CSV import option, and upload your file. When the mapping screen appears, pair each Listdom field with the source column that actually contains that value. For example, match Title to the business-name column, Content to the description column, and Address to the full address if that is how your file is structured. The exact available fields depend on your Listdom setup and custom fields.

Do not map by similar-looking labels alone. A source field called Area might mean a location, a service area, or the size of a property. Confirm what the data represents before connecting it. Leave a Listdom field unmapped if your file does not contain that information, or use a default only when the same value should genuinely apply to every imported listing.

If a field that matters to your directory does not exist yet, create and configure it in Listdom before importing, then map the source column to it. The advanced Listings mapping workflow can also create missing custom fields and handle multiple taxonomy columns or repeatable content such as FAQs, embed sections, and reviews. Those cases need more deliberate setup than a basic spreadsheet import; follow the detailed CSV and Excel listing-mapping guide for those field types.

For category or location trees, Listdom’s hierarchy-path option can interpret a column such as United States, California, San Diego as a parent-to-child path. Check the separators and spelling in your source first; a mistaken path can create terms under the wrong parent. If the taxonomy is already established, compare sample rows with the existing terms before proceeding.

Listdom’s Smart Mapping can suggest connections between source columns and Listdom fields when an AI Profile is configured. This can speed up the first pass for unfamiliar headers, but it is a suggestion step: inspect every proposed match, especially for locations, prices, status, and custom fields. An AI suggestion cannot tell whether two similarly named columns mean the same thing in your business rules.

If you expect to repeat imports with the same file structure, save the mapping as a named template in the importer. A template can save you from reconnecting the same columns next time. It does not replace checking that the next file still uses the same headers and meanings.

Test the sample, then import the full file

Run your sample through the same mapping you intend to use for the complete dataset. After the import finishes, inspect several records in the WordPress dashboard and on the public directory page. Check that the title, description, address, price, categories, locations, and custom fields landed in the right places. Try the relevant search and filters too: a value can look correct in an edit screen but still fail to behave as expected if it was assigned to the wrong type of field.

Pay particular attention to taxonomy paths, blank values, unusual punctuation, and rows that use defaults. If a result is wrong, fix the source or mapping and repeat with the sample before importing the larger file. Avoid treating a live directory as a scratch area for untested mappings.

When you are satisfied, upload the full CSV and start the import. Listdom processes the work in batches, and the import screen reports progress. Keep the page open until it reports that the process is complete. If a large job is interrupted, the importer provides recovery controls to resume from the last completed batch or discard the unfinished import; completed batches are not needlessly repeated when resuming. The recovery window is limited, so return to the import screen promptly if a job stops.

Before re-importing a file, inspect its matching behavior and the identifiers in the source. Depending on the available unique ID or title match, a row may update an existing listing rather than create a new one. That can be useful for refreshing known records, but it also means a second run is not automatically a safe “start over.” If you are unsure, test the behavior on a backup or staging copy and confirm which existing records will be affected.

Check the directory after import

An import is not finished just because the progress message reaches the end. Review the final directory as a visitor would. Search by a few imported names, filter by important categories and locations, and open listings with optional or unusual fields. Look for blank titles, duplicate taxonomy terms, address values in the wrong field, and details that should not be public.

Clean, consistently structured listing information helps visitors compare results and use filters. It also gives search crawlers and answer systems clearer facts to interpret: what each place offers, where it is, and how it differs from nearby entries. Structured data cannot compensate for inaccurate source records, and a bulk import by itself does not guarantee rankings or citations. The practical benefit is a directory whose underlying information is easier to browse, maintain, and understand.

For a repeatable workflow, keep a record of the source file, mapping template, import date, and any corrections made after review. When the source changes, compare its headers and taxonomy values with the version you tested rather than assuming a familiar filename means a familiar structure.

Common import problems and how to avoid them

A value appears in the wrong place. Recheck the mapping rather than editing every affected listing manually. Test the corrected mapping with a small sample before running the full file again.

Categories or locations are split into near-duplicates. Standardize spelling and naming in the source. For hierarchical values, check the path and separator so children are created under the intended parent.

A custom field is missing or empty. Confirm that the field exists in Listdom, that the correct source column is mapped, and that the source cells contain values in the expected format. For multiple taxonomy columns, custom fields created from source data, or repeatable FAQs, embeds, and reviews, follow the advanced CSV and Excel listing mapping guide.

The import stops before all rows are processed. Return to the CSV importer and use its recovery control while the recovery data is available. Resume if the mapping and source are still correct; discard and start again only when you have identified what needs to change.

A second run changes existing records. Check the source identifiers and the match behavior before re-importing. Do not assume a repeated upload will always create a fresh set of listings.

FAQ

Can I import listings from Excel into Listdom?

Yes. The Listdom Excel add-on supports direct .xlsx import under Listdom → Import / Export → Excel. If you do not need to upload the workbook format directly, you can also save a copy as .csv and use the built-in CSV importer.

Do I need an add-on to import a CSV file?

No for a manual CSV upload: the core Listdom CSV import flow is available from Listdom → Import / Export → CSV. Automated scheduled feed imports are a separate add-on feature.

Can I import categories and locations as parent and child terms?

Yes. The CSV importer can use a hierarchy path in a single field, such as Services, Cleaning, to create or use a parent-child path. Review the wording and hierarchy in a sample before importing the full file.

Can Listdom match my spreadsheet columns automatically?

Smart Mapping can suggest field matches when an AI Profile is configured. Review those suggestions before importing because similar column names do not always represent the same kind of information.

What should I do if a large import is interrupted?

Return to the CSV import screen promptly and choose the recovery action that fits: resume from the last completed batch if the file and mapping are correct, or discard the unfinished import if you need to revise the setup. Inspect the results after resuming.

What to learn next

If you are still deciding what information your listings should contain, start with how Listdom listings, categories, and locations work together. For the full setup sequence around launching a directory, continue with the Listdom setup guide.