Table of Contents
In this article, we will see how to install Gnumeric(ssconvert) on Windows 10 using 2 different methods. Gnumeric is a free and open source spreadsheet program that comes with number of other tools such as ssconvert, ssdiff, ssgrep etc which are used for interaction and manipulation of data. The number of features provided by Gnumeric makes it the most suitable spreadsheet program to use. It is used for performing complex calculation with high accuracy.
It is also used for creating and displaying different graphical plots such as bar plots, line graphs, pie charts or radar charts etc. It is also easy to install and use in Windows based systems. Here we will see different methods that you can employ to install Gnumeric on Windows 10 system.
How to Install Gnumeric(ssconvert) on Windows 10 Using 2 Methods
There are two different methods to install Gnumeric in Windows 10 based systems. You can use either of the method depending on your requirement and tools availability.
Method 1: Using Chocolatey
First and foremost method to install Gnumeric package is through Chocolatey software. If you have this software management tool installed in your System then you can follow below steps to install Gnumeric in your System.
Step 1: Prerequisites
a) You should have a running
Windows 10 System.
b) You should have atleast
Windows Powershell 5.0 enabled in your System.
c) You should have
Execution Policy set in your PowerShell.
d) You should have administrator access to run privileges command in your PowerShell.
Step 2: Open Powershell
Windows Powershell from the search box showing on the bottom left of your screen.
Once it appears, right click on it and select
Run as administrator. If it asks for administrator password, provide the password to open. Type
cd \ command to come to the root path of C drive.
Step 3: Search Gnumeric
To search the availability and current version of Gnumeric application, you need to use
choco search gnumeric command as shown below. As you can see from output, the current available approved version is
PS C:\> choco search gnumeric Chocolatey v1.2.0 gnumeric 126.96.36.19900531 [Approved] 1 packages found.
Step 4: Check Info
To know more about the application, you can run
choco info gnumeric command as shown below. This will give you some of the important information such as approver name, version, testing status, package url, license information etc.
PS C:\> choco info gnumeric Chocolatey v1.2.0 gnumeric 188.8.131.5200531 [Approved] Title: Gnumeric Spreadsheet | Published: 17-06-2020 Package approved by mwallner on Jul 22 2020 17:03:13. Package testing status: Passing on Jun 17 2020 21:29:52. Number of Downloads: 1115 | Downloads for this version: 760 Package url Chocolatey Package Source: https://github.com/roelvandersteen/chocolatey/tree/master/gnumeric Package Checksum: '7lrRYI2CjyiAXgAeiXCBth/dHXCVq5JmBk2iF7n+XYHgL71kHATgZR/5JC1RqWUOP4O5Ubjp868+lTM+6QRkyg==' (SHA512) Tags: gnumeric spreadsheet xls gnome Software Site: http://www.gnumeric.org/ Software License: http://git.gnome.org/browse/gnumeric/tree/COPYING-gpl3 Summary: Free, fast, accurate - Pick Any Three! Description: Gnumeric is an open-source spreadsheet program. Gnumeric is... Free: Gnumeric and its source code are available free of charge, licensed under the terms of the GNU General Public License version 2 or version 3. Fast: Gnumeric starts up quickly and handles large spreadsheets while remaining responsive. Accurate: A spreadsheet should calculate the right answer. Gnumeric's built-in functions and tools are accurate as several researchers have found. This package refers to the 32-bit installer. There is no 64-bit Windows version. Release Notes: https://gitlab.gnome.org/GNOME/gnumeric/-/blob/master/ChangeLog 1 packages found.
Step 5: Install Gnumeric
In the next step, you can install Gnumeric application by running
choco install gnumeric command as shown below.
PS C:\> choco install gnumeric Chocolatey v1.2.0 Installing the following packages: gnumeric By installing, you accept licenses for the packages. Progress: Downloading gnumeric 184.108.40.20600531... 100% gnumeric v220.127.116.1100531 [Approved] gnumeric package files install completed. Performing other installation steps. The package gnumeric wants to run 'chocolateyInstall.ps1'. Note: If you don't run this script, the installation will fail. Note: To confirm automatically next time, use '-y' or consider: choco feature enable -n allowGlobalConfirmation Do you want to run the script?([Y]es/[A]ll - yes to all/[N]o/[P]rint): y Installing 64-bit gnumeric... gnumeric has been installed. gnumeric may be able to be automatically uninstalled. The install of gnumeric was successful. Software installed as 'exe', install location is likely default. Chocolatey installed 1/1 packages. See the log for details (C:\ProgramData\chocolatey\logs\chocolatey.log).
Step 6: Setting Path
Now that application is installed successfully, you need to permanently set the
Path environment variable using
setx /M path "%path%;C:\Program Files (x86)\Gnumeric\1.12.17\bin" command as by default system will not detect the path of Gnumeric tools.
PS C:\> setx /M path "%path%;C:\Program Files (x86)\Gnumeric\1.12.17\bin" SUCCESS: Specified value was saved.
Step 7: Using ssconvert
Now that Gnumeric application is installed, it is time to demonstrate the usage of
ssconvert utility. Here we have a sample excel file called
excel_example.xlsx. We are going to convert this excel file to csv format by using
ssconvert excel_example.xlsx excel_example.csv > $null 2>&1 command as shown below. You might also notice that we are redirecting all the output and error to
PS C:\> ssconvert excel_example.xlsx excel_example.csv > $null 2>&1
After conversion, you can check the
excel_example.csv file by using
dir excel_example.csv command as shown below.
PS C:\> dir excel_example.csv Directory: C:\ Mode LastWriteTime Length Name ---- ------------- ------ ---- -a---- 16-07-2023 14:54 237 excel_example.csv
Step 8: Uninstall Gnumeric
Once you are done with Gnumeric application, you can uninstall it by using
choco uninstall gnumeric command as shown below.
PS C:\> choco uninstall gnumeric Chocolatey v1.2.0 Uninstalling the following packages: gnumeric gnumeric v18.104.22.16800531 The package gnumeric wants to run 'chocolateyuninstall.ps1'. Note: If you don't run this script, the installation will fail. Note: To confirm automatically next time, use '-y' or consider: choco feature enable -n allowGlobalConfirmation Do you want to run the script?([Y]es/[A]ll - yes to all/[N]o/[P]rint): y WARNING: No registry key found based on 'gnumeric' WARNING: gnumeric has already been uninstalled by other means. Running auto uninstaller... Auto uninstaller has successfully uninstalled gnumeric or detected previous uninstall. [NuGet] Skipping 'gnumeric\tools\gnumeric-1.12.17-20140610.exe.ignore' because it was modified. gnumeric has been successfully uninstalled. Chocolatey uninstalled 1/1 packages. See the log for details (C:\ProgramData\chocolatey\logs\chocolatey.log).
Method 2: Using GUI
Another very user friendly method which can be used to install Gnumeric application is through Graphical User Interface. In this method, you just have to follow below simple steps to install the spreadsheet program.
Step 1: Download Application
You have to visit GitHub website to download the application by clicking on below highlighted link.
It will redirect you to below page where you need to click on
download Icon as shown below.
It should download the application in your local
Download folder as shown below.
Step 2: Install Gnumeric
Once downloaded, you need to double click on the application to start with the installation steps. You will see below setup screen opened. Click on
Next to continue.
You can read the terms of agreement carefully and once reviewed click on
I Agree to proceed.
You can select or unselect the extra components that needs to be installed and then click on
Next to continue.
You can choose to install in default destination folder or you can choose to install in different location by browsing to that path. For the moment, I am choosing the default location and then clicked on
Here you need to choose the
Start Menu Folder. After choosing it click on
Install to finally install the application.
After few seconds, you will see that the installation will get finished and now you need to click on
Finish to close the setup screen.
Step 3: Setting Path
After successfully installing the application, it is now time to set the
Path of the binary. For that you can go to search box on bottom left of your screen and type
environment. You will see
Edit the system environment variables appears on the top. Click on it to open.
Advanced tab, you need to click on
Environment variables as highlighted below.
Under system variable, click on
Path environment variable and then click on
Here you need to click on
New and then set the binary path of Gnumeric tools as shown below. Once done, click on
OK to close this screen.
After setting the Path, you can now open
Windows PowerShell and run
ssconvert --version command. It should run the command and show output as shown below.
Step 4: Using ssconvert
As shown in the previous method, here also you can check the usage of ssconvert utility by running
ssconvert excel_example.xlsx excel_example.csv > $null 2>&1 command as shown below. Then you can verify the converted
excel_example.csv by using
dir excel_example.csv command.
PS C:\> ssconvert excel_example.xlsx excel_example.csv > $null 2>&1 PS C:\> dir excel_example.csv Directory: C:\ Mode LastWriteTime Length Name ---- ------------- ------ ---- -a---- 16-07-2023 14:54 237 excel_example.csv
Step 5: Uninstall Gnumeric
Once you are done using ssconvert and other Gnumeric tools, you can choose to uninstall the application from your System by going to
Control Panel and then click on
Uninstall a Program.
Here you need to select
Gnumeric Spreadsheet 1.12.17-20140610 and click on
Uninstall/Change to uninstall the application.
It will ask you to confirm the uninstallation by clicking on
No. Click on
Yes to finally uninstall the application.
After a while, it will uninstall the application as shown below. Click on
Close to complete the uninstallation.
You will see below pop up window confirming the uninstallation of application. Click on
OK to exit the window.