Add Your Data

Your data is the foundation of everything SEOmatic generates. This is where you provide the information that makes each page unique.

How you add data depends on which project type you chose:

For Pages projects

Each row = one page

This is the most important thing to understand. Every row in your data becomes one page on your website. If you have 50 rows, you get 50 pages.

Your columns are the pieces of information that change from page to page.

Example - local business pages:

3 rows = 3 pages. Each page gets its own city, phone number, address, etc

Example - product pages:

What kind of data should I include?

Include anything that changes from page to page - short facts and details, not full paragraphs.

Good data: city names, phone numbers, addresses, product names, prices, short descriptions (1-2 sentences)

Bad data: full paragraphs of content (that's what your content template and AI are for), or the same value in every row (if it doesn't change, put it in the content template instead)

How to add data

Go to the Data tab in your project. You'll see several ways to get started:

• Ask AI to generate it: Don't have data yet? Just describe what you need and AI will create a dataset for you. For example:

  • "200 US cities with state, population, and timezone"

  • "100 SaaS tools with category, pricing, and URL"

  • "50 digital marketing services with description and price"

  Type your description, hit enter, and SEOmatic generates a ready-to-use dataset you can customize.

• Upload a file: If you already have a spreadsheet, click Import existing data → Upload Spreadsheet. Drag and drop your file or click to browse. Supports CSV, XLS, and XLSX files up to 120MB.

• Connect Google Sheets or Airtable: Click Import existing data → Integrations, then pick Google Sheets or Airtable. Connect your account, select your spreadsheet or base, and import. Google Sheets stays in sync - when you update the sheet, SEOmatic sees the changes.

• Browse the dataset library: Click Dataset Library to browse pre-built datasets organized by category - Locations, Companies, E-commerce, Real Estate, and more. Pick one and customize it to your needs.

Start with an empty table Click Empty Table to create a blank spreadsheet and enter your data manually. You can add columns and rows as you go.

For Posts projects

Posts work differently. Instead of a spreadsheet, you provide a list of keywords - one keyword per article.

Go to the Articles tab in your project and add your keywords. Each keyword becomes one blog article.

For example:

• best plumber in miami

• emergency plumbing services near me

• how to fix a leaking faucet

• water heater installation cost

4 keywords = 4 blog articles. SEOmatic uses each keyword to generate a full article with a title, body content, meta description, and more.

Tips

• Keep column names short and clear (for Pages). Use city not City Name of the Business Location. These names become variables you'll use in your content template.

• Clean your data before importing. Remove empty rows, fix typos, keep formatting consistent. Bad data = bad pages.

• Start small. Try 5-10 rows first. Make sure everything looks right before importing the full dataset.

• You can always edit later. Add rows, remove rows, change values at any time.

Common questions