Crazy excel help needed... again. Every month I have a monotonous series of tasks to perform in excel and I have exhausted all of the possibilities I know of to make things easier- more details inside. [more inside]
posted by TheBones on Aug 11, 2009 - 17 answers

How do I work with a tab-delimited file when one of the fields is full of tabs? [more inside]
posted by epersonae on Dec 3, 2008 - 20 answers

I've been trying to get a 600 record Excel database into MySQL, and failed at every turn. There must be a way! [more inside]
posted by lemonfridge on Dec 5, 2007 - 15 answers

Is there an easy, preferably open source way of editing MySQL table contents? I was hoping for something which would let me use Excel (or OO Calc) to edit the live database. I need to search/replace many items in a poorly imported database. [more inside]
posted by Yavsy on Feb 6, 2007 - 10 answers