Change language

Python | Convert HTML table to Excel

Step # 1: Convert to Pandas dataframe
Pandas — it is a Python library used to manipulate tables. Our first step is to save the table from the web page in a Pandas dataframe. The read_html () function returns a list of data frames, each element representing a table on a web page. Here we assume that the web page contains one table.

# Panda import

import pandas as pd

  
# URL of the web page whose table we want to extract

url = " https://python.engineering/extended-operators-in-relational-algebra/amp/ "

  
# Assign table data to Pandas dataframe

table = pd.read_html (url) [ 0 ]

  
# Print data frame

print (table)

Exit

 0 1 2 3 4 0 ROLL_NO NAME ADDRESS PHONE AGE 1 1 RAM DELHI 9455123451 18 2 2 RAMESH GURGAON 9652431543 18 3 3 SUJIT ROHTAK 9156253131 20 4 4 SURESH DELHI 9156768971 18 

Step # 2: Storing the data frame Excel
For this we use the Pandas function, passing in the filename as a parameter.

# Pandas import

import pandas as pd

 
# URL of the web page whose table we want m extract

url = " https://python.engineering/extended- operators-in-relational-algebra / amp / "

  
# Assign table data to a Pandas dataframe

table = pd.read_html (url) [ 0 ]

 
# Save data frame to Excel file

table .to_excel ( "data.xlsx" )

Output:

In case of multiple tables on a web page, we can change the index number from 0 to the number of the required table.

Shop

Gifts for programmers

Best laptop for Excel

$
Gifts for programmers

Best laptop for Solidworks

$399+
Gifts for programmers

Best laptop for Roblox

$399+
Gifts for programmers

Best laptop for development

$499+
Gifts for programmers

Best laptop for Cricut Maker

$299+
Gifts for programmers

Best laptop for hacking

$890
Gifts for programmers

Best laptop for Machine Learning

$699+
Gifts for programmers

Raspberry Pi robot kit

$150

Latest questions

PythonStackOverflow

Common xlabel/ylabel for matplotlib subplots

1947 answers

PythonStackOverflow

Check if one list is a subset of another in Python

1173 answers

PythonStackOverflow

How to specify multiple return types using type-hints

1002 answers

PythonStackOverflow

Printing words vertically in Python

909 answers

PythonStackOverflow

Python Extract words from a given string

798 answers

PythonStackOverflow

Why do I get "Pickle - EOFError: Ran out of input" reading an empty file?

606 answers

PythonStackOverflow

Python os.path.join () method

384 answers

PythonStackOverflow

Flake8: Ignore specific warning for entire file

360 answers

News


Wiki

Python | How to copy data from one Excel sheet to another

Common xlabel/ylabel for matplotlib subplots

Check if one list is a subset of another in Python

How to specify multiple return types using type-hints

Printing words vertically in Python

Python Extract words from a given string

Cyclic redundancy check in Python

Finding mean, median, mode in Python without libraries

Python add suffix / add prefix to strings in a list

Why do I get "Pickle - EOFError: Ran out of input" reading an empty file?

Python - Move item to the end of the list

Python - Print list vertically