reaper-datasource
reaper-datasource is a REAPER extension for script developers. It reads spreadsheets and delimited files natively and hands the contents to Lua, EEL, or Python as ordinary ReaScript API functions — no backend service, no temp files, no polling.
It reads .xlsx, .xlsm, .xlsb, .xls, .ods, .csv, and .tsv.
Everything arrives as sheets of rows of string cells; a CSV is simply a
workbook with one sheet, named after the file.
Using it
Parse a whole file in one call:
local ok, result = reaper.DataSource_Parse("/path/to/book.xlsx", "")
if not ok then
reaper.ShowConsoleMsg("parse failed: " .. result .. "\n")
return
end
-- result is JSON: every sheet, with its dimensions, hidden rows, and cells
Or open a file once and ask for only what you need — useful for previews, single columns, and reactive UIs. Sheets load lazily and stay cached on the handle:
local src = reaper.DataSource_Open("/path/to/book.xlsx")
local ok, rows = reaper.DataSource_GetRows(src, "Sheet1", 1, 20)
local ok, cell = reaper.DataSource_GetCell(src, "Sheet1", 2, 3)
reaper.DataSource_Close(src)
Rows and columns are 1-based. Hidden rows are reported for .xlsx and
.xlsm workbooks, so a script can respect what the spreadsheet’s author
chose to hide. Handles aren’t garbage-collected — close them when you’re
done.
The full API reference is in the
README, and
reaper.DataSource_OpenDocs() opens the copy that ships with the
extension.
Installing
- In REAPER, open Extensions → ReaPack → Import repositories…
- Paste
https://github.com/TeamAudio/reascripts/raw/main/index.xml - Find reaper-datasource in the package browser, install it, and restart REAPER.
Builds are also attached to the
GitHub releases
if you’d rather copy the library into REAPER’s UserPlugins folder
yourself.