Freelance Project

All freelance projects at One Location


Strip / Parse Excel Doc To Db 18.09.08

I have a CSV I've put together comprised of approximately 100 Named Sheets. Each Sheet has data in Column A, anywhere from 10 - 1000 Cells (e.g. A1 - A1000) and totalling about 8,000 Cells. I need the cells extracted to my MySql so I can process further with scripts (next project). Fairly simple rules, such as each cell has 1-3 fields that need to be extracted, hierarchies are based on indents. It will end up (I hope) as two tables, each with 2-4 fields and a relation between them. I don't want the csv parsed as much as I want the script written so I can do it and tweak it.


If you enjoyed this post, make sure you
Subscribe to my RSS feed!


  • Freelance Arena
  • Unique Premium WordPress Themes
  • teliad - the marketplace for text links