How to "automatically" extract data from a messy PDF table to Excel

Chandoo β€’ January 30, 2024
Video Thumbnail

About

πŸ‘‹ Hello. I make you AWESOME at your work 😎 I make videos on Excel, Power BI & Data Analytics so that you can be awesome at your work. βœ… Excel ~ Power BI ~ SQL ~ Python ~ Interview Prep βœ… New Video Every Week ~ Subscribe πŸ’»πŸ“— My courses Advanced Excel πŸ‘‰ https://chandoo.org/wp/excel-school-program/ Advanced Power BI πŸ‘‰ https://chandoo.org/wp/power-bi-course/ Everything πŸ‘‰ https://chandoo.org/mdac ~ KNOW πŸ˜€ About me: https://chandoo.org/wp/about/ What I'm doing now: https://chandoo.org/wp/now/ Stuff I use: https://chandoo.org/wp/about/what-we-use/ FOLLOW πŸšΆβ€β™€οΈπŸšΆβ€β™‚οΈ 🌐 Website - https://chandoo.org/wp/ πŸ“ƒ FREE Data tips newsletter - https://chandoo.org/wp/subscribe/ πŸ“š Courses - https://chandoo.org/wp/training-programs/ πŸ“· Instagram - https://www.instagram.com/chandoo.xlsx/ πŸ’₯ఀెలుగు Telugu Channel - https://www.youtube.com/channel/UCuaf89M0Lt5pmXzaUssXHvw/

You May Also Like

Essential iPhone 12 Tools

AI-recommended products based on this video

Loading...
FNTCASE for iPhone 12 Clear Case: for iPhone 12 Pro Case Magnetic Military Grade Drop Protection Anti Yellowing Cell Phone Cover - Rugged Durable Shockproof Protective Bumper (Clear) Global Recycled Standard

FNTCASE for iPhone 12 Clear Case: for iPhone 12 Pro Case Magnetic Military Grade Drop Protection Anti Yellowing Cell Phone Cover - Rugged Durable Shockproof Protective Bumper (Clear) Global Recycled Standard

(2,806)
$12.99
FREE delivery Sat, Sep 20 on your first order
500+ bought in past month
Loading...
Phone Case for iPhone 12 Pro Max Case Compatible with MagSafe, YUANDMI Case for iPhone 12 Pro Max Magnetic Slim Thin Translucent Matte Back Shockproof Anti-Yellow Protective Cover Case Black

Phone Case for iPhone 12 Pro Max Case Compatible with MagSafe, YUANDMI Case for iPhone 12 Pro Max Magnetic Slim Thin Translucent Matte Back Shockproof Anti-Yellow Protective Cover Case Black

(130)
$12.99
FREE delivery Sat, Jun 14 on your first order
Loading...
FNTCASE for iPhone 12 Pro Case: iPhone Magnetic Military Grade Drop Protection Clear Cell Phone Case - Rugged Durable Shockproof Anti Yellowing Slim Cases for iPhone 12 Pro (Clear)

FNTCASE for iPhone 12 Pro Case: iPhone Magnetic Military Grade Drop Protection Clear Cell Phone Case - Rugged Durable Shockproof Anti Yellowing Slim Cases for iPhone 12 Pro (Clear)

(81)
$9.99
FREE delivery Sat, Jun 14 on your first order
50+ bought in past month
Loading...
DUEDUE for iPhone 12 Case iPhone 12 Pro Case Liquid Silicone Slim Cover with Microfiber Lining Shockproof Protective Case for iPhone 12/12 Pro 6.1 inch Light Purple

DUEDUE for iPhone 12 Case iPhone 12 Pro Case Liquid Silicone Slim Cover with Microfiber Lining Shockproof Protective Case for iPhone 12/12 Pro 6.1 inch Light Purple

(1,577)
$12.99
FREE delivery Sat, Jun 14 on your first order
100+ bought in past month
Loading...
FNTCASE for iPhone 12 Clear Case: for iPhone 12 Pro Case Magnetic Military Grade Drop Protection Anti Yellowing Cell Phone Cover - Rugged Durable Shockproof Protective Bumper (Clear) Global Recycled Standard

FNTCASE for iPhone 12 Clear Case: for iPhone 12 Pro Case Magnetic Military Grade Drop Protection Anti Yellowing Cell Phone Cover - Rugged Durable Shockproof Protective Bumper (Clear) Global Recycled Standard

(2,806)
$12.99
FREE delivery Sat, Sep 20 on your first order
500+ bought in past month
Loading...
Phone Case for iPhone 12 Pro Max Case Compatible with MagSafe, YUANDMI Case for iPhone 12 Pro Max Magnetic Slim Thin Translucent Matte Back Shockproof Anti-Yellow Protective Cover Case Black

Phone Case for iPhone 12 Pro Max Case Compatible with MagSafe, YUANDMI Case for iPhone 12 Pro Max Magnetic Slim Thin Translucent Matte Back Shockproof Anti-Yellow Protective Cover Case Black

(130)
$12.99
FREE delivery Sat, Jun 14 on your first order
Loading...
FNTCASE for iPhone 12 Pro Case: iPhone Magnetic Military Grade Drop Protection Clear Cell Phone Case - Rugged Durable Shockproof Anti Yellowing Slim Cases for iPhone 12 Pro (Clear)

FNTCASE for iPhone 12 Pro Case: iPhone Magnetic Military Grade Drop Protection Clear Cell Phone Case - Rugged Durable Shockproof Anti Yellowing Slim Cases for iPhone 12 Pro (Clear)

(81)
$9.99
FREE delivery Sat, Jun 14 on your first order
50+ bought in past month
Loading...
DUEDUE for iPhone 12 Case iPhone 12 Pro Case Liquid Silicone Slim Cover with Microfiber Lining Shockproof Protective Case for iPhone 12/12 Pro 6.1 inch Light Purple

DUEDUE for iPhone 12 Case iPhone 12 Pro Case Liquid Silicone Slim Cover with Microfiber Lining Shockproof Protective Case for iPhone 12/12 Pro 6.1 inch Light Purple

(1,577)
$12.99
FREE delivery Sat, Jun 14 on your first order
100+ bought in past month
Loading...
Joystick Replacement Kit for Oculus Quest 2/3 Controller, Repair Kit for Meta Quest 2/3 Controller, Include 2 Joysticks, T5 Screwdriver, Tweezer, Pry Tool, 4 Thumbstick Grips (Black-11-in one)

Joystick Replacement Kit for Oculus Quest 2/3 Controller, Repair Kit for Meta Quest 2/3 Controller, Include 2 Joysticks, T5 Screwdriver, Tweezer, Pry Tool, 4 Thumbstick Grips (Black-11-in one)

(1,736)
$11.63$11.53
FREE delivery Tue, Jun 17 on your first order
100+ bought in past month
Loading...
eXtremeRate Replacement Thumbsticks for Xbox Core Wireless Controller, Joysticks Repair Kit for Xbox Series X/S Controller, Custom Analog Stick Buttons for Xbox One S/X/Elite Controller - Clear Red

eXtremeRate Replacement Thumbsticks for Xbox Core Wireless Controller, Joysticks Repair Kit for Xbox Series X/S Controller, Custom Analog Stick Buttons for Xbox One S/X/Elite Controller - Clear Red

(54)
$12.99
FREE delivery Sun, Aug 24 on your first order
Loading...
eXtremeRate Replacement Thumbsticks for Xbox Core Wireless Controller, Joysticks Repair Kit for Xbox Series X/S Controller, Custom Analog Stick Buttons for Xbox One S/X/Elite - Orange & Black

eXtremeRate Replacement Thumbsticks for Xbox Core Wireless Controller, Joysticks Repair Kit for Xbox Series X/S Controller, Custom Analog Stick Buttons for Xbox One S/X/Elite - Orange & Black

(293)
$12.99
FREE delivery Sun, Aug 24 on your first order
Loading...
Cat Feather Toy, Interactive Cat Teaser Toy with Bells, Replacement Feather Refills, Natural Wand Attachment for Kittens Playing Catcher and Exercising

Cat Feather Toy, Interactive Cat Teaser Toy with Bells, Replacement Feather Refills, Natural Wand Attachment for Kittens Playing Catcher and Exercising

(0)
$2.42
$4.09 delivery Jul 2 - 22
Loading...
DUEDUE for iPhone 12 Case iPhone 12 Pro Case Liquid Silicone Slim Cover with Microfiber Lining Shockproof Protective Case for iPhone 12/12 Pro 6.1 inch Light Purple

DUEDUE for iPhone 12 Case iPhone 12 Pro Case Liquid Silicone Slim Cover with Microfiber Lining Shockproof Protective Case for iPhone 12/12 Pro 6.1 inch Light Purple

(1,577)
$12.99
FREE delivery Sat, Jun 14 on your first order
100+ bought in past month
Loading...
FNTCASE for iPhone 12 Case: iPhone 12 Pro Case Clear Slim Shockproof Cell Phone Protective Cover | Anti Yellowing Scratch Proof Drop Proof Tough 5G Mobile Phone Protection Bumper 6.1 inch Global Recycled Standard

FNTCASE for iPhone 12 Case: iPhone 12 Pro Case Clear Slim Shockproof Cell Phone Protective Cover | Anti Yellowing Scratch Proof Drop Proof Tough 5G Mobile Phone Protection Bumper 6.1 inch Global Recycled Standard

(2,171)
$7.19
FREE delivery Sat, Jun 14 on your first order
50+ bought in past month
Loading...
FNTCASE for iPhone 12 Clear Case: for iPhone 12 Pro Case Magnetic Military Grade Drop Protection Anti Yellowing Cell Phone Cover - Rugged Durable Shockproof Protective Bumper (Clear) Global Recycled Standard

FNTCASE for iPhone 12 Clear Case: for iPhone 12 Pro Case Magnetic Military Grade Drop Protection Anti Yellowing Cell Phone Cover - Rugged Durable Shockproof Protective Bumper (Clear) Global Recycled Standard

(2,806)
$12.99
FREE delivery Sat, Sep 20 on your first order
500+ bought in past month
Loading...
Phone Case for iPhone 12 Pro Max Case Compatible with MagSafe, YUANDMI Case for iPhone 12 Pro Max Magnetic Slim Thin Translucent Matte Back Shockproof Anti-Yellow Protective Cover Case Black

Phone Case for iPhone 12 Pro Max Case Compatible with MagSafe, YUANDMI Case for iPhone 12 Pro Max Magnetic Slim Thin Translucent Matte Back Shockproof Anti-Yellow Protective Cover Case Black

(130)
$12.99
FREE delivery Sat, Jun 14 on your first order
Loading...
LEGO City F1 Driver with McLaren Race Car Toy - Model Car Building Toy Kit for Kids, Boys and Girls, Ages 6+ - F1 Collectible for Fans - with a Driver Minifigure - Gift Idea for Birthdays - 60442

LEGO City F1 Driver with McLaren Race Car Toy - Model Car Building Toy Kit for Kids, Boys and Girls, Ages 6+ - F1 Collectible for Fans - with a Driver Minifigure - Gift Idea for Birthdays - 60442

(177)
$13.98
FREE delivery Sat, Jun 14 on your first order
200+ bought in past month
Loading...
FNTCASE for iPhone 12 Clear Case: for iPhone 12 Pro Case Magnetic Military Grade Drop Protection Anti Yellowing Cell Phone Cover - Rugged Durable Shockproof Protective Bumper (Clear) Global Recycled Standard

FNTCASE for iPhone 12 Clear Case: for iPhone 12 Pro Case Magnetic Military Grade Drop Protection Anti Yellowing Cell Phone Cover - Rugged Durable Shockproof Protective Bumper (Clear) Global Recycled Standard

(2,806)
$12.99
FREE delivery Sat, Sep 20 on your first order
500+ bought in past month
Loading...
Phone Case for iPhone 12 Pro Max Case Compatible with MagSafe, YUANDMI Case for iPhone 12 Pro Max Magnetic Slim Thin Translucent Matte Back Shockproof Anti-Yellow Protective Cover Case Black

Phone Case for iPhone 12 Pro Max Case Compatible with MagSafe, YUANDMI Case for iPhone 12 Pro Max Magnetic Slim Thin Translucent Matte Back Shockproof Anti-Yellow Protective Cover Case Black

(130)
$12.99
FREE delivery Sat, Jun 14 on your first order
Loading...
FNTCASE for iPhone 12 Pro Case: iPhone Magnetic Military Grade Drop Protection Clear Cell Phone Case - Rugged Durable Shockproof Anti Yellowing Slim Cases for iPhone 12 Pro (Clear)

FNTCASE for iPhone 12 Pro Case: iPhone Magnetic Military Grade Drop Protection Clear Cell Phone Case - Rugged Durable Shockproof Anti Yellowing Slim Cases for iPhone 12 Pro (Clear)

(81)
$9.99
FREE delivery Sat, Jun 14 on your first order
50+ bought in past month
Loading...
DUEDUE for iPhone 12 Case iPhone 12 Pro Case Liquid Silicone Slim Cover with Microfiber Lining Shockproof Protective Case for iPhone 12/12 Pro 6.1 inch Light Purple

DUEDUE for iPhone 12 Case iPhone 12 Pro Case Liquid Silicone Slim Cover with Microfiber Lining Shockproof Protective Case for iPhone 12/12 Pro 6.1 inch Light Purple

(1,577)
$12.99
FREE delivery Sat, Jun 14 on your first order
100+ bought in past month
Loading...
JOREST 38Pcs Small Precision Screwdriver Set, Tool Gifts for Men, Christmas Gifts for him with Torx T5, T6, Repair Tool Kit for MacBook, Computer, Laptop, iPhone, PS4 PS5, Xbox, Switch, Glasses

JOREST 38Pcs Small Precision Screwdriver Set, Tool Gifts for Men, Christmas Gifts for him with Torx T5, T6, Repair Tool Kit for MacBook, Computer, Laptop, iPhone, PS4 PS5, Xbox, Switch, Glasses

(43,599)
$14.07
FREE delivery Thu, Nov 27 on your first order
1K+ bought in past month
Loading...
Huachuang 3PCS Griddle Accessories for Blackstone: 2 Clip-on Stainless Steel Spatula Holder + Magnetic Grease Gate Blocker for 28"/36" Blackstone Griddle - Grill Barbecue Tool Set

Huachuang 3PCS Griddle Accessories for Blackstone: 2 Clip-on Stainless Steel Spatula Holder + Magnetic Grease Gate Blocker for 28"/36" Blackstone Griddle - Grill Barbecue Tool Set

(4)
$16.99
FREE delivery Sun, Aug 10 on your first order
Loading...
Soleilwear Mini Electric Screwdriver Set, 52 in 1 Precision Electric Screwdriver Cordless with 48 Magnetic Bits, Repair Tool Kit with Tweezers and Pry Bar

Soleilwear Mini Electric Screwdriver Set, 52 in 1 Precision Electric Screwdriver Cordless with 48 Magnetic Bits, Repair Tool Kit with Tweezers and Pry Bar

(83)
$49.99
PrimeFREE delivery Sat, Jun 14
100+ bought in past month
Loading...
USB C Car Charger, 3-Port 67W Super Fast Charging Dual USB-C & USB-A Car Charger Accessories Cigarette Lighter Adapter for iPhone 17 16e 16 15 14 13 12 11 Pro Max, iPad, Galaxy, Pixel, Android Phone

USB C Car Charger, 3-Port 67W Super Fast Charging Dual USB-C & USB-A Car Charger Accessories Cigarette Lighter Adapter for iPhone 17 16e 16 15 14 13 12 11 Pro Max, iPad, Galaxy, Pixel, Android Phone

(217)
$12.59
FREE delivery Sat, Sep 20 on your first order
2K+ bought in past month
Loading...
FNTCASE for iPhone 12 Clear Case: for iPhone 12 Pro Case Magnetic Military Grade Drop Protection Anti Yellowing Cell Phone Cover - Rugged Durable Shockproof Protective Bumper (Clear) Global Recycled Standard

FNTCASE for iPhone 12 Clear Case: for iPhone 12 Pro Case Magnetic Military Grade Drop Protection Anti Yellowing Cell Phone Cover - Rugged Durable Shockproof Protective Bumper (Clear) Global Recycled Standard

(2,806)
$12.99
FREE delivery Sat, Sep 20 on your first order
500+ bought in past month
Loading...
Phone Case for iPhone 12 Pro Max Case Compatible with MagSafe, YUANDMI Case for iPhone 12 Pro Max Magnetic Slim Thin Translucent Matte Back Shockproof Anti-Yellow Protective Cover Case Black

Phone Case for iPhone 12 Pro Max Case Compatible with MagSafe, YUANDMI Case for iPhone 12 Pro Max Magnetic Slim Thin Translucent Matte Back Shockproof Anti-Yellow Protective Cover Case Black

(130)
$12.99
FREE delivery Sat, Jun 14 on your first order
Loading...
FNTCASE for iPhone 12 Pro Case: iPhone Magnetic Military Grade Drop Protection Clear Cell Phone Case - Rugged Durable Shockproof Anti Yellowing Slim Cases for iPhone 12 Pro (Clear)

FNTCASE for iPhone 12 Pro Case: iPhone Magnetic Military Grade Drop Protection Clear Cell Phone Case - Rugged Durable Shockproof Anti Yellowing Slim Cases for iPhone 12 Pro (Clear)

(81)
$9.99
FREE delivery Sat, Jun 14 on your first order
50+ bought in past month