Are the [1] markers removed from the cells?
Yes. A bracketed number after a figure inside a cell is treated as a citation and stripped during parsing, so the figure can be read as a number.
Paste a Perplexity table and copy it into Google Sheets as real cells — citation markers stripped from the cells, figures with currency, separators and percentages typed as numbers — or download a .xlsx and import each table from a research answer as its own tab.
Copy the table in Perplexity, paste it into the box above, click Copy for Sheets / Excel, then click a cell in Google Sheets and paste. The grid lands with the header on that row, the [3] citation markers already stripped from the cells and the numbers recognised. For an answer with several tables, click Download .xlsx and use File → Import in Sheets to add each as a tab. Nothing is uploaded.
Use the copy button under the answer or select the text. Perplexity's copy gives markdown text with citation markers; either form is read correctly here.
The table is detected as you paste and shown as a grid. Switch tables with the tabs if the answer had more than one.
Click Copy for Sheets / Excel and paste into Google Sheets, or Download .xlsx for a typed file.
Copy a Perplexity table and paste it into Sheets and two things happen at once. The markdown pipes mean each row lands in a single cell, and even after Data → Split text to columns, the citation markers inside the cells — $4.2bn [1], 12% [2][3] — keep every figure as text. Sheets cannot sum a column whose cells end in brackets, and the SPLIT formula does not know a citation from a value. The usual repair is a SUBSTITUTE chain or a regular-expression replace on the brackets before anything adds up.
This page treats a bracketed number after a figure as a citation and strips it during parsing, before the number detection runs. Thousands separators, a leading currency symbol, a trailing % and negatives in parentheses are read as numbers; anything with a unit or a multiplier suffix (bn, million) is kept as text rather than guessed. Copy for Sheets / Excel then hands Sheets an HTML grid that pastes at the cell you click, with the header on that row and the typed figures ready to sum.
Perplexity quotes each source in the source's own format, so a single column can mix 4,200, 4.200 and 4 200. Sheets reads pasted numbers by the spreadsheet's locale (File → Settings), which makes a plain paste of mixed formats unpredictable. The .xlsx route avoids the guesswork: the tool types the figures it can read unambiguously, writes them as numeric cells, and Sheets imports them as typed. Figures it cannot read unambiguously stay text, visibly, in the preview — which is the moment to normalise them or to ask Perplexity for "all figures in one unit, numbers only".
Percentages are stored as fractions and formatted as percentages, so 12% arrives as 0.12 shown as 12%. ISO dates are recognised in any locale; ambiguous ones stay text until you set the format.
A Perplexity comparison or Deep Research report holds several tables with cited prose between them. Paste the whole answer: every table is detected and listed in the tabs above the preview, and the prose, inline citations and Sources list are ignored. Download .xlsx writes one sheet per table, headers bold and frozen, numbers typed. In Google Sheets, File → Import → Upload, choose the file, pick Insert new sheet(s), and each table becomes a tab in the spreadsheet you already have. The workbook is built in your browser; the import is the only upload, and you make it.
Stripping the markers is not the same as discarding the provenance. Paste the Sources list from the end of the answer into a Notes tab, or ask Perplexity to add a Source column to the table — a URL in its own cell is kept as text and is clickable in Sheets. For a sheet that will be shared or audited, a Source column per row is the honest layout, and Perplexity produces it reliably when asked.
Yes. A bracketed number after a figure inside a cell is treated as a citation and stripped during parsing, so the figure can be read as a number.
They can on a plain paste. Use Download .xlsx and File → Import: the numbers are typed by the tool from the formats it can read unambiguously, so Sheets does not have to interpret text.
Paste the Sources list into a Notes tab, or ask Perplexity for a Source column in the table. URLs in their own cells stay as clickable text.
Yes. Paste the whole report, Download .xlsx, then File → Import → Upload in Sheets with Insert new sheet(s). Each table becomes its own tab.
No. The conversion runs in your browser with client-side JavaScript. The Perplexity answer is never sent to a server, stored or logged.