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

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

Intelligent Text Editing: Replace or insert text content while preserving paragraph structure and formatting.

Review Comments: Add review comments to specific sections of the document.

Advanced Edits: Apply advanced edits using OOXML for tracked changes or redlining when needed.

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: 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 join logic.

Formula Recalculation: Recalculate formulas using a backed calculation engine.

Error Detection: Identify formula errors like #REF! or #DIV/0!.

Text Replacement: Replace text across multiple slides instantly.

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

Slide Management: Reorder slides, duplicate slides, or merge multiple decks.

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

Asset Extraction: Extract images into a folder or generate slide thumbnails (previews).

Structured Inventory: Get detailed text position inventories for advanced replacement workflows.

Text Extraction: Extract text content from PDFs for analysis or conversion.

Fillable Forms: Fill fillable PDF forms (AcroForm fields) programmatically.

Non-Fillable Forms: Fill non-fillable PDFs by placing text overlays (annotations) at specific coordinates.

OCR Support: Use OCR for scanned PDFs (best-effort extraction; accuracy depends on scan quality).

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

Macro-Enabled Files: .xlsm files (macro-enabled Excel) are not supported. Macros will not execute.

"Replace all instances of 'Acme Corp' with 'Hatz AI'. Keep all headings and table formatting unchanged."

"Add 5 review comments to the paragraphs that mention pricing. Keep comments short and specific."

"Shorten all slide titles to under 7 words and update the bullet points on slide 3 to match the attached notes."

"Move slide 5 to the beginning and duplicate slide 2 at the end."

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

"Fill this form with the following values: Name = John Smith, Email = [email protected], Checkbox 'I Agree' = Yes, Plan = Pro."

"Place these values into the form boxes on page 2. Match the existing font size: Field 1 = 12345, Field 2 = Sample Company, Field 3 = January 2026."

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

"Create a new column called 'Total' that multiplies quantity by unit_price. Filter to rows where Total > 100. Export as XLSX."

"Recalculate all formulas and tell me if there are any #REF! or #DIV/0! errors."

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

Fill Fillable Forms: We can programmatically fill AcroForm fields in fillable PDFs.

Fill Non-Fillable Forms: We can place text overlays (annotations) at specific coordinates to "fill" non-fillable PDF forms.

Extract Text: We can extract text content from PDFs for analysis or conversion to other formats.

OCR for Scanned PDFs: We can perform Optical Character Recognition on scanned documents (best-effort; accuracy depends on scan quality).

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.

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

PDF Form Rendering: Some PDF viewers don't render filled form values correctly without appearance regeneration. Adobe Acrobat Reader is the most reliable viewer for validating filled forms.

Non-Fillable Form Accuracy: Text overlays on non-fillable PDFs are coordinate-based and may not align perfectly with existing form lines.

From Excel to Deck: Upload an Excel spreadsheet (e.g., a list of employees or products) and a single PowerPoint template slide. Hatz can loop through your data and generate a slide presentation, 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 → 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'."

Slide Reordering & Duplication: Reorder slides or duplicate specific slides programmatically.

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.

Slide Thumbnails: Generate preview thumbnails for individual slides.

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 Position Inventory: Get detailed inventories of text positions across slides for advanced, structured replacement workflows.

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 or be cut off. 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. While animations and transitions are preserved during editing, complex animations may not behave identically after content changes.

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

Formula Recalculation: Explicitly request formula recalculation using Hatz's backed calculation engine.

Error Detection: Identify and report formula errors like #REF! or #DIV/0!.

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. Macro-enabled files (.xlsm) are not supported. Macros will not execute.

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.

Formula Recalculation is Opt-In: Formula recalculation must be requested explicitly. Formulas are not automatically recalculated.

Calculation Engine: Formula behavior may differ slightly from Excel in edge cases, as recalculation is performed using a LibreOffice-backed engine.

Provide exact references: Specify which sections, slides, sheets, or pages to modify (e.g., "slide 3," "column A," "paragraphs about pricing").

Clarify what to preserve: Tell Hatz what formatting or structure must remain unchanged (e.g., "keep formatting," "don't change layout," "maintain column order").

Set output expectations: Specify file names, formats, and any summaries you want (e.g., "export as XLSX," "name the file Report_Final.docx").

Use clear field mappings: "Field Name = Value"

Provide values in a list or simple table format

Specify which checkboxes should be checked

Hatz creates new files; it does not edit in place.

Original files remain unchanged.

Each request generates a fresh output file.

Open the PDF in Adobe Acrobat Reader (most reliable).

Try a different PDF viewer.

The system attempts appearance regeneration automatically, but viewer behavior varies.

Request shorter copy.

Ask for layout adjustments ("expand the text box on slide 2").

Specify character or word limits in your request.

Explicitly request "recalculate all formulas" in your prompt.

Confirm which formulas should be updated if only certain sheets need recalculation.

Use a higher-quality scan if possible.

Understand that OCR is best-effort and may not be 100% accurate.

Manually review extracted text for critical content.