Tired of squinting at spreadsheets disguised as JPEGs? Say goodbye to the data entry doldrums! ChatGPT's Advanced Data Analysis is here to rescue you from the clutches of poorly formatted information.

Imagine this: Your colleague sends you a snapshot of a pivotal sales report. Instead of weeping silently at your desk, you simply feed it to ChatGPT. Voilà! In seconds, you've got clean, workable data faster than you can say "optical character recognition."

This isn't just a party trick—it's a game-changer for anyone drowning in a sea of misformatted data. Think of all the time you'll save, not manually transcribing information from images or PDFs. That's time you could spend on more important tasks, like figuring out who keeps stealing your lunch from the office fridge.

So, the next time someone sends you a picture of a table (bless their heart), don't despair. Let ChatGPT do the heavy lifting while you sit back and bask in the glow of your newfound productivity. Here is the exact Prompt I used to pull the data.

Detailed Prompt to Recreate Cash Flow Table from Image to Excel

Context: You are tasked with extracting data from an image of a financial cash flow table that includes Income , Expenses , Net Operating Income , and Projection Assumptions . The extracted data must be recreated exactly as it appears in the image into an Excel spreadsheet. The final Excel file must match the image data in terms of structure, formatting, and content.

Objective:

  • Accurately extract and recreate a financial cash flow table from an image into a fully formatted Excel spreadsheet.

    • Accurately extract and recreate a financial cash flow table from an image into a fully formatted Excel spreadsheet.

  • The table must include all sections (Income, Expenses, Projection Assumptions, etc.) and the formatting (currency symbols, percentages, and decimal points) must be consistent with the image.

    • The table must include all sections (Income, Expenses, Projection Assumptions, etc.) and the formatting (currency symbols, percentages, and decimal points) must be consistent with the image.

  • Double-check that the data extracted matches the image perfectly before finalizing the Excel sheet.

    • Double-check that the data extracted matches the image perfectly before finalizing the Excel sheet.

    Steps to Achieve the Objective:

  • Image Analysis and Data Extraction:

    • Image Analysis and Data Extraction:

  • Data Structuring:

    • Data Structuring:

  • Data Formatting:

    • Data Formatting:

  • Combine Data into One Excel Sheet:

    • Combine Data into One Excel Sheet:

  • Data Verification:

    • Data Verification:

  • Final Output:

    • Final Output:

    Example of Excel Layout:

    AY 2024-2025AY 2025-2026AY 2026-2027AY 2027-2028AY 2028-2029 Scheduled Market Rent $2,313,312$2,428,978$2,839,634$2,953,220$3,071,348 Upgrade Premium $0$301,440$0$0$0 Total Market Rent $2,313,312$2,730,418$2,839,634$2,953,220$3,071,348 Gain/(Loss) to Lease -$194,239-$238,828-$241,369-$236,258-$230,351.................. Subtotal Utilities $232,831$239,816$247,010$254,420$262,053 Market Rent Growth 5.00%5.00%4.00%4.00%4.00%

    Make sure to output the table in a single Excel sheet and verify the data accuracy. Once the Excel file is created, review it and confirm all sections match the data in the original image.