HACKER Q&A
📣 stillrecursing

Do you ETL Excel files/pdfs


What's the best way to do it?


  👤 warrenm Accepted Answer ✓
What do you want to do with the resultant "extracted" data from said PDFs and Excel files?

The simplistic answer for Excel files is "save as csv"

...but you lose all the formulae in the process

If the formulae are not "important" to you, it's the "right" answer

If the formulae matter ... then there's a much more involved process that's going to vary per file