How to Create Pages from a Spreadsheet in WordPress in 2025

You have a spreadsheet with data you now want to populate pages in WordPress with?
We take you through the whole process of doing exactly that in this tutorial.

Let’s say you are working on a website for a company with multiple stores at multiple locations and don’t want to create and edit each page for every store manually.

If you have the data of each individual store in a spreadsheet like Excel, Google Sheets, or any other program that lets you create CSV files, you can then use the LPagery WordPress plugin to create pages automatically for each row in your spreadsheet.

To bulk create pages in WordPress you simply have to follow six simple steps.

Note: Some of the functionalities presented in this article are not available in the free version.

Buy LPagery Pro

Step 1: Download LPagery from the WordPress Repository

While we offer a premium version of LPagery, you don’t necessarily need it to bulk create local landing pages with WordPress.

To download the free version of LPagery you simply need to:

1. Go to your WordPress dashboard and head over to the “Plugins → Add New” section.
2. Search for “LPagery”.
3. Alternatively, you can download it here:
   https://wordpress.org/plugins/lpagery/

Step 2: Set Up a CSV/XLSX File

After installing LPagery, you’ll need to create your source file for the pages you want to create.
You can do this with any software that lets you create CSV or XLSX files.

In the top row of the spreadsheet, fill in one placeholder per column.

Example placeholders:

{city}, {service}, {your-placeholder}

Next, fill in your data.
Each row will represent one generated page later on.

Step 3: Create the Template Page Using Your Page Builder of Choice

For LPagery to work, you will need a template page. Simply follow these steps:

1. Create the Template Page

If you want to use an existing page, you can skip this step.
Otherwise, create a new regular WordPress page under “Pages → Add New” and edit it with your preferred page builder.

2. Add Placeholders (Dynamic Content)

To make the template page dynamic and able to adapt to your content, you need to add placeholders matching your CSV file.

For example, if your CSV has the following placeholders:

{city}, {service}, {your-placeholder}

You can use them like this in your page heading:

Your {your-placeholder} {service} service in {city}

That would generate pages like:

• “Your best Plumbing service in New York”
• “Your professional Plumbing service in London”
• “Your excellent Plumbing service in Tokyo”

3. Use the Template Page

Once your template is ready, publish it.
You’ll then be able to select it inside LPagery as your template page.

Step 4: Change URI Slug and Assign Categories / Parent Page (LPagery Pro only)

With LPagery Pro, you gain advanced options:

• Change the URI slug
• Assign a category
• Set a parent page
• Define status (Published, Private, or Draft)

Customize the URI Slug

By default, LPagery adds the title of the template page as the URI slug.
To customize it, you can use placeholders, for example:

`my-service-in-{city}` →
becomes `/my-service-in-new-york/`, `/my-service-in-london/`, etc.

Adding a Parent Page

You can select a parent page so that generated pages become child elements.
If your parent page slug is `services`, your resulting page URLs would look like:

/services/my-service-in-city/

Assign a Category

LPagery has a built-in category feature that enables WordPress categories for pages (not just posts).
This helps you maintain a good website structure.

Step 5: Select Your Input Type

If you’re using the free version of LPagery, you can upload a CSV or XLSX file — that’s it.

If you’re using LPagery Pro, you also have the option to:

• Link a Google Sheet (structured like your CSV)
• Use Radius mode to automatically generate pages for nearby cities

👉 Make sure LPagery can access your Google Sheet.

If you use Radius mode, include the `{city}` placeholder on your template page — it will be replaced with detected nearby cities.

Step 6: Create the Pages

When you’re done, click Next.
A popup will appear showing all pages to be created — each row represents one page.

With LPagery Pro, you can even make edits in the popup before generating.

Finally, click Generate Pages and LPagery will build all your pages automatically.
The process may take a few moments depending on your page size and number of rows.

Why Bulk Page Creation Helps

Creating pages in bulk can be useful for:

• Small local businesses
• Bloggers
• Online stores
• Marketing agencies

LPagery helps everyone save time and optimize online marketing by automatically generating local landing pages in WordPress.

About the Author

Jonas Lindemann

I’m an experienced SEO professional with over a decade of helping over 100 businesses rank higher online, especially local businesses, e-commerce stores and SaaS. As the co-founder of LPagery, I specialize in practical, proven strategies for regular SEO and Local SEO success.