Table Data

What is Table Data?

A feature you can usefully use when extracting data that 'looks like a table'.

Quick Start

➡️ Extract with TABLE DATA off ➡️ If 'it looks like a table' but data doesn't extract properly, re-extract with TABLE DATA toggle on

---

Left is OFF, right is ON. Use the default OFF state, and when you think 'it looks like a table but data doesn't extract well', try extracting with it ON.

Useful for extracting data from web pages that look like tables (tables), like this site:

https://www.kpc.or.kr/education/CourseYear.asp?UMEduType=49049012&UMEduTheme=49050037

Check the extraction difference between option off and on in the How to use it section below.

---

How to Use

1

TABLE DATA - OFF

When extracting data, the red underlined area shows whether TABLE-LIKE is applied.

When this option is off (OFF), downloading the Excel file looks like this:

Original page vs. extracted data comparison

Let's compare the original page with part of the extracted data.

But the values look a bit off. Some strings were partially duplicated in extraction (31, 31Cheonan, 21, 21Cheongju, etc.) and the number of blank spaces between columns differs. Comparing the original page's light green blank areas with the Excel file shows the extracted data alignment differs from the original at a glance.

In this case, turn IS TABLE-LIKE to ON and extract again.

2

TABLE DATA - ON

Let's extract from the same website with TABLE-LIKE option on.

The red underlined area shows TABLE-LIKE is applied.

Original page vs. extracted data comparison

Let's compare the original page with the extracted data from the same area as in section 1.

When extracting data with TABLE-LIKE option enabled, the blank areas marked in light green on the original page match exactly with the extracted data's blank areas and there's no duplicated text.

Observing Listly users, only about 10% deal with tabular data. So in most cases you don't need the TABLE-LIKE option. Use it in the default OFF state, and only turn it ON when you judge 'it looks like a table but doesn't extract well'.