What is excel-style software to manage large database?

Community Tips and Resources
#1

Hi all,

I have a database in Excel spreadsheet - more than 300Mb. I can use Excel to do some works to extract data, filtering, etc. However, it’s too slow. Can you suggest any software in Excel-style that allows me to work with large files like this?

Thanks so much,

#2

You could get a free Public Tableau account, download the free version of Tableau and analyze it (can also do calculations) while creating basic graphs, plots.

Or, you could save it as a csv file and load it into a Jupyter or Colab notebook and import pandas, numpy and scipy and analyze it that way with python.

2 Likes