Capture table data so it pastes properly to excel

  • 1
  • Question
  • Updated 3 months ago
  • Answered
Instead of having to capture one field at a time it would be great to capture a table and paste it properly into excel so it gets all the fields as they are on the screen.   I would not care if I had to turn on an option to tell it that we are in table capture mode.   
Photo of Fred

Fred

  • 2 Posts
  • 0 Reply Likes

Posted 3 months ago

  • 1
Photo of jasons

jasons

  • 273 Posts
  • 87 Reply Likes
I don’t know about snagit but I just use windows copy/paste.

It generally pastes perfect to excel.


Photo of JL1

JL1

  • 255 Posts
  • 111 Reply Likes
Right. I do this all the time. Using SnagIt for such a purpose makes no sense.
Photo of Ed Covney

Ed Covney

  • 237 Posts
  • 183 Reply Likes
Actually Windows' copy and paste do not work, at least from a PDF Sudoku grid. 
I once used Snagit's (2018) "grab text" tool and I could copy  a full Sudoku puzzle, tabs and all directly into a waiting 9 x 9 spreadsheet. The puzzles I've downloaded before are here:
    http://www.sudokuprintables.org/sudoku-printables.html
Photo of Ed Covney

Ed Covney

  • 237 Posts
  • 183 Reply Likes
Fred - I just uninstalled Snagit 2019.1.0 and re-Installed 2018.0.1 and it's working although not as well as before.
Photo of Kelly Mullins

Kelly Mullins, TechSmith Employee & Helper

  • 2823 Posts
  • 610 Reply Likes
Hi Fred,
Your best method for success is to use the Grab Text feature.

So, take a capture of your table.Like this:
.


Then right-click and choose Grab Text from the menu. You will see this box:


Click Copy All. Then paste into Excel. This is what I get:


I hope this helps
.Kelly
(Edited)
Photo of Ed Covney

Ed Covney

  • 237 Posts
  • 183 Reply Likes
Kelly - Have you tried a Sudoku puzzle in my link? Also when there are errors, you either do nothing ("4" in front of Indonesia, or misspell as the "1O" vs. "10" to start the tenth line - I know I'd much rather have a trouble indicator like "¿" where you're not 99.999% sure.
I've also noticed that, as in the Sudoku puzzles, if no letter is on a line, just spaces and numbers, it almost totally fails. 
(Edited)
Photo of Kelly Mullins

Kelly Mullins, TechSmith Employee & Helper

  • 2823 Posts
  • 610 Reply Likes
Hi Ed,
I did some testing on your Sudoku pages and found if you include the graphic black border, your image isn't seen as text-grab-capable.

I left off the black border and got this. I was just capturing the table part... not everything else.




So it looks like it captured correctly, then copied and pasted into Excel correctly.

Is this not what you need? Or is this not working for you?
Kelly
Photo of Ed Covney

Ed Covney

  • 237 Posts
  • 183 Reply Likes
Kelly - Thanks so much!
Did you do that in Snagit 2019? Begs the question, why the thick center lines are OK? I'll experiment.
Photo of Kelly Mullins

Kelly Mullins, TechSmith Employee & Helper

  • 2823 Posts
  • 610 Reply Likes
Hi,
Yes, I did that in 2019. I don't know why the outside border makes a difference here. I'm intrigued and I I get a minute, I'll ask one of the Snagit devs what the scoop is.

Overall, I hope you can experiment and get the look you need!
Thanks for using Snagit.
Kelly
Photo of Mike62

Mike62

  • 561 Posts
  • 163 Reply Likes
Small addition to the answer of Kelly - AFAIK SnagIt uses the OCR from Abbyy - copying graphics (lines) is a little difficult and one usually has to do some cell formatting afterwards.

Just for your info - below example using Abbyy Screenshot Reader - which comes pretty close to what you want I guess. You can see that, also here, the lines are not always captured.


Photo of Ed Covney

Ed Covney

  • 237 Posts
  • 183 Reply Likes
Mike - Thanks for the info, but Kelly found Snagit's secret which delivers a sheet identical to your step 2.
I then add zeroes to the blank  cells in the 9 x 9 grid and feed the results into my "solver" which rates it for difficulty - actually a work in progress, but coming along nicely.