All Questions
Tagged with csv microsoft-excel
495
questions
0
votes
1
answer
511
views
How to automatically sum columns datas of a grouped row subset with common attributes (excel csv spreadsheet)
I have a big csv file (one million rows) I imported in excel.
I have to do a simple operation, easy to be done manually, but I should do it for thousands groupings so I am looking for an automated ...
- 3
0
votes
2
answers
1k
views
How to merge multiple Mac excel files all with headers that are the same but out of order
I am using a Mac. My excel files have headers that match but are out of order. They all start with a header named "query" and then it gets mixed after that.
Here are some header examples:
...
- 137
3
votes
3
answers
4k
views
How can I open .csv files on Excel if Excel isn't in the list?
After my laptop got formatted, .csv files are opening only through Notepad. I want .csv files to open with Excel always.
For this, I tried changing its default app to Excel, but unfortunately got no ...
- 141
2
votes
1
answer
1k
views
Two different computers downloading same spreadsheet - data displays differently
I work for a company in the United States. One of my clients is in Montreal. Whenever the client tries to download a spreadsheet from our network, she ends up with a bunch of data bunched into Column ...
- 23
0
votes
2
answers
2k
views
How to use Power Query to import multiple CSV files into a single Excel worksheet as worksheet columns?
I have a recent version of Excel (but very little experience with Excel). From a folder containing many .csv files, I want to import a few of the files as columns to a single Excel worksheet. I ...
- 123
2
votes
2
answers
2k
views
Powershell script help needed for displaying network interfaces
I have a script [below] that returns information about the network interfaces in .csv format, but I also need the InterfaceAlias of each adapter returned; unfortunately, I cannot get get-wmiobject ...
- 21
2
votes
0
answers
872
views
Loading UTF8 CSV files generated on a Mac into Excel on Windows: does not recognize encoding
When I generate a UTF8 CSV file in Excel (or some other way) on Windows and then open it n Excel, I expect it to ask me to choose the right encoding.
I got a UTF8 CSV file that was generated on a Mac. ...
- 489
0
votes
1
answer
3k
views
In Excel, how to treat values starting with = as text and not a formula?
I have data exported from a database that's in a CSV that I need to view and manipulate in Excel. The problem is that some of the values in the cells start with an equal sign ( = ) so Excel thinks ...
1
vote
1
answer
806
views
Csv file - User permission needs to be created after each save
For context, I'm uploading a csv file to a Postgres database via the psql command line. The cmd can only access the file after I add Everyone to its permissions and allow full control.
The weird thing ...
1
vote
2
answers
609
views
Opening csv file with notepad with two different desktop running both windows gives different results
Opening csv file with notepad with two different desktop running both windows gives different results
One of the desktop when opened, it's kind of lined nicely with newline, but somehow the other one ...
- 147
0
votes
1
answer
327
views
How to find/replace only numbers at the end of a row?
I have a column of course names where I'm replacing anything that isn't in Roman Numeral at the end with one. So, for example: "My Course 1" should be "My Course I". I'm using the ...
- 157
1
vote
0
answers
197
views
Jira -- export tempo timesheet (grid view) to Excel
Jira: How do you export tempo timesheet (grid view) to Excel -- either .csv or an ordinary excel file.
I am using Microsoft Edge browser, and there is no easy link available (such as Export).
I ...
- 243
1
vote
1
answer
1k
views
Open Semicolon Delmited Text File in Excel Via Double Click
I can make Microsoft Excel open up a semicolon separated value text file by placing "sep=;" at the beginning of the file. Then upon double clicking, it properly separates every column and ...
- 1,630
0
votes
3
answers
421
views
Export SSL & TLS Registry Keys to XLSX
I'm currently looking to find out all SSL and TLS Registry value information on the system. I need help writing a script for powershell to look at a list of hosts that are on a csv/txt file then ...
- 53
0
votes
1
answer
737
views
Excel file reopens with vertical bar symbol
When saving a file in Excel (tested as a CSV and Workbook), when reopening the file the commas have been converted into a vertical bar | (pipe symbol), and the columns have merged. What is causing ...
- 1