Comma-separated values: a rudimentary plain-text spreadsheet. Also includes tab, space, semicolon or other-separated values.

learn more… | top users | synonyms (1)

2
votes
0answers
14 views

How to output a CSV file from a matrix of Excel formulas using multiple files?

I am receiving on a weekly basis a list of Excel spreadsheets from a supplier (around 40 spreadsheets) with data in a specific format. Since the format is a bit complex and can't be converted to CSV ...
1
vote
1answer
39 views

Why doesn't my Python script save the file when I use Task Scheduler?

I have a Python script that uses csv.writer to create a csv file. This works fine when I run it from the command line, but no file is created when I run the script using Windows Task Scheduler. The ...
0
votes
1answer
64 views

Extract csv rows [on hold]

I have 2 csv files, File1 and File2. File1 has 24000 rows and File2 has 40000 rows. File2 has some duplicate data from File1. I used TableTextCompare ...
0
votes
0answers
24 views

Excel formula returning different results on different machines

For a piece of work I'm doing, I use a formula that calculates the difference between two dates for each row in the report that the system generates. Essentially, the software I'm using generates the ...
0
votes
1answer
17 views

Remove a specific string common in multiple lines in a CSV file using shell script

I have a CSV file which contains 65000 lines (size approximately 28 MB). On each of the lines they have a path in the beginning in the format of: c:\abc\bcd\def\123\456. Now let's say the path ...
1
vote
1answer
36 views

Windows Batch to read TXT and parse lines to CSV

I've made a good deal of headway by searching this site and learning the ridiculous language that is Windows batch scripting, but frankly I'm stuck. The sample below is from our lab's old radiometer ...
0
votes
0answers
22 views

Create Xbox Music Playlist from excel list (csv)

I created a few playlists in Excel (just the artist & song title) that I wanted to Import into Xbox Music. Unfortunately the only way I could find was to search for each song indivdually and then ...
0
votes
1answer
16 views

Mail Merge comparison between fields

I have a meeting merge document which is populated from a CSV file with data entered online from a facilitator. I am unable to work out how to do multiple conditions, there are a maximum of 10 clients ...
0
votes
1answer
32 views

csv file formatting issue in excel

I have a csv file when opened in notepad looks like this: sep=, ProgramXX, PXXXXX, .... IDXXXXX, XYZXXXXX, .... This should open well formatted as csv file in excel program but what I see is this: ...
0
votes
0answers
11 views

Export specific results of Access 2010 query determined by checkbox

I am working on a planning tool which provides information about how long particular tasks should take. Everything was working as expected but I have just been informed that the user would like to ...
0
votes
0answers
12 views

phpmyadmin wordpress export only showing postmeta columns

Trying to export - and the import - a Wordpress MySQL DB using phpmyadmin. I've done this quit a bit in the past and I'm completely perplexed at this point! I have a fairly standard Wordpress DB with ...
0
votes
0answers
12 views

Styling multiple files on Libre Office Calc [duplicate]

Here's what I do now: Get CSV file from extrenal source Open it in Calc Apply style (set colors, fonts, etc.) Export as PDF Is it possible to get rid of step 3? Somehow loading data to already ...
0
votes
0answers
18 views

LibCurl: FTP, wildcard file inside wildcard directory

I am using LibCurl looking to download one file. The problem is that the server will regularly updating new directory, and inside that directory, I am looking to download SINGLE file end with *.CSV ...
0
votes
0answers
38 views

Convert CSV to an MP3 Playlist, then merge the MP3 into a single audio file based on playlist order

I have a Japanese language learning app, which contains several MP3s. I'd like to merge these MP3s into a single file, so I can take the course without using the app (as the App has a terrible ...
0
votes
1answer
30 views

PowerQuery to parse fixed width csv

I have fixed width csv.txt, e.g. Martin Junger 12 John Wing 124 To load it with PowerQuery this syntax is used: let Source = ...
2
votes
0answers
29 views

Convert UPPERCASE to PascalCase [closed]

I have 50+ CSV files (50 to 100 columns each) to load into the database using SSIS. Most of these CSV files have all uppercase headings (primarily because my Oracle exports only with all UPPERCASE ...
1
vote
0answers
36 views

Excel 2010 - Merge multiple connections into single worksheet

I have an Excel workbook containing several worksheets. Each worksheet has an external connection to a unique .csv file that is updated several times a day from different PCs. This is done so that ...
0
votes
0answers
16 views

Right click a csv file to read in RStudio?

I would like the ability to right click on a .csv file and read it in RStudio (an IDE for the statistical language R). When I say "read it in RStudio" I mean open up RStudio with the line ...
0
votes
2answers
142 views

Autoload CSV for batch printing labels (Brother P-touch Editor v5.1)

My goal is to automatically print shipping labels for an e-commerce website based on periodically created .csv-files. I have the .csv-files ready. I also have the shipping label template ready in ...
0
votes
2answers
41 views

How to remove rows that match?

I have a csv file with list of people (first name, last name, email) and then later on I will get a list of people in another csv file that unsubscribed ( only one column with email). Q: How can I ...
1
vote
1answer
31 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 ...
2
votes
2answers
104 views

excel: export csv file with japanese character

In my excel file, the Japanese character is shown correctly, while when I export it as csv, the character become question marks How should I output so that the character can be shown correctly?
0
votes
0answers
50 views

Excel 2013 keeps removing commas from CSV at save

I'm working with data exports in CSV format. Excel originally opens the files correctly. However, I've been merging in some missing data that my original queries missed (adding four rows of additional ...
2
votes
3answers
1k views

Excel adds double quotes on csv export [duplicate]

I am experiencing a weird unknown behavior in excel. The sheet I want to export to a csv file consists of 4 columns with data like this: site.aspx|de|lblChanges.Text|some text that will be used ...
0
votes
2answers
199 views

Removing commas from CSV file

I created an Excel .XLXS file, reformatted the columns from currency to numbers with 2 decimals and no thousands separator, then exported to a .CSV file, then to a .TXT file. Once I did that, the ...
2
votes
1answer
52 views

Create an animated plot of data points from csv

I have a large CSV File containing some data points [~3MB, example data] as a series of coordinates. I want to create an animated plot of point where the point is moving acoording to the given ...
1
vote
1answer
122 views

Using the with cURL command-line tool on Mac, What can I do to this script to ask it to fetch stock data which comes back WITHOUT commas?

cd documents/quoteUpdate while true do curl -o quotes.txt -s "http://download.finance.yahoo.com/d/quotes.csv?s=goog,aapl&f=sl1c1p2pt1" echo UPDATED: date sleep 10 done
0
votes
1answer
81 views

How to display US format date time in csv file in UK format in Excel 2010?

I have a Windows Performance Monitor csv file that I want to view in Excel and produce charts from. The first column in the csv file is in US datetime format. e.g. "01/12/2015 10:54:44.043" which ...
0
votes
2answers
66 views

Unable to get accurate record count of a csv file

I have a .csv file that has some values formatted as paragraphs with line breaks or sometimes bullet points. "STAT","ID","DESC" "UPD", "1", "Updated" "CHG", "2", "Changed" "UPD", "3", "Updated. ...
1
vote
4answers
100 views

How do I stop Excel from converting value 0503E000 to 5.03E+02 automatically?

Excel converting value 0503E000 to 5.03E+02 in any cell automatically in CSV I tried to convert it to text number and general but after i save it and reopen it again it goes back to 5.03E+02 How do I ...
0
votes
1answer
67 views

How do you export an Excel file to CSV with rows have differing number of columns?

I have text file with a header, master, detail, footer record. The types of rows all have a different amount of columns. When I export to CSV, it exports all data and puts in fillers to the longest ...
1
vote
1answer
485 views

How to enable the 'Save and Open' option in Internet Explorer

I've recently upgrade to Internet Explorer 11 and now when I try to download/open a *.csv file from the internet I get the following options in IE. The Save and Open option is disabled/greyed out. ...
-2
votes
1answer
66 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 ...
0
votes
1answer
39 views

Does Acrobat XI Pro Win ESD support fillable form fields from a CSV?

At work I had an old version of Adobe Acrobat Pro, version 9, which I used combined with some Actionscript and batch actions to fill in form fields using a csv file and finally outputting to one pdf ...
0
votes
1answer
123 views

Create CSV file from Excel with delimiter other than comma?

Is there a way to create a CSV file from an Excel one, but with a delimiter other than comma? I tried changing Windows parameters. In Windows Control Panel -> Click, Language & Region -> formats ...
1
vote
2answers
99 views

Formatting of output .csv file generated by a software

I've been using a software which gives the output in .csv format automatically. In my .csv output file "." is used as a decimal separator. In my colleague's computer, the same software outputs the ...
0
votes
0answers
35 views

How to swap two columns in specific rows in LibreOffice Calc?

I have a few hundred contacts stored in Google Contacts, and I would like to sort them. I exported them in CSV and opened them with LibreOffice Calc. Some of my contacts have first and last name ...
2
votes
2answers
2k views

How to convert Excel file with multiple sheets to a set of CSV files?

I have an Excel file with 20 sheets on it. Is there a way to quickly convert the file into 20 CSV files - one for each sheet? I can do it manually of course, but I'll have to be processing these ...
0
votes
1answer
12 views

How to export Outlook Express group

I need to export an Outlook Express group, but it doesn't seem to have an option for that? Is there any workaround? I've tried using the options to export but they export the whole address book.
1
vote
1answer
112 views

How to export full data from excel as a csv using macro?

I want to export an excel file as a csv using macro, but my code is only exporting the header only. How to export the full data? Here's my code: Sub CSVFile() Dim My_filenumber As Integer Dim ...
0
votes
2answers
41 views

Excel Formats Numbers as Dates

I have several very large .csv files that I need to work with, and Excel makes this very easy (obviously). One of the fields is in the format 10/3/2013 19:00, and Excel automatically converts this to ...
13
votes
3answers
1k views

Excel does not honor the delimiter setting for reading or writing CSV files

When saving/opening CSV files in Excel, the default separator is a semicolon (;), as I need it to be a comma (,) I tried to change it by changing the Language and Regional settings following several ...
1
vote
1answer
35 views

Why does Excel only invoke the Text Import Wizard for .txt files?

Excel ignores comma delimiters in .csv files, but invokes the Text Import Wizard for .txt files that "appear delimited". Surely it should behave the same way for .csv files?
2
votes
4answers
190 views

Grep to filter gigantic CSV file

I'm dealing with a CSV file that contains over 2 million lines. Quite a big one. I need to use grep (or any better way) to retrieve the entire row if the value of the second column matches 'jpn' or ...
1
vote
2answers
66 views

Can you save font choice in a CSV file?

I have an XLSX file where there are two different fonts. One cell contains English, while the other contains another language. I would like to save this XLSX file as a CSV file without losing the ...
1
vote
2answers
36 views

reverse print without trailing

I have a bash file calling a dns zone and have piped out the fqdn which I need to output in reverse. The snippet below does that fine except I get a trialing . at the end which I don't want creating ...
2
votes
3answers
333 views

Converting a .txt file with tab as separators into a excel spreadsheet

I have lines of data in a text file where each entry is separated by tab. I want them in different columns and each line to form a separate row in excel. I tried using Data > Import but it all comes ...
0
votes
0answers
206 views

Excel VBA Script How to Open a File and Insert character into Cell

I'm hoping this is an easy one. I am importing a directory of CSV files with long numbers (16 digits plus 4 leading zeroes). I need Excel to preserve the number data instead of applying scientific ...
0
votes
1answer
49 views

How to replicate an anchor tag in Excel

I have an Excel (csv) like this: column1 link yahoo <a href="www.yahoo.com">Yahoo</a> google <a href="www.google.com">Google</a> Is there any way to make link ...
0
votes
1answer
44 views

How to search for a certain keyword that match the variable in batch file

I have search and tried various question and solution that are posted in this site. But a beginner like me doesn't have the brain for it. The code below work well if I put 1 single string. how to ...