Convert PDF to Qlik Online

Drop a PDF file below, check the table it reads, and get Qlik back. The file is read in your browser, so the document stays on your machine, and you can edit the table before you export.

From

The only part of this site that uses a server. The address is sent to it so the page can be fetched, because a browser is not allowed to fetch someone else's page itself. Your own files are never involved.

Nothing here is uploaded. The parsing happens on this page.
Edit
Paste or upload something above and it will appear here.
ToDataMarkupDocumentsCodeSchemasImages

The output will appear here once there is a table to convert.

What PDF is

PDF describes a page: glyphs at coordinates, not rows and columns. A table in a PDF is a visual arrangement, not a data structure.

Reports, invoices, statements and anything sent to be read rather than processed.

What Qlik is

A Qlik load script block using LOAD INLINE, which embeds the data in the script itself.

QlikView and Qlik Sense developers.

What changes when you convert PDF to Qlik

Every character in a text-based PDF carries its position on the page. Characters sharing a baseline are one row. Columns are found from the vertical strips no character ever occupies, which is why extraction works cleanly on a document laid out with spacing and badly on one laid out with ruled lines. A header repeated at the top of each page is detected and dropped rather than landing in the middle of the data.

Suitable for small reference tables. For anything large, load from a file instead.

What carries over from PDF to Qlik

PDF records 2 things about a table that Qlik has no way to hold.

Qlik wants a type for each column, and PDF does not record one. Tablizer leaves every value as text unless you tick "Detect numbers", which types each value from how it looks. Leave it off and a zip code, a phone number or a leading-zero id arrives intact; turn it on and those are the columns to check afterwards.

A line break inside a cell ends the row in Qlik, so line breaks are replaced rather than carried through.

Qlik marks its header cells differently from its data cells, so the first row is written with that marker.

Anything visual in the PDF - weight, alignment, colour, column widths - has no counterpart in Qlik and is dropped. The values are what survives.

This is the direction that recovers structure: PDF has no table in it to read, only an arrangement that looks like one, so the rows and columns are inferred rather than read.

A worked example

Three rows of staff data, with an identifier that has a leading zero, a value containing a comma, a value containing quotes and one blank cell. Those are the four places formats disagree, so they are the four places to look.

The page text, as the extractor sees it
id   name              role           started     hours
007  Halima Yusuf      Analyst, data  2024-03-15  38.5
012  Jonah "Jo" Pryce  Engineer       2025-11-02
104  Wei Chen          Manager        2023-06-30  40
Qlik out
Data:
LOAD * INLINE [
id,   name,   role,   started,   hours
  '007', 'Halima Yusuf', 'Analyst, data', '2024-03-15', '38.5'
  '012', 'Jonah "Jo" Pryce', 'Engineer', '2025-11-02', ''
  '104', 'Wei Chen', 'Manager', '2023-06-30', '40'
];

Questions

How do I convert PDF to Qlik?

Drop your PDF file onto the box above. Check the table in the grid, then copy or download the Qlik from the output panel. It takes one step and the file never leaves your browser.

Can I get my table back out of the PDF?

Out of one made here, yes, because the text is real text. Out of a scanned document, no. A scan is an image of a page, and pulling data from it needs optical character recognition, which is a different job with a different failure rate.

One of my cells has a line break in it - what happens?

A line break would end the row in Qlik, so it is replaced instead of carried through. The rest of the cell stays where it belongs.

Is there a limit on file size?

No. The work happens on your own machine, so the limit is your machine's memory rather than an upload cap. A file with tens of thousands of rows converts in a second or two.

Is my data uploaded anywhere?

No. The parsing and generating are done by JavaScript running on this page. You can watch the network tab while you convert and see that nothing is sent.

Advertisement

Related conversions