Share via

How to import loose data in form of values onto excel from pdf?

Manuel E Ares Reus 21 Reputation points
2021-02-12T03:27:06.537+00:00

I want to import or copy the following data (values) from a pdf onto excel so that I can make a time chart. I have tried importing the data through excel but it doesn't give me the option to order the values and make a time chart. Thank you in advance for your answers. 67209-capturedatatest.png

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,716 questions
0 comments
Accepted answer
  1. Emily Hua-MSFT 27,646 Reputation points
    2021-02-12T08:50:27.947+00:00

    @Manuel E Ares Reus

    Based on the picture you shared, I make a simple example.
    I suggest you select the range of data, copy and past into Excel as text.
    67382-4.gif

    Then use "Text to Columns" to split these data.
    67359-5.gif

    Any misunderstanding, please let me know.

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Manuel E Ares Reus 21 Reputation points
    2021-02-12T03:29:18.013+00:00

    I forgot to provide context, here it is, thank you all again. 67120-capturedatatest2.png

    0 comments
  2. Manuel E Ares Reus 21 Reputation points
    2021-02-12T16:23:04.217+00:00

    Thank you very much. I was able to do it.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.