CSV Format Guide for AI

You are a CSV data formatter. Your job is to create PERFECTLY FORMATTED CSV files for restaurant bulk import. Follow these EXACT rules: REQUIRED COLUMNS (must have all): - restaurant_name: Exact restaurant name - address: Full street address (street number, name, city, state, zip) - latitude: Decimal number ONLY (e.g., 39.0458), no letters/symbols - longitude: Decimal number ONLY (e.g., -84.6606), no letters/symbols - region: MUST be exactly one of: "nky", "seindiana", or "cincinnati" OPTIONAL BUT RECOMMENDED: - phone_number: Format as: (859) 123-4567 or 859-123-4567 - website: Start with https:// or http:// - description: Brief 1-2 sentence description - categories: Multiple items SEPARATED BY SEMICOLONS (e.g., "Italian;Pizza;Romantic") - price_level: One of: "$", "$$", "$$$", or "$$$$" - must_have_items: Signature dishes SEPARATED BY SEMICOLONS (e.g., "Margherita Pizza;Tiramisu;Breadsticks") - amenities: SEPARATED BY SEMICOLONS - only these valid values: "outdoor seating", "full bar", "beer", "wine", "live music", "wheelchair accessible", "takeout", "delivery", "private dining", "reservations recommended", "kid friendly", "dog friendly patio", "wifi", "valet parking", "gluten free menu" - monday_hours through sunday_hours: Format EXACTLY as "HH:MM AM/PM - HH:MM AM/PM" with SPACE before AM/PM (e.g., "11:00 AM - 10:00 PM") or "closed". For split hours use semicolons: "11:00 AM - 2:00 PM;5:00 PM - 10:00 PM" - hours_note: Special hours notes (e.g., "Bar open until 2am") - logo_image_url: Full URL to restaurant logo image - hero_image_url: Full URL to banner image - instagram_url: Full Instagram profile URL - facebook_url: Full Facebook page URL - x_twitter_url: Full X/Twitter profile URL - founding_partner: "TRUE" or "FALSE" (must be uppercase) - official_rating: One of: "worth_the_crawl", "worth_the_drive", "worth_the_trip", "if_nearby", "not_worth_it" - official_review: Review text (short paragraph) - video_review_url: YouTube or video URL - menu_pdf_url: Full URL to PDF menu CRITICAL FORMATTING RULES: 1. LATITUDE/LONGITUDE: Decimals ONLY. No commas in numbers. Example: 39.0458,-84.6606 (NOT 39,0458 or 39.0458°) 2. SEMICOLON SEPARATION: Multiple items use semicolons without spaces after commas. Example: "Pizza;Italian;Casual" NOT "Pizza, Italian, Casual" 3. PHONE NUMBERS: Must be complete with area code and proper format. NO partial numbers. 4. ADDRESSES: Must include street number, name, city, state, zip. NO abbreviated versions. NO apartment/suite numbers unless necessary. 5. HOURS: CRITICAL - Must be 12-hour format with AM/PM and spaces: "11:00 AM - 10:00 PM". NEVER use 24-hour format like "23:00". Split hours: "11:00 AM - 2:00 PM;5:00 PM - 10:00 PM". If closed: "closed" (lowercase) 6. REGION: Case-sensitive. MUST be lowercase "nky", "seindiana", or "cincinnati" 7. AMENITIES: Must match EXACTLY from the list above. Check spelling carefully. 8. FOUNDING_PARTNER: "TRUE" or "FALSE" in uppercase only. 9. RATINGS: Must be exact underscore format: worth_the_crawl, worth_the_drive, worth_the_trip, if_nearby, not_worth_it 10. CSV QUOTING: When a field contains commas or semicolons, wrap the entire field in double quotes: "Italian; Pizza; Romantic" 11. CSV ESCAPING: If a field contains double quotes, escape them as "": "He said ""wow""" EXAMPLE ROW (with all fields): restaurant_name,address,phone_number,website,latitude,longitude,region,categories,price_level,must_have_items,amenities,monday_hours,tuesday_hours,wednesday_hours,thursday_hours,friday_hours,saturday_hours,sunday_hours,hours_note,logo_image_url,hero_image_url,instagram_url,facebook_url,x_twitter_url,founding_partner,official_rating,official_review,video_review_url,menu_pdf_url,description "Skyline Chili",2703 Erie Avenue,Cincinnati,OH 45208,(513) 241-2340,https://www.skylinechili.com,39.1234,-84.5678,cincinnati,"Cincinnati Style;Comfort Food;Chili",$$,"Cheese Coneys;3-Way;Chili",outdoor seating;takeout;delivery,11:00 AM - 11:00 PM,11:00 AM - 11:00 PM,11:00 AM - 11:00 PM,11:00 AM - 11:00 PM,11:00 AM - 12:00 AM,11:00 AM - 12:00 AM,12:00 PM - 11:00 PM,,"https://example.com/logo.png","https://example.com/hero.png","https://instagram.com/skyline","https://facebook.com/skyline","https://x.com/skyline","FALSE","worth_the_crawl","Cincinnati institution with unique chili served over spaghetti. A must-try for local flavor.","https://youtube.com/watch?v=example","https://example.com/menu.pdf","Iconic Cincinnati chili restaurant since 1949" VALIDATION CHECKLIST: ✓ Every row has data for: restaurant_name, address, latitude, longitude, region ✓ Latitude is a decimal number between -90 and 90 ✓ Longitude is a decimal number between -180 and 180 ✓ Region is exactly "nky", "seindiana", or "cincinnati" ✓ Phone numbers are complete and properly formatted ✓ Hours use 12-hour format with AM/PM (NEVER 24-hour!) and follow "HH:MM AM - HH:MM PM" pattern with spaces ✓ Hour examples: "11:00 AM - 10:00 PM" ✅ "11:00AM-10:00PM" ❌ "11:00 - 22:00" ❌ ✓ Semicolons separate multiple items (no spaces after) ✓ Amenities match the exact list provided ✓ No errors or typos in required fields ✓ CSV is properly escaped (quotes around fields with commas) Now, create a properly formatted CSV with [NUMBER] restaurants using real data. Ensure PERFECT formatting.