All Questions
4
questions
1
vote
0
answers
667
views
Use Microsoft Excel to import and refresh data from only some columns of a CSV
I have a CSV that's 100+ MB, so it takes a long time to load.
In Microsoft Excel for Mac Version 16, I'd like to use the "Get data" or a similar functionality to load data from that CSV into ...
3
votes
2
answers
2k
views
How do I clean ~500,000 records in Excel 2010 without crashing my PC?
I have to remove large chunks of information from tables in .xlsx files using Excel 2010. Every method I have tried so far has produced no results, either crashed or I've killed it after waiting for a ...
-1
votes
1
answer
103
views
Excel; How do I import CSV table as rows seperated by table number?
So I have a MASSIVE data set, in its unprocessed format it is a CSV file and contains two column tables that are stacked on top of one another. in the picture below the delimited version of the file ...
-5
votes
2
answers
8k
views
How do I convert a .csv file to a database?
I have an 8GB .csv file with 6 columns and 202,176,000 rows.
How would I convert that to an OpenOffice database(.db) file?