Convert PDF table to Google Sheets workaround

In less than 12 minutes, learn how to take a PDF table and import it into Google Sheets in order to change the data, create charts, or reconvert it to another format such as Microsoft Excel .xlsx. Note that it's a complicated workaround involving other tools in G Suite (including Google Drive and Google Docs and text and CSV files), and will only work with simple PDF tables - complex tables, or mixed tables and other content on the PDF page can't easily be converted to PDF using this method. This video also shows how to handle errors in the import process, such as mismatched columns and rows. Narrator Ian Lamont is the founder of i30 Media Corporation, publisher of IN 30 MINUTES cheat sheets & guides.

NOTE: This is not an official video. Please review relevant terms of service. i30 Media Corporation cannot be held liable for any direct, indirect, incidental, consequential, or special damages of any kind, or any damages whatsoever, arising out of or in connection with the use of this video.

MORE IN 30 MINUTES VIDEOS & BLOG POSTS

[thompwal]

Thanks for the clarification and step by step instructions..

[Hallahanify]

the part where you add the coma in between all the values in the text editor, i cant figure out how to do that in windows.

[dirknoom]

Good video, but there's an extension (I don't know how long it's existed) called "pdf table importer" that seems to work extremely well. I've only used it once, but it's saved a lot of time.

[davidries]

Thanks for the explanation. I see, writing off would be faster ... ;-)

[icecorgi]

A BILLION THANKS, SAVED ME A LOT OF TIME!

[rogerdavis]

Can't you just show the "right" way to do the job instead of all the "wrong" ways???!!!

[moheuddin_sehab]

this is a very tedious way... just copy then use split function

[TJHuntley]

I'm looking for a script that sends the PDF from gmail to sheets automatically. I know there is a way to do it, I am just not certain how. Any suggestions would be appreciated.

[joelverley]

Awesome bro, worked like a charm! Thanks for making this tutorial.

[juanlanda]

Great video! Learned more about Google sheets. Only see this being more useful with bigger data.

[cozytrucking]

Is there any changes about the file converting recently ?

[annusharma]

Awesome video, thanks it will help me a lot .

[jeffwei]

If you have any sizable table this will take way too much work...

[sukhjinder]

IVE DOWNLOADED ALL OF MY TAX SLIPS FROM REVENUE CANADA AS A PDF FILE INTO GOOGLE DRIVE, AND THEN IMPORTED THEM INTO GOOGLE SHEETS. I DID IT ONCE, BUT I FORGOT HOW I DID IT, SO I KNOW THAT AS OF MARCH 2024 IT WAS POSSIBLE TO DO THIS. ON ANDROID. I CAN'T REMEMBER HOW I DID IT THOUGH.

[robbywk]

Good video! If the creator just did it right the first time would have saved all of the viewers time, though.

[CheekFleek]

I try upload the notepad but the sheet option does not show my notepad at all

[maheshtikiyani]

Sir, I typed ફ્રુટ in Google sheets, when I export it in the form of PDF then it will change automatically, , what should I do sir?

[society-firstcorp]

What about converting a pdf list not in a table? Do you have a video for that?

[alexsheer]

great video and clear instruction. earned my upvote

[debugelectronics]

esto solo sirve si es una tabla pequeña, tengo un pdf de 89 páginas con columnas pero no puedo poner comas en cada palabra pues hay frases :( no sirve si no es para algo especifico y simple