SnipSheet › Guides

Guides

Step by step answers for getting tables out of PDFs, scans, screenshots and web pages into Excel and Google Sheets.

How to copy a table from a PDF to Excel and keep the columnsCopying a table from a PDF into Excel often puts everything in one column. Here are two ways to keep the rows, columns and numbers intact.How to convert a PDF table to Excel on a MacExcel for Mac has no PDF import. Here is how to get a table from a PDF into Excel or Numbers on a Mac, including scanned PDFs.How to convert a bank statement PDF to ExcelTurn the transactions in a PDF bank or credit card statement into an Excel or Google Sheets table with real dates and amounts.How to get a table from a scanned PDF into ExcelScanned PDFs are images, so copy and paste and Excel's PDF import don't work. Here is how to turn a scanned table into Excel.How to turn a screenshot of a table into ExcelTurn a screenshot or image of a table into an Excel spreadsheet with real numbers, without retyping anything.How to get a table from a PDF or image into Google SheetsGoogle Sheets can't import PDF tables. Here is how to get a table from a PDF, scan or screenshot into Google Sheets with the numbers intact.How to convert a table that spans several PDF pages to ExcelLong tables that run over several PDF pages usually come out broken, with repeated headers in the middle. Here is how to combine them into one clean Excel table.Converting PDFs to Excel with European number formatsNumbers like 1.234,56 or 12,5 % often turn into text or wrong values when converting a PDF to Excel. Here is how to get them right.How to copy a table from a website into ExcelCopying a table from a web page into Excel often brings formatting, links and broken columns. Here are clean ways to get web tables into Excel.