Share via

Import from PDF - I need keep empty rows

Anonymous
2024-02-22T10:24:13+00:00

When importing a single column PDF table into Excel, it skips blank rows. I am importing a PDF file. It contains a table with one column. If a cell is empty, Excel skips it and groups the cells together. Is there a way to keep the blank lines when importing?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ashish Mathur 102K Reputation points Volunteer Moderator
    2024-02-23T07:31:33+00:00

    Hi,

    Depending upon what you want, you may need to carry out transformations. Share the PDF file and show the expected result very clearly.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2024-02-23T07:23:43+00:00

    yes i used PQ

    Was this answer helpful?

    0 comments
  3. Ashish Mathur 102K Reputation points Volunteer Moderator
    2024-02-23T03:22:23+00:00

    Hi,

    Have you tried to import it using Power Query?

    Was this answer helpful?

    0 comments
  4. Anonymous
    2024-02-22T13:27:19+00:00

    Could you share us a test PDF file to reproduce your issue?

    For sharing a sample workbook, upload to OneDrive or any other cloud drives. Then post a link here.

    When you convert PDF to Excel ,the data may be unstructured.

    You may also try other way to convert PDF to useful data.

    💬1 - The Best Ways to Extract Data from PDF Documents - Klippa

    Was this answer helpful?

    0 comments