How to Use Our Tools
Complete step-by-step guides for merging, splitting, converting, and transforming Excel files and PDFs. Every feature explained in detail.
Merge Excel Files
Combine multiple Excel spreadsheets (XLS, XLSX, CSV) into one file with smart column matching, conflict resolution, and 100% privacy.
Ziehen und ablegen oder zum Auswählen klicken
Laden Sie zwei oder mehr Excel-Dateien über die Drag-and-Drop-Zone auf der Startseite hoch. Sie können XLS (Excel 97-2003), XLSX (Excel 2007+) und CSV-Dateien hochladen — und verschiedene Formate in einer einzigen Zusammenführung mischen. Dateien werden unter der Upload-Zone mit Name, Größe und erkannten Blättern aufgelistet. Sie können Dateien per Drag-and-Drop am Greifpunkt neu ordnen oder einzelne Dateien mit dem Löschen-Button entfernen.
Sie können Dateien aus verschiedenen Quellen hochladen — Verkaufsberichte, Umfrageantworten, Datenbankexporte — solange sie im XLS-, XLSX- oder CSV-Format vorliegen.
Wählen Sie, wie Ihre Dateien kombiniert werden sollen
Wählen Sie im rechten Seitenbereich einen der drei Zusammenführungsmodi: Einzelne Tabelle stapelt alle Daten in einem fortlaufenden Blatt, perfekt zum Kombinieren ähnlicher Daten. Mehrere Blätter platziert jede hochgeladene Datei als separaten Tab in einer Arbeitsmappe, ideal zum Organisieren nach Quelle. Selektives Zusammenführen lässt Sie bestimmte Blätter aus jeder Arbeitsmappe auswählen — ideal wenn Dateien mehrere Blätter enthalten, Sie aber nur bestimmte benötigen.
Verwenden Sie Einzelne Tabelle, wenn alle Dateien die gleiche Spaltenstruktur haben (z.B. monatliche Verkaufsberichte). Verwenden Sie Mehrere Blätter, wenn Sie Daten nach Quelldatei getrennt halten möchten.
Kopfzeilen, Datenbereich und Formatierung fein abstimmen
Passen Sie Ihre Zusammenführung mit erweiterten Optionen an. Wählen Sie die Kopfzeilenbehandlung, um zu steuern, wie Spaltenüberschriften behandelt werden — nur die Kopfzeilen der ersten Zeile beibehalten, Blattnamen-Labels zur Identifikation hinzufügen oder die Kopfzeilenbehandlung überspringen. Legen Sie einen benutzerdefinierten Datenbereich fest, indem Sie Start- und Endzellen angeben (z.B. A1 bis Z1000), um nur einen Teil jeder Datei zusammenzuführen. Aktivieren Sie Formatierung beibehalten, um originale Zellstile und Farben in der Zusammenführung zu erhalten.
Wenn Ihre Dateien Kopfzeilen in der ersten Zeile haben, verwenden Sie immer 'Kopfzeilen beibehalten', um doppelte Kopfzeilen in der Ausgabe zu vermeiden.
Intelligente Abgleichung richtet verschiedene Spaltenstrukturen aus
Bei Zusammenführung im Einzeltabellen-Modus analysiert das Tool automatisch die Spaltenüberschriften aller Dateien. Wenn Spalten nicht genau übereinstimmen — zum Beispiel 'Kundenname' in einer Datei und 'Mandantenname' in einer anderen — erscheint ein Dialog für Spaltenabweichungen. Sie können Spalten manuell über Dropdown-Menüs zuordnen oder auf 'Fortfahren' klicken, um ohne Neuzuordnung zusammenzuführen. Der Fuzzy-Matching-Algorithmus schlägt automatisch die besten Übereinstimmungen vor.
Die Spaltenkonfliktlösung erscheint nur im Einzeltabellen-Modus. Wenn Sie Konflikte vollständig vermeiden möchten, verwenden Sie stattdessen den Mehrere-Blätter-Modus.
Wählen Sie, welche Blätter aus Arbeitsmappen einbezogen werden
Wenn Sie Excel-Dateien mit mehreren Blättern hochladen, erscheint das Blattauswahl-Panel unter den Zusammenführungsoptionen. Für jede Datei können Sie einzelne Blätter an- oder abwählen. Verwenden Sie die Alle- und Keine-Buttons für schnelle Auswahl. Abgewählte Blätter werden beim Zusammenführen komplett übersprungen.
Besonders nützlich, wenn Arbeitsmappen Zusammenfassungsblätter, Diagramme oder Metadaten-Blätter enthalten, die Sie nicht in der Ausgabe haben möchten.
Klicken Sie auf Zusammenführen und erhalten Sie Ihre Datei sofort
Sobald alles konfiguriert ist, klicken Sie auf Dateien zusammenführen. Das Tool verarbeitet alle Dateien lokal in Ihrem Browser — nichts wird auf einen Server hochgeladen. Nach Abschluss erscheint ein grünes Erfolgsbanner und der Download-Button wird aktiv. Klicken Sie auf Herunterladen, um Ihre zusammengeführte XLSX-Datei zu speichern. Sie können das Tool auch über die Social-Sharing-Buttons mit Kollegen teilen.
Die Ausgabe wird immer als moderne XLSX-Datei gespeichert für maximale Kompatibilität mit Excel, Google Sheets und anderen Tabellenkalkulationen.
Zusammenführungsmodi erklärt
Wählen Sie den richtigen Modus für Ihr Szenario
Einzelne Tabelle
Stapelt alle Daten aus jeder Datei in ein fortlaufendes Blatt. Ideal zum Kombinieren von Dateien mit gleicher Spaltenstruktur — wie Monatsberichte, Umfrage-Batches oder regionale Datenexporte. Kopfzeilen werden aus der ersten Datei beibehalten und intelligente Spaltenzuordnung richtet Daten automatisch aus.
Ideal für: Monatsberichte, Umfragedaten, ähnlich strukturierte Exporte
Mehrere Blätter
Platziert jede hochgeladene Datei als benannten Tab in einer einzelnen Arbeitsmappe. Die ursprüngliche Datenstruktur jeder Datei bleibt vollständig erhalten. Perfekt wenn Sie Dateien in einer Arbeitsmappe konsolidieren möchten, ohne die Daten zu vermischen.
Ideal für: Organisation nach Quelle, Archivierung mehrerer Berichte
Selektives Zusammenführen
Volle Kontrolle darüber, welche Blätter aus jeder Arbeitsmappe einbezogen werden. Laden Sie Multi-Blatt-Excel-Dateien hoch und wählen Sie nur die benötigten Blätter aus. Nicht ausgewählte Blätter werden komplett übersprungen.
Ideal für: Multi-Blatt-Arbeitsmappen, spezifische Datenextraktion
Leitfaden zu erweiterten Optionen
Optimieren Sie jeden Aspekt des Zusammenführungsprozesses
Kopfzeilenbehandlung
Steuern Sie, wie Spaltenüberschriften behandelt werden. 'Kopfzeilen beibehalten' behält nur die Kopfzeile der ersten Datei bei. 'Blatt-Labels hinzufügen' fügt den Quell-Blattnamen vor den Daten ein. 'Keine Behandlung' behandelt alle Zeilen gleich ohne spezielle Kopfzeilen-Logik.
Datenbereich
Begrenzen Sie die Zusammenführung auf einen bestimmten Zellbereich. Geben Sie eine Startzelle (z.B. A1) und Endzelle (z.B. Z1000) ein, um nur einen Teil jeder Datei zu extrahieren. Nützlich bei Dateien mit zusätzlichen Metadaten oder Notizen außerhalb des Hauptdatenbereichs.
Formatierung beibehalten
Behält die originale Zellenformatierung, Farben, Schriftstile und bedingte Formatierung aus Ihren Quelldateien bei. Bei Deaktivierung werden nur Rohdatenwerte übertragen.
PDF to Excel Converter
Extract tables and data from PDF documents into clean, editable Excel spreadsheets. Smart table detection with multiple extraction modes.
Drag and drop or click to select a PDF
Start by uploading your PDF file using the drag-and-drop zone. The tool accepts standard PDF files up to 50 MB. Once uploaded, the file name, size, and PDF badge are displayed. If your PDF is password-protected, a password field will appear automatically — just enter the password to unlock it.
For best results, use PDFs with clearly structured tables rather than scanned images. Scanned PDFs may produce lower-quality results. For scanned documents, try our Image to Excel (OCR) tool instead.
Choose extraction mode, output format, and options
In the options panel on the right, configure how your PDF data should be extracted. Choose from three Extraction Modes: Auto (automatically detects tables and text), Table Mode (optimized for structured tabular data), or Lines Mode (extracts text line by line). Select your Output Format — XLSX for Excel or CSV for plain text. Set a Page Range (e.g., "1-3, 5") to convert only specific pages. Choose a Delimiter (Auto, Tab, Pipe, Comma, Semicolon, or Space) to control how columns are separated. Enable "Sheet per page" to place each PDF page into a separate Excel sheet tab.
Use "Auto" extraction mode for most PDFs — it intelligently detects whether the content is a table or plain text. Use "Table" mode only when you know the PDF contains structured tabular data with clear rows and columns.
Check the extracted data before converting
Click the "Preview" button to see a preview of the extracted data before committing to the full conversion. The preview shows a paginated table view with row counts, column counts, and total pages detected. This lets you verify the extraction quality and adjust settings if needed before downloading.
Always preview first when working with complex PDFs that have mixed content (tables, paragraphs, headers). This saves time by letting you adjust settings before the full conversion.
Process and download your Excel file
Click the "Convert Now" button to process the full PDF conversion. A progress indicator shows the conversion status. Once complete, a green success banner appears with the conversion time. Click the "Download" button to save your converted XLSX or CSV file. The output file name is automatically generated from your original PDF name with a timestamp.
The converted XLSX file is compatible with Microsoft Excel, Google Sheets, LibreOffice Calc, and all major spreadsheet applications.
Key Features
Smart Table Detection
Automatically detects tables in your PDF and extracts structured data into clean spreadsheet columns.
3 Extraction Modes
Auto, Table, and Lines modes let you choose the best extraction method for your PDF content.
Password Support
Unlock and convert password-protected PDFs by entering the document password.
Page Range Selection
Convert only specific pages (e.g., "1-3, 5") instead of the entire document.
Sheet Per Page
Place each PDF page into a separate Excel sheet tab for organized output.
Preview Before Download
Check extracted data in a table preview before committing to the full conversion.
Excel Splitter
Split large Excel files into smaller pieces with 9 powerful split modes — by rows, sheets, columns, formulas, dates, file size, and more.
Drag and drop or click to upload XLS, XLSX, or CSV
Upload a single Excel or CSV file using the drag-and-drop zone at the top of the page. The tool accepts XLS, XLSX, and CSV formats. Once uploaded, a step progress bar updates to show you are in the "Configure" phase. The file info panel shows the file name, detected sheets, total rows, and columns.
For very large files (50,000+ rows), close other browser tabs to free up memory. All processing happens locally in your browser, so performance depends on your device.
Choose from 9 powerful split modes
Use the Split Configuration panel on the right to choose how your file should be split. The tool offers 9 split modes: By Fixed Rows (split every N rows), By File Count (divide into N equal files), By Sheet (each sheet as a separate file), By Column Value (group rows by a column's value), By Blank Rows (split at empty rows), By File Size (limit each output file's size), By Formula Type (separate formula cells from value cells), By Expression (custom conditions), and By Date Range (time-based groups). Each mode has its own configuration options that appear when selected.
The "By Column Value" mode is incredibly powerful for splitting sales data by region, employee records by department, or survey responses by category — any column with repeating group values.
Refine your data and save split configurations
Use the Data Filters panel to narrow down which rows are included before splitting. You can filter by column values, exclude empty rows, or set conditions. The Template Manager lets you save your split configuration as a reusable template — perfect for recurring tasks like monthly report splitting. Simply save a template, and load it next time to apply the same settings instantly.
Save templates for split configurations you use regularly. For example, create a "Monthly Sales Split" template that splits by the "Region" column and filters for the current month.
Check your data before splitting
Switch between four tabs below the upload area: Preview (see your data in a table), Results (view split output after processing), Statistics (column stats, value distributions, data type breakdowns), and Formulas (detect and inspect Excel formulas). The Preview tab shows your raw data with pagination and column headers. The Statistics tab gives you a powerful analytical overview of your dataset.
Use the Formulas tab to check if your file contains Excel formulas before splitting. The tool preserves formulas across split files, but it is good to know what formulas are present.
Process your file and download results
Click the "Split Now" button to process your file. The step progress bar updates to show the "Split" phase, and then moves to "Results" when complete. Switch to the Results tab to see all generated files. You can download individual files or download all files at once as a ZIP archive. Each output file is named based on your split criteria (e.g., by column value or row range).
You can click "New File" at any time to reset and upload a different file. Your split configuration and templates are preserved.
9 Supported Split Modes
By Fixed Rows
Split every N rows — perfect for breaking large datasets into manageable chunks.
By File Count
Divide into N equal files — ideal when you need a specific number of output files.
By Sheet
Each sheet becomes a separate file — great for multi-sheet workbooks.
By Column Value
Group rows by a column value — perfect for categorizing data by region, department, etc.
By Blank Rows
Split at empty rows — useful for data with natural section breaks.
By File Size
Limit each output file size — handy when email or system upload limits apply.
By Formula Type
Separate formula cells from value cells — useful for data auditing.
By Expression
Custom conditions and expressions — maximum flexibility for power users.
By Date Range
Time-based groups — split data by week, month, quarter, or year.
Excel to JSON Converter
Convert Excel (XLS, XLSX) and CSV files to structured JSON with advanced options for nested objects, type parsing, and custom formatting.
Drag and drop or click to select a file
Upload a single Excel (XLS, XLSX) or CSV file using the drag-and-drop zone. The tool processes files entirely in your browser — nothing is uploaded to any server. Once a file is uploaded, the tool automatically detects all available sheets and displays them in the options panel. The file name and size are shown below the upload area.
This tool processes everything locally using the SheetJS library. Your data never leaves your device, making it safe for sensitive financial or personal data.
Choose format, indentation, and data parsing rules
In the options panel on the right, configure your JSON output. Select which Sheets to process by checking/unchecking individual sheets. Choose a Structure Format: Flat Array (array of row objects — best for APIs), Object Dictionary (object with sheet names as keys — for multi-sheet files), or Wrapped Root ({ data: ... } wrapper — for frameworks). Pick Indentation: 2 spaces (readable), 4 spaces (more spaced), or Minified (smallest file size). Set Empty Cells handling: Omit (skip empty cells), Null (set to null), or Empty String (set to "").
Use "Flat Array" format for single-sheet files when you need clean API-ready JSON. Use "Object Dictionary" when your file has multiple sheets and you want to preserve the sheet structure.
Control nested objects, type parsing, and date formats
Toggle three advanced data parsing options: Nested Objects — when enabled, column headers with dots (like "address.city") are converted into nested JSON objects ({ address: { city: "..." } }). Auto-Parse Types — keeps numbers, booleans, and dates as their native types instead of converting everything to strings. Raw Date Format — when enabled, preserves Excel's internal date serial numbers instead of converting to JavaScript Date objects.
Enable "Nested Objects" if your column headers use dot notation (e.g., "user.name", "user.email") — the tool will automatically create nested JSON structures from flat spreadsheet columns.
Process your file and get JSON output
Click the "Convert Now" button to generate JSON from your spreadsheet. The output appears in a syntax-highlighted preview panel below, showing the first 5,000 characters. The file size of the generated JSON is displayed. Click "Download" to save the JSON file. The downloaded file name matches your original file name with a .json extension.
You can copy the JSON directly from the preview panel for quick use. For large files, the preview is truncated but the full JSON is included in the download.
Key Features
Multiple Output Formats
Flat Array, Object Dictionary, or Wrapped Root — choose the best structure for your use case.
Nested Object Support
Column headers with dots are converted to nested JSON objects automatically.
Sheet Selection
Choose which sheets to include — process one sheet or all sheets at once.
Type Preservation
Numbers, booleans, and dates are preserved as native JSON types, not strings.
Minified or Pretty
Choose 2-space, 4-space, or minified indentation for your output.
100% Client-Side
All processing happens in your browser. Your data never leaves your device.
Mail Merge Generator
Generate bulk personalized letters, emails, and documents from Excel or CSV data using {{Tag}} placeholders. Export as TXT, HTML, or PDF.
Upload an Excel or CSV file with your records
Upload an Excel (XLS, XLSX) or CSV file containing your data records. The tool reads the first sheet and displays all detected columns. A data table preview shows all your records with column headers. You can search and filter records using the search bar above the table. The record count is displayed showing matching vs. total records. Don't have a file? Click "Try Demo" to load sample customer data instantly and explore the tool.
Make sure your column headers are in the first row. Trailing spaces in column names are automatically trimmed. The tool reads the first sheet of multi-sheet workbooks.
Create a rich-text template with {{Tags}} for personalization
Write your document template in the rich-text editor. Insert data placeholders by clicking column name buttons below the editor — each click inserts a {{ColumnName}} tag at the cursor position. The editor supports rich text formatting: Bold, Italic, Underline, Headings (H1, H2), Paragraph, Bullet Lists, Numbered Lists, Text Alignment (Left/Center/Right), Text Color, and Clear Formatting. You can also add a Subject Line Template for email drafts. Use {{#if Status}} conditional {{/if}} blocks for conditional content. Insert dynamic QR codes with {{qr ColumnName}} and dynamic images with {{img ImageURLColumn}}.
Your template is automatically saved to localStorage — so even if you close the browser, your template is preserved when you return. Click "Load Demo Template" to see an example template.
See live previews of each personalized document
The Preview panel on the right shows a live, rendered preview of your template merged with actual data. Use the left/right navigation arrows to cycle through all records and see how each personalized document looks. The preview renders rich text, images, and QR codes in real-time. You can also preview the Subject Line merged with the current record. Copy the rendered body to clipboard with "Smart Copy" (preserves HTML formatting), copy the subject line separately, or click "Open in Email App" to launch your default email client with the preview pre-filled.
Use "Smart Copy (Email Body)" to copy the rendered HTML to your clipboard — it preserves bold, italic, lists, and formatting when pasted into email clients like Gmail or Outlook.
Choose output format, filename pattern, and generate documents
In the Download section, choose your output format: TXT (plain text), HTML (rich formatted), or PDF (printable documents). Set a Filename Pattern using {{Tags}} — for example, "invoice_{{Name}}.html" generates unique filenames for each record. The {{row}} tag inserts the row number. Click "Generate & Download ZIP" to create all documents at once. A real-time progress bar shows generation status. Once complete, the ZIP file downloads automatically containing all personalized documents. The ZIP file size is displayed after generation.
PDF generation uses html2canvas for high-quality rendering. For large datasets (100+ records), TXT and HTML formats are significantly faster than PDF because each PDF requires rendering.
Power Features
Rich Text Editor
Full formatting toolbar — bold, italic, headings, lists, alignment, colors, and more.
{{Tag}} Placeholders
Click column names to insert personalization tags at the cursor position.
Conditional Logic
Use {{#if}} blocks to show/hide content based on data values.
Dynamic QR Codes
Generate QR codes from any data column using {{qr ColumnName}}.
Dynamic Images
Embed images from URL columns using {{img ImageURLColumn}}.
Multi-Format Output
Export as TXT, HTML, or PDF — all delivered in a ZIP archive.
Live Preview
See each personalized document rendered in real-time with record navigation.
Auto-Save Templates
Templates are saved to localStorage and persist across browser sessions.
Template Quick Reference
Basic Tags
{{Name}} → John Doe{{Email}} → john@example.comConditional Logic
{{#if Status}}Paid{{/if}}{{#unless Paid}}Overdue{{/unless}}Dynamic QR Code
{{qr Email}} → generates QR imageDynamic Image
{{img PhotoURL}} → embeds imageImage to Excel (OCR)
Extract text and tables from images using OCR technology. Convert photos, screenshots, receipts, and scanned documents to Excel spreadsheets.
Drag and drop or click to select image files
Upload one or more images using the drag-and-drop zone. Supported formats include PNG, JPG/JPEG, WebP, BMP, and TIFF. You can upload multiple images at once (up to 20 MB each). Uploaded images are displayed as thumbnails with file name and size. Remove individual images with the delete button, or clear all images to start over. The tool processes images entirely in your browser using Tesseract.js OCR.
For best OCR accuracy, use clear, high-resolution images with good contrast. Screenshots of spreadsheets work very well. Blurry or low-resolution photos may produce lower-quality results.
Choose language, extraction mode, and enhancement options
In the options panel, configure your OCR settings. Select the OCR Language from 20+ supported languages including English, Hindi, German, French, Spanish, Japanese, Korean, Chinese (Simplified/Traditional), Arabic, and more. Choose an Extraction Mode: Table (detects and reconstructs table grid from word positions) or Lines (extracts text line by line). Select Output Format: XLSX or CSV. Enable "Sheet per Image" to place each image's data on a separate Excel sheet. Toggle Image Enhancement to preprocess images for better OCR accuracy — with three strength levels (Low, Medium, High). Enable Auto-Upscale to automatically enlarge small images for improved text recognition.
Always enable Image Enhancement for photos and scanned documents. The preprocessing pipeline applies grayscale conversion, contrast adjustment, and Otsu's binarization — dramatically improving OCR accuracy.
Run OCR and review extracted data with confidence scores
Click "Convert to Excel" to start the OCR process. A progress indicator shows the current status: loading language model, enhancing image, and recognizing text — with per-image progress. Once complete, extracted data is displayed in a table preview with per-cell confidence color coding: Green (≥80% confidence — high accuracy), Yellow (50-80% — may need review), and Red (<50% — likely needs correction). You can click any cell to edit its content inline — corrections are applied instantly. The overall confidence score and conversion time are displayed.
Pay special attention to cells with yellow or red confidence highlights — these are the most likely to contain OCR errors. Click directly on any cell to correct the text before downloading.
Download the converted spreadsheet
Click "Download" to save the converted file as XLSX or CSV. If you enabled "Sheet per Image" with multiple images, each image's data appears on its own named sheet tab. Column widths are automatically adjusted to fit the content. If you edited any cells after OCR, click "Regenerate File" to update the download with your corrections before saving.
Use "Sheet per Image" when converting multiple related images (like multi-page scanned documents) to keep each page's data organized in separate tabs within one workbook.
OCR Features
20+ Languages
English, Hindi, German, French, Spanish, Japanese, Korean, Chinese, Arabic, and many more.
Smart Table Reconstruction
Spatial analysis of word positions reconstructs table grids from images.
Image Enhancement
Grayscale conversion, contrast adjustment, and Otsu's binarization for better accuracy.
Auto-Upscale
Automatically enlarges small images for improved text recognition.
Inline Cell Editing
Click any extracted cell to correct text directly before downloading.
Confidence Scoring
Per-cell color coding shows OCR confidence — green, yellow, or red.
Multi-Image Batch
Process multiple images at once with optional sheet-per-image output.
100% Client-Side
Tesseract.js runs entirely in your browser. No image uploads to any server.
Supported Image Formats
Maximum file size: 20 MB per image. Multiple images can be processed at once.
Profi-Tipps für beste Ergebnisse
Stellen Sie sicher, dass alle Dateien die gleiche Spaltenreihenfolge und Benennung verwenden für saubere Einzeltabellen-Zusammenführungen.
Große Dateien? Schließen Sie andere Browser-Tabs, um Speicher für schnellere Verarbeitung freizugeben.
Ordnen Sie Dateien per Drag am Greifpunkt neu — die Zusammenführungsreihenfolge entspricht der Dateiliste.
Sie können XLS, XLSX und CSV-Dateien in einer einzigen Operation mischen.
Alle Verarbeitung erfolgt in Ihrem Browser — Ihre Dateien verlassen nie Ihr Gerät.
Verwenden Sie die Datenbereich-Option, um Kopfzeilen oder Fußnoten in unordentlichen Tabellen zu überspringen.