# Image to text, extract specific data in order to insert into columns **URL:** \ **Category:** Ask for Help\ **Created:** [December 20, 2023, 2:50pm UTC](https://community.glideapps.com/t/image-to-text-extract-specific-data-in-order-to-insert-into-columns/68880 "2023-12-20T14:50:59Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Rimatcom](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rimatcom/32/32285_2.png) [@Rimatcom](https://community.glideapps.com/u/Rimatcom)\ **Post date:** [December 20, 2023, 2:50pm UTC](https://community.glideapps.com/t/image-to-text-extract-specific-data-in-order-to-insert-into-columns/68880/1 "2023-12-20T14:50:59Z")
Hello community, I hope everyone is well during these special dates. I am looking to implement the following functionality and I need some guidance on the best method to use. If you have experience with this, I would appreciate your insights. I need the user to take a photograph of a bank transfer receipt, and once they upload the photo to the app, extract CERTAIN specific data such as the amount, the name of the person who made the transfer, and the date, among other details. I am planning to use the A.I. image-to-text function to extract text, but I’m unsure how to extract specific data like the amount, name, and date. Once I have this data, the goal is to insert it into specific columns for that information. The idea behind this functionality is to automate data entry for the user by simply taking a photo. Any help is welcome, thank you. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [December 20, 2023, 2:59pm UTC](https://community.glideapps.com/t/image-to-text-extract-specific-data-in-order-to-insert-into-columns/68880/2 "2023-12-20T14:59:05Z")
> [@robotsparkles PDF → Glide AI → Query JSON is MAGIC](https://community.glideapps.com/t/pdf-glide-ai-query-json-is-magic/66944): > > wave Hey Fellow Gliders! Glide AI is crazy powerful. With “Document to Text”, you can extract the text from any document in seconds… If that’s not magical enough, you can use AI to format that text as JSON with any structure you define. Then, parse that JSON using Query JSON column to precisely predict and extract the values from the original PDF with almost 100% reliability. The tutorial below showcases two scenarios: Resume PDF → Document to Text → Format as JSON → Extract values and det… ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [December 20, 2023, 11:47pm UTC](https://community.glideapps.com/t/image-to-text-extract-specific-data-in-order-to-insert-into-columns/68880/3 "2023-12-20T23:47:52Z")
[![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/2/82330577da8076322e88c6fc849bef165db664a5.jpeg "The Smartest AI Expense Tracker no-code app ever built!") ](https://www.youtube.com/watch?v=69_5sh01I3Q) We had somewhat of the same setup here. I used Google Cloud & GlideAI to transcribe the image’s text into a JSON form I pre-defined, then query the JSON to get the fields I need. With the availability of OpenAI’s vision model, I think it should be easier to do that now. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [January 19, 2024, 2:22pm UTC](https://community.glideapps.com/t/image-to-text-extract-specific-data-in-order-to-insert-into-columns/68880/4 "2024-01-19T14:22:05Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.