How to Export CSV Data from Yelp for Business and Import It into clariBI

Yelp for Business provides insights into how customers interact with your business listing, including page views, customer leads, and review data. Importing your Yelp data into clariBI lets you analyze review sentiment, engagement trends, and customer acquisition patterns with AI.

What You Can Export from Yelp for Business

• Page view and visitor metrics over time
• Customer leads (calls, directions, website clicks, messages)
• Review text, ratings, and dates
• Review response data
• Revenue estimates from Yelp Ads (if applicable)
• Photo view counts
• Check-in data from customers
• Request a Quote activity (if enabled)

Export CSV Data from Yelp for Business

Method 1: Activity Dashboard Data

1. Log in to your Yelp for Business account at biz.yelp.com
2. Navigate to the Activity section from the left sidebar
3. Review your visitor and lead metrics on the dashboard
4. Yelp's direct CSV export is limited — you may need to manually select and copy data from the Activity dashboard tables
5. Paste the data into a spreadsheet application (Google Sheets or Excel)
6. Save or download the spreadsheet as a CSV file

Method 2: Reviews Export

1. Go to the Reviews section in your Yelp for Business dashboard
2. Yelp does not currently offer a one-click CSV export for reviews
3. To capture review data, you can manually compile reviews into a spreadsheet with columns for Date, Rating, Review Text, and Reviewer Name
4. Alternatively, use the Yelp Fusion API (developer access required) to programmatically retrieve review data — visit developers.yelp.com for documentation
5. Save your compiled data as a CSV file

Method 3: Third-Party Tools

1. Several third-party review management tools (such as Birdeye or Podium) integrate with Yelp and offer CSV export of review data
2. If you use one of these tools, export your Yelp review data from their dashboard as CSV
3. This is often the most efficient approach for getting structured Yelp data into a CSV format

Tips for Clean Exports

• When manually compiling data, use consistent date formats (YYYY-MM-DD) and standardize column names for cleaner imports into clariBI
• Include the star rating as a numeric column (1-5) so clariBI can calculate averages and trends
• If using the Yelp Fusion API, request data in batches by date range to keep your dataset organized

Import Your Data into clariBI

1. Log in to your clariBI account at claribi.com
2. Click Data Sources in the left sidebar
3. Click the + Add Source button (top right)
4. Under Direct Upload, select CSV File
5. Enter a descriptive name (e.g., "Yelp - Reviews and Activity 2024")
6. Click the upload area or drag and drop your CSV file
7. Click Create Data Source

Once imported, you can ask clariBI questions like:
- "What is my average star rating by month and is it improving or declining?"
- "How do page views correlate with the number of new reviews received?"
- "What are the most common themes in my 1-star and 2-star reviews?"

clariBI's AI will automatically analyze your data and suggest relevant insights.