Join 3,424 readers in helping fund MetaFilter (Hide)

11 posts tagged with database and spreadsheet. (View popular tags)
Displaying 1 through 11 of 11. Subscribe:

I've made a huge mistake?

How can I create a web-searchable database of indexed newspaper articles? [more inside]
posted by orrnyereg on Sep 19, 2012 - 6 answers

Spreadsheet vs. Database?

I've been using a spreadsheet (actually, three or four different spreadsheets....) to keep track of names, contact info, and task completion for a large number of people. Would switching to a database ultimately be easier and less stressful? And if so, what would be the best software for a database newbie to use? Or is there some other perfect solution out there? [more inside]
posted by kittenmarlowe on Jan 29, 2012 - 6 answers

Keeping track of payments?

Need ideas on how to keep track of people making multiple payments for large trips or activities, with the ability to report how much they still owe. Much more detail inside. [more inside]
posted by kraigory on May 23, 2011 - 5 answers

How do I turn Gmail into a database?

Is there a way to turn my Gmail account into a database? I have tons of valuable information in my 15 gigabytes Gmail box...can you recommend exciting ways of extracting it? [more inside]
posted by skylar on Feb 3, 2011 - 6 answers

I can build it, I just need to know what kind of bricks.

[web programming filter] I need to build a web page that displays spreadsheet data. The data in the spreadsheet changes depending on which user is logged in to the site. Some of the data is preset and some is entered by the user (and saved between sessions). What might be the most efficient programming solution and the easiest to maintain? [more inside]
posted by Drasher on Aug 3, 2010 - 8 answers

Spreadsheets, Databases - Help Me. Please.

Well, I created a spreadsheet in Google docs. A simple, no frills document where there are various columns - one s for email addresses. Those addresses I want to go into my Address book in either Gmail or Thunderbird. Downloaded the spreadsheet into Excel - in CSV format - tried to save it to text - it's obviously not working. Someone online directed me to the Google Scripts and to API. This is so not my forte' and it's for a non-profit and am getting lost in a sea of geekage. Is there a simple way to just export the column of email addresses, convert them into a database separated by columns, fit for my email program? Thanks in advance.
posted by watercarrier on Jul 21, 2010 - 15 answers

Better than vi versus emacs!

Please help settle a bet: Is a spreadsheet a simple type of database, or are they fundamentally different things? [more inside]
posted by perrce on Apr 2, 2009 - 38 answers

Sort Me Out

I need to create a database in Excel, with clickable column headers (clicking on them will sort by that column). More inside, of course. [more inside]
posted by Rubythursday on Feb 4, 2009 - 7 answers

Help me prioritize the people I bug for money

Excel-filter: I have a spreadsheet with a list of donations made over the past year. Unfortunately, when an individual has donated multiple times within a year there is a new row for each donation. Fortunately, that individual is assigned the same unique identifier. How do I make it so that each individual has one row with total donations for the year? [more inside]
posted by ewiar on May 1, 2007 - 6 answers

Database for a small merchant

Help, business owners! I run a mail order business -- about 3-5 orders a day, with about 15 items in stock. For years I have used an Excel spreadsheet to keep track of orders. Is there a better way? [more inside]
posted by hodyoaten on Oct 2, 2006 - 5 answers

How to run a SQL Query on an Excel Spreadsheet

I have an Excel Spreadsheet (using Excel 2003). Rather than creating formulas to answer ad hoc questions that I have, I would like to be able to quickly type in a SQL querty against the data in the spreadsheet. So, I could scroll down to the bottom of the sheet to see how many rows I have, OR I could type" select count(*) from data_table" instead. I prefer the latter. Any suggestions? [more inside]
posted by apark on Apr 7, 2006 - 6 answers

Page: 1