Skip to content
UsecaseBoard
← All use cases
articledata entry

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.

Save ideas in this browser. Upvotes count across the board.

Prompt excerpt

No prompt excerpt was provided by the source.

Sponsored

CodeBuddy

Tencent Cloud AI coding assistant for IDE and CLI.

Try CodeBuddy ↗
Explore all →