Does anyone know of a friendly program for batch-converting a folder full of hundreds of HTML tables to CSV format that will load in Google Spreadsheets? I know I could just load one in Excel but I need to automate it to handle tons of these files.
posted by johngoren
on Aug 7, 2014 -
9 answers

I am using Excel 2011 on Mac OS X Lion. I have a workbook created by a colleague with 25 worksheets in it. I would like to export all of these to individual csv files. Is there a way to do it all in one batch? [more inside]
posted by bluefly
on Jul 22, 2013 -
2 answers

Hi, I have a .csv that exceeds the maximum number of rows that Excel can handle, and before I can import it into a geodatabase in ArcGIS, I need to make one small edit – I need to delete the first row. Is there any way to do this and resave the file (preferably in a format other than .csv) in a way that retains the rows unable to be loaded in Excel?
posted by avocet
on May 9, 2013 -
20 answers

Question about splitting data into columns: I have one column of data that I'd like to split into seven separate columns. A typical, complete row in the column looks like "mefi:1,​ask:3,​meta:2,​projects:5,​jobs:5,​music:6,​irl:4" where the number values can be anywhere from 1-6. The problem is that if any one or more of the seven subsites are left unanswered, the entire value is missing (there is no "[subsite]:0" or "," as a placeholder). Consequently, separating the column into seven distinct columns using the comma as the separator causes the data to fall/shift into the wrong output columns if any one or more of the seven subsite categories are missing. How can i fix this? [more inside]
posted by iamkimiam
on Sep 21, 2012 -
7 answers

About a dozen people have tried to solve this. All failed. Exporting from Excel to .csv causes cells to show #NAME? instead of the actual value. [more inside]
posted by Mr_Zero
on Jun 30, 2011 -
7 answers

I make mailing labels by pulling information about specific real-world locations into small database files. I used to get MS Access-ready DBase files, but now I have to work with CSV files, which don't seem to play well with Access. Please help me get more use out of Access, find out how to convert CSV to DBase or similar file types, or figure out better ways to use Excel. Long version inside. [more inside]
posted by filthy light thief
on May 16, 2011 -
7 answers

I would like to take the information from this Wikipedia page (the HTML table parts) and dump it into Excel. I don't need the flags, I just need the latitude, longitude, city name and country. What's the easiest way of doing this? [more inside]
posted by jontyjago
on Jul 10, 2010 -
7 answers

I suspect I have a problem using OS X to upload a CSV file to a webform, and I suspect I’ll need an XLS guru to help me figure it out. [more inside]
posted by digitalprimate
on Apr 13, 2010 -
7 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'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

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

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

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

Page:
1

About Ask MetaFilter

Ask MetaFilter is a question and answer site that covers nearly any question on earth, where members help each other solve problems. Ask MetaFilter is where thousands of life's little questions are answered.