Local SEO teams
Directory audits
Favorable to scraping
Compare venue names, addresses, categories, websites, and social links against owned location data before a citation cleanup project.
Directories$50Free
Foursquare Scraper by Keywords
This Foursquare scraper turns venue detail pages into a structured CSV export for local business research. Import the template into the UScraper local desktop app, run the bundled keyword sample, and collect venue names, addresses, categories, ratings, hours, phone numbers, websites, and social links without building a Foursquare Places API pipeline.
Output
CSV
Columns
22
Input mode
Multi-URL
Source
Venue pages
Template
Free
At a glance
Export Foursquare business data to CSV
The bundled example targets pizza and New York venue pages, then writes one row per place. Replace the sample URLs with your own reviewed venue list when you need to scrape Foursquare locations for prospecting, market maps, category QA, or local directory cleanup.
Foursquare to CSV without code
Export venue data into a spreadsheet your team can open in Excel, Sheets, BI tools, or enrichment workflows.
Repeatable venue-page loop
Use the Navigate URL list for reviewed Foursquare pages, then append each result into one CSV with headers.
Local desktop custody
The workflow runs in your local browser session and writes the file to the folder configured in UScraper.
Live extraction with fallback
The helper first attempts JSON-LD and DOM data, then uses bundled sample values when the demo pages redirect or block.
Who this is for
Teams that need Foursquare venue data
Market researchers
City scans
Favorable to scraping
Build a spreadsheet of restaurants, parks, or neighborhood venues for competitor mapping, territory analysis, and local demand research.
Agencies and operators
Lead lists
Favorable to scraping
Collect public contact signals from reviewed detail URLs before manual qualification, outreach planning, or enrichment in a CRM.
How to use
Run the Foursquare scraper by keywords
1
Download and import
Download the hosted JSON template from this page and import it into the UScraper desktop app.
2
Replace or review the venue URLs
The sample graph includes six Foursquare detail URLs for a pizza/New York test batch. Swap in your approved venue pages before production use.
3
Confirm the CSV path
Structured Export writes foursquare-scraper-by-keywords.csv with headers and append mode. Change the save folder if your team uses a shared workspace.
4
Run the browser flow
UScraper navigates, waits for the page, waits for body, runs the extraction helper, and maps fields into the export block.
5
Open and verify output
Check row counts, blank contact fields, redirects, and category values before using the CSV in reports or downstream tools.
Output preview
What the Foursquare CSV export looks like
The full export includes 22 columns: keyword, location, detail_url, business_name, address, street_address, neighbourhood, locality, region, postal_code, city, category1, category2, price_range, rating, rating_count, opening_hours, telephone, website, facebook, twitter, and instagram.
| keyword | location | business_name | city | category1 | rating | rating_count | telephone | website |
|---|---|---|---|---|---|---|---|---|
| pizza | New York | Vito's Slices & Ices | New York | Pizzeria | 9.3 | 27 | (212) 273-1186 | vitosslicesandices.com |
| pizza | New York | Sottocasa Pizzeria | New York | Pizzeria | 9.5 | 156 | (646) 928-4870 | sottocasanyc.com |
| pizza | New York | Brooklyn Bridge Park | Brooklyn | Park | 9.6 | 4,402 | (212) 803-3822 | nyc.gov/parks |
foursquare-scraper-by-keywords.csvColumn
keyword
Search theme attached to the input batch, such as pizza.
Column
location
Market or city label attached to the batch.
Column
detail_url
Foursquare venue URL processed by the Navigate block.
Column
business_name
Venue name from live page data or fallback sample values.
Column
address
Full display address when available.
Column
category1
Primary venue category, such as Pizzeria or Park.
Column
rating
Visible venue rating or aggregate rating value.
Column
opening_hours
Hours text from page data when present.
Column
telephone
Public phone number listed for the venue.
Column
website
Public website URL when Foursquare exposes one.
Column
Facebook URL if found in page links or structured data.
Column
Twitter or X URL if found.
Sample rows
2 of many
| keyword | location | detail_url | business_name | address | category1 | rating | opening_hours | telephone | website | ||
|---|---|---|---|---|---|---|---|---|---|---|---|
| pizza | New York | Vito's Slices & Ices | 464 9th Ave, New York, NY 10018 | Pizzeria | 9.3 | Today Noon-11:00 PM | (212) 273-1186 | vitosslicesandices.com | |||
| pizza | New York | Rubirosa Ristorante | 235 Mulberry St, New York, NY 10012 | Italian Restaurant | 9.1 | Mon-Wed 11:30 AM-11:00 PM | (212) 965-0500 | rubirosanyc.com |
Headers included - one row per configured Foursquare venue page
For adjacent local-data workflows, pair this with the OpenStreetMap Scraper for POI Data, the Yellow Pages scraper, the Contact Details scraper, or browse the full UScraper template library.
Frequently asked questions
Foursquare venue pages may be public, but automated collection can still be limited by Foursquare terms, robots rules, database rights, privacy rules, and local law. Keep batches modest, avoid bypassing login walls or access controls, preserve source context, and get legal review before reselling or redistributing a commercial venue dataset.
Before you run
Practical limits and maintenance
Guardrails for reliable Foursquare exports
Access
Venue pages can redirect to login or not-found screens
The template is best for reviewed URL lists. If a page redirects, confirm the URL manually and avoid trying to bypass access controls.
Pacing
Keep batches modest and observable
Heavy unattended collection can trigger throttling or empty responses. Start with the bundled six-URL sample, then expand gradually.
Layout
Structured data and page markup can change
Empty names, missing ratings, or blank contact fields usually mean Foursquare changed the page or hid the data. Re-test one URL and update the export mapping before scaling again.
Download the free Foursquare scraper JSON template, install the local desktop app from UScraper download, and use it whenever you need a reviewable way to export Foursquare venues into 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