I am trying to make a python script that takes a CSV file and turns it into an HTML table. I need it to combine a column containing a website name and another column containing a URL into an HTML link. [more inside]
posted by Mjolnir on Aug 23, 2009 - 7 answers

Using a relational table in a one-to-many relationship in Access, what is the best way to export a csv file with one row per record (from the one half) with a variable number of columns (from the many half)? [more inside]
posted by JeremiahBritt on Aug 19, 2009 - 6 answers

ExcelMacroFilter: Writing a macro that imports a series of .csv files into their own worksheets in the same workbook in Excel 2007 would save me ridiculous amounts of time. I have written a macro to import the files and rename the worksheet accordingly, but I'm new to VBA and can't for the life of me work out how to get Excel to automatically repeat the import from File_1.csv to File_x.csv. Help please? [more inside]
posted by cholly on Jul 30, 2009 - 4 answers

I have a CSV file relating a measurement value with elapsed time. I'd like to overlay the changing measurement value over a video, using the time values in the CSV to sync the two. I have a MacBook, iMovie, and not much else. Is there a reasonably cheap or free way to do this?
posted by tirade on Jun 17, 2009 - 2 answers

I'm using a shell script to handle some excel docs by converting to csv and reformatting it a little bit. I'm having some difficulty going on with the next part of the script. Some help would be great. :) [more inside]
posted by fightoplankton on Jun 10, 2009 - 11 answers

This is a long question about CSVs, Excel, Imports and byte-sizes. Here's the rub: I have two completely identical files. They contain exactly the same characters in the same order. One has been opened and saved (Not altered in any way) in Excel. The other has not. The one opened in Excel is 20 bytes larger. The ERP will only accept the one saved in Excel. Why? More inside. [more inside]
posted by GilloD on May 14, 2009 - 34 answers

How do I view .csv (comma-separated values) files IN Firefox in a nice fixed-width column format? [more inside]
posted by shmooly on Apr 15, 2009 - 4 answers

Excel is chapping my hide. I have a comma-delimited .csv which contains quote-demarcated text fields. The source of my never-ending joy is the recurrent use of inch-marks and commas within the textfields. Right this way... [more inside]
posted by mwhybark on Feb 25, 2009 - 18 answers

I have a large amount of csv data that I need formatted in a certain way. How do I do this? [more inside]
posted by sidr on Feb 13, 2009 - 11 answers

Excel: I have a long list of 2000 items addresses in a csv. That single column is all there is. Need to chop that list into 10 separate csv files of 20 items each. Is there a way to automate this? [more inside]
posted by skypieces on Jan 21, 2009 - 7 answers

I need a freeware app that can efficiently view and edit massive CSV files. I have a couple of 6K column csv files I need to look at and edit. [more inside]
posted by srboisvert on Dec 18, 2008 - 12 answers

How can I take a sports schedule in a table format and easily make an iCal calendar? [more inside]
posted by theichibun on Dec 15, 2008 - 3 answers

What's the simplest way for me to grab a daily digest of my twitter output? [more inside]
posted by cortex on Oct 29, 2008 - 6 answers

I have a mysql table, and i have a csv file. I need to update some(not all) rows in the mySQL DB using the data in the CSV file. Is there an easy way to do it? There are about 2700 rows that need to get updated. 3 of the cols. in the CSV can be used to find the correct rows in the DB (and yes, I am in fact a n00b) (everything is on a windows machine)
posted by photodegas on Sep 9, 2008 - 4 answers

I need to save an Excel csv file of numbers with leading zeroes (e.g., 00987654). [more inside]
posted by archimago on Aug 20, 2008 - 8 answers

What are the field names for importing a csv file into google calendar besides (Subject, Start Date, Start Time) and do you have any cool tricks when importing info into googlecal?
posted by drezdn on Jul 15, 2008 - 2 answers

I've just uploaded a .csv email list of about 9000 people to phplist... but phplist shows the list as having 0 members. (Actually, I've gotten this result twice... with two different 9000 member lists.) Any guesses as to what I'm doing wrong... or what I should be doing differently? Thanks! (Host: Hostgator)
posted by darth_tedious on Jul 11, 2008 - 4 answers

Using OpenOffice Calc (Spreadsheets) - Is there any way to divide the strings in one column into two by the space in each cell? [more inside]
posted by l33tpolicywonk on May 30, 2008 - 5 answers

Converting CSV to TAB: is there a free software for this? [more inside]
posted by Oneirokritikos on Feb 28, 2008 - 14 answers

ParseFilter: I have a CSV file full of leads I need to parse into a more, er, concise format. What would the hive mind recommend? [more inside]
posted by cdmwebs on Nov 3, 2007 - 23 answers

(Geekfilter) Can I convert Earthlink TotalAccess (WinXP PC) Email (.dat or .csv) mailboxes to Apple Mail (.mbox) mailboxes on a Mac? (AKA: How can Earthlink be this stupid?) [more inside]
posted by spitbull on Jul 9, 2007 - 5 answers

I am trying to find a way to generate a CSV table based on output from two or more command line programs (DOS on Windows XP). [more inside]
posted by nasreddin on May 23, 2007 - 7 answers

Automate Excel Filter..... I am getting via email a CSV file daily that I would like to automate into excel. [more inside]
posted by keep it tight on May 14, 2007 - 4 answers

Why is my CSV export missing commas, which is foiling my upload? [more inside]
posted by fijiwriter on Feb 14, 2007 - 16 answers

Is there an easier way to combine CSV files? There is a bit [more inside]
posted by keep it tight on Jan 9, 2007 - 9 answers

How can I view and search csv files exported from excel on my mac, using free tools?
posted by mecran01 on Oct 28, 2006 - 9 answers

How do I export Outlook messages without losing the dates/times? [more inside]
posted by zharptitsa on May 24, 2006 - 4 answers

So I'm doing my expenses, and I want to see every night I sent an email after 8:00 or so, because that implies I took a cab home that night. (I can bill them without receipts, but I want to be honest and I'm doing this for a couple months.) Is there a way to export email headers from Outlook to excel or a csv file, so I can sort them by time and count up my trips?
posted by mtstover on Mar 27, 2006 - 6 answers

Suppose you wanted to scrape information from a web page and dump it into a CSV file for use in a database - specifically a large table of contact information coded in HTML. Is there an application (I work in OS X, but have access to Windows machines) that will do this? Would it be possible to write up an AppleScript or something similar to do the job?
posted by aladfar on Feb 7, 2005 - 17 answers

HTML form to CSV file: Simple enough for a remedial programmer, but difficult for an artsy designer. Any advice? [mi] [more inside]
posted by aladfar on Oct 22, 2004 - 6 answers

I have several hundred contacts with all sorts of information in my old OS9 outlook, which I must keep using for awhile due to our antiquated network. However, I was able to export my contacts as a "csv" file which seems to be some sort of excel spreadsheet. How do I import it into my OSX address book?
posted by luriete on Oct 14, 2004 - 7 answers