Daniel J. Choi

Office 2007 MIME Types

Dev

Here’s a list of MIME Types for Office 2007 files (those pesky files extensions that end with an x). Useful for file type checking in web applications and the like.

  • .docm – application/vnd.ms-word.document.macroEnabled.12
  • .docx – application/vnd.openxmlformats-officedocument.wordprocessingml.document
  • .dotm – application/vnd.ms-word.template.macroEnabled.12
  • .dotx – application/vnd.openxmlformats-officedocument.wordprocessingml.template
  • .potm – application/vnd.ms-powerpoint.template.macroEnabled.12
  • .potx – application/vnd.openxmlformats-officedocument.presentationml.template
  • .ppam – application/vnd.ms-powerpoint.addin.macroEnabled.12
  • .ppsm – application/vnd.ms-powerpoint.slideshow.macroEnabled.12
  • .ppsx – application/vnd.openxmlformats-officedocument.presentationml.slideshow
  • .pptm – application/vnd.ms-powerpoint.presentation.macroEnabled.12
  • .pptx – application/vnd.openxmlformats-officedocument.presentationml.presentation
  • .xlam – application/vnd.ms-excel.addin.macroEnabled.12
  • .xlsb – application/vnd.ms-excel.sheet.binary.macroEnabled.12
  • .xlsm – application/vnd.ms-excel.sheet.macroEnabled.12
  • .xlsx – application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
  • .xltm – application/vnd.ms-excel.template.macroEnabled.12
  • .xltx – application/vnd.openxmlformats-officedocument.spreadsheetml.template

Read Next

How to Remove the Top Border from Drupal Tables

Dev

I’ve been very busy developing a couple projects over the past couple days, but here is a quick little trick to get around one of Drupal’s quirks. If you’re unfamiliar with Drupal, it’s a fantastic CMS (content management system) built on PHP and MySQL. For those blog-savvy among us, it is to general websites what WordPress is to blogs. I use Drupal to get sites up quickly and with great functionality, and I highly recommend it to anyone who is looking to build powerful, custom websites without “re-inventing the wheel.”

Anyway, Drupal has this strange quirk in its source that creates a small grey border on the top of tables inserted in a page’s content.  A quick trip to my inspector revealed how to remove the top border from Drupal tables.  Simply add the following line to your CSS.

body tbody { border-top: none; }

All there is to it. 🙂

Export MySQL Query Results to CSV

Dev

If you’re SSH’d into a MySQL server and want to export MySQL query results to CSV (readable by Excel), simply add the below snippet to the end of your query.

INTO OUTFILE '/tmp/results.csv' 
FIELDS TERMINATED BY ',' ENCLOSED BY '"' 
LINES TERMINATED BY '\n'

Note that ‘/tmp/results.csv’ in the code above should correspond to a writeable destination, and the file can’t already exist.

© 2026 Daniel J. Choi

Sliding Sidebar

My friends call me Dan.

Currently, building Recca.

Previously, co-founder @ Plastiq.

Recent Posts

Categories