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

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

Looking to extract more info from this database

We are storing information about application hits in a database. Sadly my database/excel skills are pretty limited and I'd like some help getting more info out of the information we have. [more inside]
posted by Admira on Jul 17, 2013 - 11 answers

Data overload

I'm designing and managing a very ambitious data visualization app for the arts and culture sector, and am trying to find the best way to organize the data types and attributes. Excel just ain't doin' it anymore. [more inside]
posted by nosila on May 30, 2013 - 6 answers

Need a simple database solution (I think)

I'm compiling an Excel spreadsheet full of personal data. What my employer would like to do is add that information to their existing website and make it searchable and filterable, so that researchers can filter out all guys who were born in year X or town Y, search for all guys named Cohen, etc. [more inside]
posted by Palindromedary on Apr 16, 2013 - 6 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

Help me be the best data guy I can be

Part of my current job involves manipulating a large amount of data. I need to learn how to do this more efficiently and on a larger scale. What should I use? What should I learn? What is the best (free) way to teach myself? [more inside]
posted by dersins on Jun 18, 2012 - 26 answers

Microsoft Acess Charts dead-end.

Microsoft Access 2007 - how on earth do I cut / copy / export / do anything with my Pivot Chart, besides print it? [more inside]
posted by Jimbob on Nov 23, 2010 - 12 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

Analyzing Surname Data

I need help visually and clearly showing/analyzing surname data retrieved from 23andme.com's Relative Finder feature. [more inside]
posted by angelaas525 on Jul 9, 2010 - 4 answers

What blogs/books should I read before creating an archival database?

I'm making an archival database (in Excel) with about 10,000 rows and 6-7 columns for each row. I'm doing this so the information will be easy to cross-reference and search. I've never done anything like this before and am looking for books, blogs, etc. for tips, suggestions, and anything that will make my life and this project easier.
posted by melodykramer on Mar 29, 2010 - 16 answers

I want to turn my Google Docs spreadsheet of a route into something prettier with photos and stats - how to do it easily?

I want to turn my Google Docs spreadsheet of a route into something prettier with photos and stats - how to do it easily? [more inside]
posted by soulbarn on Aug 12, 2009 - 3 answers

Serious help needed with Excel

Crazy excel help needed... again. Every month I have a monotonous series of tasks to perform in excel and I have exhausted all of the possibilities I know of to make things easier- more details inside. [more inside]
posted by TheBones on Aug 11, 2009 - 17 answers

Looking ideas on what systems can be used for efficient internal business reporting in a small / medium business

What efficient systems can one use to report different internal working data generated in a small / medium sized business - excel is too clumsy and a customized database based application feels like an overkill? [more inside]
posted by shalam on May 17, 2009 - 6 answers

How to extract data from HTML

How to extract data automatically from a group of HTML pages to an Excel file or to a database? [more inside]
posted by elgilito on Apr 22, 2009 - 5 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

Timeline Charts on Steroids

I am tasked with preparing a multi-category, filterable timeline as a work project. I think Access is probably the best way to do this, but I need some help with the mechanics, or suggestions on where to find a template. [more inside]
posted by Inkoate on Oct 11, 2008 - 1 answer

Escaping the grind

My friend works in database applications each day to create in house reports. He's bored and wants to go it alone. [more inside]
posted by simplesharps on Sep 3, 2008 - 0 answers

Getting Excel to count the number of repititions in a column?

Excel Filter : I've got a list of a lot of names. All the names are in one column with a different name on each row. The names repeat a varying number of times. How can I get Excel to count how many times each name repeats and then put that number in a column next to the name? [more inside]
posted by Autarky on Aug 15, 2008 - 3 answers

Gathering ebay infos.

cp /mnt/com/ebay/completed_auctions/ps3 ~/ps3.txt ?? [more inside]
posted by SirStan on Jul 23, 2008 - 6 answers

Merge Excel worksheets?

What's the easiest way to merge data from multiple Excel worksheets into one big worksheet [more inside]
posted by ewiar on Jul 21, 2008 - 2 answers

How can I get the USDA's nutrition data into excel?

How can I get data from the USDA's food database into excel? [more inside]
posted by Nish ton on Jan 5, 2008 - 8 answers

Please save me from "Excel Hell"

I need suggestions for an application (or database) to help my employer keep better track of live-trivia scorekeeping results. They are currently doing it all in various separate Excel spreadsheets, and this is (almost) 2008, so I'm sure there must be a better way. [more inside]
posted by jmnugent on Dec 24, 2007 - 3 answers

Help me Excel.

Please help me create an expandable excel function that can find and extract cell rows. [more inside]
posted by guruguy9 on Oct 11, 2007 - 5 answers

Help me merge Excel with Access:

How do I add a 4,000 name MS Excel file to an existing MS Access database? [more inside]
posted by 2bucksplus on Jul 2, 2007 - 3 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

How to easily search/replace in MySQL database?

Is there an easy, preferably open source way of editing MySQL table contents? I was hoping for something which would let me use Excel (or OO Calc) to edit the live database. I need to search/replace many items in a poorly imported database. [more inside]
posted by Yavsy on Feb 6, 2007 - 10 answers

Save me two weeks of manual labor, please

I have a data set of approximately 9,000 hip-hop tracks. It's in an Excel file. I have the song title, the artist, and the album. Now I just need the year. How can I find and automatically import the year into the Excel file without manually looking up every track on Google? Is there a way to do this with MusicBrainz or a similar database?
posted by schroedinger on Jan 26, 2007 - 9 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

MS Excel database question

Basic Microsoft Excel question. How do I join two databases together when they share elements but are not coextensively equal? (More) [more inside]
posted by Mr. Justice on Jan 22, 2006 - 8 answers

DatabaseFilter: Linked tables

Database 101... I have two tables, with one common field, an ID number. One table has many more records than the other. How can I tell which records in the 'big' table are also in the 'small' table? [more inside]
posted by clgregor on Sep 2, 2005 - 5 answers

I need some relational database features for invoicing in MS Excel.

Invoicing with MS Excel--squeezing relational database features out [MI]
posted by adamrice on Feb 17, 2004 - 10 answers

Page: 1