How to Convert Graph Images into Usable Excel Data
Question details
The user needs to extract underlying numerical data from a chart or graph image to analyze it within Excel.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Attempting to recreate or analyze data that is locked in a static image format (like a graph screenshot) when the original spreadsheet source file is unavailable.
- Observed behavior
- Excel's native 'Data from Picture' feature fails to accurately extract data points from visual graphs, as it is primarily designed to read clearly formatted text and tables.
Before attempting to digitize a graph image manually, verify if you can contact the original chart creator to request the source spreadsheet, as this is always the fastest and most accurate method.
Use a Web-Based Graph Digitizer Tool
Use specialized graph extraction software to calibrate the image axes and pinpoint the data values, which can then be exported as a CSV file.
Graph digitizers like WebPlotDigitizer are designed specifically to read chart images (such as line graphs, scatter plots, or bar charts) and translate the visual points back into raw X and Y coordinates.
Open a graph digitizing tool (e.g., WebPlotDigitizer) in your browser and upload the screenshot of your chart.
Select your plot type (e.g., 2D X-Y Plot). Click on known points on the X and Y axes within the image and enter their exact numerical values to set the scale.
Manually click along the plotted lines or bars to mark the data points. If the tool supports it, use the automatic extraction algorithm to highlight the data curve.
Click 'View Data' to see the generated numerical values, then select 'Download CSV' to save the file to your computer.
Launch Excel, go to File > Open, and select the downloaded CSV file to begin analyzing your recovered data.

Extract Labeled Data Points using OCR
If your chart image contains explicit numerical data labels next to every point, you can use Optical Character Recognition (OCR) to extract the text.
Analyze and Visualize Extracted CSV Data with WPS Office
While extracting data from static graph images requires specialized digitizer tools, organizing, formatting, and analyzing the resulting CSV files is effortless with WPS Spreadsheet. As a highly compatible and free alternative to Microsoft Excel, WPS Office provides all the tools you need to turn raw data back into stunning charts.
- 1. Open your extracted CSV: Launch WPS Spreadsheet, click on Menu > Open, and select the CSV file generated by your graph digitizer.
- 2. Format your data: Use the familiar Data tools, such as Text to Columns, to ensure your extracted X and Y values are properly separated.
- 3. Recreate your chart: Highlight your organized data, navigate to the Insert tab, and choose a Chart type to visualize your recovered data.

Frequently Asked Questions
Can I use Excel's 'Data from Picture' feature to read a line graph?
No, Excel's 'Data from Picture' feature is specifically optimized for printed data tables and structured text. It cannot interpolate data points from visual lines, curves, or scatter plots on a graph.
What is the best free tool to digitize graph images?
WebPlotDigitizer is widely considered one of the best free, web-based tools for extracting numerical data from chart and graph images. It supports various chart types including 2D X-Y plots, bar charts, and polar diagrams.
How accurate is the data extracted from a chart image?
The accuracy depends heavily on the resolution of the image and how precisely you calibrate the axes during the extraction process. It typically provides a very close estimate, but you should always review the results for errors before finalizing your analysis.




