PDF Financial Tables to Excel
Employer not named by the sourceRemote
Frontier is not the employer and does not collect applications.
About this role
Python, Data Processing, Excel, PDF, LaTeX, Data Extraction, Data Analysis, Data Management · I have up to five PDF files that contain structured financial tables—balance-sheet style figures, quarterly summaries, and similar line-item data. I need every table lifted cleanly from each document and placed into Excel (.xlsx) so the numbers can be filtered, summed, and charted right away.
Accuracy is critical: every row, column heading, currency symbol, and negative value must match the source. Please keep each original table on a separate sheet and preserve any sub-totals or notes that appear inside the table area. If a PDF holds multiple tables, name the sheets intuitively so I can find them quickly.
You’re free to use Adobe Acrobat, Tabula, Camelot, Python + pandas, or any reliable extraction tool you prefer, as long as the final workbook opens flawlessly in recent versions of Excel. Once done, send back the .xlsx file (one workbook per PDF) along with a brief note on any anomalies you encountered—missing glyphs, merged cells, or unreadable scans—so I know what to double-check.
That’s the full scope. Let me know your timeline and any clarifications you need before starting.