Researchers lose days retyping supplementary tables. This guide covers converting PDF research data to Excel for analysis.
Step 1: Download the publisher PDF
Use the official PDF from the journal when available; it usually has cleaner text than a scanned copy.
Step 2: Extract tables only
On pdfintoexcel, keep Tables only so prose sections are ignored.
Step 3: Keep tables separate
Choose Split output so Table 1, Table 2 and supplementary tables each get their own sheet.
Step 4: Export to your stats tool
Save as CSV from Excel, or read the workbook directly with readxl in R or pandas.read_excel in Python.
Landing page with cleanup tips: research data PDF to Excel.