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
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
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 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
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
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
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?
[more inside]
posted by soulbarn
on Aug 12, 2009 -
3 answers
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
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 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
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
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
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
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
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
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
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
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
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
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
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
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
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
Invoicing with MS Excel--squeezing relational database features out [MI]
posted by adamrice
on Feb 17, 2004 -
10 answers
