How to make hundreds of service area or product pages from a spreadsheet without making spam

By Ranjit Bhinge, founder of Blur Studio · Updated · 11 min read

Short answer: You can make hundreds of pages from a spreadsheet by writing one page template and letting a tool fill it from one row per page. The tool is the easy part. The hard part is the sheet: each row needs real facts that make its page different and useful, or Google may treat the set as spam. Ploy, a software subscription where an AI agent builds and hosts websites, does this with its built-in database, called PloyDB, and every generated page still needs a human to read it.

Ranjit Bhinge

You need hundreds of service area or product pages and cannot build each one by hand, but you do not want to publish a pile of thin pages.

I'm Ranjit, and I run Blur Studio: 15+ years building software, 120 apps taken live, and clients who have gone on to raise $10M+. I build AI systems and processes that help businesses do a lot more with a lot less time. I also work differently from most of what else is out there, more on that further down this page. Say hello.

Making hundreds of pages from a spreadsheet works when each row holds facts that really differ from the next row, and fails when only a town name or a product code changes. Build a clean sheet with real facts per page, test 10 pages first, read a sample for errors and thin text, then publish in batches and watch Google Search Console, the free Google tool that reports how your pages are indexed and searched.

This is a how-to for owners of local service businesses, distributors and shops. It focuses on the sheet itself, which most guides skip. For the local service angle, read service area pages for local clients. Ploy is one tool among several, and the method works with any of them. Prices are as of November 2026.

This page may contain affiliate links from which Blur Studio earns commissions.

What "pages from a spreadsheet" means

People call this programmatic SEO. SEO, short for search engine optimization, means making pages easy for Google to find and useful to searchers. "Programmatic" means a program builds the pages from data. You write one template with slots, such as a headline, a facts table and a list of related pages. Each spreadsheet row fills the slots and becomes one page.

It suits two kinds of sites. A service business with 40 towns can have a page per service per town. A distributor with 3,000 products can have a page per product. Both can be done well or badly, and the difference is what is in the row.

What Google says: the rules in its own words

Google's spam policies, which have no updated date shown on the page, name two things that matter here.

  • Scaled content abuse: many pages "generated for the primary purpose of manipulating search rankings". Google says this applies "no matter how it's created", by people, by automation or by a mix. Its examples include generative AI producing many pages that add no value, and many pages that make little sense but contain keywords.
  • Doorway abuse: pages created "to rank for specific, similar search queries" that funnel users to an intermediate page. Google's examples include multiple pages targeted at regions or cities that funnel users to one page, and "substantially similar pages that are closer to search results than a clearly defined, browseable hierarchy".

Google's page on generative AI content says AI output "may contain inaccuracies" and tells publishers to manually fact-check and review it, including titles, meta descriptions and structured data. Structured data, here, means labelled facts in the page code, such as the price or the name of a product, that search engines read.

Two more data points, labelled for what they are. In 2019, John Mueller, a Google Search advocate, replied on social media about a site with 1,300 city pages: "That sounds like doorway pages" (reported by Search Engine Roundtable). That was an opinion on one case. In September 2026, TechWyse, a trade news site, reported that he wrote on Bluesky (a social network) on 7 September 2026 that programmatic SEO "like this" "often leads to a site that's either spam, borderline spam, or low quality". He was replying to one site that generated pages from combinations of domain names, technologies and attributes. He also said Google's systems may have "lost faith" in such a site, and that recovery "tends to take time and significant effort". TechWyse notes he did not say all programmatic SEO is spam. This is a trade-press report of a social post about one case, not Google policy. The policy test is purpose and value, not the method or the page count.

Step 1: decide which rows deserve a page

Do this before you open any tool. Go down your list and keep a row only if you can say yes to all four questions.

  1. Would a real customer land here and be helped? If you would not publish the page if Google did not exist, do not publish it.
  2. Do you really serve or sell this? A page for a town you do not work in, or a product you cannot supply, is a doorway page.
  3. Does the answer differ from the neighbouring row? If the next page would say the same thing with one word changed, merge them into one page.
  4. Can you name three facts only this row has? Local examples: a response time from your nearest depot, a local rule, a job you did there. Product examples: a spec value, a fitment note, a stock location.

Rows that fail go into one stronger page, such as a single "areas we serve" page with a real map and list. A clearly browseable hierarchy, such as service, then region, then town, is the structure Google's doorway wording contrasts with.

Step 2: design the columns

A spreadsheet that makes good pages has more columns than you expect. Group them in four layers.

LayerExample columns (service area)Example columns (product)
IdentityService, town, URL slug, page titleProduct name, part number, brand, URL slug
Unique factsResponse time, nearby landmarks, local rule or permit, price range you charge thereSpecs, sizes, compatible models, pack size, stock location
ProofJob count in that town, a real review quote with permission, a photo from a job thereDatasheet link, certification, a photo of the actual item
NavigationNearby towns to link, parent service pageCategory, related products, replaces or alternatives

The layers that matter most are unique facts and proof. If you cannot fill them for most rows, the sheet is not ready.

A rule I use, and it is my own judgment and not a Google threshold: at least a quarter to a third of the visible words on each page should come from the row's own columns, not from the shared template. Adjust it to your pages, and judge by reading, not by counting.

Cell hygiene

  • One fact per cell. Do not paste a paragraph where a number belongs.
  • Empty cells must hide their slot in the template. A page that says "Response time: " with nothing after it looks broken.
  • Check units, currency and spelling per row. A 5 to 10 percent error rate on 400 rows is 20 to 40 wrong pages.
  • Keep a "reviewed by" and "reviewed on" column. It becomes your quality log.

A worked example with made-up numbers

An electrician serves 24 towns and offers 6 services. That is 144 possible pages. The made-up checks below show how the filter shrinks the list.

StepRows leftWhy
All service by town pairs1446 services times 24 towns
Remove pairs you do not actually sell there120No commercial work in 4 of the towns
Remove pairs with no unique facts78Cannot name three facts for 42 rows
Merge near-identical neighbours64Small adjacent towns share a page
Pilot batch10The 10 with the most facts and jobs

The sheet that began as 144 ideas becomes 64 pages worth publishing, and 10 of them go first. If this were a distributor, the same filter would remove discontinued products, products with no spec data and near duplicates such as a colour variant that belongs on one page.

Your options, from least effort to most

OptionWhat it gives youCost to checkWatch for
No tool: build 10 pages by handA real test of whether these pages get visitsYour timeIt is slow past about 30 pages, but you learn what each page needs
Webflow, a visual website builder with a built-in CMS (content management system)Collection pages: one template, one item per pageBasic is $15 a month on yearly billing and is for sites that do not need a CMS. Premium is $25 a month on yearly billing and adds the CMS. Starter is free with a limited CMS. Check Webflow's pricing page for the monthly price and the item limitsPloy's own comparison page lists heavy programmatic SEO at scale under "pick Webflow if"
WordPress, the most used website softwarePlugins and custom post types can build pages from dataCheck the vendor page or plugin pageNeeds set-up and updates, so budget developer time
Freelancer or developerA custom template and import scriptQuote only or hourlyAsk who maintains it after launch
Ploy with PloyDBAn AI agent builds the template and the table, one row per pageIncluded with PloyDB and the SEO agent. Page limits are not published. Generation uses creditsSee below for limits

Where Ploy fits: one option of several

Per Ploy's docs, PloyDB is a built-in spreadsheet-style database. You ask Ploy's agent to build one template that turns every row into a page. Adding a record publishes a page, and edits reach visitors usually within a minute without republishing. You can import a CSV, which stands for comma-separated values, a plain file any spreadsheet can save. The first row becomes the column names. Read the PloyDB guide for how rows become pages.

Limits from Ploy's database docs, last updated 18 November 2026: 97 columns per table, 128 KB per text value, CSV import up to 32 MB, files up to 10 MB each, 30 days of version history, and CSV export up to 10,000 rows per view. Ploy says CSV is for exchanging data, not for backup. The docs do not discuss search rankings.

Ploy's pricing page, as of November 2026: Free $0, Starter $50 a month, Pro $300 a month, Enterprise by quote. Credits do not roll over, and Ploy does not publish what a page build costs in credits. See the Ploy pricing guide. Run your 10-page pilot first and read the credit use before you plan 400 pages.

What Ploy's docs do not document, which matters for this job: a per-row noindex setting, a check for duplicate or thin pages, or a uniqueness score. Noindex, a tag that asks Google not to list a page, is documented only as a manual note for staging pages. Ploy's CMS docs do warn to always review before publishing and say unreviewed, low-quality content can perform poorly in search. Draft items are left out of the sitemap, which is the file that lists your pages for search engines. So the quality gate in this guide is your job, not the tool's.

Step 3: run a 10-page pilot

  1. Pick the 10 rows with the strongest facts.
  2. Build the template and generate those 10 pages as drafts, or on a preview address, not live.
  3. Read every page in full. Check each number, name and claim against your own records.
  4. Open three pages side by side. If a reader could swap their headline and body and not notice, the template is too thin. Add slots and facts.
  5. Publish the 10 and note the date.
  6. Wait and watch. Mueller said in 2021 (reported by Search Engine Journal) that indexing a new page can take from several hours to several weeks, so judge by weeks, not days.

Pass and fail rules for the pilot

CheckPassFail, and what to do
Fact checkNo wrong facts in 10 pagesAny wrong fact: audit the whole column before continuing
Swap testEach page has at least three facts the others lackAdd columns or merge rows
IndexingMost of the 10 appear as indexed in Search Console after a few weeksMany stay unindexed after several weeks: improve the pages before adding more
Real visits and leadsSome searches, some calls or formsNone after several weeks: do not scale until you know why
Customer responseCustomers say the page answered their questionAsk sales staff what customers asked. Put it in the sheet

Step 4: publish in batches

If the pilot passes, publish in batches of 25 to 50, with a check between batches. This is a safe pace I suggest, not a Google rule. After each batch:

  • Spot-check five pages for blank slots, broken links and wrong facts.
  • Check that every page has its own title and meta description, and that each is unique.
  • Check the sitemap lists the new pages and that nothing blocked sits in it.
  • In Search Console, watch indexing and any messages under manual actions. A manual action called "thin content with little or no added value" lists doorway pages as an example, per Google's page.
  • Add internal links so each page can be reached by clicking from a category or hub page, not only from the sitemap.

On crawling: Google's crawl budget page says its advice is for large sites, such as 1 million or more unique pages that change about weekly, or 10,000 or more that change daily, and calls the numbers a rough estimate. A few hundred pages is far below that, so for you the real risk is thin or duplicate pages, not crawl limits.

Who should not do this

  • You have no real facts per row. If the only difference is the name of a town, do not build the set. Write 10 good pages by hand instead.
  • You cannot review the output. AI-written pages need a human reader. If nobody will read 400 pages, publish 40.
  • You want to rank without helping anyone. That is what the spam policies name. Stop.
  • You need live data on each page. Prices, stock or availability that change daily need a system connected to your source. A database table you edit by hand will go stale.
  • You need heavy programmatic SEO at scale. Ploy's own comparison page concedes this to Webflow. Ask a developer to scope a custom build.

How I'd approach this

I would treat the spreadsheet as the product and the tool as a printing press. Spend 80 percent of the time on the sheet. If you want to use Ploy for the pages, start on the Free plan with a 10-row table, build the template, and check the credit use on one batch. Move to Starter only when you need a custom domain, and move beyond it only when you know your page count and credit use. Keep a copy of your sheet outside any tool, since CSV is for interchange.

First week plan. Day 1: list every possible page and apply the four-question filter. Day 2: design the columns and fill the first 10 rows with real facts. Day 3: build the template and generate the 10 drafts. Day 4: read every page and fix the sheet, not the page. Day 5: publish the 10 and add them to your sitemap and internal links. Then wait several weeks before the next batch, and let Search Console, calls and forms tell you whether to scale. If it passes, grow in batches of 25 to 50 with the same review.

For a large catalog or listing system with live data, or ongoing care of thousands of pages, Blur Studio builds the custom version, including connections to your stock and pricing systems and ongoing care. See what that includes. For a product catalog angle, read product catalog websites for distributors.

You may also want city-by-service pages for a client.

Questions people ask

Is programmatic SEO against Google's rules?

Google's spam policies do not use the word programmatic. They ban scaled content abuse and doorway abuse, judged by purpose and value "no matter how it's created". Pages that help real customers and differ in real ways are the safe side of that line.

How many pages can I make from one spreadsheet in Ploy?

Ploy does not publish a page limit for PloyDB. Its database docs list 97 columns per table, 128 KB per text value and a 32 MB CSV import. Generation uses credits, so test on a small table and check your credit use first.

Do I need a different page for every town?

Only where the page can say something true and useful that differs from the next town. Otherwise make one strong areas page. Our service area pages guide has a quality gate.

Can AI write the page text for each row?

It can draft it, and Google says to fact-check and review AI output before publishing. A person should read every page in a pilot and a sample of every batch afterwards.

How long until the pages show up on Google?

It varies. John Mueller said in 2021 that indexing a new page can take several hours to several weeks. Do not judge before several weeks, and do not publish a second batch before the first has been checked.

What if I already published too many thin pages?

Remove or merge the weakest, improve the rest, and watch Search Console for manual action messages. Google's manual action page says to fix the problem and then request a review. Recovery can take time.

Can I get my data out of PloyDB later?

Per Ploy's docs, you can export CSV up to 10,000 rows per view, and Ploy says CSV is for interchange, not backup. Keep your own master copy of the sheet. Our PloyDB guide has an exit test.

Is this different for product pages?

The method is the same, but the facts are specs, fit and stock. For large catalogs, see product catalog websites for distributors.

More in this topic: Websites: landing pages for ads, offers and catalogs (8 guides) →

Sources

Ready for the next step?

A 30 minute call. If you do not need me, I will tell you.

Ranjit Bhinge You talk to me, Ranjit. I reply within a few hours.

Not sure what you need? Tell me what is going on. I will point you the right way, even if it is not me.

Blur Studio · 30 minute call

Book a 30 minute call

You talk to me, Ranjit. If you do not need me, I will tell you.

  • We talk about your business and what is going on.
  • You leave with a clear next step, even if it is not me.
  • I reply to every message within a few hours.
Loading the calendar…