Table to CSV
About Tool
Extracting data from web pages or text-based documents often results in fragmented "table-like" text that doesn't fit standard spreadsheet formats. Table to CSV is designed to take these pasted rows—whether they are HTML-like snippets or plain text with inconsistent delimiters—and turn them into a structured CSV file ready for analysis.
Format Detection and Normalization
One of the most difficult parts of scraping data is handling varying row lengths or missing cells. This tool features a Normalize row length option that automatically pads shorter rows, ensuring your CSV remains perfectly aligned. It also includes "Header detection" to identify if the first row should be treated as column labels. If you find your table is exceptionally long, you can use a CSV Splitter after the conversion to break the data into more manageable chunks.
Cleaning Up Pasted Text
When copying tables from PDFs or legacy software, you often end up with "border-only lines" (like sequences of dashes or pipes) that aren't actual data. The "Remove border-only lines" feature filters these out automatically. Furthermore, the tool can auto-detect the source format, whether it is HTML tags, pipe-separated text, or rows separated by two or more spaces. This makes it much easier to transition data into a JSON to Table workflow for developers who need to move between web formats and CSV.
Practical Applications
This tool is a favorite for researchers and marketers who need to "scrape" data manually from websites that don't offer an export button. By highlighting the table on a site, copying it, and pasting it here, you bypass the need for complex scraping scripts. It is also useful for converting text-based reports from older terminal-based systems into modern spreadsheets.
How to Convert Tables
- Paste Source: Drop your table rows or HTML content into the large text area.
- Select Format: Use "Auto detect" or manually specify if it's "Plain text" or "HTML-like".
- Refine: Enable "Trim cell whitespace" and "Normalize row length" for a cleaner result.
- Run: Click the "Run" button and then download your resulting CSV.
Frequently Asked Questions
Can I paste raw HTML <table> tags?
Yes, the tool can parse HTML-like rows and extract the text content from between the tags to form CSV cells.
What if some rows have more columns than others?
If you enable "Normalize row length," the tool will add empty cells to the shorter rows so that every row has the same number of columns as the longest one.
Does it support tabs as a separator?
Yes, you can manually select "Tab" as the plain text delimiter if the auto-detection does not catch it.
How does "Trim cell whitespace" help?
It removes leading and trailing spaces from each cell, which is common when copying data from visual tables where extra spacing is used for alignment.
Similar Tools
-
CSV Cleaner and Deduplicator
Clean CSV files by removing duplicate rows, empty rows, and messy spacing issues.
-
CSV Column Extractor
Extract selected CSV columns quickly for reporting, cleanup, and spreadsheet workflows.
-
CSV Merger
Merge multiple CSV datasets with matching columns into one downloadable combined file.
-
CSV Splitter
Split large CSV data into smaller chunks by row count for easier export and sharing.
-
CSV to JSON
Convert CSV text into structured JSON for APIs, code, and data workflows.
-
CSV to SQL
Convert CSV rows into SQL INSERT statements for database seeding and import workflows.
-
CSV Viewer and Editor
View, inspect, and lightly edit CSV data in a clean table interface in the browser.
-
Excel to JSON
Convert spreadsheet rows into JSON objects for integrations and development tasks.
Reviews