Local SEO teams
Venue audits
Favorable to scraping
Compare review language, ratings, and tip volume across restaurants, hotels, cafes, or retail locations already collected in a target market.
Directories$50Free
Foursquare Reviews Scraper by URL
This Foursquare reviews scraper imports a list of venue URLs, opens each page in the UScraper local desktop app, and exports Foursquare review or tip data to a clean CSV. Use it when you need Foursquare reviews to CSV for local SEO research, restaurant monitoring, competitor analysis, or venue sentiment checks without building a custom crawler.
Output
CSV
Columns
10
Input
Venue URLs
Storage
Local
Waits
Built in
At a glance
Export Foursquare reviews from venue URLs
The template is built for direct Foursquare business URLs rather than keyword search pages. That makes the run more controlled: you decide which venues belong in the batch, UScraper opens each URL, waits for the page to settle, and then checks whether the page is blocked by a login prompt. If the login wall appears, the workflow skips that URL and continues to the next input instead of writing misleading empty rows.
When a venue page is accessible, the automation scrolls and clicks visible "show more" or "load more" style controls, normalizes review and tip text, and writes hidden row markers for Structured Export. The result is a spreadsheet-friendly Foursquare data extractor that keeps venue-level fields beside each review row for easier filtering and grouping.
Review data with venue context
Each row can include the source URL, business name, price range, aggregate rating, rating count, telephone, reviewer name, date, review text, and upvote count.
Multi-URL batch workflow
The Navigate block accepts multiple Foursquare venue URLs and the Loop Continue block moves through the list while the CSV stays in append mode.
Local desktop export
The stock workflow saves the file on your computer. Your URL list and review CSV do not move to a hosted scraping service unless you add that behavior.
Best-effort expansion
The injected interaction step scrolls and opens more visible tips or reviews before export, which helps capture rows that are not immediately visible on load.
Who this is for
Use cases for Foursquare review exports
Market researchers
Competitor tracking
Favorable to scraping
Export Foursquare reviews for known competitors and classify recurring themes such as service speed, menu quality, pricing, or location convenience.
Agencies
Client reporting
Favorable to scraping
Keep a repeatable CSV evidence trail for approved venue URLs, then combine it with data from other review platforms in a spreadsheet or BI tool.
For broader local datasets, pair this template with the Foursquare Scraper by Keywords, Google Maps Reviews Scraper, and Tripadvisor Hotel Reviews Scraper. You can also browse the full UScraper template library when you need follow-up extractors for business listings, search results, or social proof pages.
How to use
Configure the Foursquare scraper by URL
2
Add venue URLs
Replace the sample Philadelphia venue URLs in the Navigate block with your approved Foursquare business pages. Keep one clean venue URL per input.
3
Use an authenticated session
If Foursquare redirects your pages to login, open the site in the same browser profile used by UScraper and sign in before running the batch.
4
Confirm the CSV path
Structured Export writes foursquare-reviews-scraper-by-url.csv with headers enabled and file mode set to append. Change the save folder before client-specific runs.
5
Run and review output
UScraper opens each URL, waits, expands visible review content, exports structured rows, and continues the loop. Spot-check a few rows before using the file downstream.
Output preview
CSV fields from the Foursquare review extractor
The CSV mirrors the Structured Export block in the workflow definition. Each accessible venue can produce multiple rows, and each row repeats the venue context so you can filter by business, rating, reviewer, or review date without joining another file.
| Business_URL | Business_name | Rating | Username | Date | Review | Upvote |
|---|---|---|---|---|---|---|
| https://foursquare.com/v/example-cafe/123 | Example Cafe | 8.7 | Maya R. | Jan 12, 2026 | Great coffee, fast counter service, and reliable Wi-Fi during the morning rush. | 4 |
| https://foursquare.com/v/sample-bistro/456 | Sample Bistro | 8.1 | Jordan K. | Dec 3, 2025 | The lunch menu is compact but the sandwiches are consistent and fairly priced. | 2 |
| https://foursquare.com/v/downtown-tacos/789 | Downtown Tacos | 9.0 | Priya S. | Nov 18, 2025 | Order ahead if you visit after work. The carnitas tacos are the standout item. | 6 |
foursquare-reviews-scraper-by-url.csvColumn
Business_URL
The Foursquare venue URL currently being processed.
Column
Business_name
Venue name detected from the page title or page content.
Column
Price_range
Dollar-sign price range when Foursquare exposes it on the page.
Column
Rating
Aggregate venue rating, when visible.
Column
Rating_count
Visible rating, review, or tip count captured from the page text.
Column
Telephone
Venue phone number when a public number appears on the page.
Column
Username
Reviewer or tip author name found near the review text.
Column
Date
Review or tip date in the visible page format.
Column
Review
Cleaned review or tip text.
Column
Upvote
Visible upvote or like count, when present.
Headers included - all accessible venue URLs append under the same 10 columns
Frequently asked questions
Foursquare reviews and tips may be publicly visible, but automated collection can still be restricted by Foursquare terms, privacy rules, copyright, robots directives, and local law. Use modest runs, avoid bypassing access controls, and get legal review before using exported reviews commercially.
Before you run
Practical limits and maintenance notes
Keep these constraints visible
Login
Unauthenticated pages may be skipped
Foursquare can redirect venue pages to a login screen. If the CSV is empty, confirm the page is accessible in the browser profile UScraper is using.
Rate limits
Large batches need conservative pacing
Avoid aggressive loops. Add longer waits if pages load slowly, and pause when Foursquare shows verification, throttling, or unusual response pages.
Layout drift
Review markup can change
The workflow uses best-effort text and DOM detection. Missing usernames, dates, or upvotes usually mean the visible layout changed or that a venue has sparse review content.
Download the free template, install the desktop app from UScraper download, and use this workflow whenever you need to export Foursquare reviews into a structured local CSV.
Get Started
Download and use this template instantly
$50Free
What's Included
- Template JSON file ready to import
- Pre-configured scraping nodes
- Works with UScraper desktop app
Open-source templates
UScraper templates are open source. Improve this workflow or contribute a new one to help the community grow.
Contribute on GitHubBrowse more templates in the library
All Templates