Extract Charts From PowerPoint
Get the numbers behind every chart in a deck as Excel or CSV
Drop a PowerPoint fileTap to choose a PowerPoint file
or click to browseor tap to choose
Get the numbers behind the charts, in your browser
Large files (over 50 MB) may take longer or run out of browser memory
About Extract Charts From PowerPoint
Pulls the numbers out of the charts in a PowerPoint presentation (.pptx) and gives them back as tables you can use: one Excel workbook with a sheet per chart, a CSV file per chart in a ZIP, or the Excel workbook PowerPoint keeps inside each chart. For each chart you see the slide it is on, the type, and the data table.
The numbers come from the copy PowerPoint stores inside each chart: they are the values as they were last saved, without formulas. When a chart has its own embedded workbook, choose "Original workbooks" to get it as it is, with formulas and any extra sheets. A chart that was pasted as a picture has no data to read, and a chart linked to an outside workbook may have no stored numbers; both are listed in the notes. Old .ppt files: open them in PowerPoint and save as .pptx first.
- Where do the numbers come from?
- From the copy PowerPoint stores inside each chart, which holds the values as they were last saved. They are numbers, not formulas.
- What is Original workbooks?
- Many charts also contain a whole Excel workbook that opens when you choose Edit Data. This option gives you that workbook as it is, with its formulas and any other sheets.
- Why is a chart missing?
- A chart pasted as a picture has no data. A chart linked to an outside workbook may have no stored numbers. Both are listed in the notes.
- Is anything uploaded?
- No. The deck is read in your browser.
How to use Extract Charts From PowerPoint
Drop your .pptx. Each chart is listed with a picture of its slide, its type and the table of numbers. Choose one Excel workbook with a sheet per chart, CSV files, or the original workbooks, then download. A preview of the table sits next to every chart.
When to use it
Useful when you have only the slides and need the numbers, when a chart has to be redrawn in another tool, or when you want to check the figures behind a chart.
When not to use it
If the chart is a picture, there is nothing to extract; use Extract From PowerPoint to get the picture. For tables on slides rather than charts, copy them from PowerPoint.
Tips for best results
Use the Excel option for several charts. Check the first rows of the table against the chart. Text that looks like a formula is saved as text so a spreadsheet will not run it.
Limitations
Only stored values are read; formulas are not. Combination and secondary-axis charts are read series by series. Charts linked to an outside workbook may have no stored numbers. The result has not been checked in desktop PowerPoint.
Privacy
The deck is read inside your browser tab and is not uploaded. A request that counts the use goes to this site when you download and carries no part of your file.
Related PowerPoint tools: