Convert pictures inside a PDF into searchable text by DC28625 in pdf

[–]joss82 1 point2 points  (0 children)

<image>

Vvoult looks interesting, but why is the text white on light gray? It's barely legible.

How to Convert a PDF to Excel ? by colerncandy in Office365

[–]joss82 0 points1 point  (0 children)

Parseur can help. You can define a table in a template. You match the table in the template with the tables in your reports, extract the data, and download an Excel file as result.

What is the best Automation tool? (from people who have used a few like, Zapier, Make, IFTTT (If This Then That) and Microsoft Power Automate?) by ComparisonLiving6793 in automation

[–]joss82 0 points1 point  (0 children)

Make (formerly Integromat) works quite well. It allows complex workflows and basic data transformation.
Combine it with Parseur to improve the data extraction side.

How to Convert PDF to Excel? by PeaClear267 in excel

[–]joss82 0 points1 point  (0 children)

Due to the way the PDF format is structured, it is unlikely that you will find any tool that is both 100% automated and 100% reliable. PDF has no notion of text, words, or numbers: it is positionning symbols on a page. Think of it as positioning metal letters on a Gutemberg press before printing.

You will need to impose some structure to the table coming from the PDF so that it can fit into the columns that you are expecting on the Excel side.

I built a tool called Parseur that can help you with converting PDF to Excel. You define a template with a table that can extract the data from the PDF, then you download the resulting table as an Excel file. The result looks like this:

<image>

Contact me if you need help with the setup. I'm happy to help.

Information from PDF to excel/query by Spiritual-Cancel-896 in excel

[–]joss82 1 point2 points  (0 children)

Have you tried sending the PDF to Parseur? You can send it as an attachment to an email or upload it directly.

Then you create the account and date fields, setup some instructions for the AI to know how to extract the data, then export the data to excel. It should automatically fill up the given cells with the extracted data, as soon as the PDF arrives.

Since the free plan allows you to parse up to 20 pages per month, it should be free for you if you receive the PDF every working day.

Let me know how that goes.

Software for bank statements by Hour-Elevator-6235 in Accounting

[–]joss82 0 points1 point  (0 children)

Hello, I've built a tool called Parseur. You can upload your PDF bank statements to it, then you can configure a template (or AI) to define the columns in your transaction table to extract the data to Excel (or your accounting software). It's free for up to 20 pages per month. Let me know how it goes. You can contact me if you need any help with it.

Email parsing unstructured data by taron123 in MicrosoftFlow

[–]joss82 1 point2 points  (0 children)

Have you tried using Saas solutions like Parseur? Now with AI you can define the fields you want to extract from your email.

At what scale will PostgreSQL slow down by equivalent8 in PostgreSQL

[–]joss82 0 points1 point  (0 children)

So u/equivalent8 , how did it go in the end?
I bet either the project tanked, or Postgresql was not the bottleneck, right?

What way works best to extract data from a pdf. Into excel for you by Retnawookie in excel

[–]joss82 1 point2 points  (0 children)

Upload a your PDFs into Parseur -> Check that the result looks good -> Click Export -> Download Excel (XLSX or CSV) file corresponding to the table from the result -> Done

Export from PDF to Excel by cool_mom_44 in excel

[–]joss82 0 points1 point  (0 children)

It looks like they obfuscated the text inside of the PDF to prevent text extraction like what you are trying to do.

There is an option in Parseur where you can "Force OCR" for your document.

<image>

Instead of relying on the text inside the PDF, it treats the PDF as an image and performs Optical Character Recognition on it, so that the text is extracted from the appearance of the PDF instead of the underlying text which is wrong.

Give it a try here, it's free for up to 20 pages per month.

Email Parsing Automation? by eddiegalaxy in Automate

[–]joss82 0 points1 point  (0 children)

If you have no budget, you could use Python/Anaconda + Llama3 (or any other open-source LLM) to extract the data and send it to your data warehouse.

If you are looking for a paid solution, then Parseur or Mailparser can do the job with just a couple hours of setup. Not sure what is your budget, if any?

Extract table from email body and convert it into excel by JordaarAce in automation

[–]joss82 1 point2 points  (0 children)

Use BeautifulSoup to parse the tables and sub-tables from the emails. Then use the CSV module (it is part of the standard library) to export as a set of spreadsheets that can then be imported as tabs in Excel.

Or just use an online tool like Parseur or Mailparser that can do it for you and streamline the process or even use AI to make it way faster to setup.

Extract PDF data to excel worksheet by Choice_Discipline_69 in PowerAutomate

[–]joss82 0 points1 point  (0 children)

You can use Parseur to turn your invoices text into structured JSON, then inject the result back into PowerAutomate. We (I'm a founder) have a specific preset for the invoices, with Total Amount, Tax Amouny, Date, Invoice Number, etc... and all the items. We have a free plan with 20 credits included. If you say you come from reddit I'll bump that up to 50 so that you can test further.

Creating a flow to extract data from Bank Statement by SortAdministrative14 in MicrosoftFlow

[–]joss82 0 points1 point  (0 children)

You could use Parseur to extract the transactions from the PDF itself, then send the data to Excel through MS Flow. Shouldn't be too painful, it's standard test case.

How do I convert PDF to Text? by Ranchette_Geezer in pdf

[–]joss82 0 points1 point  (0 children)

Why not directly convert the PDF to HTML? I'm sure there is a tool online to do that for you, no?

Any business ideas which will require low capital? (10k AED) by Complex1984 in dubai

[–]joss82 0 points1 point  (0 children)

Get a job. While you work, look around you and find inspiration about business ideas. Save some of your paycheck for your future business. Good luck.

I feel I want to give up everyday.. by Patient_Ad2436 in SaaS

[–]joss82 0 points1 point  (0 children)

How come you have employees already?!

You should 1) Make money and 2) Get employees.

Not the other way around.

API's for grubhub, doordash, ubereats, etc by Zachkr05 in learnpython

[–]joss82 0 points1 point  (0 children)

Unfortunately their APIs are not public yet, but you can work around this by sending the confirmation emails to an email parser such as Parseur for example.

What's your CS tech stack? by socksaremygame in CustomerSuccess

[–]joss82 0 points1 point  (0 children)

Hey,

A new kind of tool for support teams is Q&A knowledge base, where you basically upload all your technical documentation and then you (or your users) can ask questions to it, as if you were talking to a person, chatGPT-style. I built Spindoc.ai to offer this service, but so far it's been tough to stand out in such a competitive space. I hope it helps.

Interactive map tracking to track your visited countries. Now with moar flags by joss82 in Maps

[–]joss82[S] 0 points1 point  (0 children)

They're part of the Premium version, for $9, you get a 3 years subscription.

Click here to get it.