Questions tagged [excel]

For questions about data related to a software program created by Microsoft that uses spreadsheets to organize numbers and data with formulas and functions.

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

How to get data from pandora papers

From pandora papers we know that who are in that list. But how do i get pdf, excel sheets, images etc. types data,to use as evidence, from pandora papers for a person in that list ?
user avatar
  • 313
0 votes
0 answers
14 views

How to open a zip folder's metadata as .CSV?

I'm working with a less than great reporting platform. Certain users of our system were expected to upload a certain document by a specific date. If they had not, they were sent a reminder. We are ...
user avatar
0 votes
1 answer
30 views

R or Excel: Calculate difference between dates

I have a list of course completion dates (person, start, end) in the following format (exemplary): Person X || Sept 21, 2021 06:30 PM || Sept 21, 2021 06:50 PM Now I'd like to calculate the overall ...
user avatar
2 votes
1 answer
53 views

How to look up the Census Block Code of an address?

I am trying to divide up a pool of addresses currently in Microsoft Excel according to the Census Block Code. Would anyone tell me where can I access data like that? Any instructions? Moreover, is it ...
user avatar
1 vote
1 answer
572 views

Database with multiple values for the same ID

I have a database where each entity has a unique ID, but recently all of the entity names were changed (not in the same way) to improve readability. This has made a lot of the summary reports look ...
user avatar
  • 21
3 votes
3 answers
304 views

wikidata extract

I have a list of wikidata entity IDs (i.e. Tour Eiffel Q243, Big Ben Q41225...), and a list of properties (i.e. coordinates P625, country P18 ...). Is there any way to gather and extract in Excel (or ...
user avatar
3 votes
1 answer
276 views

Extracting variables from unstructured Excel files [closed]

I have hundreds of Excel files (databases) from which I want to extract a subset of variables. The data are not systematically in the same cell (e.g. G4) and also don't always start on the same row. ...
user avatar
  • 39
6 votes
1 answer
366 views

Finding tables in messy structured Excel / csv file to import them in DB

we have a lot of messy structured excel files containing tables somewhere on a sheet and we want to import these tables into a database to do some analytic on it. There problem is that we don't have ...
user avatar
  • 61
3 votes
1 answer
223 views

Australia Hotel/Motel Data

I am wondering if there is anyone here that either has 2013-2015 list of hotels in Australia with contact phone numbers and if it had emails that would be a bonus. I am currently putting an excel ...
user avatar
2 votes
1 answer
615 views

Getting more than 100 records from OpenFDA in MS Excel [duplicate]

I have a query that appears to identify 975 items per the meta information. I used the limit (100) & skip (25) parameters to get the result. However, if I try to use that same query in Excel (...
user avatar