All Questions
Tagged with microsoft-excel csv
141
questions with no upvoted or accepted answers
1
vote
1
answer
144
views
Text file to comma delimited file
I have a text file that needs to be converted to a comma delimited file. I have imported my text file into excel and then have chosen the Fixed width and according to this I have separated my columns ...
1
vote
0
answers
931
views
How can I automatically import csv files into SQL Server?
My goal
Automated aggregation of data so that I can use a tool (Microsoft Power BI or equivalent) to automatically update dashboards and or reports with the new data.
The situation
I work with an ...
1
vote
2
answers
167
views
Trying to convert .xls into .csv that have different delimiters than excel 2010 is automatically saving it as
I'm trying to get a .csv file with this exact format http://puu.sh/ubMVZ/6d7b9968d5.png to be used in a statistical analysis in metaboanalyst (this is a list of concentrations of metabolites from ...
1
vote
2
answers
249
views
CSV files downloaded from limesurvey are displaying strangely in MS Excel 2016
I administered a questionnaire using limesurvey and downloaded the responses in csv format to analyse in R. For some reason, the column names are displaying very weirdly in excel. I have tried Data -->...
1
vote
1
answer
59
views
Issue saving SQL query results in Excel
My query results look like this in SQL Server. EmpBarr has string with multiple values that must be double quoted and comma delimited.
id EmpBarr
6928108 "ELL","LII","LLL"
When I copy the ...
1
vote
0
answers
85
views
Creating a website CSV
Im building a webshop, and asked a wholesale for a datafeed import for all my products.
They did not have it so im wondering if i could create my own.
Ive got all the information except discriptions.
...
1
vote
1
answer
197
views
Conversion from Excel to CSV Correct Cells with Errors
I have a lot of cells which I want them to be formatted as texts. However according to Excel they are not texts and hence should be corrected to numbers instead. For example, "6814070833E000101" is a ...
1
vote
0
answers
333
views
Office Excel 2011 for Mac : when exporting an excel sheet to csv, around 25000 empty csv lines get added
so when saving as windows csv and press save i get the actual data:
1,1,2,
then i get around 25'000 lines:
,,,
,,,
,,,
,,,
,,,
,,,
....
when i do the same with libre office i get only the data, no ...
1
vote
0
answers
2k
views
How to Avoid rounding off when converting from CSV to Excel?
As far as I know (") double quotes are used in the CSV file and who opening the file in Excel it should treat that as Text and all the numbers should displayed.
My actual CSV file value is: 1,026....
1
vote
0
answers
471
views
Number formatted as text keeps reverting to scientific notation in Excel
I am creating a large file in Excel that contains two columns with large numbers. I am formatting these columns (actually the entire worksheet) as TEXT.
When I save the file as .xlsx and open it ...
1
vote
0
answers
3k
views
Excel Text Import Wizard Default Delimiter
Within the Text import Wizard, the default delimiter is TAB. Is it possible to permanently modify this default to be a comma?
Don't be tempted to think that this is a duplicate question. Neither this ...
1
vote
1
answer
89
views
Applying settings by default to CSV documents opened in MS Excel
End-users of a system we are developing are given a plain-old CSV file that end users will be opening in MS Excel. One of the columns will contain entries which consist of strings of numeric digits. ...
1
vote
1
answer
87
views
Macro exports date column to csv as numeric value rather than dd/mm/yyyy
The following code has achieved what I require except that the date [cell B2] is exported as as five digit numeric value rather than dd/mm/yyyy.
How to I amend the code to force B2 to export as dd/mm/...
1
vote
0
answers
117
views
Locked between MailChimp and European Windows for CSV export?
I have a CSV export for our application that is being used by end users (not tech-savvy).
For some European regional settings Excel expects a semicolon ; for delimiting (comma is used for decimals).
...
1
vote
1
answer
194
views
Manually editing Excel worksheet, need my edits to save as written in .csv without reformatting back
Here is my issue:
I have exported about 2000 records from a database to manually clean up the dates attached to them. (It appears that someone exported these records before, then re-imported them ...