Transcribe a photographed roster one page at a time
At a glance
A martial-arts researcher used ChatGPT and CSV files to move a photographed roster into Google Sheets. This workflow is listed under data entry, spreadsheets.
- Agents / tools
- ChatGPT, Google Sheets
SourceBuilding a tool for these workflows? See weekly rates.
What they did
1) Gather the photographs of the roster and ask ChatGPT to extract the names, dates and other table fields into a spreadsheet. The author started with nine photos containing about 250 records. 2) When a promised long background transcription produced no file, switch to asking for one page at a time and request a separate CSV for each page. 3) Upload the resulting CSV files to Google Sheets manually and check the extracted records against the photographs. The original material listed early UK Brazilian Jiu Jitsu black belts.
How it went
The author obtained individual CSV files through the page-by-page approach after the initial background-work promise failed.
Worth knowing
The author found the process manual and frustrating; the article does not establish that the transcription was error-free.