Identify Tables From Context

identify tables from context

B
buildprompt
·May 3, 2026·
441 0 213
$6.99
Prompt
356 words

A spreadsheet is a digital tool that organizes and stores data in a tabular format, consisting of rows and columns.

  • Row: row runs horizontally and is typically used to represent individual records or sets of related data. Each row is identified by a number (1, 2, 3, etc.) along the left side of the sheet.
  • Column: column runs vertically, columns typically hold specific types of data that describe an attribute of the data stored in the rows. For instance, a column might be designated for dates, names, or other categories of data. The meaning of different rows in the same column is similar, meanwhile its column name is consistent in semantics.

Your task is to take the unstructured plaintext and screenshot provided and convert it into a well-organized spreadsheet format using JSON following format_instructions.

Identify the main entities, attributes, or categories mentioned in the text and use them as keys in the JSON object. Then, extract the relevant information from the text and populate the corresponding values in the JSON object. Ensure that the data is accurately represented and properly formatted within the JSON structure. The resulting JSON spreadsheet should provide a clear, structured overview of the information presented in the original text.

You should use image to find spreadsheet columns, and use plaintext to locate row data.

The column of the spreadsheet should be as many and specific as possible. Here are examples of "bad case" and "good case":

  • Bad case: "Title" and "Description." (using generic labels)
  • Bad case: "#1," "#2," "#3" (using ambiguous labels)
  • Good case: "Best Seller," "Price," "Rating," and "Number of Ratings" (providing specific details)
  • Good case: "Issue," "Assignee," State","Date", "Author", "Label" (displaying comprehensive information in the spreadsheet with labels)

The row data of the spreadsheet should be as many as passible. The content of plaintext is often more than that of image. Therefore, for row data, you need to extract as much as possible from the plaintext, even though it is not displayed in the image.

Ensure that the entire spreadsheet is meaningful.

{plaintext}

Output: MUST following the format instructions.

{format_instructions} DO NOT translate anything.

How to Use

Use with LangChain: hub.pull("yangluo/identify-tables")

Need help?

Connect with verified experts who can help you succeed.

Related Prompts

More prompts in Creative & Design

View All
Creative & Design
Midjourney

Midjourney Prompt Generator

Outputs four extremely detailed midjourney prompts for your keyword.

S
schemawriter$6.99
1,755,666 2,783,616
Creative & Design
ChatGPT

Convert Your Small And Lazy Prompt Into A Detailed And Better Prompts With This Template.

Convert your small and lazy prompt into a detailed and better prompts with this template.

Q
querycraft$4.99
209,414 107,942
Creative & Design
Universal

One Click Personalized Workout and Diet Plan

With just one click, create a personalized diet and exercise plan. Just enter the information.

P
promptcore$4.99
13,911 13,924
Creative & Design
Universal

learning new skill

Looking to learn or improve a specific skill but have no prior experience? Here's a 30-day learning plan designed specifically for beginners like you. Whether you're interested in coding, cooking, photography, or anything in between, this plan will help you build a solid foundation and make steady progress towards your goal. Each day, you'll have a specific task or activity to complete, ranging from watching instructional videos to practising hands-on exercises. The plan is designed to gradually increase in complexity as you build your knowledge and skills, so you can start with the basics and steadily work your way up. By the end of the 30 days, you should have a solid understanding of the fundamentals of your chosen skill, as well as a set of practical techniques and strategies to help you continue improving in the future. So, whether you're looking to learn a new hobby or develop a new professional skill, this 30-day learning plan is the perfect place to start.

A
aicanvasFree
2,090 2,100
Creative & Design
Universal

FitnessGPT v2: One-Click Personal Trainer

An upgraded version of DigitalJeff's original 'One Click Personal Trainer' prompt.

P
primequery$4.99
6,241 6,268
Creative & Design
Universal

MoneyMindGPT - Your AI-Powered Personal Financial Advisor

MoneyMindGPT is an AI-powered financial advisor that offers personalized guidance to improve your financial health. It helps you with budgeting, saving, investing, and debt reduction by creating custom plans based on your unique needs. Accessible and easy to use, MoneyMindGPT supports you on your journey to financial success.

M
modeshift$4.99
5,254 5,276