Excel & Data Feature Overview
Organize, compare, convert, and anonymize tables. Explains supported tasks, usage steps, and how to check results on a single page.
Excel & Data Tasks Handled by the Tool
Organize, compare, convert, and anonymize tables Tasks are organized into input, execution, and result review steps. Start with the default settings, then change only the options you need to reduce configuration errors.
General Usage Steps
- Select a tool from the list below that suits your needs.
- Provide a file or value and review the output options.
- After processing, check the output file's name, format, and size, then save it.
Excel & Data Feature List
This feature is available to run from the current public catalog.
Merge Multiple Excel Files
Copy all sheets from multiple XLSX files into one workbook.
Open Feature →Split Excel Sheets into Separate Files
Split each sheet in an Excel workbook into a separate XLSX file and package them in a ZIP.
Open Feature →Merge Multiple CSV Files
Combine the headers and rows of multiple CSV files into a single UTF-8 CSV file.
Open Feature →Remove Duplicate Table Rows
Remove exact duplicate rows from CSV or XLSX files, keeping one copy of each.
Open Feature →Remove Empty Rows & Columns
Find and delete empty rows and columns.
Open Feature →Standardize Phone Number, Date, and Amount Formats
Automatically standardize phone numbers, dates, amounts, and whitespace in a table.
Open Feature →Compare Two Excel Files
Exports differing cells, their rows and columns, and their previous and new values to XLSX.
Open Feature →Split Columns
Split the selected column into multiple columns using a delimiter.
Open Feature →Merge Columns
Combine multiple columns using a specified delimiter to create a new column.
Open Feature →Character Encoding Converter
Resaves CSV and TXT files using UTF-8, CP949, or EUC-KR encoding.
Open Feature →Password-Protect XLSX
Protect an Excel file in an AES-encrypted ZIP archive.
Open Feature →Convert JSON to CSV
Convert a JSON array of objects into a CSV table.
Open Feature →CSV to JSON
Convert CSV rows into an array of JSON objects.
Open Feature →JSON to XLSX
Convert a JSON array of objects into an Excel table.
Open Feature →Convert XLSX to JSON
Convert the first Excel worksheet into an array of JSON objects.
Open Feature →XML to JSON
Convert XML hierarchies to JSON structures.
Open Feature →Convert JSON to XML
Convert a JSON array into an item-based XML document.
Open Feature →Convert YAML to JSON
Convert YAML data to JSON.
Open Feature →JSON to YAML
Convert JSON data into easy-to-read YAML.
Open Feature →Split Large CSV Files
Split a CSV into files with the specified number of rows and save them as a ZIP archive.
Open Feature →Extract text from an image
Recognize Korean or English text in a photo and save a copyable TXT file.
Open Feature →Convert Table Image to Excel
Use OCR to extract a table from an image and organize it into XLSX rows and columns.
Open Feature →Anonymize Excel Data
Replaces selected columns with asterisk masking or SHA-256 hashes.
Open Feature →