The openFDA drug enforcement reports API download returns results in one large JSON file.

Unfortunately I have no experience in parsing/programming JSON and I need the drug enforcements data in Excel/CSV format (2004-present as far as I know).

Can anyone help please?

  • What data are you talking about? Please provide a link. Commented Mar 13, 2017 at 21:56
  • Thanks a lot for your answer! I really appreciate. I want to get these data on drug enforcments: open.fda.gov/drug/enforcement/reference Commented Mar 14, 2017 at 9:31
  • 1
    I have edited your question to exactly describe the issue. Please take some time next time to do the same.
    – user4293
    Commented Mar 14, 2017 at 13:01

1 Answer 1


Download the JSON file and open it with a Json to CSV converter like http://www.convertcsv.com/json-to-csv.htm

You will get this file.

  • Thank you very much. My problem is that the JSTON file that is downloadable contains only 2012-2017 records. However OpenFDA says that "The openFDA drug enforcement reports API returns data from the FDA Recall Enterprise System (RES)... Currently, this data covers publically releasable records from 2004-present". And I am not able to run openFDA API queries to retrieve the data starting from 2004. Thanks again for help. Commented Mar 14, 2017 at 13:50
  • Their database does not allow you to go back before 2012, and their APIs neither. You may want to check if someone has this data or ask the US Food & Drug Administration directly. Commented Mar 14, 2017 at 14:32
  • I see. I will probably make a Freedom of Information Act (FOIA) request. Thanks for help. fda.gov/RegulatoryInformation/FOI/HowtoMakeaFOIARequest/… Commented Mar 14, 2017 at 14:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.