I’ll load it into mysql if I’m doing anything intensive with it. The joy of excel though is that I don’t need to. I’ll often use excel to quickly tidy the data, remove unwanted fields or run some string functions before loading into a database. Quicker that way.
Likewise sometimes you just want to pull out a few rows quickly.
2 million cells isn’t actually much, particularly if the data has a few dozen fields.
I’ll load it into mysql if I’m doing anything intensive with it. The joy of excel though is that I don’t need to. I’ll often use excel to quickly tidy the data, remove unwanted fields or run some string functions before loading into a database. Quicker that way.
Likewise sometimes you just want to pull out a few rows quickly.
2 million cells isn’t actually much, particularly if the data has a few dozen fields.
I’ll load it into mysql if I’m doing anything intensive with it. The joy of excel though is that I don’t need to. I’ll often use excel to quickly tidy the data, remove unwanted fields or run some string functions before loading into a database. Quicker that way.
Likewise sometimes you just want to pull out a few rows quickly.
2 million cells isn’t actually much, particularly if the data has a few dozen fields.
I’ll load it into mysql if I’m doing anything intensive with it. The joy of excel though is that I don’t need to. I’ll often use excel to quickly tidy the data, remove unwanted fields or run some string functions before loading into a database. Quicker that way.
Likewise sometimes you just want to pull out a few rows quickly.
2 million cells isn’t actually much, particularly if the data has a few dozen fields.
Phil Buckley says
Not used it since 2006 Alan Stainer – have I missed it? Nope
Phil Buckley says
Not used it since 2006 Alan Stainer – have I missed it? Nope
Phil Buckley says
Not used it since 2006 Alan Stainer – have I missed it? Nope
Phil Buckley says
Not used it since 2006 Alan Stainer – have I missed it? Nope
Mat Bennett says
Me! I like Google apps, but I can’t be without excel. The 2 million cell limit doesn’t even come close for me.
Mat Bennett says
Me! I like Google apps, but I can’t be without excel. The 2 million cell limit doesn’t even come close for me.
Mat Bennett says
Me! I like Google apps, but I can’t be without excel. The 2 million cell limit doesn’t even come close for me.
Mat Bennett says
Me! I like Google apps, but I can’t be without excel. The 2 million cell limit doesn’t even come close for me.
James Lane says
Mat Bennett You have more than 2 million cells in a spreadsheet?
James Lane says
Mat Bennett You have more than 2 million cells in a spreadsheet?
James Lane says
Mat Bennett You have more than 2 million cells in a spreadsheet?
James Lane says
Mat Bennett You have more than 2 million cells in a spreadsheet?
Alan Stainer says
Mat Bennett if you are using that many cells, I suggest using a database instead!
Alan Stainer says
Mat Bennett if you are using that many cells, I suggest using a database instead!
Alan Stainer says
Mat Bennett if you are using that many cells, I suggest using a database instead!
Alan Stainer says
Mat Bennett if you are using that many cells, I suggest using a database instead!
Mat Bennett says
I’ll load it into mysql if I’m doing anything intensive with it. The joy of excel though is that I don’t need to. I’ll often use excel to quickly tidy the data, remove unwanted fields or run some string functions before loading into a database. Quicker that way.
Likewise sometimes you just want to pull out a few rows quickly.
2 million cells isn’t actually much, particularly if the data has a few dozen fields.
Mat Bennett says
I’ll load it into mysql if I’m doing anything intensive with it. The joy of excel though is that I don’t need to. I’ll often use excel to quickly tidy the data, remove unwanted fields or run some string functions before loading into a database. Quicker that way.
Likewise sometimes you just want to pull out a few rows quickly.
2 million cells isn’t actually much, particularly if the data has a few dozen fields.
Mat Bennett says
I’ll load it into mysql if I’m doing anything intensive with it. The joy of excel though is that I don’t need to. I’ll often use excel to quickly tidy the data, remove unwanted fields or run some string functions before loading into a database. Quicker that way.
Likewise sometimes you just want to pull out a few rows quickly.
2 million cells isn’t actually much, particularly if the data has a few dozen fields.
Mat Bennett says
I’ll load it into mysql if I’m doing anything intensive with it. The joy of excel though is that I don’t need to. I’ll often use excel to quickly tidy the data, remove unwanted fields or run some string functions before loading into a database. Quicker that way.
Likewise sometimes you just want to pull out a few rows quickly.
2 million cells isn’t actually much, particularly if the data has a few dozen fields.
James Lane says
=if(MB1=”Unnecessarily large spreadsheet”,”Microsoft Excel”,”Google Sheets”)
James Lane says
=if(MB1=”Unnecessarily large spreadsheet”,”Microsoft Excel”,”Google Sheets”)
James Lane says
=if(MB1=”Unnecessarily large spreadsheet”,”Microsoft Excel”,”Google Sheets”)
James Lane says
=if(MB1=”Unnecessarily large spreadsheet”,”Microsoft Excel”,”Google Sheets”)
Mat Bennett says
^ pretty much nails is :)
SEO Tools for excel is the other thing I’d miss, although that is preference over necessity
Mat Bennett says
^ pretty much nails is :)
SEO Tools for excel is the other thing I’d miss, although that is preference over necessity
Mat Bennett says
^ pretty much nails is :)
SEO Tools for excel is the other thing I’d miss, although that is preference over necessity
Mat Bennett says
^ pretty much nails is :)
SEO Tools for excel is the other thing I’d miss, although that is preference over necessity