Your HTML input should contain at least one TABLE tag. If your HTML contains more than one TABLE tag, you can choose which table to convert by changing the "Which Table" selection.
All tables will be converted by default into 1 CSV file.
See also CSV to HTML Table
Step 1: Select your input
- Enter Data
- Choose File
- Enter URL
Choose File Encoding
Enter URL as data source
Step 2: Choose output options [optional]
Output Options Output Field Separator: , ; : Bar-| Tab Other-ChooseForce Wrap values in double quotes
No line breaks in CSV [Use this to remove line breaks in field values]
Remove HTML tags in CSV [Use this to prevent seeing HTML tags in your output]
Replace multiple spaces with 1 space in CSV [Use this if you have too much space in your output]
Step 3: Generate output
Which table?
Result Data:
Save your result: .csv EOL:
How to Convert HTML Table to Excel Online ?
1. Upload or paste your HTML Table
Just paste [copy html source code from a browser] or drag-and-drop your HTML file into the textarea of Data Source, and it will immediately perform the magic of the conversion. The HTML table converter will automatically search for tables from the html source code you provide.
2. Edit your HTML Table online, if needed
You can edit your data online like Excel through Table Editor, and the changes will be converted into Excel in real-time.
3. Copy the converted Excel
The generated Excel is separated by tabs, it's here: Table Generator. You can copy and paste into Microsoft Excel, Google
Sheets or Numbers, or download as an xlsx
file.
Note: Your data is secure, the converts is done completely in your web browser and we will not store any of your data.
HTML stands for Hypertext Markup Language. HTML is the code that is used to structure a web page and its content, paragraphs, list, images and tables etc.
Microsoft Excel is an electronic spreadsheet application that enables users to store, organize, calculate and manipulate the data with formulas using a spreadsheet system broken up by rows and columns.
See all How-To Articles This tutorial demonstrates how to import an HTML table into Excel or Google Sheets.
Import Table Data From Website
Using the Power Query feature, you can pull live data directly from a website into Excel.
1. Open the Excel file that you wish to import the data into.
2. In the Ribbon, select Data > Get & Transform Data > From Web.
3. Type in the URL from which you wish to fetch the data and click OK.
4. In the Navigator, on the left, select the table to be imported, then click Transform Data.
5. The Power Query Editor will open. Manipulate the table as required – in this case, select Use First Row as Headers. Then to load the data, click Close and Load.
6. The table will then be loaded into Excel with two new Ribbon tabs available: Table Design and Query.
How to Import an HTML Table into Google Sheets
1. Open the Google sheet where the data needs to be imported to and select the cell where the data will be positioned.
2. Then, type in an HTML import formula such as the one shown below:
=IMPORTHTML["//www.floatrates.com/historical-exchange-rates.html", "table",0]
3. As soon as you press Enter, Google Sheets will try to load the data into the sheet.
Once done, the data will be displayed.