How to Create Pages from a CSV File in WordPress

You have a CSV file 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’re working on a website for a company with multiple stores at multiple locations and don’t want to create and edit each page manually.

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

Let’s look at exactly how this works:

To bulk create pages in WordPress, simply follow six easy steps.

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 there’s a premium version of LPagery, you don’t necessarily need it to bulk create local landing pages.

To download the free version of LPagery:

1. Go to your WordPress dashboard → Plugins → Add New
2. Search for “LPagery”
3. Or download directly 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.
You can use any software that exports CSV or XLSX files.

In the top row, fill in one placeholder per column, for example:

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

Then fill in your data — each row represents one generated page later.

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

For LPagery to work, you’ll need a template page. Follow these steps:

1. Create the Template Page

If you already have a page, skip this step.
Otherwise, create a new WordPress page (Pages → Add New) and edit it with your page builder.

2. Add Placeholders / Dynamic Content

To make the page dynamic, use the same placeholders from your CSV.
For example:

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

This could generate:

• “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 page is ready, publish it.
You can then select it as your template page inside LPagery.

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

With LPagery Pro, you gain extra options after selecting your template page:

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

Customize the URI Slug

By default, LPagery uses the title of your template page as the slug.
To customize it, use placeholders, for example:

my-service-in-{city}

This produces URLs like:

www.your-domain.com/my-service-in-new-york/

Adding a Parent Page

You can select a parent page so generated pages become child pages.
If the parent page has the slug `services`, your resulting URL looks like:

www.your-domain.com/services/my-service-in-new-york/

Assign a Category

LPagery includes a category feature for pages as well as posts.
This helps you maintain a clean website structure.

Step 5: Select Your Input Type

If you’re using the free version, you can only upload a CSV or XLSX file.

If you’re using LPagery Pro, you can also:

• Link to a Google Sheet (same structure as your CSV)
• Use the Radius option to automatically create pages for nearby cities

Make sure LPagery has access to your Google Sheet.

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

Step 6: Create the Pages

Once setup is complete, click Next.
A popup will display all pages to be created (each row = one page).

With LPagery Pro, you can edit this list before generation (e.g., delete or add rows/columns).

Click Generate Pages to start building your pages.
This process may take a few moments depending on how many you’re generating.

Why Bulk Page Creation Is Useful

Bulk page creation is helpful for:

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

LPagery helps you save time and optimize online marketing by automatically creating 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.