Questions tagged [spreadsheet]

A spreadsheet is an interactive computer application for organization, analysis and storage of data in tabular form

Filter by
Sorted by
Tagged with
1
vote
0answers
8 views

Single tool, ideally open source, for specifying application use cases, requirements, and functional specifications

Is there a free or inexpensive tool that supports the development of Use Cases (or User Stories), Requirements, and Functional Specifications? I know there is a tendency to blur the lines between ...
0
votes
0answers
5 views

Showing private Google data to the public?

Currently running into a problem where I have a lot of data on Google Sheets but it's limited to be shown to specific people (distinguished by a user's email). Without changing the permission on who ...
0
votes
1answer
12 views

Compare two excel sheets

csv spreadsheets with the following data: Sheet 1: ID Name Address City PostalCode Phone Sheet 2: ID Name Address City PostalCode Phone I would like to compare the two sheets for added rows, ...
0
votes
0answers
10 views

Software for barcode registry

I have a fruit harvesting business that I would like to find existing, or implement software to keep a registry of scanned bin barcodes for each day, per team, and block area of an orchard. Any given ...
0
votes
0answers
9 views

OCR with data recognition and organization

I have tons of pictures of patient exams documents of which I need to extract the patient number and exam type and write it into and excel sheet, but this process is very time consuming, is there any ...
1
vote
0answers
12 views

Spreadsheet program where I can paste image and it belongs to a cell?

In Miscrosoft Excel and LibreOffice Calc when I paste image from clipboard, it is appearing above the cells, not belonging to any of them. I need that image data was belong to a single cell I pasted ...
0
votes
0answers
12 views

Create data entry form that loads fields from s3 and enables writing/editing data as spreadsheet back into amazon rds

I am currently maintaining a google spreadsheet to enter/edit several thousand rows for about 100 different entities - i.e. there are 10-20 rows for each entity name key (each key has slightly ...
1
vote
0answers
10 views

Is there an practical SQL interface that feels like excel?

I have used SQL Server Managment Studio, and Azure Data Studio, and MySql Workbench. I wouldn't consider myself an expert on using any of those programs. However, it seems like I still do a large ...
0
votes
0answers
17 views

Gratis Windows spreadsheet which supports 64 bit integer values and has charting

Important: just because it is a 64-bit .EXE does not mean that it supports 64 bit integer values (I'm looking at you, Excel). If you don't understand what 64 bit precision is, please don't just Google ...
0
votes
2answers
34 views

Any spreadsheet provide more then double precision?

Excel is not designed for highly accurate calculations. Its design follows the IEEE 754 specification for floating point math, which calls for only the 15 most significant digits to be stored. If the ...
1
vote
2answers
61 views

Online spreadsheet webapp that can view 10 million rows

I have a data file with 14 columns and 9,523,125 rows. What online spreadsheet program (NOT A DATABASE!) can view at least 9,523,125 rows? I must be able to: upload the CSV file view it (with some ...
1
vote
1answer
28 views

Spreadsheet that understands symbolic numbers

I am about to do some calculations involving Pi. These would be easy to do in a spreadsheet, but I need the result to use Pi as a symbol - not as an approximated value. Eg: A B C 1 =5 =Pi ...
6
votes
2answers
46 views

Wiki for spreadsheets / tabular data

Wikipedia has tables, but they're always part of an article, not standalone editing with VisualEditor is clunky editing with wikicode is a nightmare sometimes they can be sorted, but that's about ...
2
votes
1answer
36 views

What is the best spreadsheet-like tool to manage structured data with tags and multiple columns of different sizes

I'm trying to find a tool which can fit my needs in the management of a list a scientific papers I read during my phd thesis. For each paper I collect title, authors, write a summary, give tags... I ...
0
votes
0answers
19 views

Drag and drop bug reporting tool/software

Currently, my clients are using excel/Google Sheets to report their issues & encountered bugs when they are using the delivered Android APKs. I'm looking for the fastest alternative reporting ...
1
vote
2answers
977 views

Web App front end for Excel (or similar spreadsheet muscle)

I would like to create a web application that steps a user through the building of an economic model, ultimately exportable as a complex multi-worksheet excel with calculations throughout. It would be ...
1
vote
0answers
43 views

Database and Spreadsheet combination

Is there any software that combines spreadsheet and database engine functionality? I would like to be able to paste two tables (for example results of SQL queries, with 20+ different columns each) ...
1
vote
0answers
29 views

Email Client with Excel-Like Interface

I am after an e-mail client that lets me add custom columns, and sort and filter e-mails in a way similar to the way Excel works. I manage a small team of researchers who do interviews with various ...
2
votes
1answer
660 views

Using Microsoft Excel as user interface for a windows form application [closed]

I want to create a windows form application using c#, that uses Microsoft excel as interactive user interface, in the other word, I want to load the data from database to Excel, and after user ...
1
vote
1answer
50 views

Free software to use as aircraft register with photos

I'm sure there's a name for software of this kind, but Google hasn't been particularly helpful. I'm looking for online, self-hosted software that will generate a database/spreadsheet table with ...
0
votes
2answers
48 views

MSExcel/spreadsheet data entry vs traditional form data entry

I don't know if anyone here has a job that involves heavy data entry. I hope to get some opinions, or suggestions to something new. My company has a private database which stores various kind of ...
3
votes
3answers
114 views

Own spreadsheet web application server

I need to embed spreadsheets in my web application, something similar to Google Sheets. I also need to store the data in my server (i.e. embedding Google Sheets and storing the sheet in Google's ...
0
votes
1answer
57 views

Spreadsheet software analog whitch separates Data from Presentation

Microsoft Excel mixes formating, presentation and data, that drives me crazy. I just can't use my poor data this way. Is there a tool which works with data and tunes its reporting separately? I can ...
1
vote
1answer
77 views

Alternative Windows program for editing Excel xml format spreadsheets

I don't have Microsoft Office at home, but would occasionally like to edit spreadsheets from work. We use the Excel .xml format also knows as "SpreadsheetML". Does anybody know of a program that will ...
2
votes
5answers
89 views

Looking for Online Data Storage Software/Web Application

The company that I work for has collected a LOT of data (hundreds of thousands of entries) in Excel spreadsheets that are separated into labelled columns (ex. Name, Number, E-mail, Address, etc.). ...
2
votes
1answer
124 views

Excel alternative that uses JavaScript

I'm looking for a very simple Excel alternative that is cross platform, open source and uses JavaScript instead of the terrible Excel language (whatever it is called). So that every cell can have a ...
1
vote
0answers
70 views

software that combines graph and spreadsheet flexibilities

I'm at the beginning of a big project and I want to find a tool that works somehow like this (using a simple example): Suppose that you have some signal sources (e.x. sensors) that produce a voltage ...
0
votes
1answer
50 views

Social network with unique database capabilities

We're a non-profit organization that coordinates the donation of school supplies from wealthy schools to under-funded schools. My goal is to build an online application that empowers all of the ...
2
votes
1answer
29 views

Spreadsheet with language-agnostic networking API

I'm looking for a spreadsheet that can be controlled from outside, similar to e.g. how LibreOffice can be controlled via the UNO API. I'd like it to have standard manual manipulation functionality - ...
2
votes
4answers
789 views

Spreadsheet for text or text editor with columns and rows

I want to organize text in columns and rows. I want to be able to set a fixed width for the columns. The rows should expand (indefinitely) to fit the text vertically. I want to be able to change row ...
0
votes
1answer
21 views

Opening and sorting huge files

I am working with huge files like 2.000.000.000 rows. I need this file to be sorted, maybe filtered an so on. Can you recommend me a software? Preferably on Linux, but can be in any OS. I am looking ...
2
votes
3answers
123 views

Windows text editor with cells

Is there text editor which treats letters and unoccupied space as cells and allows to copy any rectangular area to any place? Somewhat like Excel, but with one cell for letter.
1
vote
0answers
24 views

What software can be used for logical operations in spreadsheet data

I have a spreadsheet(csv) file with 6 columns and 800 rows which I update daily with new data(file will be deleted and a new one is created). I want to do logical operations in those new data and also ...
1
vote
1answer
108 views

Spreadsheet Software (Javascript Funtions)

With Google Docs you're able to create GoogleScripts which allows to write Javascript Functions which you can use in Google Spreadsheet columns. I looking for a spreadsheet application (offline) ...
1
vote
0answers
20 views

Map of points from non-public Google Sheets containing latitude/longitude, updated automatically

My Google Sheet has the latitude/longitude of my suppliers: Name Latitude Longitude Tube&co 44.878 32.171 Bending2000 44.894 32.140 The sheet has 150 ...
3
votes
1answer
53 views

Distributing and maintaining excel-file

I am responsible for a spreadsheet that contains a database of products and their properties. I need a way to distribute it to people in the organization. Control over rights to write is important, ...
1
vote
1answer
40 views

Generating multiple PDF documents from spreadsheet and images

I am looking for a free or low cost product that i can use to quickly create multiple PDF documents populated with text and images from a spreadsheet. I have a background image which will the a ...
1
vote
0answers
25 views

Several persons/companies sharing one conference room - Which web app for reservations?

My company owns two conference rooms that are sometimes used by other companies as well. At the moment, 15 people can book the room using an Excel sheet on Dropbox. One room is green, the other one ...
2
votes
2answers
98 views

Spreadsheet with rowspan?

I have a list of 105 files. I need to analyze each file and for each file make a list of certain commands found in the file. Thus to each file they correspond several commands. What software do you ...
4
votes
3answers
2k views

Linux alternative to Excel pivot table

My company uses some simple MySQL queries to generate a CSV report of a bunch of stats (about 20 columns, rows in the low thousands). We then use Microsoft Excel to create pivot tables to explore and ...
4
votes
1answer
538 views

Simple spreadsheet for Android

I am looking for a simple spreadsheet app to use on my Android phone. Desired features: Basic spreadsheet functionality, ie entering data in rows and columns, including properly formatted dates/...
1
vote
1answer
166 views

Software to handle large Excel .xls files

Some users receive XLS files from other offices for analysis, but these files are extremely large and the performance of Excel is low. I know the best solution could be transfer this information to a ...
3
votes
2answers
336 views

spreadsheet alternatives Pascal:Basic :: ???:Spreadsheets

I use excel. I use google sheets. I've used Opencalc. And to really date me, I've used Visicalc. I've come to the conclusion that spreadsheets are in essence the 'Basic' of tabular data. I am ...
2
votes
0answers
1k views

unified document editor

There are a lot of "Office" clones, but I'm looking for something that is a bit different. I am looking for a document editor that has a single unified interface and which does not distinguish ...
3
votes
1answer
255 views

Speadsheet software that can handle thousands of columns

Microsoft Excel has a max number of columns of 16,384 Open/Libre Office Calc has max number of columns of 1,024 A summery of the limits for several speadsheet softwares can be found here I have ...
3
votes
1answer
527 views

What is a good alternative to Zoho Reports?

What other services are similar to Zoho Reports? I performed a search for alternatives and all articles seemed to focus on the CRM and so it was a false comparison. Al the alternatives were about CRM ...
9
votes
1answer
500 views

General purpose database application alternatives for iOS and Mac

I am looking for a way to manage inventory in the field. I want to use an ipad/iphone for taking inventory, and use a mac to generate reports. This can be a single app or a pair of apps. I can do ...
6
votes
5answers
21k views

Windows spreadsheet program that can handle 10 million rows

I have a data file with 14 columns and 9,523,125 rows. What Windows desktop spreadsheet program (NOT A DATABASE!) can handle at least 9,523,125 rows? I need to view the data, and sort by columns. ...
3
votes
1answer
91 views

Spreadsheet software that can open several CSV as tabs in the same window?

I have 3 local CSV files that I often need to check. I don't like to have too many windows open, so tabs would be great. Is there a spreadsheet program that would open the 3 CSV files as tabs of the ...