Forum

Optimizing the Conv...
 
Notifications
Clear all

Optimizing the Conversion of Scanned Documents to Excel with Power Query

2 Posts
2 Users
0 Reactions
194 Views
(@safoine)
Posts: 1
New Member
Topic starter
 

I have several scanned documents to convert into Excel files—thousands of pages. As a first step, I used an application to convert the images into readable text. Then, using Power Query, I extracted the tables. My problem is that Power Query doesn’t correctly identify the columns and splits a single column into multiple ones. Is there a solution to speed up the process?

I created an example using a document from the internet.

 
Posted : 20/11/2024 1:48 pm
Riny van Eekelen
(@riny)
Posts: 1185
Member Moderator
 

Difficult to judge without seeing examples of the scanned/converted files you are working with.

 
Posted : 21/11/2024 2:18 am
Share: