No Setup Required: You do not need to enable specific tool toggles.

Native Integration: It works automatically without requiring the "Auto-tool" toggle.

Intelligent Editing: Edit and replace text while preserving the original paragraph structure.

Global Formatting: Update fonts, headers, and styles across the entire document instantly.

Content Generation: Generate entirely new reports, insert images, or update tables based on your instructions.

Data Hygiene: Instantly clean complex datasets, standardize formats, and remove duplicates.

Deep Analysis: Calculate metrics, generate summary tables (e.g., sales totals by region), and create charts.

Mass Merging: Combine multiple CSVs or Excel sheets into one master file using complex join logic.

Template Automation: Upload a template and a dataset to generate dozens of slides instantly (e.g., one slide per product).

Mass Updates: Find and replace text, update footers, or standardize fonts across 100+ slides in seconds.

Slide Management: Merge multiple decks, reorder slides, or extract images into a folder.

Content Reconstruction: Extract text and tables from a PDF to rebuild them into an editable Word document (.docx).

Structural Control: Merge multiple PDFs, split pages into separate files, rotate pages, or reorder them.

Overlays: Apply watermarks (e.g., "CONFIDENTIAL") or stamp page numbers on existing documents.

Original File Preservation: Your original upload is never overwritten. Hatz always creates a brand-new output file for any edits made.

Link Expiration: Download links generated by Hatz typically expire after approximately 1 hour for security. If a link expires, simply ask Hatz to regenerate it.

Environment Pausing: The code execution environment may pause after a period of inactivity to save resources. It will resume automatically as soon as you continue the conversation.

Incorrect phrasing: "Now filter the data." (Hatz might look back at your original upload).

Correct phrasing: "Now filter the data in the new file you just created."

Password Protection: Hatz cannot process encrypted or password-protected files. Please upload an unlocked copy.

Scanned PDFs: If your PDF is a scanned image rather than digital text, Hatz may not be able to read or edit the content without Optical Character Recognition (OCR), which varies in accuracy.

PDF to Word Conversion: This process extracts text and tables to build a new editable document. It does not perform a pixel-perfect visual conversion. Complex layouts (like magazines or brochures with floating images) may be simplified to linear text to ensure editability.

Excel Pivot Tables: Hatz calculates data summaries (e.g., "Sales by Region") and writes the static results to cells. It does not create interactive Pivot Table objects that allow you to drag and drop fields within Excel.

Visual Fidelity: When converting files, slight shifts in margins, fonts, or image placement are normal as the system reconstructs the document.

DOCX: "Update the attached .docx: replace every instance of 'ACME Co' with 'Acme Corporation', update the address block to [New Address], make the font blue, and return the edited document."

PPTX: "Rebrand this deck: change the primary color of the headers to #0B5FFF, update the footer to 'Q1 2026', and add a title slide. Return the updated .pptx."

PDF: "Merge these two PDFs into one, rotate pages 3-5 to portrait, and return the merged PDF."

Spreadsheet to Report: "Analyze this CSV, calculate month-over-month growth, create a bar chart for the top 5 regions, and return an Excel file plus a PDF summary."

Merge & Combine: We can take multiple PDF files (or a PDF and a Word doc) and staple them together into a single document.

Split & Extract: We can slice a document apart. For example, "Extract pages 1–3 into a new file" or "Split every page into its own separate file."

Rotate & Reorder: If pages were scanned upside down or out of order, we can fix the orientation and sequence.

Watermark & Stamp: We can apply overlays on top of the existing page. This is useful for adding "DRAFT," "CONFIDENTIAL," or page numbers.

Security: We can add password protection to encrypt the file.

What it is: We can scan the entire document for specific terms and replace them.

Why it works in Word: When we replace a short word (e.g., "USA") with a long phrase (e.g., "The United States of America"), the Word document automatically pushes the rest of the text forward to make room. In a PDF, this would simply type over the existing text.

What it is: Adding or removing large blocks of text.

Why it works in Word: If you ask us to remove a paragraph, the text below it slides up to fill the empty space. If we add a new image, the text wraps around it. This ensures the document never looks "broken."

What it is: changing fonts, colors, headers, and bolding.

Why it works in Word: We can apply global style changes (e.g., "Make all headers Blue and Bold") instantly.

What it is: Extracting lists or tables.

Why it works in Word: Once converted, tables become editable grids. We can extract this data into Excel or reformat the table borders and shading.

Complex Layouts & Formatting: PDFs with heavy design elements—such as multiple columns, floating images, or background graphics—may not convert perfectly to Word. You may notice text boxes shifting, margins changing, or images moving slightly in the converted file.

Scanned Documents (Images): If your PDF is a scanned image (e.g., a photo of a document) rather than a digital text file, Hatz may not be able to "read" or edit the text without performing Optical Character Recognition (OCR). The accuracy of this depends heavily on the clarity of the scan.

Font Substitutions: PDFs often contain proprietary or custom fonts. When converting to Word or generating new PDFs, Hatz may substitute these with standard system fonts (like Arial or Times New Roman) if the original font is not available in our system.

Interactive Elements: Fillable forms, checkboxes, digital signatures, and drop-down menus are often "flattened" during conversion. They will become static images or text and will no longer be clickable or interactive.

"Round Trip" Fidelity: If you convert a PDF to Word, edit it, and convert it back to PDF, the final document may not look pixel-perfectly identical to the original. Slight variations in spacing and layout are normal.

From Excel to Deck: Upload an Excel spreadsheet (e.g., a list of 50 employees or 100 products) and a single PowerPoint template slide. Hatz can loop through your data and generate a 50-slide presentation instantly, where every slide is perfectly formatted with that specific row's data.

Dynamic Placeholders: You can set up "keys" in your slide (like {{Client_Name}} or {{Date}}). Hatz can scan the deck and programmatically replace those keys with real values across the entire presentation.

Use Cases:

Mass Find & Replace: Need to update a project code, a year (2024 $\rightarrow$ 2025), or a company name across a 100-slide deck? Hatz does it instantly, preserving the original formatting of the text.

Font & Color Standardization: If you have a messy deck where headers are a mix of Arial, Calibri, and Times New Roman, Hatz can enforce a single style rule (e.g., "Make every Title bold, size 24, and blue") across the entire file.

Footer & Note Management: You can instantly append "Confidential - Internal Use Only" to the footer of every slide or clear out all speaker notes before sharing a file externally.

Seamless Merging: You can combine multiple separate files (e.g., a "Marketing Update," a "Financial Report," and a "Strategy Deck") into a single, cohesive Master Presentation.

Smart Splitting: Conversely, you can take a massive Master Deck and ask Hatz to "Save slides 1-10 as 'Executive Summary.pptx' and slides 11-30 as 'Appendix.pptx'."

Asset Extraction: Need the original images from a presentation? Hatz can "unzip" the PowerPoint and give you a folder containing every high-resolution image used in the deck.

Update Chart Data: If you have a standard "Monthly Revenue" slide with a bar chart, you don't need to redraw it. You can provide Hatz with the new numbers for this month, and it can update the underlying data table, causing the chart to reflect the new values automatically.

Text Overflow (The "Box" Problem): Code inserts text into the box you tell it to. If you try to put a 500-word paragraph into a small text box designed for a title, the text will run off the bottom of the slide. Code does not automatically resize fonts or create new slides to handle overflow.

Complex Layout Reflow: Hatz cannot "intelligently" rearrange a slide layout based on visual balance. For example, if you swap a vertical image for a horizontal one, it might overlap with text or look stretched.

Animations & Transitions: Hatz cannot easily create or modify complex animations (e.g., "Fade in logo after 2 seconds"). These settings are stored in complex XML structures that are risky to modify via code.

SmartArt: SmartArt (hierarchy charts, cycle diagrams) are complex grouped objects. Hatz generally cannot add new nodes or bullets to a SmartArt graphic without breaking it.

File Format: These features work with modern .pptx files. Older .ppt (Binary) files from the Office 97-2003 era must be saved as .pptx before Hatz can edit them.

Intelligent De-Duplication: Instantly identify and remove duplicate rows based on specific criteria (e.g., "Remove duplicates only if the Email AND Phone Number match").

Format Standardization: Fix those annoying inconsistencies. Hatz can scan columns to ensure all phone numbers follow (555) 123-4567 format, all dates are MM/DD/YYYY, and all names are Title Cased.

Fill the Gaps: Hatz can intelligently handle missing data—filling blank cells with "N/A," "0," or even calculating the average of the column to fill the gap.

The "Super Merge": Have 3 different CSV files? Hatz can stitch them all together into one Master Workbook in the blink of an eye.

Complex Joins: Hatz can perform SQL-style joins. You can upload a "Sales" sheet and a "Customer" sheet, and Hatz will merge them into a single view based on Customer ID, even if the files are formatted differently.

Splitting & Partitioning: The reverse is also true. Upload a Master Sales Report and ask Hatz to "Create a separate Excel file for every Sales Rep," and it will generate individual files containing only that rep's data.

Pivot Tables & Aggregation: Ask Hatz to "Summarize total revenue by Region and Product Category," and it will generate a clean summary table instantly.

Complex Math: Need to apply a complex commission tier logic to 10,000 rows? Hatz can run the calculation on every row and write the result into a new column—faster and more accurately than drag-filling formulas.

Filtering & Logic: "Keep only rows where the Status is 'Active' and the Date is after Jan 1st." Hatz filters the noise so you can focus on the signal.

Visual Polish: Hatz can apply professional styling to your new spreadsheet—bolding headers, freezing the top row, adjusting column widths to fit the text, and changing font colors.

Conditional Formatting: Hatz can highlight data programmatically. "Highlight any cell in the 'Profit' column that is negative in Red, and anything over $10,000 in Green."

VBA Macros (.xlsm): Hatz generally strips out or ignores VBA Macros; it focuses on the data, not the internal code of the file.

Images & Objects: If you have floating images, charts, or embedded objects (like a PDF inside an Excel cell), these may be lost or removed during processing. Hatz reads the grid (rows/columns), not the "layer" above it.

Live Formulas vs. Values: When Hatz performs a calculation (e.g., adding Column A + Column B), it typically writes the result (e.g., "10") into the cell, not the formula (e.g., =SUM(A1, B1)). This ensures the data is correct, but it means the cell won't update dynamically if you change the inputs later.

Password Protection: Hatz cannot open or edit password-protected spreadsheets unless you remove the password first.

Pivot Table Interactivity: While Hatz can create a summary table that looks like a pivot table (calculated data), it generally does not create a native "Live Pivot Table" object that you can drag and drop fields within inside Excel. It creates the result of the pivot.