// CSV/Excel → JSON / SQL — ACACIA freeware. 100% en el navegador. ES/EN. Acento fucsia. const { useState, useEffect, useMemo, useRef } = React; const STRINGS = { es: { nav_more:"← Más herramientas", theme_label:"Cambiar tema", lang_label:"Idioma", eyebrow:"Herramienta gratis", h1:"CSV / Excel a ", h1b:"JSON y SQL", hero_p:"Pega tus datos o sube un CSV y conviértelos a JSON o a sentencias SQL (INSERT) al instante.", privacy_chip:"La conversión ocurre en tu navegador. Nada se sube.", input:"Entrada (CSV / pegar de Excel)", output:"Resultado", upload:"Subir CSV", delim:"Separador", d_auto:"Detectar", d_comma:"Coma (,)", d_semi:"Punto y coma (;)", d_tab:"Tabulador", d_pipe:"Barra (|)", header:"Primera fila = encabezados", infer:"Inferir números/booleanos", format:"Formato", f_json:"JSON", f_jsonl:"JSON por línea", f_sql:"SQL (INSERT)", table:"Nombre de tabla", placeholder:"nombre,correo,edad\\nAna,ana@mail.com,30\\nLuis,luis@mail.com,25", copy:"Copiar", download:"Descargar", copied:"¡Copiado!", rows:"{n} filas", empty:"Pega o sube datos para ver el resultado.", cta_h3:"¿Necesitas mover o integrar datos de tu negocio?", cta_p:"En ACACIA conectamos hojas, sistemas y bases de datos para PyMEs. Hablemos.", cta_btn:"Hablar con ACACIA", faq_title:"Preguntas frecuentes", faq:[["¿Cómo convierto CSV a JSON?","Pega el CSV o súbelo, marca si la primera fila son encabezados y elige JSON. Obtienes un arreglo de objetos."],["¿También genera SQL?","Sí, elige el formato SQL e indica el nombre de la tabla para obtener sentencias INSERT."],["¿Mis datos se suben?","No. Todo ocurre en tu navegador; los datos nunca salen de tu dispositivo."]], foot_free:"© 2026 ACACIA · Herramienta gratis", foot_tools:"Herramientas", foot_privacy:"Privacidad", foot_contact:"Contacto", foot_crafted:"hecho con", foot_by:"por", }, en: { nav_more:"← More tools", theme_label:"Toggle theme", lang_label:"Language", eyebrow:"Free tool", h1:"CSV / Excel to ", h1b:"JSON & SQL", hero_p:"Paste your data or upload a CSV and convert it to JSON or SQL (INSERT) statements instantly.", privacy_chip:"Conversion happens in your browser. Nothing is uploaded.", input:"Input (CSV / paste from Excel)", output:"Result", upload:"Upload CSV", delim:"Delimiter", d_auto:"Detect", d_comma:"Comma (,)", d_semi:"Semicolon (;)", d_tab:"Tab", d_pipe:"Pipe (|)", header:"First row = headers", infer:"Infer numbers/booleans", format:"Format", f_json:"JSON", f_jsonl:"JSON per line", f_sql:"SQL (INSERT)", table:"Table name", placeholder:"name,email,age\\nAna,ana@mail.com,30\\nLuis,luis@mail.com,25", copy:"Copy", download:"Download", copied:"Copied!", rows:"{n} rows", empty:"Paste or upload data to see the result.", cta_h3:"Need to move or integrate your business data?", cta_p:"At ACACIA we connect spreadsheets, systems and databases for SMBs. Let's talk.", cta_btn:"Talk to ACACIA", faq_title:"FAQ", faq:[["How do I convert CSV to JSON?","Paste or upload the CSV, mark whether the first row are headers and pick JSON. You get an array of objects."],["Does it generate SQL too?","Yes, pick the SQL format and set the table name to get INSERT statements."],["Is my data uploaded?","No. Everything happens in your browser; data never leaves your device."]], foot_free:"© 2026 ACACIA · Free tool", foot_tools:"Tools", foot_privacy:"Privacy", foot_contact:"Contact", foot_crafted:"crafted with", foot_by:"by", }, }; function makeT(lang){return (k,v)=>{let s=(STRINGS[lang]&&STRINGS[lang][k])!=null?STRINGS[lang][k]:(STRINGS.es[k]!=null?STRINGS.es[k]:k);if(v&&typeof s==="string")for(var x in v)s=s.split("{"+x+"}").join(v[x]);return s;};} const LangContext=React.createContext("es"); function detectLang(){try{var s=localStorage.getItem("acacia-lang");if(s==="es"||s==="en")return s;}catch(e){}return (navigator.language||"es").toLowerCase().indexOf("en")===0?"en":"es";} function triggerDownload(text,filename,mime){var blob=new Blob([text],{type:mime||"text/plain"});var url=URL.createObjectURL(blob);var a=document.createElement("a");a.href=url;a.download=filename;document.body.appendChild(a);a.click();a.remove();setTimeout(()=>URL.revokeObjectURL(url),1500);} function parseCSV(text, delim){ const rows=[]; let row=[], field="", i=0, inQ=false; while(ibestN){bestN=counts[k];best=k;} } return best; } function coerce(v, infer){ if(!infer) return v; const s=v.trim(); if(s==="") return null; if(/^-?\d+$/.test(s)) return parseInt(s,10); if(/^-?\d*\.\d+$/.test(s)) return parseFloat(s); if(/^(true|false)$/i.test(s)) return s.toLowerCase()==="true"; return v; } function toObjects(rows, hasHeader, infer){ if(!rows.length) return {headers:[],data:[]}; let headers, body; if(hasHeader){ headers=rows[0].map((h,i)=>h.trim()||("col"+(i+1))); body=rows.slice(1); } else { const n=Math.max(...rows.map(r=>r.length)); headers=Array.from({length:n},(_,i)=>"col"+(i+1)); body=rows; } const data=body.map(r=>{ const o={}; headers.forEach((h,i)=>{ o[h]=coerce(r[i]!=null?r[i]:"", infer); }); return o; }); return {headers,data}; } function toJSON(rows,hasHeader,infer,perLine){ const {data}=toObjects(rows,hasHeader,infer); if(perLine) return data.map(o=>JSON.stringify(o)).join("\n"); return JSON.stringify(data,null,2); } function sqlVal(v){ if(v===null||v===undefined||v==="") return "NULL"; if(typeof v==="number") return String(v); if(typeof v==="boolean") return v?"TRUE":"FALSE"; return "'"+String(v).replace(/'/g,"''")+"'"; } function toSQL(rows,hasHeader,infer,table){ const {headers,data}=toObjects(rows,hasHeader,infer); if(!data.length) return ""; const t=(table||"tabla").trim().replace(/[^A-Za-z0-9_]/g,"_")||"tabla"; const cols=headers.map(h=>"`"+h.replace(/`/g,"")+"`").join(", "); return data.map(o=>"INSERT INTO `"+t+"` ("+cols+") VALUES ("+headers.map(h=>sqlVal(o[h])).join(", ")+");").join("\n"); } function App(){ const [lang,setLang]=useState(detectLang); const [theme,setTheme]=useState(()=>{try{return localStorage.getItem("acacia-theme")||"light";}catch(e){return "light";}}); const t=makeT(lang); const [input,setInput]=useState(""); const [delim,setDelim]=useState("auto"); const [hasHeader,setHasHeader]=useState(true); const [infer,setInfer]=useState(true); const [format,setFormat]=useState("json"); const [table,setTable]=useState("mi_tabla"); const [copied,setCopied]=useState(false); const fileRef=useRef(null); useEffect(()=>{document.documentElement.setAttribute("data-theme",theme);try{localStorage.setItem("acacia-theme",theme);}catch(e){}},[theme]); useEffect(()=>{document.documentElement.setAttribute("lang",lang);try{localStorage.setItem("acacia-lang",lang);}catch(e){}},[lang]); const result=useMemo(()=>{ if(!input.trim()) return {out:"",n:0,err:""}; try{ const d=delim==="auto"?detectDelim(input):(delim==="tab"?"\t":delim); const rows=parseCSV(input,d); const n=Math.max(0,rows.length-(hasHeader?1:0)); let out=""; if(format==="json") out=toJSON(rows,hasHeader,infer,false); else if(format==="jsonl") out=toJSON(rows,hasHeader,infer,true); else out=toSQL(rows,hasHeader,infer,table); return {out,n,err:""}; }catch(e){ return {out:"",n:0,err:String(e.message||e)}; } },[input,delim,hasHeader,infer,format,table]); const onFile=(e)=>{const f=e.target.files&&e.target.files[0];if(!f)return;const r=new FileReader();r.onload=()=>setInput(String(r.result||""));r.readAsText(f);}; const copy=async()=>{try{await navigator.clipboard.writeText(result.out);setCopied(true);setTimeout(()=>setCopied(false),1600);if(window.acaciaTrack)window.acaciaTrack("csv_convert",{format});}catch(e){}}; const dl=()=>{const ext=format==="sql"?"sql":(format==="jsonl"?"jsonl":"json");triggerDownload(result.out,"datos."+ext,format==="sql"?"text/sql":"application/json");if(window.acaciaTrack)window.acaciaTrack("csv_convert",{format});}; return (
ACACIA ACACIA
{t("nav_more")}
{t("eyebrow")}

{t("h1")}{t("h1b")}

{t("hero_p")}

{t("privacy_chip")}
{format==="sql" &&
setTable(e.target.value)} />
}