All Questions
Tagged with microsoft-excel csv
495
questions
1
vote
1
answer
43
views
How do I use an API to extract to CSV? [closed]
Sorry, I've tried reading up on it but I just don't understand any of it.
There is an organisation, ALISS.org, which has a section with their API that lets you interact with their database of local ...
0
votes
0
answers
61
views
Concatenating of the strings of the each paragraph
Is there way concatenate the strings of the each paragraph in one line? For example, I have many the same paragraphs with the space between them, it looks like:
Is there way to put each such ...
0
votes
1
answer
92
views
Why do Ratios not carry over from Xlsx to CSV format
I have an XLSX file that we have output from SAS. The column in question are results from an assay that result in a titer ratio, "NEG" or "Not Assessed". In the XLSX file the ...
1
vote
1
answer
728
views
Change encoding to Unicode in .csv exported from Gmail
I'd like to copy the typed-in addresses from Gmail to Outlook 2021 (Windows 10).
To do this, I'm using the Google Contacts Export to Outlook CSV function and nk2edit.
The problem is that the special ...
0
votes
1
answer
901
views
Convert (part of) XML data back to tabular data or CSV/tab separated without using scripting
Is there an easy way to convert (part of) XML data back to tabular data, so comma separated values or tab separated or Excel? I sometimes get XML log files, and for clarity and comparing it more ...
1
vote
1
answer
660
views
How to tell Excel to change right encoding in opened file?
Can somebody tell me please how to tell Excel to set up right encoding for csv file? It seems it is not possible without any annoying steps. I would like to see something like Libre office or Open ...
1
vote
1
answer
950
views
Excel: How to search for values from a column within a cell that has comma seperated values
I have one column with text in seperate rows, and a cell that has comma seperated values within the singular cell, as below.
One
Two
AB
AB, EF
CD
...
I'd like a formula to return True if any text ...
0
votes
2
answers
72
views
Misleading data format Excel .csv
I am generating a .csv file with data like the example below:
TIME,LUX
18:00:00,30
18:00:01,30
18:00:02,30
18:00:03,30
18:00:04,30
18:00:05,30
18:00:06,30
18:00:07,30
18:00:08,30
18:00:09,30
18:00:10,...
0
votes
0
answers
907
views
How to import multiple csv-files in Excel at once with VBA
I am trying to import multiple csv-files within the same directory into my Excel sheet using VBA. The following code is working very well with just one csv-file. But I lack the knowledge to adapt my ...
0
votes
2
answers
203
views
I have two cells each with comma delimited values, I want to combine these into one cell
I have two excel cells(A1 and B1) each contains comma delimited values in, I want to combine these values into one cell (C1), so that the first value from cell A1 is "linked" to the first ...
1
vote
1
answer
1k
views
Excel - CSV file formats Date column in different ways
I am working on creating a personal finance dashboard and therefore integrating different CSV files downloaded from different sources into one big table.
The problem I am facing is that the date ...
-1
votes
2
answers
242
views
MS excel not coping data in correct format from csv file
I am coping data from csv file
it contains tables
in that table there is column name PostedDate
when i copy that PostedDate column in excel it shows wrong formatting (ie instead of / it shows -)
...
0
votes
2
answers
2k
views
i downloaded a csv file, but data is not separated by commas
I downloaded a dataset from kaggle.
kaggle data:
but all the data is in one column in excel.
data in excel:
I need this data for my project. how can I get this data separated?
7
votes
2
answers
2k
views
Bulk fix for Excel 97-2003 error "format does not match extension"
Context
I have received around 1700 97-2003 excel files with a ton of data including some text information. I am trying to read them all into Stata before I clean and run some statistical analysis. ...
0
votes
1
answer
263
views
running 2 excel versions at once, cant associate filetype to older version
I have excel 07 and the latest Excel 365 (I think thats Excel 16) both installed in windows 10. When I just had 07, I had no problem associating csv and xlsx files with that program. Now that I have ...