58 posts tagged with csv.
Displaying 1 through 50 of 58. Subscribe:

How do I import a CSV file into MySQL

I am using mysql for the first time and I need to create a table using syntax to population a table with approximately 6000 rows. I am having trouble figuring out Bulk Import and Import From and am finding the explanations on the internet to be over my head. Can anyone explain this using language and steps suitable for a beginner?
posted by DorothySmith on Jan 22, 2016 - 12 answers

Reading a CSV file in R, problems with escaped quotes?

I'm beginner-level with R, trying to work with a CSV file. I've noticed some rows are being interpreted incorrectly, and would like some help figuring out a way around that. I think the problem is escaped quotes not being parsed how I would like. [more inside]
posted by RobotHero on Oct 29, 2014 - 9 answers

Best way to convert 900 HTML table files to CSV?

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

Document-Oriented Database for Non-Programmers?

Is there such a thing as a Document-Oriented Database for Non-Programmers? I've been searching the web for several days and I'm quite confused so I thought to post here. [more inside]
posted by dylan_k on Dec 3, 2013 - 20 answers

How to Export All Sheets in an Excel File?

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

Adventures in giant-CSV land

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

please help my create a spreadsheet from a list of links.

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

How can I separate this data column properly?

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

Bringing business cards into 2012

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

Bookfort self-destruct will commence in 5 ... 4 ... 3 ...

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

Help a noob out.

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

Convert text with whitespace to csv

perl or sed or awk help for newbie [more inside]
posted by v-tach on Mar 20, 2012 - 26 answers

Simple data extraction program from TXT to CSV?

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

Make Excel stop babysitting me.

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

This is the dumbest thing I've done in a while...

I desperately need help importing a CSV file as EMAIL into Outlook 2010 inbox. [more inside]
posted by lattiboy on Sep 8, 2011 - 5 answers

Help me deal with a huge text file!

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

Saving .csv files in Excel

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

How can I more easily edit CSV tables in Access or Excel?

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

File Conversion - XML - CSV?

Advice on converting XML to csv. [more inside]
posted by a womble is an active kind of sloth on Apr 6, 2011 - 2 answers

MySQL: How to Selectively Update a Table from a CSV List?

MySQL: How Do I Selectively Update a Table from a CSV List? [more inside]
posted by darth_tedious on Nov 18, 2010 - 8 answers

How Do I Extract Multiple Data and Put Them into CSV Format?

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 to export data from a SQL database into a CSV file and add some new data?

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

HTML Table to Excel to CSV

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

How do I get a CSV file to display properly?

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

Turns out our top referrer is Zombo.com

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

Column-oriented CSV in Python?

Is there a simple, elegant way to iterate over columns in CSV files using Python? [more inside]
posted by Kadin2048 on Jan 11, 2010 - 13 answers

How many rows in an xls file

How to tell how many rows are in an excel file? [more inside]
posted by missmagenta on Dec 20, 2009 - 8 answers

Help me with a tricky (for me) Python problem

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

How to export csv with variable number of columns?

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

Help required for Excel VBA n00b

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

Can I overlay CSV data onto a video?

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

Shell script handling CSV columns

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

What deep magyck is Excel wielding to make my CSVs work?

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 files IN Firefox in a nice fixed-width column format?

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 delimited text import FAIL

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

csv data formatting

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

Split one long column to multiple CSVs in Excel?

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

CSV editor capable of editing giant files

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

Lazy Calendar Copying

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?

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

mySQL + CSV file = grey hair.

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

CSV Help!

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

Importing csv file into Google Calendar

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

PHPList: 9000 members uploaded, 0 displaying.

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

Splitting Strings in Spreadsheets?

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

Free CSV to TAB?

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

Address Parsing 101, please!!

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

Move a mailbox out of Earthlink Total Access?

(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

Integrating the output of 2+ programs?

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

Help me autoimport!

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

Page: 1 2