prizepicksapi
Sign inGet free API key
Answer from PP API Inc.

How do I get PrizePicks lines in a spreadsheet?

Use the CSV export endpoint: a short Apps Script loads it into Google Sheets, and Power Query loads it into Excel. Each request returns up to 200 rows with the opening line and move count beside every current line.

Get free API keySpreadsheet guide
Pixel-art basketball centered on a court diagram.
LeagueCurrent rowsRequests per refresh
CFB4,62024
NHL4,06221
NFL3,90120
NBA3,01716
UCL2,76514
SOCCER8315
NHL1P8025
TENNIS4693
NFL1H4463
CBB3292
At 200 rows per request. The Free plan includes 100–500 credits a month.

The spreadsheet guide has both scripts in full. You can build your layout first against the keyless demo export, which holds fictional players with the same columns.

Test the columns without a key

Code
=IMPORTDATA("https://prizepicksapi.com/api/v1/demo/export?league=NBA&limit=5")

Go further

Spreadsheet guideCSV export guideGET /api/v1/export
Is there an API for PrizePicks?Is there a free player props API?Is there a PrizePicks API on GitHub?How do I get today's PrizePicks lines?
All questions

Independent data service, not affiliated with PrizePicks. Information only, not betting advice.