How Can I Convert Multiple JSON Files into PDF, Excel, or CSV Format at Once?

Questions
1

:bullseye: What is your goal?

to solve my technical query related to this product.

:thinking: What is the problem & what have you tried?

Not converting json files into readable formats and i have tried many online tools but all are not perfect.

3
  1. Get the JSON files
    • Google Drive, Dropbox, OneDrive, S3, FTP, Email attachments, etc.
  2. Parse the JSON
    • Use JSON > Parse JSON if the structure is known.
    • If the JSON structure varies, first inspect a sample file and map the fields you need.
  3. Convert to CSV
    • Use an Iterator to process array items.
    • Map the fields into rows.
    • Use CSV > Create CSV.
  4. Convert to Excel
    • Create rows directly in Microsoft 365 Excel or Google Sheets.
    • Alternatively generate a CSV and open it in Excel.
  5. Convert to PDF
    • First transform the JSON into HTML or a formatted document.
    • Then use a PDF service such as PDF.co, Plumsail, PDFMonkey, DocuGenerate, or Google Docs → PDF export.

For multiple files, simply process them in a loop:
List Files → Download File → Parse JSON → Convert → Save Output

The best solution depends heavily on the JSON structure. If you can share a sample JSON file and the desired output format (PDF, Excel, or CSV), the community can suggest the exact modules and mapping strategy.

4

Hey NeillHuman :waving_hand: glad you’re here :partying_face:
Just having a spare time to share the workflow with mock json data

5

Well there we go, great stuff!! @mathew0406 I think John just made your day :clap: