Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [excel]

The tag has no usage guidance.

1
vote
1answer
219 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 ...
3
votes
3answers
186 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 ...
3
votes
1answer
193 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. ...
6
votes
1answer
326 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 ...
3
votes
1answer
177 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 ...
2
votes
1answer
399 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 (...