Does it remove the [1] citation markers from table cells?
Yes. A marker like [3] or [1][2] after a figure is stripped from the cell during parsing, and the figure that remains is read as a number where it is unambiguous.
Paste a Perplexity table and copy it into Excel as real cells, or download a typed .xlsx. The [3]-style citation markers are stripped from the cells, figures with currency, thousands separators and percentages are typed as numbers, and each table in a research answer becomes its own sheet.
Select the table in Perplexity, copy, and paste it into the box above. Citation markers like [3] are removed from the cells as it is parsed, the figures are read as numbers, and the grid is shown in a preview. Click Copy for Sheets / Excel and paste into Excel for separate columns, or Download .xlsx for a typed workbook with a bold frozen header. 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 Excel, or Download .xlsx for a typed file.
Perplexity's tables are good tables — it builds them from several sources and says which — but the citing happens inside the cells. A revenue column reads $4.2bn [1], $3.9bn [2], $4.1bn [1][3]. Paste that into Excel and every cell is text: the marker is not a number, so the number next to it is not a number either, and the column sums to nothing. The usual fix is Find and Replace on the brackets, then Text to Columns to split the pipes, then converting the text to numbers, then fixing the header.
This page treats a [3] after a figure as what it is — a citation, never data — and strips it from the cell during parsing. What is left is read by the number detection: thousands separators, a leading $, € or £, a trailing %, negatives in parentheses or with a minus. Those cells become numeric in the .xlsx and right-aligned in the preview. The hidden characters that come with text quoted from web pages, including non-breaking spaces glued to numbers, are removed first.
Because Perplexity quotes each source in that source's own style, one column can hold $4.2bn, 4,200 million and 4.2B for the same quantity. The tool reads what is unambiguous — 4,200 is a number, $4.2 is a number — and keeps anything with a unit or a suffix (bn, million, B) as text rather than guessing a multiplier. That is deliberate: silently turning 4.2B into 4,200,000,000 would be right most of the time and catastrophic the rest. Normalise the column in the preview or in Excel, or ask Perplexity for "all figures in millions of dollars, numbers only" and the column arrives typed.
Percentages and dates are simpler. 12% is stored as 0.12 and formatted as a percentage; ISO dates are kept as text in the .xlsx and recognised by Excel on paste. Year columns are numbers, which is what you want for sorting.
A Perplexity comparison or a Deep Research report often holds a summary table, a per-company table and a timeline. Paste the whole answer. Each table is detected and listed in the tabs above the preview; the prose, the inline citations in the prose and the Sources list are ignored. Copy for Sheets / Excel and the CSV download act on the selected table; Download .xlsx writes every table as its own sheet, in order, headers bold and frozen. The workbook is built in your browser.
Stripping the markers from the cells does not have to mean losing the sources. The Sources list at the end of the answer is a numbered list of URLs; paste it into a Notes sheet, or into a column of its own, so the workbook still records where each figure came from. If one column's provenance matters cell by cell, ask Perplexity to add a Source column to the table — the URL in its own cell survives as text, which is exactly right.
Yes. A marker like [3] or [1][2] after a figure is stripped from the cell during parsing, and the figure that remains is read as a number where it is unambiguous.
Because bn is a multiplier the tool will not guess. $4.2 would be typed; $4.2bn is kept as text so nothing is silently scaled. Normalise the column or ask Perplexity for numbers in a single unit.
Paste the Sources list from the end of the answer into a Notes sheet or a column, or ask Perplexity to add a Source column to the table; URLs in their own cells are kept as text.
Yes. Paste the whole report; every table is detected, the tabs switch between them, and Download .xlsx writes one sheet per table.
No. The conversion runs in your browser with client-side JavaScript. The Perplexity answer is never sent to a server, stored or logged.