Questions tagged [microsoft-excel]

For recommendations for software that interoperates with the Microsoft Excel spreadsheet software.

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

Push and pull online software solution

Current Situation In our office environment before we moved over to Office 365, we designed Excel workbooks to cover our admin tasks, these workbooks were unique to each member of staff. All staff ...
2
votes
4answers
338 views

Looking for 64 bit Windows 7 spreadsheet program

I have used MS Excel 2007 for many years on a 32 bit computer. My newer computer is a 64 bit Windows 7 (yes, it's an antique :-). The 2007 software will not install on my 64 bit computer. I spoke ...
1
vote
0answers
19 views

Software for categorizing data based on language and type

Currently, I'm using windows file explorer for categorizing. There are folders for years (2017, 2018, etc.) and each of them has sub-folders for types (type_1, type_2, etc.) and under each sub-folder, ...
1
vote
3answers
29 views

Program to take spreadsheet data, compute data, charts/graphs for multiple pages that allows user input

I have a spreadsheet that is for a group of clients. Each line of data has information on insurance claims, of which include a client number that is unique to that client. I am looking for a program/...
0
votes
0answers
10 views

Transfer content from google sheet to external excel file

I’m trying Google Form and its tool to generate a sheet document based on the answer of the form. Now, I’d like to transfer the content from this sheet to an external excel file, to keep it updated as ...
0
votes
0answers
17 views

Cloud-Based Alternative to Microsoft Excel? Main Requirement = Conditional Formatting

I currently use the desktop version of Microsoft Excel to visualise data tables using data bar gradient conditional formatting. For example like this: https://www.contextures.com/images/...
1
vote
1answer
25 views

Tool to convert SEC EDGAR Form 13F into Excel?

I'm using Windows 10. I'm looking for a tool to convert https://www.sec.gov/Archives/edgar/data/1037389/000103738919000272/xslForm13F_X01/renaissance13Fq32019_holding.xml to .xls. I found Intrinio on ...
0
votes
0answers
12 views

How to solve a non linear equation in nodejs / javascript

I have to solve an excel solver equation. Which content some non linear equations. let assume X is 12*1 vector of unknown values. the element values are x1,x2,x3,..,x12 y1,y2,...,y12 are known ...
0
votes
0answers
14 views

Excel template field mapping software

We have an excel file in a specific format that loads data into our internal system. Example of the file Name, Cost, Location, Notes We receive data from our clients in different formats (>100 ...
2
votes
1answer
33 views

Mobile Friendly Data Entry App

I am trying to create a data entry "app" to collect daily readings across our site. Here are the three biggest constraints: Software - ideally, we would use some software within the Microsoft 365 ...
0
votes
1answer
27 views

Good, free software for candlestick charting (using CSV or text input file)

I am looking for Desktop software which takes Daily Open/Close/High/Low (and possibly Volume) input as csv or any text format. I already have Excel but I found several shortcomings with Excel If ...
0
votes
1answer
24 views

Interactive spreadsheet survey

I'm looking for an online survey platform which would allow participants to input information into a blank interactive online spreadsheet. The spreadsheet would be blank for each individual ...
0
votes
0answers
12 views

How to handle a very large CSV file

The authors of a paper on migrating birds have made public a CSV file which has about 707,000 rows. These represent the flight path coordinates of 707 flights made by individual birds. I want to ...
0
votes
0answers
4 views

Intelligently identifying and analyzing tabular data in Excel spreadsheet

Our company is building an online system that needs to accept Excel files as part of the registration process of our service. Our system will only be interested to consume what looks like columns and ...
0
votes
1answer
22 views

How to import table data from excel into Azure FROM LINUX

I'm in a database management class and the professor strictly teaches toward windows machines, so she uses Microsoft SQL Management Studio to interface with our databases. I have a linux machine, so I ...
0
votes
0answers
6 views

Machine learning in data extraction

Are there any tools that have “self leaning and auto transformation” capability whereby we can interrogate a client-provided file in it’s native format, identify key data elements, and pull pertinent ...
0
votes
0answers
5 views

Tools that can do AI based document-data-extraction

I have a requirement for an “auto transformation” capability whereby we can interrogate a client-provided file in it’s native format, identify key data elements, and pull pertinent content into a ...
0
votes
0answers
15 views

Help developing a golf score tracking mobile application

I, along with three other people, are assigned a project for our upper-level college course. We are responsible for creating a mobile application for our schools golf team. Here are the specifications ...
0
votes
0answers
694 views

Generalized Excel VBA tool to run SAP reports and save output

My team often needs to extract data from the SAP R3 GUI into a file format such as Excel. We have been using VBA scripting to do this, using the approach described in https://stackoverflow.com/...
-1
votes
1answer
13 views

Uploading csv files to an R file without having excel

I'm starting an internship where I'll be uploading different csv files into some R files I'm working on. Problem is, I don't have excel and can't really pay for Microsoft Office. Are there any options,...
1
vote
0answers
27 views

Best Tool for Analyzing Multi-Tab Excel Files with 100-500k Records

I have started a new job and I need to analyze client's databases. Many times when we first meet with them we just get a huge Excel file with a dozen or so tabs and a partial to full dump of various ...
0
votes
2answers
14 views

VBA in Excel vs Access for data conversion

We are upgrading our enterprise software and part of that effort I have to perform sales order (data) conversion from legacy to new software. I have moderate experience with macros/VBA in excel and I ...
0
votes
0answers
11 views

Software for backing-up my phone text messages into php/excel

Does any one know an android software or web application for converting phone text messages into sql/excel. Its only for representation purposes and i think i can use them in the future.
1
vote
0answers
8 views

Mapping Application for Excel

I'm not sure if this is the right place to ask this question but I need to map around 20 truck routes that are listed in excel. I would like to plot each stop as a point on a city map, and then draw a ...
0
votes
0answers
9 views

Suggestion for an open source to be used as UI and to consolidate data into Excel Spreadsheet

We have a table in MS Excel, where different users enter into different rows of data. All the data is collected and consolidated into the same sheet. Kindly suggest a web-based open-source, which can ...
1
vote
0answers
8 views

How to manipulate Excel with python

I would like to perform some operations on an existing excel files which already contains some datas and formulas. It contains also charts. The operations that I would like to do are adding some ...
0
votes
0answers
7 views

Open MS EXCEL file from C# and end C# program

I have a program on C# and i want to put the results to .xlxs file. But the problem is, that i want to open to a user this .xlxs file, that the user can see it opened on his screen, and, at the same ...
1
vote
0answers
11 views

Which programming language works with tables and databases, considering reports and GUI?

I’ve been working with VBA previously but i want to learn other programming language, having a project in place I would like to know which language to pick and start learning… This project is based in ...
0
votes
0answers
4 views

Is there a software that can filter files in sharepoint/teams?

I have a issue, where i have about 5k files. Its xsl, doc and pdf. I want to clean up my files, by using a filter software? anything that can filter it so that i can search/delete all files that are ...
1
vote
1answer
28 views

Huge excel file with python

I've a huge file in the size of around 600 MB, I've to write some python codes and generate new columns, for now, I'm using python, but unfortunately, no luck as I'm getting memory error to get ...
1
vote
0answers
14 views

Library to develop web-based spreadsheet, compatible with Excel and PDF

I'm looking for open source library's which can make own web editor for editing excel sheets like Google Spread sheet. I want webify the excel sheet & Pdf as web application. Are there any Open ...
0
votes
0answers
5 views

Automated and faster and reproducible making bar-plots with chart titles and error bars

I want to make 100 barplots with chart titles and error bars with some software that is faster than Excel with requires so much click and drag, and is better than R with creates graphs that are ...
0
votes
0answers
39 views

Tool to connect Excel VBA macro to IBM AS/400 Access Client

I am working with data in excel and IBM AS/400 Access Client. they linked together using vba macro. However, recently my company wants to change to IBM AS/400 Access Client Solution which is the ...
-1
votes
2answers
23 views

Convert CSV file to another layout

I would like to change the layout of a input CSV file and change the layout of values. So the initial Format has headings like: - Customer Zone Type 1 2 3 4 5 6 7 8 9 10 11 12 Under the number ...
0
votes
0answers
32 views

Line Graphing from dynamic excel data

I have been developing a tool that processes timetable data and would like some advice on how to develop the graphical output. I do intend to keep the data in excel, but would like to output to a ...
1
vote
1answer
41 views

How can I programmatically insert an image in to an excel file?

I have a folder with an excel file and an image. Which programming language can I use to insert the image to a cell programmatically? The files are located on a Linux server running a strictly ...
1
vote
0answers
8 views

What program would you use to do simple querying on tabular data?

I often receive data in Excel files and want to some simple lookups the way I would with SQL. In Excel, doing something like select b.field from a join b on a.a1 = b.a1 and a.a2 = b.a2; is doable with ...
2
votes
1answer
29 views

C# Library for manipulating Excel Files?

I'm working on a project to migrate excel data into new excel files that are compatible with another system. As part of this work, I have to do a lot of data manipulation between excel sheets (...
0
votes
0answers
9 views

What software should I use to build an app that can communicate with SharePoint?

I'm trying to build an app where the user can draw with their finger and have the drawing be placed in an Excel file which is sent to SharePoint. It can either be an android or web application. I ...
0
votes
1answer
16 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, ...
1
vote
1answer
17 views

Converter for Microsoft Office XML to OOXML (Office Open XML)?

We have some software producing a spreadsheet in the Microsoft Office XML file format (introduced in Office XP) and would like to convert this to the newer OOXML format that has been used with Office ...
0
votes
0answers
13 views

RStudio or SQL for data cleaning

I am wanting to detect corrupt and inaccurate records to check for data quality from large data sets that originate from Microsoft Access and Excel. Things I would like to check for: Validity which ...
0
votes
0answers
10 views

Microsoft Word and Excel

I'm looking for a light and simple alternative to Microsoft Word. I would like an application that can run on IOS10 and also mobile applicability on the go for editing.
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
17 views

Android app for quick data notes

I am looking for an Android app in which I can quickly input numbers on standard sheets, without always switching on the touch keyboard. I'll explain a little further. I periodically go to some shops ...
1
vote
0answers
5 views

Software for 3D Processing

I have a project for my work which requires me to take XYZ data from a CSV/Excel file using this data I need to generate a 3D line/spline then using this I need to render small segments of a pipe ...
1
vote
0answers
13 views

Connect Excel to HDFS and update data real time

I am trying to figure out a method or software for updating data into HDFS real time. My requirement is as follows: I will have an Excel in a server. That Excel data needs to be loaded into HDFS. IF ...
1
vote
0answers
31 views

Software to connect Apache Derby DB with Excel

I would like to use a Apache Derby database as source for an Excel file so that I can use the tables and manipulate them in Excel. I have tried to connect the Derby DB with the Derby ODBC Driver ...
0
votes
0answers
17 views

COTS EDI software to view an XSD in Excel

Which commercial off-the-shelf software offers a feature to make an EDI data mapping specification for remote programmers based upon an XSD file? The remote programmer will not have access to the COTS ...
1
vote
0answers
8 views

Software to annotate PDF from Excel or Python

I have a large PDF files. Each PDF page contains a chart and also includes a unique identifier, i.e. chart number. I have individual comments for each chart and would like to insert these in the ...