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
I want to create a spreadsheet from the hyperlinks and words in a word list on Wiktionary. Please take me through the steps. Thanks!
[more inside]
posted by iamkimiam
on Nov 20, 2012 -
8 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
Android/cloud-based note app query. I'm looking for recommendations for an Android app that'll accept the large chunk of csv data I have and keep it synced with my PC.
[more inside]
posted by jonathanbell
on Jul 23, 2012 -
5 answers
I have a large number of books that I want to donate to a library or sell. I want to give my friends and family first pick at anything they want (my primary aim is to quickly reclaim the physical space used up by the books). I need a workflow that will allow me to scan the books' UPCs, etc. with my iPhone 4's camera and end up with an email-able spreadsheet
pre-populated with ISBN/Title/Author. Columns for genre, edition and/or year, and short blurbs would also be welcome.
I have a PC laptop with the MS Office suite in addition to the iPhone. What are my options? Thanks, hivemind!
posted by Inspector.Gadget
on May 20, 2012 -
6 answers
Programming challenge: pull XML data with an HTTP GET, process and/or lightly transform it, and output a csv file. Please help me figure this out in Java or tell me what other language to use.
[more inside]
posted by Aizkolari
on Mar 27, 2012 -
19 answers
I have several hundred machine-generated, human-readable TXT files; one text file per serialized device tested. Each file has test values in predictable places, although in a very irregularly-shaped "table" if you could even call it that. I want a simple Windows program where I say: "Okay, program, here's the row and columns where field #1 starts and ends, ... here's the row and columns where field #n starts and ends ... Give me a CSV file with those values I need and nothing more."
[more inside]
posted by ZenMasterThis
on Jan 14, 2012 -
18 answers
Excel is treating me like a child because it thinks I can't tell the difference between .csv and .xlsx. It's wasting my time. Help?
[more inside]
posted by ootandaboot
on Dec 5, 2011 -
9 answers
On a Win7 desktop, how can I open and read a 1.61 GB CSV file containing text (kind of an archive of e-mails) without freezing up the system?
posted by vidur
on Sep 1, 2011 -
12 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
Extract
Multiple Data (email, names, dates, and IDs) from a Huge Messy Text File, and Sort Them into a CSV: How do I do this? I've read this on extracting
emails, but I can't figure out how to do this with several different data points.
[more inside]
posted by darth_tedious
on Oct 19, 2010 -
19 answers
How can I export data from a SQL database into a CSV file and add a new column at the same time?
[more inside]
posted by jfricke
on Sep 8, 2010 -
8 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
What are best enterprise level Web Analytic / Stat programs that work with IIS and Apache sever logs?
[more inside]
posted by wcfields
on Mar 10, 2010 -
1 answer
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
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
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
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
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
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
