Comprehensive Tool Guides

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.

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.

1
엑셀 파일 업로드

드래그 앤 드롭 또는 클릭하여 선택

홈 페이지의 드래그 앤 드롭 영역을 사용하여 두 개 이상의 엑셀 파일을 업로드하세요. XLS(Excel 97-2003), XLSX(Excel 2007+), CSV 파일을 업로드할 수 있으며, 다른 형식을 혼합할 수도 있습니다. 업로드된 파일은 이름, 크기, 감지된 시트와 함께 표시됩니다. 그립 핸들을 드래그하여 파일 순서를 변경하거나 삭제 버튼으로 개별 파일을 제거할 수 있습니다.

엑셀 파일 업로드

판매 보고서, 설문 응답, 데이터베이스 내보내기 등 다양한 출처의 파일을 업로드할 수 있습니다 — XLS, XLSX, CSV 형식이면 됩니다.

2
병합 모드 선택

파일 합치는 방법 선택

오른쪽 패널에서 세 가지 병합 모드 중 하나를 선택하세요: 단일 스프레드시트는 모든 데이터를 하나의 연속 시트에 쌓습니다. 다중 시트는 각 파일을 하나의 워크북에서 별도 탭으로 배치합니다. 선택적 병합은 각 워크북에서 특정 시트를 선택할 수 있습니다.

병합 모드 선택

모든 파일이 동일한 열 구조를 가진 경우 단일 스프레드시트를 사용하세요. 소스 파일별로 데이터를 분리하려면 다중 시트를 사용하세요.

3
고급 옵션 설정

헤더 처리, 데이터 범위, 서식 미세 조정

고급 옵션으로 병합 방식을 맞춤 설정하세요. 헤더 처리를 선택하여 열 헤더 처리 방법을 제어합니다. 사용자 정의 데이터 범위를 설정하여 각 파일의 특정 부분만 병합할 수 있습니다. 서식 유지를 활성화하여 원본 셀 스타일과 색상을 유지하세요.

고급 옵션 설정

파일의 첫 번째 행에 헤더가 있는 경우, 병합 출력에서 헤더 행이 중복되지 않도록 항상 '헤더 유지'를 사용하세요.

4
열 충돌 처리 (해당 시)

스마트 매칭으로 다른 열 구조 정렬

단일 스프레드시트 모드로 병합할 때, 도구는 모든 파일의 열 헤더를 자동으로 분석합니다. 열이 정확히 일치하지 않는 경우 — 예를 들어 한 파일의 '고객명'과 다른 파일의 '클라이언트명' — 열 불일치 대화 상자가 나타납니다. 드롭다운 메뉴를 사용하여 열을 수동으로 매핑하거나, 그대로 계속을 클릭하여 재매핑 없이 병합할 수 있습니다.

열 충돌 처리 (해당 시)

열 충돌 해결은 단일 스프레드시트 모드에서만 나타납니다. 충돌을 완전히 피하려면 다중 시트 모드를 사용하세요.

5
특정 시트 선택 (선택사항)

다중 시트 워크북에서 포함할 시트 선택

다중 시트 엑셀 파일을 업로드하면, 병합 옵션 아래에 시트 선택 패널이 나타납니다. 각 파일에서 개별 시트를 체크하거나 해제하여 병합에 포함하거나 제외할 수 있습니다. 전체 및 없음 버튼을 사용하여 빠르게 선택할 수 있습니다.

특정 시트 선택 (선택사항)

워크북에 요약 시트, 차트, 메타데이터 시트가 포함되어 있어 병합 출력에 원하지 않는 경우 특히 유용합니다.

6
합치기 및 다운로드

클릭하여 합쳐진 파일을 즉시 받기

모든 설정이 완료되면 파일 합치기 버튼을 클릭하세요. 도구는 브라우저에서 로컬로 모든 파일을 처리합니다 — 서버에 업로드되지 않습니다. 병합이 완료되면 녹색 성공 배너가 나타나고 다운로드 버튼이 활성화됩니다. 다운로드를 클릭하여 병합된 XLSX 파일을 저장하세요.

합치기 및 다운로드

출력은 항상 Excel, Google Sheets 및 기타 스프레드시트 애플리케이션과 최대 호환성을 위해 최신 XLSX 파일로 저장됩니다.

단일 스프레드시트

모든 파일의 데이터를 하나의 연속 시트에 쌓습니다. 월간 보고서, 설문 배치와 같이 동일한 열 구조를 가진 파일을 결합하는 데 이상적입니다. 첫 번째 파일의 헤더가 보존되고 스마트 열 매칭이 데이터를 자동으로 정렬합니다.

적합: 월간 보고서, 설문 데이터, 유사 구조 내보내기

다중 시트

각 업로드된 파일을 하나의 워크북 내에 별도의 이름이 지정된 탭으로 배치합니다. 각 파일의 원본 데이터 구조가 완전히 보존됩니다. 데이터를 혼합하지 않고 하나의 워크북으로 통합하려는 경우 적합합니다.

적합: 소스별 파일 정리, 여러 보고서 보관

선택적 병합

각 워크북에서 병합에 포함할 시트를 완전히 제어할 수 있습니다. 다중 시트 엑셀 파일을 업로드하고 필요한 시트만 직접 선택하세요. 선택 해제된 시트는 완전히 건너뜁니다.

적합: 다중 시트 워크북, 특정 데이터 추출

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.

1
Upload Your CSV Files

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.

2
Arrange File Stacking Order

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.

3
Smart Header Matching & Conflict Resolution

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.

4
Choose Output Format & Download

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.

1
Upload Your Excel File

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.

2
Choose from 9 Split Modes

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.

3
Configure Filters & Preview

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.

4
Split & Download (Individual or ZIP)

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.

Conversions Suite

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.

1
Upload Your PDF File

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).

2
Configure Extraction Mode & Delimiters

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.

3
Preview Extracted 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.

4
Convert to XLSX or CSV

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.

1
Upload Images or Screenshots

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.

2
Configure OCR & Language Settings

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.

3
Review with Confidence Highlighting & Inline Editing

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.

4
Export to Excel or CSV

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.

CSV to Excel Converter

Convert CSV and TSV text files into styled, formatted Microsoft Excel workbooks with custom delimiters and automatic data-type detection.

Open Tool

Step-by-Step Instructions

  1. Step 1Upload your CSV, TSV, or comma-separated text file.
  2. Step 2Select delimiter (comma, semicolon, tab, pipe) and character encoding (UTF-8, Windows-1252).
  3. Step 3Preview column formatting, date recognition, and number parsing.
  4. Step 4Download the converted XLSX spreadsheet formatted for Microsoft Excel and Google Sheets.
Pro Tip: Automatic number and date detection prevents leading zeros from being dropped on IDs and phone numbers.
Excel to CSV Converter

Export Excel workbooks (XLS, XLSX) to clean, standard CSV text files for databases, CRM platforms, and data science pipelines.

Open Tool

Step-by-Step Instructions

  1. Step 1Upload your Excel spreadsheet (XLS, XLSX, XLSM).
  2. Step 2Select which worksheet tab you want to export to CSV.
  3. Step 3Choose your preferred field delimiter (comma, semicolon, tab) and quote escaping rules.
  4. Step 4Download the clean UTF-8 CSV file ready for database or system imports.
Pro Tip: Choose UTF-8 encoding to preserve international accents, non-Latin scripts, and currency symbols.
Excel to JSON Converter

Transform spreadsheet rows into clean JSON arrays, nested key-value dictionaries, or API payloads with native type preservation.

Open Tool

Step-by-Step Instructions

  1. Step 1Upload your Excel or CSV file via the dropzone.
  2. Step 2Select output structure: Flat Array (for APIs), Sheet Dictionary, or Nested Objects (dot notation like user.name).
  3. Step 3Choose indentation (2-space pretty or minified) and empty-cell handling (omit, null, or empty string).
  4. Step 4Download the generated JSON file or copy it directly to your clipboard.
Pro Tip: Use dot notation headers (e.g. address.city, address.zip) to automatically produce deeply nested JSON objects.
JSON to Excel Converter

Convert JSON arrays, API responses, or JSON files into tabular Excel workbooks (.xlsx) with flattened nested properties.

Open Tool

Step-by-Step Instructions

  1. Step 1Paste your JSON payload or upload a .json file.
  2. Step 2Configure flattening depth for nested JSON objects and array handling.
  3. Step 3Preview the tabular structure with detected column headers.
  4. Step 4Download your structured Excel or CSV file ready for analysis.
Pro Tip: Complex nested JSON trees are automatically unnested into dot-notated spreadsheet columns.
PowerPoint (PPT) to Excel Converter

Extract presentation tables, bulleted lists, and slide text from PPT and PPTX slideshows into organized spreadsheet rows.

Open Tool

Step-by-Step Instructions

  1. Step 1Upload your PowerPoint slideshow (.pptx, .ppt).
  2. Step 2Select extraction target: Slide Tables Only or All Slide Content.
  3. Step 3Choose whether each slide is placed into a separate sheet tab or unified into one sheet.
  4. Step 4Download your structured Excel file with all presentation data cataloged.
Pro Tip: Ideal for converting financial pitch decks, survey summary presentations, and boardroom reports into raw spreadsheets.
Data Cleaning Suite

Data Cleaning & Manipulation

Diff spreadsheets, remove duplicate entries, concatenate multi-column records, and automate mail merges.

Compare Excel Files (Diff)

Compare two Excel spreadsheets side by side to instantly highlight modified cell values, inserted rows, and deleted data.

Open Tool

Step-by-Step Instructions

  1. Step 1Upload your Original (Base) file and your Modified (Comparison) file.
  2. Step 2Select which sheets to compare and match primary key columns (e.g. ID, SKU, Email).
  3. Step 3Review the visual color-coded diff: Green for additions, Red for deletions, and Yellow for modified values.
  4. Step 4Export a detailed difference report listing every change with cell coordinates.
Pro Tip: Matching by a unique Key Column ensures accurate comparison even if rows have been sorted or reordered.
Remove Duplicate Rows

Identify, highlight, and purge duplicate entries in Excel and CSV files with customizable column matching rules.

Open Tool

Step-by-Step Instructions

  1. Step 1Upload your Excel or CSV dataset.
  2. Step 2Choose which columns to check for duplicates (e.g. Email, Phone, or All Columns).
  3. Step 3Select your retention strategy: Keep First occurrence, Keep Last occurrence, or Remove All duplicates.
  4. Step 4Download your deduplicated dataset with an optional audit sheet of removed rows.
Pro Tip: Toggle Case-Insensitive matching so "[email protected]" and "[email protected]" are accurately flagged as identical.
Combine Columns (Concatenate)

Merge two or more columns into a single consolidated column with custom delimiters, prefixes, and suffixes.

Open Tool

Step-by-Step Instructions

  1. Step 1Upload your Excel or CSV file.
  2. Step 2Select the columns you wish to join (e.g. "First Name" and "Last Name").
  3. Step 3Choose a separator (Space, Comma, Dash, Slash, or custom character).
  4. Step 4Preview the concatenated column and download the updated spreadsheet.
Pro Tip: Enable "Ignore Empty Cells" so missing middle names or secondary addresses do not produce awkward double spaces.
Mail Merge Generator

Generate customized letters, emails, and invoices from Excel rows using rich {{tags}} and conditional formatting.

Open Tool

Step-by-Step Instructions

  1. Step 1Upload your spreadsheet with recipient or customer records.
  2. Step 2Design your template in the rich editor with {{ColumnName}} tags, dynamic QR codes, and {{#if}} conditional blocks.
  3. Step 3Cycle through live previews to verify each personalized record.
  4. Step 4Generate and download all personalized documents as TXT, HTML, or PDF in a single ZIP file.
Pro Tip: Use {{qr Email}} or {{img LogoUrl}} to dynamically embed personalized QR codes and web images for each recipient.
Security & Optimization

Security, Encryption & Compression

Reduce bloated Excel file sizes and secure sensitive spreadsheets with AES password protection.

Compress Excel File Size

Shrink bloated Excel (.xlsx) file sizes by optimizing internal XML structures, stripping unused metadata, and compressing images.

Open Tool

Step-by-Step Instructions

  1. Step 1Upload your oversized Excel file.
  2. Step 2Choose your compression level: Balanced (recommended) or Maximum compression.
  3. Step 3The optimizer strips unused styles, clears ghost formatting ranges, and compresses embedded images.
  4. Step 4Download your slimmed-down workbook with 100% of data and formulas preserved.
Pro Tip: Great for files that exceed email attachment limits (25 MB) or cloud portal upload caps.
Encrypt Excel (Password Protect)

Protect confidential spreadsheets with military-grade 128-bit / 256-bit AES encryption before emailing or storing them.

Open Tool

Step-by-Step Instructions

  1. Step 1Upload the Excel workbook you wish to protect.
  2. Step 2Enter and confirm a strong password.
  3. Step 3Select encryption standard (Standard or High Security AES-256).
  4. Step 4Download your encrypted workbook. It cannot be opened or viewed without the password.
Pro Tip: Encryption is performed client-side using industry-standard cryptography so your password and data are never sent to a server.
Unlock Excel (Decrypt Password)

Remove password protection from encrypted Excel files when you have the password, producing an unprotected copy.

Open Tool

Step-by-Step Instructions

  1. Step 1Upload your password-protected Excel file (.xlsx).
  2. Step 2Enter the document decryption password.
  3. Step 3The tool unlocks the file in your browser and decrypts the spreadsheet streams.
  4. Step 4Download the unlocked, unrestricted Excel file ready for editing and sharing.
Pro Tip: Ideal when you need to remove passwords from multiple company spreadsheets for batch merging or automated ingestion.
Formulas & Lookups

Lookup Automation Suite

Automate VLOOKUP, XLOOKUP, HLOOKUP, INDEX MATCH, multi-criteria joins, and fuzzy typo matching without writing formulas.

Excel VLOOKUP Helper

Perform instant vertical lookups between two tables without writing complex VLOOKUP formulas or dealing with #N/A errors.

Open Tool

Step-by-Step Instructions

  1. Step 1Upload your Primary table and Lookup table.
  2. Step 2Select the Lookup Column (the key to search for) and the Return Column (the data you want to retrieve).
  3. Step 3Choose exact match or approximate match.
  4. Step 4Download your enriched spreadsheet with the matched data joined seamlessly.
Pro Tip: No more counting column index numbers or locking cell ranges with $ symbols!
Excel XLOOKUP Helper

Modern 2-way lookups: search left, right, top, or bottom with automatic fallback values and exact matching.

Open Tool

Step-by-Step Instructions

  1. Step 1Upload your datasets.
  2. Step 2Select your search key and target columns (works in any direction, even searching to the left).
  3. Step 3Set fallback values for unmatched records (e.g. "Not Found" or 0).
  4. Step 4Download your merged spreadsheet with high-speed 2-way lookups applied.
Pro Tip: Overcomes VLOOKUP's classic limitation of only searching to the right of the lookup column.
Excel HLOOKUP Helper

Horizontal table lookups: search along a row and retrieve corresponding values from rows below.

Open Tool

Step-by-Step Instructions

  1. Step 1Upload your horizontal spreadsheet table.
  2. Step 2Choose the header row to search and the data row to retrieve.
  3. Step 3Specify match sensitivity.
  4. Step 4Download your transposed and looked-up dataset.
Pro Tip: Perfect for financial projection tables arranged horizontally by quarter or year.
INDEX & MATCH Tool

Dynamic 2-dimensional lookups matching both row headers and column headers simultaneously.

Open Tool

Step-by-Step Instructions

  1. Step 1Upload your matrix or 2D table.
  2. Step 2Set your vertical row lookup criteria and horizontal column criteria.
  3. Step 3The tool performs a dynamic matrix intersection lookup.
  4. Step 4Download the looked-up results with zero formula errors.
Pro Tip: The gold standard for complex financial models and pricing matrices.
Multi-Criteria Lookup

Join tables based on multiple matching conditions (e.g. First Name AND Last Name AND Department).

Open Tool

Step-by-Step Instructions

  1. Step 1Upload both spreadsheets.
  2. Step 2Select multiple matching key pairs (e.g. Key 1: Customer ID, Key 2: Order Date).
  3. Step 3The engine joins rows only when ALL specified criteria match simultaneously.
  4. Step 4Download the multi-condition merged master table.
Pro Tip: Eliminates the tedious Excel workaround of creating helper concatenation columns.
Excel Fuzzy Lookup (Typo Matcher)

Approximate string matching: connect tables even when names, companies, or addresses contain typos and misspellings.

Open Tool

Step-by-Step Instructions

  1. Step 1Upload both datasets.
  2. Step 2Select the text columns to compare (e.g. Company Name or Client Name).
  3. Step 3Adjust the similarity threshold (e.g. 85% match tolerance).
  4. Step 4Review matched pairs with similarity scores and export the reconciled table.
Pro Tip: Matches variations like "Microsoft Corp" vs "Microsoft Corporation" or "John Smith" vs "Jon Smith" automatically.

최상의 결과를 위한 프로 팁

1

가장 깔끔한 단일 스프레드시트 병합을 위해 모든 파일이 동일한 열 순서와 이름을 사용하도록 하세요.

2

큰 파일? 다른 브라우저 탭을 닫아 빠른 처리를 위한 메모리를 확보하세요.

3

그립 핸들을 드래그하여 파일 순서를 변경하세요 — 병합 순서는 파일 목록 순서를 따릅니다.

4

단일 병합 작업에서 XLS, XLSX, CSV 파일을 혼합할 수 있습니다.

5

모든 처리는 브라우저에서 이루어집니다 — 파일은 기기를 떠나지 않습니다.

6

데이터 범위 옵션을 사용하여 지저분한 스프레드시트의 헤더 행이나 추가 내용을 건너뛰세요.

도움이 더 필요하신가요?FAQ 보기지원 문의