SheetFactorys is a focused AI calculation and data cleaning add-on built specifically for Google Sheets™. Engineered as a lightweight utility for operators, analysts, and traders who want practical spreadsheet automation without bloated software, complex scripting, or invasive permissions. Clean up to 50,000 cells per operation, run custom AI formulas directly inside your sheet cells (=SF), and stream live market rates (=SF_V) with automatic updates.

--------------------------------------------------
KEY CAPABILITIES
--------------------------------------------------

1. HIGH-CAPACITY DATA CLEANER (UP TO 50,000 CELLS)
Clean messy exports from CRM, ERP, Stripe, Shopify, or accounting tools (up to 10,000 cells on Pro, up to 50,000 cells on Business):
- Standardize mixed dates (such as MM/DD/YYYY, DD-MM-YYYY, and text dates) into uniform ISO formats.
- Format local and international phone numbers without breaking country codes.
- Normalize casing (Title Case, UPPERCASE, lowercase) and strip leading or trailing spaces.
- Remove non-breaking spaces (CHAR 160) and trailing minus signs from accounting reports.
- Deduplicate rows while preserving your core data structure.

2. IN-CELL CUSTOM AI FUNCTIONS (=SF)
Execute operations directly inside sheet cells without opening the sidebar:
- Type =SF("summarize category", A2:B20) to generate text analysis or categorizations.
- Type =SF_CLEAN(A2:A500, "standardize dates") for fast inline cleaning.
- Drag formulas down rows just like native spreadsheet functions.
- Works directly within supported range limits.

3. PLAIN ENGLISH FORMULA GENERATOR & ERROR FIXER
Turn plain text requests into functional spreadsheet formulas:
- Generates working formulas including nested IF, XLOOKUP, INDEX/MATCH, and ARRAYFORMULA functions.
- Diagnoses common spreadsheet errors such as #REF!, #VALUE!, #SPILL!, and #N/A.
- Provides plain-language explanations of formula logic to help you understand the solution.
- Checks formula syntax before inserting into your sheet.

4. LIVE MARKET RATES & GLOBAL CONSTANTS (=SF_V)
Stream financial rates directly into your active sheet without writing web scrapers:
- Track live spot prices for Gold, Silver, Copper, and Crude Oil.
- Real-time interbank Forex exchange rates with automatic currency pair conversion.
- Optional 7-second active cell auto-refresh for volatile market rates.
- Save workspace constants (such as standard tax rates or commission percentages) across formulas.

5. BUSINESS DASHBOARDS & FORMULA TRANSLATOR
- Build executive KPI cards and summary tables in a dedicated "SheetFactorys Dashboard" sheet.
- Translate formulas back and forth between Google Sheets™ and Microsoft Excel®.

--------------------------------------------------
DATA PRIVACY & SECURITY GUARDRAILS
--------------------------------------------------
- Strict Current-Only Scope: SheetFactorys requests access only to the active spreadsheet you explicitly open (spreadsheets.currentonly). It does not access your Google Drive™ files or external documents.
- Ephemeral In-Memory Processing: Your spreadsheet data is processed in memory during requests and is never used to train public AI models.
- Security Verification: Architecture verified under the Cloud Security Alliance (CSA) STAR Level 1 self-assessment program.
- Encrypted Transport: All communications are encrypted in transit via TLS 1.3.

--------------------------------------------------
TRANSPARENT PRICING
--------------------------------------------------
- Free Forever ($0): Includes 5 formula generations and 5 data cleanings daily (up to 500 cells per run), basic error fixing, and 1 dashboard per month. No credit card required.
- Pro ($19/mo): Unlimited formulas, up to 10,000 cells cleaning capacity per sheet, full formula error correction, and 20 dashboards per month.
- Business ($49/mo): Up to 50,000 cells cleaning capacity per operation, live market rates (=SF_V), unlimited dashboards, and global variables.

--------------------------------------------------
POPULAR SEARCH QUERIES
--------------------------------------------------
data cleaner, clean Google Sheets™, remove duplicates, standardize dates, fix #ref error, formula generator, query formula maker, live gold price in sheets, xlookup alternative.

--------------------------------------------------
TRADEMARKS & LEGAL ATTRIBUTION
--------------------------------------------------
Google Sheets™, Google Workspace™, Google Drive™, and Google Chrome™ are trademarks of Google LLC.
Microsoft Excel® is a registered trademark of Microsoft Corporation.