I will extract tables from your PDF into a clean excel spreadsheet
Data and Research Speciallist
About this Gig
Most "PDF to Excel" results are a screenshot in a cell, or a table with three merged rows of junk in the middle of it. You get a spreadsheet you can actually use.
What I do differently, and why it matters
Footnotes travel with the data. Statistics tables carry notes that change what the numbers mean different denominators, revised definitions, "data from 2019 onwards has been reweighted". Most extractions drop those notes. The result is a spreadsheet that looks right and is quietly wrong. I carry them through into the sheet.
Rates and levels get separate, named columns. Where a table mixes thousands and percentages, each column is named for what it is. You will not discover that "21.0" was a rate by sorting it and wondering why the totals are nonsense.
Nothing is guessed. If a page is illegible, a cell is ambiguous, or a figure is missing, you get a blank plus a line in my notes saying so. I do not fill a hole with a plausible-looking number.
Worked example available in the gig gallery: a 37-page UK Office for National Statistics labour market bulletin, four tables pulled out into a four-sheet workbook with footnotes intact and totals verified 15 areas, 4 datasets.
Type:
Convert data
•
Formatting
•
Data cleaning
Tool:
Excel

