scan receipt into numbers

[cSalmon]

How would I scan a receipt using iphone so it imports the data into Numbers (or excel)? I understand I can scan into Notes or to pdf. Any suggestions as I’ve got a lot of scanning to do and what to find a streamline way to get info into spreadsheets. Any links to tutorials would also be helpful.

thanks

 

[Slartibart]

simply scanning/photographing the r3ceipt and then select the text/numerical content in the image/photo and copy&paste it into where ever does not work for you? What OS/device are you want to use here?

 

[cSalmon]

thanks for the response, the idea would be to have all the data be imported into different cells instead of copying and pasting each piece of data individually. I will use whatever is recommended not to have to do this individually.

iPhone 16 18.6
Mac OS 14.7.7

 

[DeltaMac]

To direct the data properly, you will need a purpose-built script, which would direct each item to the relevant cell, as it is scanned and copied to your Mac. You just would identify where the data are located for importing, and what you want those data to do after the import. Pretty basic stuff for either Excel or Numbers, I would think. Haven't had a use for either for a bunch of years, but both should come with built-in scripts that do what you need, or easy-to-follow steps to make your own custom script.

 

[Slartibart]

It depends on the layout of the recipe, but I have no problems using e.g., the built in OCR on my iPP on a photograph and select, copy,paste all text into various cells in Numbers in one go. Obviously some cells have to be manually adjusted, but for what I tried it is pretty decent.

Is this something people do a lot?

 

[User #07242024]

There are apps for receipt scanning into CSV/Excel. I’m still on iOS 15 (old iOS) so it’s better if you look them up yourself.

 

[chabig]

I bet any of the current AIs could read the receipt and figure out what is what, then generate a CSV file for import.

 

[cSalmon]

Is this something people do a lot?

I literally can't believe 'everyone' isn't asking for a streamlined system that does this very function!

I've tried the copy paste method - I spend more time fixing the spreadsheet than just manually logging each data point in.

 

[cSalmon]

There are apps for receipt scanning into CSV/Excel. I’m still on iOS 15 (old iOS) so it’s better if you look them up yourself.

any suggestions to look at, most seem to be expensive subscriptions that want you to upload data