Hey i wanna create an automation in python. I have some images with datas near 5000 and i want that datas enter to the ecxal file

Help Needed: Extract Data from Image to Excel Format
Description
I have an image containing tabular data with various fields such as sales dates, customer names, dealer names, amounts, phone numbers, and more. I need help extracting this data accurately and populating it into a structured Excel file.

Requirements
Extract all data entries from the provided image.

Use a fixed Form Number (e.g., 12428_000001) for all records on the same page.

Increment Record Numbers starting from 1 for each entry.

Format the Sales Date as MM/DD/YYYY.

Convert Basic Amount values from millions to full numbers (multiply by 1,000).

Calculate Net Amount as the sum of Basic Amount and Insurance Amount.

Fill all other fields exactly as shown in the image.

Maintain data accuracy and formatting.

Column Structure for Excel
FORM NO.

RECORD NO.

SALES DATE

CUSTOMER NAME

INITIALS

E-MAIL ADDRESS

DEALER NAME

CUSTOMER ADDRESS

CITY

STATE

CUSTOMER PHONE

DEALER PHONE

DELIVERY TIME

INVOICE NO.

INSURANCE POLICY NO.

CHESIS NO.

BASIC AMOUNT

INSURANCE AMOUNT

TOTAL AMOUNT (if applicable)

DISCOUNT

NET AMOUNT

Files Provided
Image file containing raw data.

Blank Excel template to fill in.

Additional Notes
Page or form changes should have unique Form Numbers to distinguish data.

Assistance requested for manual extraction or automated process suggestions.

Beginnen Sie mit der Überprüfung des bereitgestellten Bildes, der leeren Excel-Vorlage sowie der aufgeführten Spaltenstruktur und Formatierungsregeln. Als erledigt gilt die Aufgabe, wenn alle Datensätze korrekt extrahiert, die erforderlichen Nummerierungs-, Datums- und Betragsumwandlungen angewendet und die strukturierte Excel-Ausgabe ausgefüllt wurden.