How to Convert Text to Excel Spreadsheets?
No complex Python scripts, VBA macros, or tedious Excel text-to-columns formulas required. This tool provides both “Text Input Mode” and “File Import Mode” to get your spreadsheets in just two easy steps:
Text Input Mode
Type or Paste Content
Enter, edit, or press Ctrl + V in the left text area to paste any text data (multi-space aligned, CSV, TSV, etc.).
Download or Copy Spreadsheet
The table will be auto-detected and rendered on the right. Click “Download Excel (.xlsx)” or “Copy Table Data” to use.
File Import Mode
Select or Drop Files
Click “Import File” to select local files, or simply drag & drop or Ctrl + V paste .txt / .csv / .log files into the page.
Download or Copy Spreadsheet
Files are parsed instantly in memory without browser lag. Click “Download Excel” or “Copy Table Data” to complete.
What is "Auto-Detection" and How Does It Work?
When copying unformatted raw text from server logs, web pages, or database dumps, delimiters are often inconsistent. With “Auto Detect” enabled, the engine scans text patterns and adapts automatically:
1. Multi-Dimensional Sampling & Scanning
The parser samples the first 8–10 lines to calculate occurrence frequencies of \t (Tab), , (Comma), | (Pipe), ; (Semicolon), and \s{2,} (Multi-spaces).
2. Weight Evaluation & Pattern Matching
Prioritizes rules by "Tab > Markdown Pipe > Standard CSV Comma > Semicolon > Multi-Spaces" to prevent false splits on copied web or database tables.
3. Dynamic Column Alignment & Cleaning
Automatically pads missing cells to balance columns, filters out Markdown separator lines (like |---|---|), and smoothly extracts headers.
What Data Formats Are Supported?
The built-in text parser covers virtually all raw text formats encountered in daily office tasks, data cleaning, and programming workflows:
1. Multi-Space / Fixed-Width Aligned Columns
Ideal for server terminal outputs, CLI commands (e.g. ps aux, docker ps), and legacy system reports aligned by multiple spaces.
2. Standard Comma-Separated Values (CSV)
Supports RFC 4180. Fields enclosed in double quotes "..." containing embedded commas are parsed precisely without misplaced columns.
3. Tab-Separated Values (TSV / Tab)
Text copied directly from HTML web tables, database query tools (DBeaver, Navicat), or existing Excel/Google Sheets tabs.
4. Pipe / Markdown Tables (|)
Supports tables from GitHub/GitLab Markdown documents, automatically trimming border pipes and removing |---|---| divider rows.
5. European Semicolon-Separated (;)
Widely used in regions like Germany and France where CSVs use semicolons ; as separators to prevent decimal comma conflicts.
6. Multi-Line Merge (N Lines per Record)
Perfect for plain-text contact lists and multi-line form exports. Merges every N lines (e.g. Name, Phone, Address) into a single row with N columns.
Frequently Asked Questions (FAQ)
How do I fix inaccurate automatic splitting?
If raw text contains mixed special symbols causing inaccurate auto-detection, you can manually select a specific mode (Multi-Spaces, Comma, Tab, Semicolon, Pipe) under “Delimiter Mode” on the left, or choose “Custom” to input your custom delimiter or regex pattern (e.g. /::|\#\#/).
Will my text or files be uploaded to a server? Is my data safe?
100% Client-Side & Completely Private. All parsing algorithms, delimiter detection, and Excel (.xlsx) generation execute entirely inside your local browser memory. No text, logs, or files are ever sent to external servers.
What is the difference between downloading Excel and copying table data?
- Download Excel (.xlsx): Generates a styled .xlsx spreadsheet with styled bold headers, auto column widths, and cell borders suitable for saving or sharing.
- Copy Table Data: Copies standard TSV clipboard data. You can directly press Ctrl + V in Excel, Google Sheets, or Apple Numbers to paste perfectly aligned cells.
Can I directly edit the converted spreadsheet on the page?
Yes, full online spreadsheet editing is supported. The right panel integrates an interactive Handsontable grid. Double-click any cell to edit, drag column widths, or right-click for the context menu. All edits are reflected in real-time when exporting.