All Questions
Tagged with microsoft-excel-2016 csv
18
questions
0
votes
1
answer
262
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
5k
views
Open UTF-8 csv files by double-clicking in Excel
I want to open UTF-8 coded csv- or text-files directly in Excel 2016 or later.
Of course I am aware of the import option, but I want to do this with a simple double-click.
Problem is that this way ...
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,610
1
vote
0
answers
4k
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
946
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
0
votes
1
answer
189
views
Excel Tables: Imported data from CSV files in a folder are not calculated
I have a source folder with CSV files in an identical format and data structure. The files contain monthly data from our internal system with columns named "service name", "date from", "date to", "...
- 162
-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
2
answers
9k
views
How to import CSV into Excel 2016
Each new version of Excel constantly becomes worse.
In earlier versions of Excel I was just able to open CSV file and work with it.
I was unable to this for Excel 2010: How to control CSV import ...
- 12.8k
1
vote
1
answer
9k
views
Save Excel Sheet as CSV in UTF-8 Using VBA
I'm working on the following macro in excel, which loops through all of the Worksheets in a Workbook and saves each to its own .csv file. The issue is that I need it to save as a .csv encoded with UTF-...
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
696
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
545
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 ...
- 39.9k
6
votes
5
answers
8k
views
How to export a spreadsheet to a UTF-8 .csv from Excel 2016 on mac?
Hoping you can help me out with this one...
For my work, I've been assisting a DBA for the last few weeks and we've now been given the task of uploading a very large spreadsheet which has several ...
- 160