Keywords: Import CSV

Overview

If you already have a CSV file, comprising of one or more Keywords, or a Keyword with sub keywords (known as Column Names in Page Generator Pro), the Plugin provides an Import CSV function, which will mass import keyword(s) and term(s) from a single CSV file, without needing to manually add them individually through the Keywords form.

To access your Keywords, click on the Page Generator Pro menu entry in the WordPress Administration interface, and then click on Keywords.
Page Generator Pro: Keywords Menu

Looking to import terms into a single keyword, and use a delimiter and column names instead?  Refer to the Keywords Documentation.

To import multiple Keywords to Page Generator Pro, click the Import CSV button below the Page Generator Pro: Keywords title, which can be found towards the top of the screen:
Page Generator Pro: Import CSV

The Import CSV form will then be displayed, where you can define the following options:
Page Generator Pro: Keywords: Import CSV

CSV File

Choose the CSV file on your computer to upload.

Import Method

Import Method is new to Page Generator Pro 2.7.6, releasing Thursday 6th August 2020 23:59 GMT.

Depending on your CSV file structure and how you want to store the data, the following options are available:

Import Columns into a single Keyword

Page Generator Pro: Import Keywords: Import Columns into Single Keyword

This option is recommended if:

  • The data in your CSV file is relational – for example, you’d want to only output a ZIP Code that belongs to a City or County, and
  • Column Names are stored in the CSV file’s first row (e.g. A1, B1, C1 in the below example).

Import Columns as multiple Keywords

Page Generator Pro: Import Keywords: Import Columns into Multiple Keyword

This option is recommended if:

  • The data in your CSV file is not relational – for example, your CSV file contains a list of services offered and locations, and those services are available in all locations, and
  • Keyword Names are stored in the CSV file’s first row.

Import Rows into a single Keyword

Page Generator Pro: Import Keywords: Import Rows into Single Keyword

This option is recommended if:

  • The data in your CSV file is relational – for example, you’d want to only output a ZIP Code that belongs to a City or County, and
  • Column Names are stored in the CSV file’s first column (e.g. A1, A2, C2 in the below example).

Import Rows as multiple Keywords

Page Generator Pro: Import Keywords: Import Rows into Multiple Keyword

This option is recommended if:

  • The data in your CSV file is not relational – for example, your CSV file contains a list of services offered and locations, and those services are available in all locations, and
  • Keyword Names are stored in the CSV file’s first column.
Newlines within a cell are not permitted, and will cause importing to fail.

Keyword Name

When importing CSV data as a single Keyword, an option is displayed to specify the Keyword name to store the data in.

This must be a unique Keyword name that does not exist in the Keywords section of the Plugin.

Import

When you’re finished, click the Import button.

A notification will be displayed confirming the number of Keywords that were imported successfully.

If you try to import a keyword that already exists, you’ll receive a warning telling you that the keyword has already been specified. None of the CSV file’s contents will be imported.