All Questions
13
questions
0
votes
1
answer
268
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 ...
- 1,173
1
vote
2
answers
3k
views
How do you open/import a CSV file with Unicode characters encoded as numeric character references?
In Excel, I tried to import (using Data > Import) a CSV file with Chinese characters. The characters are represented as Unicode numeric character references (NCR); for example 香&#...
- 113
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
1
vote
0
answers
5k
views
Loading new data from a CSV file into an Excel table
I have an Excel spreadsheet which I made by
starting with a CSV file
converting the data into a table
adding some columns to the table in which various computations happen
saving the file as .xlsx
...
- 173
0
votes
1
answer
45
views
Unable to apply numeric format to column in moderately large CSV file in Excel
I have a moderately sized CSV file (195,000 rows.) For some reason, when I try to format a column of numbers as currency when opening it in Excel, it does nothing at all. If I edit the file and leave ...
- 127
2
votes
2
answers
956
views
Why is Unicode 1200 codepage not there in excel?
I am opening a CSV file which is created with Unicode 1200 codepage but when I bring up the wizard in excel to open it, this codepage is not there. I only see UTF-7 and UTF-8.
I do need to open an ...
- 1,753
-1
votes
1
answer
182
views
Excel: New Powerquery from Web (csv) doesnt work
I want to build a worksheet where the user can input a Stock symbol and the balance sheet is automatically downloaded from morningstar to a table, and then some custom formulas are run on the data.
...
- 350
1
vote
1
answer
1k
views
Import from tab delimited text file in Excel - CR character in quote marks is ignored
I have a large TXT file delimited with TAB.
Text is enclosed with quotation marks, but Excel still breaks the values into two rows when a CR character appears within the encapsulated string.
Is there ...
- 1,836
-1
votes
1
answer
103
views
Excel; How do I import CSV table as rows seperated by table number?
So I have a MASSIVE data set, in its unprocessed format it is a CSV file and contains two column tables that are stacked on top of one another. in the picture below the delimited version of the file ...
2
votes
1
answer
15k
views
How to automatically import data from csv file and append to existing Excel table
I have a .csv file and a master excel file. The master file contains a table and I would like to automatically append the data in the .csv file to the existing table. The data has the same headers and ...
- 31
4
votes
1
answer
4k
views
How can I dynamic change separators configuration in Excel 2016 for CSV files?
I've a CSV file opened with Excel. This file use comma separators (,) but the default separator for Excel (with European configuration) is a semicolon (;).
Note: I know in America they use a comma ...
- 734
2
votes
1
answer
698
views
Import CSV data with units into Excel
I've got a bunch of CSV files that contain values with trailing units. This makes Excel think it's text so I can't sum them in a pivot table.
The data looks something like this:
Date; Text; Amount;
...
- 124
0
votes
2
answers
546
views
Add custom category type column to an Excel 2016 Power Query
Used the power query feature of Excel 2016 to import several CSV files containing personal financial history and trying to use the power pivot thing.
Problem is I really need to group the ...
- 40k