<- All use cases

Extract numbers from a PDF and convert from European format to US

Extract data from a PDF and convert numbers that are in a European format to US format, such as currency or decimals.

Try this in Lido for free ->Schedule a demo with a product specialist
Watch demo video
Lido is trusted by sales, marketing, and operations teams at:
and 100s of other companies

Why you should use this

This automation is essential for finance and accounting professionals managing international financial data, providing enhanced accuracy, time and cost efficiency, and improved compliance with local and international standards. By automating the extraction and conversion of numerical data from PDFs, it reduces human error, accelerates the monthly book closing process, and frees up resources for strategic tasks.

How it Works

This automation extract tables of data from a PDF that includes numbers that are in a European number format (currency, decimals) and converts them to US format

Talk to a product specialistTry this in Lido for free ->

Start with a PDF of one or more tables of data

Start with a PDF that has one or more tables of data in it.

Extract data from the PDF into Lido

Using the EXTRACTTABLESFROMPDF formula, Lido extracts all data it recognizes as part of a table from your PDF and adds it to a spreadsheet.

‍

=EXTRACTTABLESFROMPDF(<your GoogleDrive credential>, file_link, output_cell)

Change European format numbers to US

Use the LOCALIZENUMBER formula to change the format of a cell or range of data from one locale format to another.

‍

=LOCALIZENUMBER(EXTRACTTABLESFROMPDF(<your GoogleDrive credential>, file_link, output_cell),"ds-DE", "en-US")

Tutorials to help you get started

Step-by-step instructions to guide you through setting up this automation in Lido.
Instructions from the Lido blog ->
Youtube video ->
Talk to a product specialistTry this in Lido for free ->

Who should use this

This automation is designed specifically for professionals on accounting or finance teams at companies that engage in multi-country operations, particularly those that handle transactions in both European and US markets. If you frequently work with financial documents such as invoices, receipts, or financial statements in PDF format that contain numerical data in the European format (comma as a decimal separator), this Lido automation will be incredibly valuable.
Talk to a product specialistTry this in Lido for free ->

Related Use Cases

Discover more workflows you can automate with Lido.

Create Outlook Calendar events from Google Forms Submissions

Send Google Form responses to a new Slack Channel

Send emails based on dates in MySQL

Send email when a new row is added to MySQL

Certification tracking software

Recurring deadlines tracker

View all