Exportar las reseñas de Google Maps a Excel (CSV)

// Responsive Muse · Google Maps Reviews Exporter · v1.0 · 2026-10-22
// Saves the reviews of any place on Google Maps (your business, a competitor, a hotel you're
// comparing) to CSV or Markdown: author, stars, date, text, the owner's reply and photos count.
// Open the place, click its Reviews tab (sort them first if you like) and run the script.
// It scrolls the list and expands long reviews. It makes no network requests of its own and
// never reads cookies, passwords or tokens.
(async () => {
  const TOOL = 'Exportar reseñas de Google Maps';
  const FORMAT = 'csv';        // 'csv' (Excel, Sheets) or 'md' (readable document)
  const LIMIT = 500;           // stop after this many reviews (0 = all; big places have thousands)

  if (!/^(www\.)?google\.[a-z.]+$/.test(location.hostname) || !location.pathname.startsWith('/maps')) {
    alert('Abre primero un sitio en Google Maps y pulsa su pestaña Reseñas:\nhttps://www.google.com/maps');
    return;
  }
  const reviewsOnPage = () => [...document.querySelectorAll('div[data-review-id][aria-label]')];
  if (!reviewsOnPage().length) {
    alert('Pulsa primero la pestaña Reseñas del sitio y vuelve a ejecutar el script.');
    return;
  }
  // A small box on the page shows progress and asks before changing anything,
  // so you never need to read or edit the console.
  const many = (n, word) => `${n} ${n === 1 ? word : ({ canal: 'canales', 'canción': 'canciones', 'publicación': 'publicaciones', 'elemento guardado': 'elementos guardados' })[word] || word + 's'}`;   // 1 vídeo, 2 vídeos
  const panel = (() => {
    const box = document.createElement('div');
    box.style.cssText = 'position:fixed;right:16px;bottom:16px;z-index:2147483647;width:340px;max-width:calc(100vw - 32px);' +
      'background:#111318;color:#e6e8ee;font:14px/1.5 system-ui,sans-serif;border-radius:12px;padding:16px;' +
      'box-shadow:0 8px 30px rgba(0,0,0,.4);text-align:left';
    const head = document.createElement('strong');
    head.textContent = TOOL;
    const msg = document.createElement('p');
    msg.style.cssText = 'margin:8px 0 12px;white-space:pre-line';
    const row = document.createElement('div');
    row.style.cssText = 'display:flex;flex-wrap:wrap;gap:8px;justify-content:flex-end';
    box.append(head, msg, row);
    document.body.append(box);
    const button = (label, primary, onClick) => {
      const b = document.createElement('button');
      b.textContent = label;
      b.style.cssText = 'font:600 14px system-ui,sans-serif;padding:8px 14px;border-radius:8px;cursor:pointer;' +
        (primary ? 'background:#0f766e;color:#fff;border:1px solid #0f766e' : 'background:none;color:#e6e8ee;border:1px solid #3a3f4b');
      b.onclick = onClick;
      row.append(b);
    };
    return {
      text(t) { msg.textContent = t; },
      ask(t, yes) {
        msg.textContent = t;
        row.replaceChildren();
        return new Promise(r => {
          button('Cancelar', false, () => { row.replaceChildren(); r(false); });
          button(yes, true, () => { row.replaceChildren(); r(true); });
        });
      },
      stoppable(onStop) { row.replaceChildren(); button('Parar', false, onStop); },
      actions(t, list) {
        msg.textContent = t;
        row.replaceChildren();
        list.forEach(([label, primary, run]) => button(label, primary, run));
      },
      finish(t) { this.actions(t, [['Cerrar', true, () => box.remove()]]); },
      close() { box.remove(); },
    };
  })();
  // Offer the result as a downloaded file or as clipboard text (a real click, so it always works)
  const deliver = (summary, body, file) => {
    const save = () => {
      const a = document.createElement('a');
      a.href = URL.createObjectURL(new Blob([/\.csv$/.test(file) ? '\ufeff' + body : body], { type: 'text/plain;charset=utf-8' }));
      a.download = file;
      a.click();
      setTimeout(() => URL.revokeObjectURL(a.href), 5000);
      panel.text(`${summary}\nGuardado como ${file} (mira tu carpeta de Descargas).`);
    };
    const copy = () => navigator.clipboard.writeText(body)
      .then(() => panel.text(`${summary}\nCopiado. Pégalo en una hoja de cálculo o en una nota.`))
      .catch(() => panel.text(`${summary}\nEl navegador ha bloqueado el portapapeles: usa Descargar.`));
    panel.actions(summary, [['Cerrar', false, () => panel.close()], ['Copiar', false, copy], ['Descargar', true, save]]);
  };
  const sleep = ms => new Promise(r => setTimeout(r, ms));
  const reviews = new Map();
  // The reviews live in a scrolling side panel: find it from the first review
  let scroller = reviewsOnPage()[0];
  while (scroller && !(scroller.scrollHeight > scroller.clientHeight + 50 && /auto|scroll/.test(getComputedStyle(scroller).overflowY))) {
    scroller = scroller.parentElement;
  }
  scroller = scroller || document.scrollingElement;

  // Read the reviews currently loaded (long ones are expanded first)
  const MORE = 'button[jsaction*="review.expandReview"][aria-expanded="false"], ' +
    'button[jsaction*="review.expandOwnerResponse"][aria-expanded="false"]';
  const waited = new Set();
  const collect = async () => {
    const more = [...document.querySelectorAll(MORE)];
    more.forEach(b => b.click());
    if (more.length) await sleep(300);
    for (const el of reviewsOnPage()) {
      const id = el.dataset.reviewId;
      if (reviews.has(id)) continue;
      // Loaded after the clicks above: read it on the next pass, once expanded
      if (el.querySelector(MORE) && !waited.has(id)) { waited.add(id); continue; }
      // Review text and the owner's reply (inside .CDe7pd) use the same text class
      const text = [...el.querySelectorAll('.wiI7pd')].filter(t => !t.closest('.CDe7pd'))
        .map(t => t.innerText.trim()).filter(Boolean).join('\n');
      const reply = (el.querySelector('.CDe7pd .wiI7pd')?.innerText || '').trim();
      // Stars: an image labelled "5 stars"; hotels also show scores from other sites ("10/10")
      const label = el.querySelector('[role="img"][aria-label]')?.getAttribute('aria-label');
      const stars = label ? (label.match(/\d+([.,]\d+)?/) || [''])[0] : (el.querySelector('.fzvQIb')?.textContent || '').trim();
      reviews.set(id, {
        author: el.getAttribute('aria-label') || '',
        stars,
        date: (el.querySelector('.rsqaWe, .xRkPPb')?.textContent || '').trim(),
        text,
        reply,
        photos: el.querySelectorAll('button[jsaction*="openPhoto"], button.Tya61d').length,
      });
      if (LIMIT && reviews.size >= LIMIT) return;
    }
  };

  // 1. Scroll the panel, collecting as we go, until nothing new appears five times in a row
  let stop = false;
  panel.stoppable(() => { stop = true; });
  let idle = 0;
  while (idle < 5 && !stop && !(LIMIT && reviews.size >= LIMIT)) {
    const before = reviews.size;
    await collect();
    scroller.scrollTo(0, scroller.scrollHeight);
    await sleep(1500);
    idle = reviews.size === before ? idle + 1 : 0;
    panel.text(`Recogiendo reseñas… ${reviews.size}${LIMIT ? ' de un máximo de ' + LIMIT : ''}`);
  }
  const list = [...reviews.values()];
  if (!list.length) {
    panel.finish('No se han encontrado reseñas. Puede que Google Maps haya cambiado su diseño: avísanos en responsive-muse.com.');
    return 0;
  }

  // 2. Build the file and offer it
  const place = document.title.replace(/ [-–] Google Maps$/, '').trim() || 'place';
  const cell = v => '"' + String(v).replace(/"/g, '""') + '"';
  const body = FORMAT === 'md'
    ? `# Reseñas de ${place}\n\n` + list.map(r => `**${r.author}** · ${r.stars}★ · ${r.date}\n\n${r.text}` +
        (r.reply ? `\n\n> Propietario: ${r.reply.replace(/\n/g, '\n> ')}` : '')).join('\n\n---\n\n')
    : ['Autor,Estrellas,Fecha,Reseña,Respuesta del propietario,Fotos', ...list.map(r =>
        [r.author, r.stars, r.date, r.text, r.reply, r.photos].map(cell).join(','))].join('\n');
  const name = ('resenas-' + place).replace(/[\\/:*?"<>|]+/g, '_');
  deliver(`${stop ? 'Parado antes de terminar. ' : ''}Listo: ${many(list.length, 'reseña')}.`, body, `${name}.${FORMAT}`);
  return list.length;
})();