HTML to CSV Converter

About HTML to CSV Converter

Extract structured data from HTML and convert it into CSV (Comma-Separated Values) that you can open in Excel, Google Sheets, or any spreadsheet/database tool. This HTML to CSV converter is especially useful for turning web tables, lists, and page content into a clean, analyzable dataset.

Key Features

• HTML table extraction: Convert <table> elements into CSV rows and columns.
• List extraction: Turn ordered/unordered lists into CSV with list type and item index.
• Full content mode: Extract titles, meta tags, headings, paragraphs, links, and images into CSV.
• Multiple tables: Handle pages with more than one table, labeling each where needed.
• Header detection: Use <thead> or header rows as CSV column names.
• Custom delimiters: Choose comma, semicolon, tab, or pipe for regional and tool compatibility.
• Robust escaping: Properly escape quotes, separators, and line breaks according to CSV rules.
• Whitespace cleanup: Normalize spaces and remove extra line breaks for tidy output.

How to Convert HTML to CSV

1. Paste or upload HTML: Insert HTML markup or upload an .html file from a report, table, or page.
2. Select extract mode: Choose Tables Only, Lists Only, or All Content depending on what you need.
3. Configure delimiter and headers: Pick comma/semicolon/tab/pipe and decide whether to include headers.
4. Review CSV: Inspect the generated CSV to confirm columns and rows look correct.
5. Copy or download: Copy the CSV or download it as output.csv and open in Excel or Sheets.

Examples

Example 1: Product table

HTML table with columns Product, Price, Stock becomes:

Product,Price,Stock
Laptop,$999,15
Mouse,$25,50

Example 2: Feature list

Unordered list:

<ul>
  <li>Free shipping</li>
  <li>30-day returns</li>
</ul>

List CSV (Lists Only mode):

Type,Item,Text
Unordered,1,Free shipping
Unordered,2,30-day returns

Extract Modes

• Tables Only: Best for classic tabular datasets, reports, and dashboards.
• Lists Only: Ideal for bullet-point feature lists, menus, or navigation data.
• All Content: Capture a full snapshot of key elements from a page (title, meta, headings, links, etc.).

CSV Format & Compatibility

The output follows standard CSV rules:

• Values separated by the delimiter you choose (comma, semicolon, tab, or pipe).
• Fields containing delimiters, quotes, or line breaks are wrapped in double quotes.
• Embedded quotes inside values are doubled (e.g., "Hello" → ""Hello"").
• Optional first row of column headers for use in Excel, BI tools, and databases.

FAQ

Which delimiter should I use for Excel?

In many locales, Excel expects commas; in some European regions, semicolons work better. If you see data in one column, try a different delimiter or adjust your regional settings.

Can I use this with scraped HTML?

Yes. Paste HTML captured by your scraper or export from your tool, then use the converter to turn it into structured CSV for further processing.

Does the tool handle nested tables?

Simple and moderately nested tables usually work, but very complex layouts may need manual cleanup. For best results, start from well-structured tabular HTML.

Is my HTML uploaded anywhere?

No. All HTML to CSV conversion takes place in your browser. Your HTML, extracted data, and CSV remain on your device.

Privacy & Security

All parsing and CSV generation run client-side only. Nothing is stored or sent to servers, so you can safely convert internal reports and private web content.