
Open
Posted
Paid on delivery
I have a collection of PDFs with tables that need to end up in a clean, well-structured Excel workbook. The twist is that the table layout is not the same from file to file, so a one-size-fits-all script will not work—you’ll need logic that can adapt to shifting column counts, merged cells, and the occasional header tweak. Here is what I need: • Accurate extraction of every table, regardless of layout changes. • A single Excel (.xlsx) file with each source PDF represented on a separate sheet, preserving numeric formats and basic styling where possible. • A quick note on any tables that cannot be captured automatically so I can review them manually. I’m open to whatever stack you prefer—Python (pandas, tabula-py, camelot), Power Query, or even a smart VBA solution—as long as the final workbook is reliable and reproducible. When you respond, please include a sample or brief clip from past work that shows you have already tackled inconsistent PDF tables. That reference will help me move quickly to award the project.
Project ID: 40470468
61 proposals
Open for bidding
Remote project
Active 4 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
61 freelancers are bidding on average $41 USD for this job

Hello, With extensive experience in web design and development, our team at "My Company" is well-equipped to handle your request to extract and reformat PDF tables into Excel. Though my profile may seem lengthy in terms of reading, I'll cut right to the chase - transforming inconsistent PDF layouts into clean, structured Excel sheets is right up our alley. Our proficiency with JavaScript, known for its efficiency and flexibility, makes it an ideal choice for this project. From experience I understand that extracting data from varying table layouts could be demanding and time-consuming. But worry no more! We've successfully encountered similar challenges before and are confident in delivering what you exactly need. You mentioned needing a reliable and reproducible final workbook - our process ensures both these aspects by adapting through dynamic scripts that can handle shifting column counts, merged cells, header tweaks, ensuring accurate extraction for every table eventuality. Allow us to simplify your workflow by creating a single Excel (.xlsx) file that impeccably preserves numeric formats and basic stylings while representing each source PDF on separate sheets. We take quality very seriously and will provide you with a quick note on any tables where manual review was required. So let us turn this potentially tiresome task into a streamlined success! Let's join hands to turn your dreams into reality and creating another "WOW" factor project! Thanks!
$30 USD in 1 day
7.7
7.7

Hi, I can accurately extract and organize tables from your PDFs into a clean, well-structured Excel workbook, even when layouts vary between files. I have strong experience handling inconsistent PDF tables using Python tools such as pandas, Camelot, tabula-py, pdfplumber, and custom parsing logic. I understand that changing column structures, merged cells, and shifting headers require adaptive extraction rather than a simple fixed script. **My approach:** * Analyze each PDF structure and apply the most reliable extraction method * Handle varying column counts, merged cells, and inconsistent headers * Preserve numeric formatting and maintain logical table structure * Create one Excel sheet per source PDF for easy review * Flag problematic or low-confidence tables for manual verification * Perform final quality checks to ensure accuracy and consistency **Deliverables:** * One organized `.xlsx` workbook with separate sheets per PDF * Clean, editable table data with preserved formatting where possible * Notes for any tables requiring manual review I’ve completed similar PDF-to-Excel automation projects involving non-standard financial and reporting tables, including custom extraction workflows where OCR and rule-based cleanup were required. I can also provide a quick sample extraction from one of your PDFs before starting the full project. Best regards
$20 USD in 1 day
7.9
7.9

Hello, I've built PDF-to-Excel extraction systems before. The tricky part isn't the conversion—it's handling inconsistent table layouts and getting the data clean on the first pass. We do this regularly and know exactly where things break. We've been shipping automation and data extraction projects for years. Python and JavaScript are our go-to stack for this kind of work. Tables come out structured, no manual cleanup needed. I can walk you through the approach in a quick call if you want to see how we'd handle your specific PDFs. The $10–30 range gives us a solid starting point. Once I see a sample PDF or two, I'll give you a real number based on complexity—whether we're talking simple uniform tables or messy layouts that need custom parsing. Send over a couple of sample PDFs and let's talk through what "clean and well-structured" means for your use case. I can have a scoping plan back to you within a day. Regards, Nurul Hasan
$200 USD in 7 days
7.4
7.4

Hello I have several years of experience with processing PDF documents with Python, including converting certain tables into Excel file and I am able to build Python script for automated converting. I have completed a lot of similar projects. Could you share sample of PDF files to process? Thanks.
$17.55 USD in 1 day
7.6
7.6

As a highly skilled web-scraping specialist, I am confident in my ability to tackle your PDF-to-Excel project. My experience extracting data from websites with complex layouts and advanced anti-bot measures proves my ability to adapt to varying formats with ease. In addition, I am an expert in several relevant tools and technologies including Python (pandas, tabula-py, camelot), Power Query, and VBA solutions - giving me the versatility needed for your project. I have successfully executed various data extraction projects for global clients within industries including e-commerce and lead generation. These tasks often required me to handle inconsistencies as different websites would present data differently. I can integrate this knowledge and experience into your project to ensure every table from your PDFs is accurately captured. Furthermore, my commitment to delivering clean, structured, and reliable data compliments your need for a well-structured Excel workbook. I align myself with utmost professionalism, prompt responses, and sustained dedication – ensuring that your needs are met efficiently and effectively. Collaborating with me will guarantee not only a meticulously executed project but also a reliable business relationship focused on exceeding your expectations.
$30 USD in 2 days
7.4
7.4

Hi, I reviewed your requirements and understand the challenge is **handling inconsistent PDF table structures**, not simple extraction. Variations in column counts, merged cells, and changing headers require adaptive parsing and validation to maintain accuracy across all files. I have experience with PDF-to-Excel workflows using Python-based extraction and post-processing logic to normalize irregular tables while preserving numeric formats and structure. I can deliver: • Accurate extraction from varying table layouts • Single .xlsx output with one sheet per source PDF • Preservation of numeric formatting/basic styling where feasible • Validation checks + notes for tables requiring manual review • Reproducible workflow for future batches I’d be happy to review a few sample PDFs first and confirm the best extraction strategy, expected accuracy, and timeline. Looking forward to discussing the dataset.
$20 USD in 1 day
7.3
7.3

With fifteen years' experience under my belt, I possess the necessary expertise to not only extract your PDF tables accurately and efficiently but also to adapt to their unique and shifting layouts. My proficiencies in Python (pandas, tabula-py, camelot), Power Query, and VBA have consistently allowed me to tackle complex projects such as this one. I am confident that my analytical mindset combined with these versatile programming skills will enable me to provide you with a reliable and reproducible solution tailored to your exact needs. Whereas some solutions offer a one-size-fits-all approach resulting in inaccuracies or formatting issues, I offer a meticulous yet adaptable strategy that prioritizes accuracy, preserves numeric formats and basic styling, and ensures nothing important is missed. The final deliverable will be a single Excel (.xlsx) file with a separate sheet representing each source PDF. For transparency, I will gladly note any tables that couldn't be captured automatically so that you can manually review them. Still not convinced? Let me show you firsthand – I’d be happy to provide a sample or brief clip from past work which demonstrates my capability in tackling inconsistent PDF tables. This way, you can see the quality of my output and confidently award the project. Thank you for considering me – let's discuss how we can get your PDFs transformed into an organized Excel workbook effectively and quickly together!
$15 USD in 1 day
6.8
6.8

Hello! I can help you transcribe the data from PDF documents into an Excel spreadsheet accurately and efficiently. Please refer to my similar projects: https://www.freelancer.com/projects/data-extraction/PDF-Contacts-Excel https://www.freelancer.com/projects/internet-marketing/Get-signature-names https://www.freelancer.com/projects/39479043 https://www.freelancer.com/projects/excel/Date-Entry-Hand-Written-Revision https://www.freelancer.com/projects/pdf/Scanned-PDF-turned-into-digital https://www.freelancer.com/projects/data-entry/Data-Accuracy-Validation https://www.freelancer.com/projects/pdf/Data-Accuracy-Validation https://www.freelancer.com/projects/data-entry/JPEG-Image-Data-Entry-Required https://www.freelancer.com/projects/data-entry/English-Data-Entry-for-Level-38700963 I’m available online most of the time and respond to messages within 12-24 hours. How can I help you create the Excel spreadsheet you need? Duong
$30 USD in 3 days
7.0
7.0

That's straight forward task i can start working on it now,,, Just share pdf I will provide you free sample before award me,,,,,,,
$20 USD in 1 day
6.6
6.6

Hello there, as you can see from my profile I have experience in similar projects. Please contact me for more info Thanks
$30 USD in 1 day
6.3
6.3

Hi, I can manually convert a collection of PDFs with tables into a well-structured Excel workbook with meticulous attention to detail. Could you please share the file? I'll follow your instructions step by step. I can create a sample to demonstrate my capabilities as you wish. Could you let me know how many pages you have? To discuss the delivery time and cost. I bid $10 for a while until I know all the data you have. Thanks
$10 USD in 1 day
6.4
6.4

Hello, I have extracted inconsistent PDF tables using Python (Camelot/Tabula) on projects like 47 mixed-layout procurement PDFs into a clean Excel workbook with 98% accuracy. For your job, I will deliver one Excel file with each PDF on a separate sheet, flag any tables needing manual review, and finish within 24 hours. Please send 2–3 sample PDFs to confirm. Regards, Zafar
$30 USD in 1 day
6.2
6.2

Hi there, I am a Data Scientist and am a professional responsible for extracting actionable insights and knowledge from large volumes of data. As an experienced Data Scientist in the field of machine learning, I am highly proficient in Python and have a deep understanding of algorithms and data structures. My skills make me a great fit for your project as I can guide you through comprehensive coverage of data structures and algorithms while providing patient and thorough explanations. I have over 12-plus years of experience with Python Library Pandas, Karas, TensorFlow, NumPy, PyCharm, Py torch, Open CV, NLP, and others. With over a decade's worth of experience under my belt, including expertise in NLP, Neural Networks, CNNs, RNNs, LSTM, GANs just to mention a few, I can provide you not only with knowledge but also how to apply it efficiently. Partnering with me ensures you have a patient, knowledgeable and skilled tutor who is dedicated to your success in this field. My top priority is to provide a high quality of work, https://www.freelancer.com/u/GdevDataSceince Let's discuss this further via chat, and I'll start your project right now. Thanks Gdev
$20 USD in 7 days
5.9
5.9

Hi, I can convert your inconsistent PDF tables into a clean, structured Excel workbook. I’ll use an adaptive extraction process (Camelot/Tabula + custom cleaning) to handle shifting layouts, merged cells, and varying headers. You’ll get: • 1 Excel file with each PDF on a separate sheet • Cleaned, formatted tables • A review sheet for any problematic extractions • Reproducible script if needed Best, Muhammad
$20 USD in 1 day
5.7
5.7

Dear Client, Hello dear! I’m Md Toriqul Islam, an experienced Python and data processing specialist with 10+ years of expertise in PDF extraction and Excel automation. I’m excited to partner with you and can dive into your project immediately. I understand you need accurate extraction of inconsistent PDF tables into a structured Excel workbook while handling variable layouts, merged cells, and changing headers. I’ve successfully completed similar projects using adaptive extraction logic and validation workflows for complex document structures. I have rich experience in Python, pandas, tabula-py, camelot, openpyxl, VBA, and Excel automation. I am skilled in building reliable and reproducible data extraction solutions. I’m ready to start immediately and would be happy to share relevant sample work and discuss your PDFs in detail. Looking forward to hearing from you. Best regards, Md Toriqul Islam
$10 USD in 3 days
5.8
5.8

Drawing from my extensive experience in data analysis, extraction and management, I am confident that I can successfully tackle your project. My proficiency extends to Python, pandas, tabula-py and camelot -- tools that come in handy for projects like yours. Over the years, I've had great mastery of managing inconsistent PDF tables like what you have described. Encountering shifting column counts, merged cells and header tweaks are all familiar territories for me. From past projects I've executed similar to this, I've been able to provide accurate extraction of tables, regardless of custom layouts. I'm also skilled in producing a single clean Excel workbook with every table meticulously represented on separate sheets, preserving numeric formats and basic styling where possible. My output is thorough; you can trust that I'd provide a quick note on any tables that cannot be captured automatically so you can review them manually, ensuring everything is in line with your preference. I prioritize clear communication and client satisfaction in my work ethic as reflected in my high completion rate and positive ratings on similar projects. I am dedicated to delivering quality work that clients can trust. With your project, you can expect nothing less than a reliable, reproducible document transfer without losing any data along the way. As an added bonus; you'll have my unwavering support until your project is satisfactorily completed.
$20 USD in 7 days
5.2
5.2

Hello, I'm a web developer with over 13 years of experience. I've reviewed your project and am confident I can assist you. I have knowledge in JavaScript, Python, JavaScript, Python, Visual Basic, Excel, Scripting Please send me a message to get started. Thank You
$10 USD in 1 day
5.4
5.4

First, The PDF tables will be extracted to CSV files, Then the inconsistency of tables layout , structure, columns sort, contents, merged cells ...etc will be handeled by a custom VBA script inside Excel. I will need to see a sample of the PDFs and the proposed Excel layout required. Check sample work references and clients' reviews from my profile links below: https://www.freelancer.com/projects/excel/Excel-Auto-Execute-Macro-Upon/reviews https://www.freelancer.com/projects/excel/Fix-excel-VBA-36198376/reviews https://www.freelancer.com/projects/data-processing/data-processing-use-mail-merge/reviews
$100 USD in 3 days
5.2
5.2

Hello there, We will extract every table from your PDFs into a single .xlsx workbook, one sheet per source file, with numeric formats and styling preserved. Our approach uses Camelot with a fallback to tabula-py. For inconsistent layouts, we will detect column counts and merged cells dynamically per page, then normalize headers before writing to Excel. Any table that fails auto-extraction gets flagged in a summary sheet for your manual review. A couple of quick things to confirm: 1) Roughly how many PDFs are in the collection? 2) Do any files contain scanned pages, or are they all text-based? The number quoted here is a starting estimate. The exact cost and timeline will be confirmed after we go through the full scope together. Looking forward to potentially working together. Thanks, Faizan
$90 USD in 5 days
4.5
4.5

Hi there, I am A.R.M. MASUD, with a strong data science background. I specialize in creating customized Excel-based solutions that streamline business processes, enhance data management, and enable insightful analysis. Whether it’s developing advanced macros, automating workflows, or integrating Excel with other Microsoft applications, I deliver robust, efficient solutions tailored to your specific needs. My expertise includes AR/AP Management, Financial Statement Preparation, Expense Tracking, Budgeting and Forecasting, Cash Flow Management, and APR Calculation via the Sales Force Formula. I design and develop advanced Excel workbooks with tailored features such as formulas, macros, pivot tables, Power Query, mail merge, email via Outlook and Gmail, add-ins, customized macros, and automated repetitive tasks using Excel VBA. I also create interactive dashboards for real-time data visualization, providing fully functional and customized Excel workbooks, automated workflows, and macros for efficient task management and data integration between Excel and other business systems. https://www.freelancer.com.bd/projects/excel/Advanced-Data-Processing-Chart/reviews Thank you for considering your Microsoft Excel development project. I am confident that my expertise and commitment to excellence will add significant value to your business operations. Thanks A.R.M MASUD
$20 USD in 7 days
4.7
4.7

Dubai, United Arab Emirates
Payment method verified
Member since Sep 17, 2016
$30-250 USD
$10-30 USD
$30-250 USD
€250-750 EUR
$30-250 USD
₹12500-37500 INR
₹1500-12500 INR
₹12500-37500 INR
$25-50 USD / hour
₹600-1500 INR
$30-250 USD
$250-750 USD
₹12500-37500 INR
$30-250 AUD
$10-30 USD
$8-15 USD / hour
$8-15 USD / hour
₹750-1250 INR / hour
₹750-1250 INR / hour
₹75000-150000 INR
$30-250 USD
$10-30 USD
₹400-750 INR / hour
₹12500-37500 INR
$250-750 USD