How to Use Our Free Tools
Complete step-by-step guides for merging, splitting, converting, securing, and transforming Excel files and PDFs. Every feature explained in detail with pro tips.
Spreadsheet Merging & Splitting
File Conversions (PDF, OCR, PPT, CSV, JSON)
Data Cleaning & Manipulation
Security & File Size
Formulas & Lookup Automation
Merge Excel Files Online
Combine multiple Excel spreadsheets (XLS, XLSX, CSV) into one consolidated master workbook with intelligent column matching, conflict resolution, and 100% browser-based privacy.
ドラッグ＆ドロップまたはクリックで選択
ホームページのドラッグ＆ドロップゾーンを使用して、2つ以上のExcelファイルをアップロードします。XLS（Excel 97-2003）、XLSX（Excel 2007+）、CSVファイルに対応し、異なるフォーマットを1回の結合で混在させることもできます。ファイルはアップロードゾーンの下に名前、サイズ、検出されたシートと共にリスト表示されます。グリップハンドルをドラッグしてファイルの順序を変更したり、削除ボタンで個別のファイルを削除できます。
売上レポート、アンケート回答、データベースエクスポートなど、XLS、XLSX、CSV形式であれば異なるソースのファイルをアップロードできます。
ファイルの結合方法を選択
右側パネルで3つの結合モードから選択：「単一スプレッドシート」はすべてのデータを1つの連続シートに積み重ね、類似データの結合に最適。「複数シート」は各ファイルを1つのワークブック内の別タブとして配置、ソース別にデータを整理するのに理想的。「選択的結合」は各ワークブックから特定のシートを選択可能 — 複数シートを含むファイルから特定のものだけが必要な場合に最適。
すべてのファイルが同じ列構造を共有している場合（月次売上レポートなど）は「単一スプレッドシート」を使用。ソースファイルごとにデータを分けたい場合は「複数シート」を使用。
ヘッダー処理、データ範囲、書式設定を微調整
詳細オプションで結合方法をカスタマイズ。「ヘッダー処理」で列ヘッダーの扱いを制御 — 最初の行のヘッダーのみ保持、データソースを識別するためのシート名ラベル追加、またはヘッダー処理なし。「データ範囲」でセル範囲を指定（例：A1からZ1000）して各ファイルの一部のみを結合。「書式保持」を有効にすると、元のセルスタイル、色、書式を結合出力に保持。
ファイルの最初の行にヘッダーがある場合は、結合出力でヘッダー行の重複を避けるため、常に「ヘッダー保持」を使用してください。
スマートマッチングが異なる列構造を整列
単一スプレッドシートモードで結合する場合、ツールは全ファイルの列ヘッダーを自動分析します。列が正確に一致しない場合 — 例えば一方のファイルに「顧客名」、もう一方に「クライアント名」がある場合 — 列の不一致ダイアログが表示されます。ドロップダウンメニューで手動マッピングするか、「そのまま続行」をクリックして再マッピングなしで結合できます。ファジーマッチングアルゴリズムが最適な一致を自動提案します。
列の競合解決は単一スプレッドシートモードでのみ表示されます。競合を完全に避けたい場合は、代わりに複数シートモードを使用してください。
複数シートのワークブックから含めるシートを選択
複数シートを含むExcelファイルをアップロードすると、結合オプションの下にシート選択パネルが表示されます。各ファイルについて、個別のシートにチェックを入れたり外したりして、結合に含めるか除外するかを選択できます。「すべて」と「なし」ボタンで素早く選択。チェックを外したシートは結合プロセスで完全にスキップされます。
結合出力に含めたくないサマリーシート、チャート、メタデータシートがワークブックに含まれている場合に特に便利です。
結合をクリックして即座に結合ファイルを取得
すべての設定が完了したら、「ファイルを結合」ボタンをクリックします。ツールはブラウザ内でローカルにすべてのファイルを処理 — サーバーにはアップロードされません。結合が完了すると、緑色の成功バナーが表示され、「ダウンロード」ボタンがアクティブになります。ダウンロードをクリックして結合されたXLSXファイルを保存。ソーシャル共有ボタンでツールを同僚と共有することもできます。
出力は常にモダンなXLSXファイルとして保存され、Excel、Google Sheets、その他のスプレッドシートアプリケーションとの最大互換性を確保します。
単一スプレッドシート
すべてのファイルのデータを1つの連続シートに積み重ねます。月次レポート、アンケートバッチ、地域別データエクスポートなど、同じ列構造を持つファイルの結合に最適。最初のファイルからヘッダーが保持され、スマート列マッチングがデータを自動整列。
最適な用途：月次レポート、アンケートデータ、類似構造のエクスポート
複数シート
各アップロードファイルを1つのワークブック内の名前付きタブとして配置。各ファイルの元のデータ構造は完全に保持されます。データを混在させずに1つのワークブックにファイルを統合したい場合に最適。
最適な用途：ソース別整理、複数レポートのアーカイブ
選択的結合
各ワークブックから結合に含めるシートを完全にコントロール。複数シートのExcelファイルをアップロードし、必要なシートだけを選択。未選択のシートは完全にスキップされます。
最適な用途：複数シートワークブック、特定データの抽出
How to Merge CSV Files Online
Seamlessly combine multiple CSV, TSV, and text files into one clean, consolidated master file. Features intelligent column alignment, drag-to-reorder, and 100% private browser-based processing.
Drag and drop multiple CSV files into the merger zone
Start by dragging and dropping two or more CSV, TSV, or text files into the upload area. The tool parses headers, line delimiters, and row counts instantly without uploading data to external servers.
You can merge CSV files alongside XLS and XLSX spreadsheets seamlessly in a single merge operation.
Drag files up or down to set row sequence
Reorder your files by dragging them up or down in the file queue. The order in the list directly determines which file's records appear first in the combined master dataset.
Useful for chronological datasets like monthly billing exports, quarterly invoices, or server access logs.
Automatic header matching across different column layouts
Our engine aligns columns by header name, not by column position. If file A has "Email" in column 1 and file B has "Email" in column 4, the data aligns perfectly. Any mismatched headers can be linked with the interactive column mapping dialog.
If column headers have slight variations (e.g., "Full Name" vs "Name"), map them together in one click to unify them.
Download as a single CSV file or formatted Excel workbook
Choose your desired output format: a single clean CSV file ready for database or API import, or an XLSX workbook for Microsoft Excel and Google Sheets. Click "Merge Files" to download instantly.
All processing under 15 MB runs locally inside your browser with zero latency and 100% data privacy.
Smart Header Matching
Columns align by header name regardless of column ordering in individual CSVs.
Auto Delimiter Detection
Supports commas, semicolons, tabs, and pipes in mixed files automatically.
Drag & Drop Reordering
Easily drag and drop to arrange the vertical order of merged data.
CSV & XLSX Output
Download as a unified CSV dataset or multi-sheet Excel workbook.
100% Client-Side Privacy
Files process in your browser via Web Workers without leaving your machine.
Large Volume Support
Merge dozens of CSV exports with hundreds of thousands of rows effortlessly.
How to Split Excel Files
Divide large Excel files into smaller workbooks with 9 customizable split modes: by row counts, worksheet tabs, unique column entries, file sizes, or date windows.
Drag and drop or click to upload XLS, XLSX, or CSV
Upload a single Excel or CSV file using the drag-and-drop zone. The tool inspects your sheets, row counts, and column structure locally.
For large files (50,000+ rows), client-side processing keeps your data completely secure on your machine.
Select the splitting logic that matches your workflow
Select from 9 specialized modes: By Fixed Rows, By File Count, By Sheet Tab, By Column Value (e.g., Region, Department), By Blank Rows, By File Size, By Formula Type, By Expression, or By Date Range.
Splitting by "Column Value" is perfect for dividing sales reports by representative, territory, or customer type.
Preview the resulting chunks before splitting
Use the Preview and Statistics tabs to inspect how the data will divide. Exclude blank lines, filter out unnecessary records, or save your settings as a reusable template.
The statistics tab gives you a bird's-eye view of row counts, unique values, and column distribution.
Download files separately or as a compressed archive
Click "Split Now" to process. When complete, download individual split files or click "Download All as ZIP" for a single packaged archive.
Each output file automatically receives an informative suffix based on your split rule.
By Fixed Rows
Split every N rows into equal chunks.
By File Count
Divide into N equal files.
By Sheet
Each sheet becomes a separate workbook.
By Column Value
Group rows by unique column entries.
By Blank Rows
Split at empty row separators.
By File Size
Limit each file size to meet upload limits.
By Formula Type
Separate formula rows from plain text.
By Expression
Custom rules for power users.
By Date Range
Group rows by month, quarter, or year.
File Format Converters
Convert PDF, scanned images, PowerPoint presentations, CSV, and JSON into Excel spreadsheets with zero data loss.
How to Convert PDF to Excel
Extract digital tables from PDF invoices, bank statements, and reports into clean, formula-ready XLSX or CSV files.
Drag and drop or select a PDF document
Upload standard or password-protected PDF files up to 50 MB. If password-protected, a prompt allows you to enter the decryption key instantly.
💡 PDFs with native digital tables convert with the highest precision. For scanned photos, use Image to Excel (OCR).
Choose Auto, Table Mode, or Lines Mode
Select Table Mode for structured financial statements, or Auto Mode for mixed text and tables. Customize delimiters, page ranges, and whether each PDF page becomes its own sheet tab.
💡 Enable "Sheet per Page" to keep multi-page PDF statements cleanly partitioned in your spreadsheet.
Verify row and column boundaries before converting
Click Preview to inspect the tabular grid, verify column separations, and check row alignments before creating the final document.
💡 Verify number formats in the preview to ensure monetary and percentage values align cleanly.
Download ready-to-use Excel workbook
Click "Convert Now" to extract the data into an Excel (.xlsx) workbook or plain text CSV file. Compatible with Excel, Google Sheets, and LibreOffice.
💡 Output files preserve numerical types so mathematical formulas like SUM and AVERAGE work immediately.
How to Convert Images to Excel (OCR)
Digitize photos, screenshots, and paper scans into editable spreadsheets using optical character recognition in 20+ languages.
Supports PNG, JPG, JPEG, WebP, BMP, and TIFF
Upload photos of physical invoices, spreadsheet screenshots, paper receipts, or scanned documents. Batch upload multiple images at once.
💡 High-contrast images with clean lighting produce the most accurate OCR character recognition.
Choose from 20+ languages and enhancement filters
Select your document language (English, Hindi, German, French, Spanish, Japanese, Chinese, etc.). Toggle image pre-processing (contrast auto-boost and Otsu binarization) for crisp text detection.
💡 Enable Auto-Upscale for small or low-resolution screenshots to sharpen small numbers and decimals.
Inspect cell confidence and edit errors directly
Tesseract.js identifies table boundaries and colors cells by accuracy: Green (high confidence), Yellow (review recommended), and Red (low confidence). Click any cell to fix typos directly.
💡 Quickly scan red cells to fix misinterpreted characters (like 0 vs O or 1 vs l) before downloading.
Save as XLSX with optional sheet-per-image tabs
Download your digitized data as a polished XLSX workbook or CSV. Multi-image uploads can be merged into a single sheet or split into separate tabs.
💡 All OCR processing happens entirely in your browser memory — no sensitive photos are uploaded to any cloud.
Convert CSV and TSV text files into styled, formatted Microsoft Excel workbooks with custom delimiters and automatic data-type detection.
Step-by-Step Instructions
- Step 1Upload your CSV, TSV, or comma-separated text file.
- Step 2Select delimiter (comma, semicolon, tab, pipe) and character encoding (UTF-8, Windows-1252).
- Step 3Preview column formatting, date recognition, and number parsing.
- Step 4Download the converted XLSX spreadsheet formatted for Microsoft Excel and Google Sheets.
Export Excel workbooks (XLS, XLSX) to clean, standard CSV text files for databases, CRM platforms, and data science pipelines.
Step-by-Step Instructions
- Step 1Upload your Excel spreadsheet (XLS, XLSX, XLSM).
- Step 2Select which worksheet tab you want to export to CSV.
- Step 3Choose your preferred field delimiter (comma, semicolon, tab) and quote escaping rules.
- Step 4Download the clean UTF-8 CSV file ready for database or system imports.
Transform spreadsheet rows into clean JSON arrays, nested key-value dictionaries, or API payloads with native type preservation.
Step-by-Step Instructions
- Step 1Upload your Excel or CSV file via the dropzone.
- Step 2Select output structure: Flat Array (for APIs), Sheet Dictionary, or Nested Objects (dot notation like user.name).
- Step 3Choose indentation (2-space pretty or minified) and empty-cell handling (omit, null, or empty string).
- Step 4Download the generated JSON file or copy it directly to your clipboard.
Convert JSON arrays, API responses, or JSON files into tabular Excel workbooks (.xlsx) with flattened nested properties.
Step-by-Step Instructions
- Step 1Paste your JSON payload or upload a .json file.
- Step 2Configure flattening depth for nested JSON objects and array handling.
- Step 3Preview the tabular structure with detected column headers.
- Step 4Download your structured Excel or CSV file ready for analysis.
Extract presentation tables, bulleted lists, and slide text from PPT and PPTX slideshows into organized spreadsheet rows.
Step-by-Step Instructions
- Step 1Upload your PowerPoint slideshow (.pptx, .ppt).
- Step 2Select extraction target: Slide Tables Only or All Slide Content.
- Step 3Choose whether each slide is placed into a separate sheet tab or unified into one sheet.
- Step 4Download your structured Excel file with all presentation data cataloged.
Data Cleaning & Manipulation
Diff spreadsheets, remove duplicate entries, concatenate multi-column records, and automate mail merges.
Compare two Excel spreadsheets side by side to instantly highlight modified cell values, inserted rows, and deleted data.
Step-by-Step Instructions
- Step 1Upload your Original (Base) file and your Modified (Comparison) file.
- Step 2Select which sheets to compare and match primary key columns (e.g. ID, SKU, Email).
- Step 3Review the visual color-coded diff: Green for additions, Red for deletions, and Yellow for modified values.
- Step 4Export a detailed difference report listing every change with cell coordinates.
Identify, highlight, and purge duplicate entries in Excel and CSV files with customizable column matching rules.
Step-by-Step Instructions
- Step 1Upload your Excel or CSV dataset.
- Step 2Choose which columns to check for duplicates (e.g. Email, Phone, or All Columns).
- Step 3Select your retention strategy: Keep First occurrence, Keep Last occurrence, or Remove All duplicates.
- Step 4Download your deduplicated dataset with an optional audit sheet of removed rows.
Merge two or more columns into a single consolidated column with custom delimiters, prefixes, and suffixes.
Step-by-Step Instructions
- Step 1Upload your Excel or CSV file.
- Step 2Select the columns you wish to join (e.g. "First Name" and "Last Name").
- Step 3Choose a separator (Space, Comma, Dash, Slash, or custom character).
- Step 4Preview the concatenated column and download the updated spreadsheet.
Generate customized letters, emails, and invoices from Excel rows using rich {{tags}} and conditional formatting.
Step-by-Step Instructions
- Step 1Upload your spreadsheet with recipient or customer records.
- Step 2Design your template in the rich editor with {{ColumnName}} tags, dynamic QR codes, and {{#if}} conditional blocks.
- Step 3Cycle through live previews to verify each personalized record.
- Step 4Generate and download all personalized documents as TXT, HTML, or PDF in a single ZIP file.
Security, Encryption & Compression
Reduce bloated Excel file sizes and secure sensitive spreadsheets with AES password protection.
Shrink bloated Excel (.xlsx) file sizes by optimizing internal XML structures, stripping unused metadata, and compressing images.
Step-by-Step Instructions
- Step 1Upload your oversized Excel file.
- Step 2Choose your compression level: Balanced (recommended) or Maximum compression.
- Step 3The optimizer strips unused styles, clears ghost formatting ranges, and compresses embedded images.
- Step 4Download your slimmed-down workbook with 100% of data and formulas preserved.
Protect confidential spreadsheets with military-grade 128-bit / 256-bit AES encryption before emailing or storing them.
Step-by-Step Instructions
- Step 1Upload the Excel workbook you wish to protect.
- Step 2Enter and confirm a strong password.
- Step 3Select encryption standard (Standard or High Security AES-256).
- Step 4Download your encrypted workbook. It cannot be opened or viewed without the password.
Remove password protection from encrypted Excel files when you have the password, producing an unprotected copy.
Step-by-Step Instructions
- Step 1Upload your password-protected Excel file (.xlsx).
- Step 2Enter the document decryption password.
- Step 3The tool unlocks the file in your browser and decrypts the spreadsheet streams.
- Step 4Download the unlocked, unrestricted Excel file ready for editing and sharing.
Lookup Automation Suite
Automate VLOOKUP, XLOOKUP, HLOOKUP, INDEX MATCH, multi-criteria joins, and fuzzy typo matching without writing formulas.
Perform instant vertical lookups between two tables without writing complex VLOOKUP formulas or dealing with #N/A errors.
Step-by-Step Instructions
- Step 1Upload your Primary table and Lookup table.
- Step 2Select the Lookup Column (the key to search for) and the Return Column (the data you want to retrieve).
- Step 3Choose exact match or approximate match.
- Step 4Download your enriched spreadsheet with the matched data joined seamlessly.
Modern 2-way lookups: search left, right, top, or bottom with automatic fallback values and exact matching.
Step-by-Step Instructions
- Step 1Upload your datasets.
- Step 2Select your search key and target columns (works in any direction, even searching to the left).
- Step 3Set fallback values for unmatched records (e.g. "Not Found" or 0).
- Step 4Download your merged spreadsheet with high-speed 2-way lookups applied.
Horizontal table lookups: search along a row and retrieve corresponding values from rows below.
Step-by-Step Instructions
- Step 1Upload your horizontal spreadsheet table.
- Step 2Choose the header row to search and the data row to retrieve.
- Step 3Specify match sensitivity.
- Step 4Download your transposed and looked-up dataset.
Dynamic 2-dimensional lookups matching both row headers and column headers simultaneously.
Step-by-Step Instructions
- Step 1Upload your matrix or 2D table.
- Step 2Set your vertical row lookup criteria and horizontal column criteria.
- Step 3The tool performs a dynamic matrix intersection lookup.
- Step 4Download the looked-up results with zero formula errors.
Join tables based on multiple matching conditions (e.g. First Name AND Last Name AND Department).
Step-by-Step Instructions
- Step 1Upload both spreadsheets.
- Step 2Select multiple matching key pairs (e.g. Key 1: Customer ID, Key 2: Order Date).
- Step 3The engine joins rows only when ALL specified criteria match simultaneously.
- Step 4Download the multi-condition merged master table.
Approximate string matching: connect tables even when names, companies, or addresses contain typos and misspellings.
Step-by-Step Instructions
- Step 1Upload both datasets.
- Step 2Select the text columns to compare (e.g. Company Name or Client Name).
- Step 3Adjust the similarity threshold (e.g. 85% match tolerance).
- Step 4Review matched pairs with similarity scores and export the reconciled table.
最良の結果を得るためのプロのヒント
最もクリーンな単一スプレッドシート結合のため、すべてのファイルで同じ列順序と命名を確保。
大きなファイル？他のブラウザタブを閉じてメモリを解放し、処理を高速化。
グリップハンドルをドラッグしてファイルを並べ替え — 結合順序はファイルリストの順序と一致。
1回の結合操作でXLS、XLSX、CSVファイルを混在可能。
すべての処理はブラウザ内で行われ、ファイルはデバイスから出ません。
乱雑なスプレッドシートのヘッダー行やフッターメモをスキップするにはデータ範囲オプションを使用。