Before you start

Upload your file and pick a tool. Your files never leave your device: everything runs inside your browser.

• The tables bar (top of the page): every file you upload, and every tool result, becomes a table there. Use "⋯" to download it, delete it, or change its header row.
• "Send to →": moves a result to another tool without downloading and uploading. The original file never changes.
• Matching is exact: the whole value, ignoring cosmetic differences (Arabic digits, spaces, date format).
• Tables are lost when you close the page. Download your work first; "⬇️ Download all" saves them all in one file.

🔍 Data Filter

You have a list of numbers (IDs, employee numbers, passports) and want their rows from a big sheet, or want to remove them from it.

1. Upload the file and pick the column to search in (like "ID number").
2. Paste the values: one value per line.
3. Choose "Keep matches" or "Exclude matches", then press the button.
4. Download the result, along with the list of values that were not found.

If a "not found" value is in another column, it tells you where it found it.

✏️ Bulk Edit by List

Edits a column in the rows of a list of keys at once, like changing the project of 200 employees by their ID numbers.

1. Choose the table, the shared column (like the ID number), and the column to edit.
2. Paste the keys with one value for all, or two columns from Excel: the key, then its value.
3. Press "Show the changes before applying" and review them.
4. Press "Apply the change", then download the result.

The download has a log of every change, and the values that were not found.

🧹 Smart Cleaner

Checks the list and cleans it in one click: Arabic digits, extra spaces, hidden characters, merged cells, empty rows, and mobiles in different formats.

1. Choose the table, and the structure and column problems show up by themselves.
2. Review the suggestion, and change the rules or any column's type under "Customise" if you like.
3. Press "Apply the suggestion" and see before and after in the preview.
4. Download the result: it includes "Change log" and "Needs review".

Save your settings as a "recipe" and apply it to next month's list in one click.

🎨 Conditional Coloring

Colors the cells or rows that meet your conditions (like expired iqamas), and downloads the file with its colors.

1. Choose the table.
2. Add a rule: the column, the condition, the value, its color, and whether the cell or the whole row is colored.
3. Press "Color and show the preview".
4. Download the file with colors, along with a "Color key" sheet.

The first rule that matches a cell wins. Colored downloads are limited to 100,000 rows.

✂️ Columns & Text

Split a column (like a four-part name into four columns), merge columns, replace values with a table, extract digits and letters, or trim spaces.

1. Choose the table, and choose what you want to do.
2. Choose the column and the settings, and where the result goes.
3. Press "Show the preview" and review the counts and rows.
4. Press "✅ Apply", and download the result or continue on it with another operation.

The new columns are text, so leading zeros in IDs and mobiles are kept, and the original file never changes.

⚖️ Compare Two Files or Lists

Compares an old sheet with a new one: what was added, what was removed, and what changed in each row.

1. Choose the old file, then the new one (or paste two lists in the "Two lists" tab).
2. Choose the shared column (like the ID number) if it was not picked for you.
3. Press "Compare the files" and move between the categories: only in old, only in new, common, changed.
4. Download the result: each category in its own sheet.

"📄 Open as a table" turns any category into a table you can send to another tool.

🔄 Format Converter

Convert the file to xlsx or CSV with proper Arabic, gather sheets of several files into one file, and repair garbled Arabic in CSV.

1. Choose the tab: Convert format, Gather sheets, or Repair garbled Arabic.
2. Choose the table (or tables, or upload the garbled file) and the sheets you want.
3. Choose the format and the output file name.
4. Press the download button.

For values Excel changes in CSV (like leading zeros in IDs), tick "Protect them" so they stay as they are.

📅 Dates

Works out age, length of service and days remaining, and converts between Hijri and Gregorian, for a whole column at once.

1. Choose the table and the date column, and answer the day/month order question if it appears.
2. Choose the operation: Hijri ⇄ Gregorian, change the format, difference, add a period, or working days.
3. Press "✅ Apply", and a new column with the result is added.
4. Download the result. Values that were not understood are in the "Needs review" sheet.

The ready-made buttons (Age, Length of service, Days remaining) fill in the settings for you.

👥 Duplicates

Finds the duplicate rows and shows them as groups before anything is deleted, then you choose what stays.

1. Choose the table.
2. Choose "All columns" or a shared column (like the ID number).
3. Press "Show duplicates" and review the groups.
4. Pick the action (keep first, last, most complete…) and press "Run".

The original file does not change; the result is a new table.

🔗 Lookup, Merge & Split

Four tabs, each doing a job you used to do with formulas or copy and paste:

1. Lookup: choose your file, the data file and the shared column (like the ID number), and the columns to bring.
2. Stack: select the tables you want in one table, and link the columns whose names differ.
3. Split: split the table by a column's value (like the project), every set number of rows, or equal parts among employees.
4. Random sample: draw a number or a percentage of the rows, from each group if you like.

The original file never changes; each result becomes a new table. Repeated and missing keys get their own sheets in the download.

🧮 Column by Conditions

Adds a new column whose value follows conditions you write (if the salary is over 5000, the grade is "A"), or a calculation between two columns.

1. Choose the table.
2. In "By conditions" write the rules and each one's result, or choose "Calculated column", the operation and the two columns.
3. Type the new column name and press "Add the column".
4. Review the rows per rule, then download the result.

The first rule that matches a row sets its value, so order the rules from narrowest to widest.

📤 Prepare a File to Send

Choose the columns to send, order and rename them, and mask IDs and mobiles with stars like ******5678.

1. Choose the table and the columns to send, and order them by dragging or with the arrows.
2. Choose the masking for each column: show the last or first characters, stars instead of the value, or delete it.
3. Type the file name, and press "Prepare and show the file".
4. Download the file, and save the settings as a template if you send the same list every time.

A column hidden in Excel is not selected by default and carries a "Hidden in Excel" badge; the original list never changes.

📋 Text to Table

Turns lines copied from a system or an email, a numbered list, or WhatsApp messages into a tidy table with columns.

1. Paste the text, upload a text file (.txt), or take it from an open table.
2. The tool detects the column separator and WhatsApp messages by itself; change them if you like.
3. Check the preview, and press "Add to the open tables".
4. Download the table or send it to another tool.

Every value stays exactly as written; leading zeros in numbers and mobiles are kept.