All Questions
Tagged with microsoft-excel csv
495
questions
-1
votes
1
answer
58
views
What is causing the xcopy file from having an error in it?
I am new to xcopy. I am trying to move a file that is in excel format to a new destination and as a csv file. I have to do this so that the DMExpress ETL job can move the file and then read it. This ...
- 1
-1
votes
2
answers
246
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 -)
...
-1
votes
1
answer
289
views
How to get folder location of file? (Powershell) [closed]
I am using the script below, found on this thread.. I would like to automatically save the Excel file in the same folder as the CSV file, using the same name as the CSV file.
How can I get the ...
- 11
-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
votes
1
answer
49
views
How to format a CSV with blank data in some places
I have a CSV with the following headings (and example data):
Serial Number, Photocopier Model, Copy Volume, MeterType
432322,Canon,Copy Volume, MeterType
,,23423,BW
,,983,Colour
,,4405,A3 BW
,,34,A3 ...
- 116
-1
votes
1
answer
52
views
How do I automatically remove nonstandard elements from fields in a .csv file? (see description)
I have an enormous contacts file in .CSV format with about 15,200 entries. Many entries are nonstandard, repeating the email address in the first name field or something like this. I want to ...
-1
votes
2
answers
2k
views
Excel: Convert to Txt Comma Separator With a Tab Deliminator File
I had a text file that used a comma separation value.
I imported the file into Excel, used Text to Columns, and changed to a tab deliminator, so I can work on the file.
I've completed the work on ...
-1
votes
1
answer
1k
views
Convert multiple excel worksheets to .csv
I found this macro for converting multiple excel worksheet in a workbook to individual named .csv files, but don't know how to remove the workbook name from the converted file name. I'm sure its ...
-1
votes
1
answer
2k
views
Visual Basic and Excel data streaming in real time [closed]
I'm currently working on a program that runs in visual basic (not VBA). The program collects data from sensors and produces a data file (*.csv) of the information it collected after a certain stretch ...
-1
votes
1
answer
35
views
Place a String separated by commas into the Excel rows
I have a String like this separated by the commas:
id, payment_request_id, user_id, market_id, exchange_id, type_id, nominal, ask_price, original_rate, min_execution, from_date, to_date, state, ...
- 523
-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 ...
-1
votes
1
answer
1k
views
Invalid date value in csv file
I export data in csv format from sql server database. It contain 5 column. one column have date and time value. When i checked the date -time value i found date time value is in wrong format. I add ...
- 320
-2
votes
1
answer
121
views
Messed up CSV file
I was trying to open a CSV file that was in an APK, but the text came up all messed up. I don't know if this is an encoding issue, an encryption or to do with the fact that I changed the .apk file ...
-2
votes
1
answer
2k
views
Automate alignment of columns in CSV
I often work with CSV files, that other people will work with in a text editor. I want to have nice alignment of columns, e.g.:
Height, Age, Whatever
11, 12, 13
For large files, this is ...
- 121
-5
votes
2
answers
8k
views
How do I convert a .csv file to a database?
I have an 8GB .csv file with 6 columns and 202,176,000 rows.
How would I convert that to an OpenOffice database(.db) file?
anon