Local Business Directory

What You'll Build

A directory of local businesses with individual profiles and city/category landing pages. Perfect for "plumber in Austin" style searches.

Prerequisites

• A dataclean.to account (free tier works)
• Business data in CSV format
• Basic knowledge of HTML/JavaScript (optional)

Step 1: Prepare Your Data

Your CSV should have columns for:

name,address,city,state,zip,phone,website,category
Joe's Plumbing,123 Main St,Austin,TX,78701,5551234567,joesplumbing.com,Plumber
...

Step 2: Upload and Clean

1. Create a new project in dataclean.to
2. Upload your CSV file
3. Review the auto-detected types
4. Apply normalization: phone_us, url_https, location_city_state
5. Run duplicate detection with 85% threshold

Step 3: Configure Schema

1. Select "LocalBusiness" template
2. Map your columns to schema fields
3. Preview the generated JSON-LD

Step 4: Export and Use

Choose your export method:

• Clean CSV - Download for use with static site generators
• JSON-LD ZIP - Individual schema files per business
• API - Fetch data dynamically for your pages

API Example

// Fetch businesses in Austin
const response = await fetch(
  'https://dataclean.to/v1/my-directory/items?city=Austin',
  { headers: { 'X-API-Key': 'your_key' } }
);
const { data } = await response.json();

// Render with schema
data.forEach(business => {
  console.log(business.name, business._schema);
});

Next Steps

• Add more businesses to your directory
• Create category-specific pages
• Set up Google Sheets sync for live updates