Scan paper invoice into Excel as CSV

[wtom0412]

Hello all,

I am looking for a solution that will enable me to use a scanner to "import" a paper document into excel to create a csv of the fields on the document.

I have to get around 600 invoices that have been printed on A4 paper (all the same format - meaning the layout of the document is the same for all 600 docs) into a CSV doc.

I would like the solution to "read" the docs, and recognise the Invoice Number, Customer Name, Date, Dollar Value etc and place the data into columns on the CSV.

If anyone knows of anything that has been done before and could point me in the right direction I would be very grateful

Thanks in advance.

Cheers, Toby

 

[vladimiratanasiu]

Hello all,

I am looking for a solution that will enable me to use a scanner to "import" a paper document into excel to create a csv of the fields on the document.

I have to get around 600 invoices that have been printed on A4 paper (all the same format - meaning the layout of the document is the same for all 600 docs) into a CSV doc.

I would like the solution to "read" the docs, and recognise the Invoice Number, Customer Name, Date, Dollar Value etc and place the data into columns on the CSV.

If anyone knows of anything that has been done before and could point me in the right direction I would be very grateful

Thanks in advance.

Cheers, Toby

You didn't mention what version of Excel you use. For example, in Excel 2021 / Office 365, the conversion from pdf to excel format can be done also by PowerQuery.

 

[wtom0412]

You didn't mention what version of Excel you use. For example, in Excel 2021 / Office 365, the conversion from pdf to excel format can be done also by PowerQuery.

Hiya,

I am using 365. I have never used PowerQuery, I'll check it out, thank you.

Cheers, Toby

 

[Joe4]

I am using 365. I have never used PowerQuery, I'll check it out, thank you.

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[wtom0412]

Good advice, thank you.