# How to pass pdf to text **URL:** \ **Category:** Beginner Questions\ **Tags:** connections\ **Created:** [October 20, 2024, 2:55pm UTC](https://community.make.com/t/how-to-pass-pdf-to-text/58353 "2024-10-20T14:55:56Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Matias\_Gallardo](https://avatars.discourse-cdn.com/v4/letter/m/ac91a4/32.png) [@Matias\_Gallardo](https://community.make.com/u/Matias_Gallardo)\ **Post date:** [October 20, 2024, 2:55pm UTC](https://community.make.com/t/how-to-pass-pdf-to-text/58353/1 "2024-10-20T14:55:56Z")
“Hey, I’m new to the platform. Sorry for the trouble, but there’s something I can’t figure out. I’m trying to convert PDF files into text. My idea is simple: take invoices in PDF format and load them into Google Sheets or Excel tables. That’s it.” ---
**Author:** ![Fario\_Consulting](https://avatars.discourse-cdn.com/v4/letter/f/5daacb/32.png) [@Fario\_Consulting](https://community.make.com/u/Fario_Consulting)\ **Post date:** [October 23, 2024, 1:39pm UTC](https://community.make.com/t/how-to-pass-pdf-to-text/58353/2 "2024-10-23T13:39:51Z")
Hi Matias, Welcome to the Make community! PDFs are more complicated than standard text files. It might be a bit of an overkill, but if you PDF file is extremely complex you could use Google Cloud Vision (or some OCR software) to get the correct text from your PDF ---
**Author:** ![Matias\_Gallardo](https://avatars.discourse-cdn.com/v4/letter/m/ac91a4/32.png) [@Matias\_Gallardo](https://community.make.com/u/Matias_Gallardo)\ **Post date:** [November 1, 2024, 12:22am UTC](https://community.make.com/t/how-to-pass-pdf-to-text/58353/3 "2024-11-01T00:22:15Z")
Hello everyone! 😊 I’m working on a project and have put together some ideas and connections based on similar examples I’ve seen. But I’m facing two major issues that I could use some advice on: 1. **ChatGPT isn’t recognizing my files and instead seems to be inventing data**. 2. **When I try to save everything in a JSON file, I get an error saying the format is incorrect** , and I get stuck there. If anyone has any tips or has run into similar problems, I’d love to hear how you solved them! Thanks in advance! ![screenshot-us2_make_com-2024_10_31-21_17_10](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/e/a/ead07cb587eb17391bf5fd26191a7e03e266fb03.png) ---
**Author:** ![PDFco](https://avatars.discourse-cdn.com/v4/letter/p/f9ae1b/32.png) [@PDFco](https://community.make.com/u/PDFco)\ **Post date:** [November 1, 2024, 6:25am UTC](https://community.make.com/t/how-to-pass-pdf-to-text/58353/4 "2024-11-01T06:25:21Z")
Hello Matias\_Gallardo, [PDF.co](http://PDF.co) provides a solution for converting PDF documents into text format. You can find more information in our documentation here:[PDF to Text Documentation](https://developer.pdf.co/api/pdf-to-text/index.html). Additionally, we offer tools that allow you to convert PDF documents directly into Excel files, which can also be imported into Google Sheets. For more details, please refer to our documentation here:[PDF to Excel Documentation](https://developer.pdf.co/api/pdf-to-excel/index.html). If you have any questions or need further assistance, please feel free to reach out! ---
**Author:** ![Matias\_Gallardo](https://avatars.discourse-cdn.com/v4/letter/m/ac91a4/32.png) [@Matias\_Gallardo](https://community.make.com/u/Matias_Gallardo)\ **Post date:** [November 5, 2024, 1:09am UTC](https://community.make.com/t/how-to-pass-pdf-to-text/58353/5 "2024-11-05T01:09:52Z")
![screenshot-us2_make_com-2024_11_04-22_07_03](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/d/1/d1d92fbf845f8811d7b6c1f9a1e1dbbd2ec682f6.png) ![screenshot-us2_make_com-2024_11_04-22_07_14](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/e/6/e672bcd4974d8b1c92b2b0d95f04eef0992fac46.png) Hello, although I have tried exporting it from ChatGPT as JSON or using PDFco, I keep getting the same error. I don’t know how to fix it. If anyone has any ideas, I would appreciate it ---
**Author:** ![PDFco](https://avatars.discourse-cdn.com/v4/letter/p/f9ae1b/32.png) [@PDFco](https://community.make.com/u/PDFco)\ **Post date:** [November 7, 2024, 11:33pm UTC](https://community.make.com/t/how-to-pass-pdf-to-text/58353/6 "2024-11-07T23:33:54Z")
Hello [Matias\_Gallardo](https://community.make.com/u/Matias_Gallardo), We’d like to assist you in resolving the issue you encountered. To help us better understand the situation, could you please provide more details and screenshots, especially about your setup? This will help us determine how the issue might have occurred. Best regards, [PDF.co](http://PDF.co) Support Team ---
**Author:** ![Matias\_Gallardo](https://avatars.discourse-cdn.com/v4/letter/m/ac91a4/32.png) [@Matias\_Gallardo](https://community.make.com/u/Matias_Gallardo)\ **Post date:** [November 10, 2024, 11:55pm UTC](https://community.make.com/t/how-to-pass-pdf-to-text/58353/7 "2024-11-10T23:55:44Z")
Hello, good day! I’m sharing these screenshots, but I also want to clarify that I have tried, in the step from pdfco to parse JSON, to use both JSON file formats offered by pdfco: “legacy” and “new”. In the parse JSON step, I tried using the output from pdfco and also manually entering the JSON string ![screenshot-us2_make_com-2024_11_10-20_57_00](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/7/a/7a3239f35653d283f81086eb5bc504e12df9ec21.png) ![screenshot-us2_make_com-2024_11_10-20_46_37](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/5/f/5fba02e1b7df8a91f7cca830ab77de99eb85893e.png) ---
**Author:** ![PDFco](https://avatars.discourse-cdn.com/v4/letter/p/f9ae1b/32.png) [@PDFco](https://community.make.com/u/PDFco)\ **Post date:** [November 12, 2024, 7:37pm UTC](https://community.make.com/t/how-to-pass-pdf-to-text/58353/9 "2024-11-12T19:37:58Z")
Hello [Matias\_Gallardo](https://community.make.com/u/Matias_Gallardo). Thank you for sharing the screenshot! To proceed, please use the generated data from [PDF.co](http://PDF.co) PDF to JSON as a JSON string. For your reference, we have provided a sample screenshot below: ![](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/b/8/b826233a7cbe2370869a1961d35fc006fd768d16.png) If you continue to encounter any issues or need further assistance, please don’t hesitate to reach out. We’re here to help! Best regards, [PDF.co](http://PDF.co) Support Team ---
**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\ **Post date:** [February 10, 2025, 7:45pm UTC](https://community.make.com/t/how-to-pass-pdf-to-text/58353/10 "2025-02-10T19:45:32Z")