How to Use Our Tools

होम पेज पर ड्रैग-एंड-ड्रॉप ज़ोन का उपयोग करके दो या अधिक Excel फ़ाइलें अपलोड करें। आप XLS (Excel 97-2003), XLSX (Excel 2007+), और CSV फ़ाइलें अपलोड कर सकते हैं — और एक ही मर्ज में अलग-अलग फॉर्मेट मिक्स भी कर सकते हैं। फ़ाइलें अपलोड ज़ोन के नीचे नाम, साइज़ और डिटेक्ट किए गए शीट के साथ दिखाई देती हैं। आप ग्रिप हैंडल से फ़ाइलों को रीऑर्डर कर सकते हैं, या डिलीट बटन से फ़ाइलें हटा सकते हैं।

दाएँ पैनल में तीन मर्ज मोड में से एक चुनें: एकल स्प्रेडशीट सभी डेटा को एक शीट में स्टैक करती है, समान डेटा को जोड़ने के लिए बेस्ट। एकाधिक शीट हर फ़ाइल को एक वर्कबुक में अलग टैब के रूप में रखती है, सोर्स के अनुसार डेटा व्यवस्थित करने के लिए आदर्श। चयनात्मक मर्ज आपको हर वर्कबुक से विशिष्ट शीट चुनने देता है — जब फ़ाइलों में कई शीट हों लेकिन आपको केवल कुछ चाहिए।

एडवांस विकल्पों के साथ मर्ज को कस्टमाइज़ करें। हेडर प्रबंधन चुनें — केवल पहली पंक्ति के हेडर रखें, डेटा सोर्स पहचानने के लिए शीट नाम लेबल जोड़ें, या हेडर प्रबंधन छोड़ दें। कस्टम डेटा रेंज सेट करें — शुरुआती और अंतिम सेल (जैसे A1 से Z1000) निर्दिष्ट करके प्रत्येक फ़ाइल का केवल एक हिस्सा मर्ज करें। फॉर्मेटिंग रखें विकल्प सक्षम करें ताकि मूल सेल स्टाइल, रंग और फॉर्मेटिंग बनी रहे।

एकल स्प्रेडशीट मोड में मर्ज करते समय, टूल स्वचालित रूप से सभी फ़ाइलों के कॉलम हेडर का विश्लेषण करता है। यदि कॉलम बिल्कुल मेल नहीं खाते — जैसे एक फ़ाइल में 'ग्राहक नाम' और दूसरी में 'क्लाइंट नाम' — तो एक कॉलम मिसमैच डायलॉग दिखाई देता है। आप ड्रॉपडाउन मेन्यू से मैन्युअली कॉलम मैप कर सकते हैं, या रीमैपिंग के बिना मर्ज जारी रख सकते हैं। फ़ज़ी मैचिंग एल्गोरिदम स्वचालित रूप से सर्वोत्तम मैच सुझाता है।

जब आप कई शीट वाली Excel फ़ाइलें अपलोड करते हैं, तो शीट सिलेक्शन पैनल दिखाई देता है। प्रत्येक फ़ाइल के लिए, आप व्यक्तिगत शीट को चेक या अनचेक कर सकते हैं। 'सभी' और 'कोई नहीं' बटन से तेज़ सिलेक्शन करें। अनचेक की गई शीट मर्ज प्रक्रिया में पूरी तरह स्किप हो जाएंगी।

सब सेट हो जाने पर, 'फ़ाइलें मर्ज करें' बटन पर क्लिक करें। टूल आपके ब्राउज़र में लोकली सभी फ़ाइलों को प्रोसेस करता है — किसी सर्वर पर कुछ अपलोड नहीं होता। मर्ज पूरा होने पर, हरी सक्सेस बैनर दिखती है और डाउनलोड बटन एक्टिव हो जाता है। मर्ज किए गए XLSX फ़ाइल को सेव करने के लिए डाउनलोड पर क्लिक करें। आप सोशल शेयरिंग बटन से टूल को सहकर्मियों के साथ शेयर भी कर सकते हैं।

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.

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.

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.

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.

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.

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.

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.

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.

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

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.

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

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.

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.

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.

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

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.

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.

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.

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.

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.

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.