Convert CSV Data to Restaurant Schema Markup

✓ Tested Works with CSV, Excel, Google Sheets → JSON-LD Schema

By dataclean.to team · 2026-02-13

Restaurant directories, food delivery platforms, and hospitality businesses maintain restaurant databases in spreadsheets that contain all the data needed for schema.org Restaurant markup. When implemented correctly, Restaurant schema enhances your listings in Google's local search results, knowledge panels, and Maps integration. dataclean.to converts your CSV restaurant data into validated Restaurant JSON-LD, normalizing the addresses, business hours, cuisine classifications, and pricing information that these listings require.

The Problem

Restaurant data in spreadsheets combines the challenges of local business data with food-industry-specific issues. Cuisine types are described inconsistently — "Italian", "Italian/Pizza", "Southern Italian", "Italian-American" — and Google expects specific servesCuisine values. Price ranges use different conventions: "$$", "Moderate", "$15-$30", "Mid-range." Menu URLs might point to PDF files, third-party platforms, or broken links. Business hours have special cases for brunch, happy hour, and late-night service that don't fit standard hour formats. Delivery and reservation capabilities are noted in free-text columns rather than structured boolean fields. Cleaning this data for schema.org compliance requires domain-specific understanding. Restaurant schema type specification

How to Fix It

Upload your restaurant directory CSV

Import your CSV with restaurant data. Include columns for restaurant name, address, phone, website, cuisine type, price range, hours, menu URL, delivery options, reservation support, ratings, and images.

Detect restaurant-specific data patterns

dataclean.to identifies address components, phone formats, URL fields (website and menu links), pricing indicators, cuisine text, and business hour patterns. Each field type receives appropriate cleaning rules for the Restaurant schema context.

Normalize restaurant data fields

Clean and standardize: addresses parse into PostalAddress components, phone numbers convert to E.164, hours structure into OpeningHoursSpecification entries, cuisine types normalize to consistent values, price ranges map to schema.org's priceRange format, and URLs are validated.

Map to Restaurant schema properties

Map your columns to Restaurant properties: name, description, address, telephone, url, servesCuisine, priceRange, openingHoursSpecification, menu (URL), acceptsReservations, image, and aggregateRating. Restaurant inherits all LocalBusiness properties plus food-specific additions.

Generate Restaurant JSON-LD

Export JSON-LD for each restaurant with nested PostalAddress, GeoCoordinates, OpeningHoursSpecification, and AggregateRating objects. Test with Google's Rich Results Test and deploy via hosted API or downloaded files.

Frequently Asked Questions

What is the difference between Restaurant and LocalBusiness schema?

Restaurant is a specific subtype of FoodEstablishment, which is itself a subtype of LocalBusiness. It inherits all LocalBusiness properties and adds food-specific ones like servesCuisine, menu, and acceptsReservations. Using Restaurant instead of generic LocalBusiness gives Google more precise information about the business type.

How should I format the priceRange property?

Schema.org's priceRange accepts free-text price indicators. Google recognizes dollar sign conventions ($, $$, $$$, $$$$) and numeric ranges. dataclean.to standardizes inconsistent price indicators (like 'Moderate' or 'Mid-range') to the dollar sign convention that Google processes most reliably.

Can I include menu items in the Restaurant schema?

Restaurant schema supports a menu property that links to a menu URL or contains Menu and MenuItem structured data. If your CSV includes menu item data (item names, descriptions, prices), dataclean.to can generate nested Menu/MenuItem schema within the Restaurant markup or as separate linked schema.

Example: Input → Output

name	cuisine	address	phone	hours
La Bella Italia	Italian	456 Oak Ave Chicago	(312) 555-0100	Mon-Sun 11am-10pm
la bella italia	italian	456 oak ave	chicago il	(312)555-0100	daily 11-22

Red rows show common data quality issues. dataclean.to normalizes and generates JSON-LD automatically.

{
  "@context": "https://schema.org",
  "@type": "Restaurant",
  "name": "La Bella Italia",
  "servesCuisine": "Italian",
  "address": {"@type": "PostalAddress", "streetAddress": "456 Oak Ave", "addressLocality": "Chicago"},
  "telephone": "+13125550100"
}

💡 How it works: Restaurant schema enables rich results with cuisine type, hours, and reviews in local search.

Ready to Clean Your Data?

Upload your CSV or spreadsheet and get clean, structured data in minutes.

Get Started Free

Related Use Cases

Schema Generation

Csv To Local Business Schema

Clean Data For Schema Markup