Questions tagged [csv]

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

Filter by
Sorted by
Tagged with
3 votes
2 answers
3k views

Notepad++ replace doesn't work for Regular Expression

EDIT Proof that it should work: http://regexr.com?30pf2 I'm trying to replace all occurrences of , that are not within quotes with a ~ 20,72275,Epidurography,1 21,72285,X-Ray C/T Spine Disk,1 22,...
Brandon J. Boone's user avatar
3 votes
5 answers
27k views

Comma separated values (literally, not csv) in the same cell in excel, put in individual cells

I have a column of cells in excel which contain mails, some only contain one mail as they should but others, have more than one email per cell in this format: [email protected], [email protected], three@...
Trufa's user avatar
  • 197
3 votes
2 answers
5k views

Convert XLS to CSV in Unix

Is there an easy to compile plain C XLS (Excel sheet(s)) to CSV (or other text delimited format) converter for Linux or the BSDs that doesn't rely on Perl and installing a bunch of module perl modules ...
dlamblin's user avatar
  • 10.7k
3 votes
2 answers
15k views

Adding Header to CSV file using Powershell

I have a CSV file and data in CSV file looks like below its vertically formatted. that file is not having headers i want to add header to that file. when i tried to add using below powershell script ...
Ade's user avatar
  • 51
3 votes
1 answer
401 views

How to trim down PowerShell output in .csv file to write only the Release ID of a Windows 10 OS?

This script work but the output to the .csv in the release id field is everything associated with the registry key. All I want in the field is the release id number (1909, 1809, 1709). How to I edit ...
webby68's user avatar
  • 259
3 votes
2 answers
2k views

How do I clean ~500,000 records in Excel 2010 without crashing my PC?

I have to remove large chunks of information from tables in .xlsx files using Excel 2010. Every method I have tried so far has produced no results, either crashed or I've killed it after waiting for a ...
scc268's user avatar
  • 191
3 votes
2 answers
4k views

Sublime text 3, multiline select, how to go to a specified characted (on all lines)?

I have a CSV like this id,name,city 1,John,New York 10,Peter,Los Angeles 223,Joseph,London I'm in multiline select mode. I obtained the multiline cursor by selecting all the rows I needed and ...
vlad-ardelean's user avatar
3 votes
1 answer
7k views

How to `cut` (extract a subset of columns) a CSV file that contains quoted strings`

I have a CSV file and want to discard a couple of columns. So let's say this is a sample file: column a, column b, column c value a, value b, value c value a, "quoted, b", value c And now let's ...
yankee's user avatar
  • 693
3 votes
1 answer
2k views

How to link csv file in Libreoffice 5

In previous versions of Libreoffice Calc, it was straightforward to import and link csv files through [Import] -> [Sheet from file...], as per the instructions on this page. This allowed me to refresh ...
Qi Chen's user avatar
  • 133
3 votes
1 answer
7k views

How to import csv file from url into Google Docs (Drive)

I have a CSV file on a server, available via http. I want to import this into Google Docs to analyse it. Is there a way to do it directly? Trying to do it via iPad, no PC. Trying to avoid the ...
Chris Kimpton's user avatar
3 votes
3 answers
2k views

Manually "draw" data for chart, output to CSV [closed]

I need a service that will allow me to draw a chart line by hand and generate data points for what I drew. This might sound crazy, but I need some data (preferably in CSV output) that will only ...
Ambidex's user avatar
  • 385
3 votes
1 answer
451 views

How to return in a cell all the matching values present in a column?

Suppose I have the following data: A B 1 idx1 VAL1 2 idx2 VAL2 3 idx3 VAL3 4 idx4 VAL1 5 idx5 VAL4 6 idx6 VAL1 7 idx7 VAL1 8 idx8 VAL2 9 idx9 VAL5 10 idx10 VAL3 For each "VAL[n]" ...
Backo's user avatar
  • 177
3 votes
1 answer
3k views

Split cells by uppercase and lowercase words in excel

I've got a CSV file with contacts inside that I want to import in an online contacts list. Unfortunately, the CSV file has one single column for the full name, and does not differentiate "First Name"...
user3420936's user avatar
3 votes
1 answer
721 views

Excel - Text transformation keeping Roman Numerals uppercase

I have a CSV file that is exported from another program with one of the columns being the title. The data in the original program is all uppercase for the title field so when it exports, the title ...
ACanadianCoder's user avatar
3 votes
3 answers
31k views

How can I make Excel save a .csv using commas and quotes?

I am trying to save file as a .csv, however, Excel is not using the standard comma separator and quotes. Here is an example of what I want: "0","70","0","4/29/2012 12:00","13311250""1","70","0","4/30/...
Hooplator15's user avatar
3 votes
2 answers
258 views

Which delimiter allows major spreadsheet programs to open CSV files by double-clicking?

I'm writing an iOS 8 app that allows you to export data to be sent as an email attachment. Currently, I'm exporting the data to a CSV file with 7 columns and x number of rows. When I first created it, ...
Erik's user avatar
  • 151
3 votes
7 answers
11k views

Delete empty column from csv file with bash script

Looking for some way to look at a csv file and delete columns including the header that have no values in the subsequent lines that follow. Perhaps if I wanted to delete column Test03 from below ...
user1988900's user avatar
3 votes
1 answer
7k views

CSV files cant store special characters?

I have read several other questions on this subject but none have an answer which fixes my problem. I have an execel file which is in russian and I need to convert it to CSV without it losing any of ...
Kevlar's user avatar
  • 343
3 votes
1 answer
3k views

How to display/monitor the tail of a growing CSV file in tabular format?

I am looking for a way to display an open, "live" CSV file under Windows 7. For example, I have a proprietary program running that is generating log data in CSV format. I'd like to keep an eye on what ...
yosh m's user avatar
  • 2,266
3 votes
1 answer
1k views

Word 2007 prompts twice for "Opening this document will run the following SQL command" for Mail Merge

I am trying to figure out why my mail merge in the a Word document is prompting me twice for seemingly two different data sources. Both prompts look like the following: . The first prompt points ...
Chad Harrison's user avatar
3 votes
3 answers
2k views

How to visualize/graph a massive dataset?

I have a CSV file of data collected using Performance Monitor. It collected CPU usage at 5 second intervals for two weeks. I need to be able to graph or visual the data in a way that'll help me ...
Chris Thompson's user avatar
3 votes
1 answer
6k views

Removing the last tab of a line in a file

I have a text file which consists of tab delimted fields terminated with a CR/LF. Before the CR/LF an extra tab has been inserted effectively creating a blank field at the end of every line. I would ...
JamieDainton's user avatar
3 votes
1 answer
194 views

Powershell - Combine two CSVs with 1 CSV Dynamic

I have created a Powershell script to send alerts based on network status' found by running a Python script to check Uplink status. The Python script creates a CSV and my Powershell script selects the ...
Jonathan-Ball's user avatar
3 votes
3 answers
6k views

Combine multiple CSV files by column, not by row

I have ~100 CSV files that I want to combine into one single Excel spreadsheet (everything in one tab, not in separate tabs). These CSV files are identical in format: each contains 4,000 rows and 2 ...
tcollar's user avatar
  • 31
3 votes
1 answer
11k views

Dbeaver export result set to multiple CSV files

I'm using the latest version of DBeaver on Mac, querying against a remote MSSQL database and I've got a query that results in 24 million rows. I need to get this data into CSV format, but rather than ...
jaydel's user avatar
  • 131
3 votes
1 answer
1k views

Find common columns (same column name/header but different positions) from two or more excel worksheets

I have excel worksheets (csv format) from different clients, where first row of all worksheets contain the column names. However, the order and number of columns in each worksheet can be different. ...
xkcd's user avatar
  • 171
3 votes
4 answers
14k views

cannot find any saved .csv files

I did search through many of the .csv realated topics that the search returned so I hope this is an appropriate new question... I am trying to setup an excel spreadsheet using a .csv file as the data ...
Awill's user avatar
  • 41
3 votes
1 answer
3k views

Regex to find commas, excluding commas inside a string demarcated by double quotes

I would like to manipulate a closed .csv file without opening it through a button on an Excel AddIn. I am able to complete all the steps but am having a problem with finding a regex that would ...
Francois's user avatar
3 votes
4 answers
13k views

Convert a JSON file to CSV or XLS (Excel) format

I have a number of JSON files which my old charting system will not accept as a data format for import. Is there an easy way to convert these to CSV or XLS?
Travis's user avatar
  • 33
3 votes
2 answers
19k views

Import CSV file into Exchange Mail Contacts using powershell without duplicates

The Problem: A good number of people's info was added to my "Mail Contact" list in Exchange Management Console, but not all. Summary: I'm attempting to add a list of several hundred people ...
Mike Kellogg's user avatar
3 votes
4 answers
16k views

Batch script to append record to csv files

I have a bunch of stock data in csv's that I am backtesting trading strategies on. The problem is that my strategy buys the open market price if a signal was found yesterday, unfortunately my data is ...
Brandon Ogle's user avatar
3 votes
2 answers
4k views

How to combine multiple rows of data of a single customer in a cell as comma separated values?

I have a PIVOT table report like the one below: Customer Name Category Date Met ----------------------------------- Customer 1 Core 9 10 Customer 2 ...
Dayal Saran M's user avatar
3 votes
1 answer
5k views

How to add time duration column total from Skype Call History CSV file in Excel 2010?

How to add time duration column total from Skype Call History CSV file in Excel 2010? These are my exact steps on how to set up my Excel spreadsheet. How to import Skype Call History CVS in Excel ...
XP1's user avatar
  • 1,041
3 votes
2 answers
7k views

Getting Excel to handle CRLF's correctly in CSV

I am creating CSV files to be opened in Excel. The rows are separated by CRLF and that's fine, but some of the input data contains CRLF data in it as well. Per the usual standards, I surround them ...
Ben Fulton's user avatar
3 votes
0 answers
945 views

When importing CSVs, does Excel have a limit of 32,767 characters or 32,758 characters?

According to the documentation, Excel has a limit of 32,767 characters per cell. However, when I save a CSV file that looks like this: "Cell with exactly 32,767 characters........","...
Pikamander2's user avatar
3 votes
0 answers
111 views

Excel csv-import into table referenced by name

I have a worksheet called raw_data where I import some data via the Data-Import Wizard. This created a new name-referenced range called abc.csv. However if I try to create a table on another ...
Philipp Birkl's user avatar
3 votes
2 answers
2k views

Finding why there is a difference in size for a CSV file with the same content

Situation: I run a macro to format an excel file, and save the formatted excel file as a .xlsx, the file size is 37 KB. I copy the content and save it into a new file, 30 KB. Issue: I want to know ...
Simon's user avatar
  • 131
3 votes
1 answer
2k views

How to Disable Auto-Formatting of All Column Values when opening CSV Files in Microsoft Excel [duplicate]

How can I stop Microsoft Excel from auto formatting data when imported from a csv/text file? Specifically, I want it to treat all of the values as text. The files come to me as tab delimited text ...
Patty Eilers's user avatar
3 votes
2 answers
10k views

Formatting date in excel for csv upload

I am looking to upload a csv file to Google apps. I am outputting my date from SQL as mm/dd/yy but when I try and save it in excel as a csv it changes my date format to mm/dd/yyyy. Is there a way to ...
john french's user avatar
3 votes
1 answer
269 views

Outlook 2007 export contacts including list info

I want to export all contacts in outlook 2007 for import to gmail. Many of the contacts are members of various distribution lists, but there are no info in the exported csv-file as to which ...
Bo01's user avatar
  • 145
3 votes
0 answers
761 views

How to setup a CSV web datasource

In Excel, I can import a CSV from the web as text by simply pasting in the URL as a file name, but when I ask Excel to update, it has stripped the URL and tries to find a file on the local hard drive ...
tovare's user avatar
  • 583
3 votes
1 answer
1k views

Free or Open Solution for Storing and Charting CSV data [closed]

I'm presently storing CSV files, combining them, opening them in open office, creating pivot tables and then generating charts from the spreadsheet. I've looked at OOBase, but appending csv files to ...
rrrfusco's user avatar
  • 145
3 votes
2 answers
1k views

Convert tab separated to a human readable aligned column headers

Let's say I have a spreadsheet with the following example data: I need to display this in plain text but still human readable. When saved in a tab separated format (tsv) it will output something ...
Alex KeySmith's user avatar
2 votes
3 answers
9k views

Splitting a 7 million row CSV by a specific column

How would I go about splitting a very large (7 million rows) CSV file into several different sheets/files by a specific numerical column. It should split into about 10 different files.
BrandonMXB's user avatar
2 votes
2 answers
6k views

Remove every line breaks following carriage return (^M) and join the lines

edit: Now that I got answers, I marked one by @KamilMaciorowski that fits better to the title as an answer, but this answer by @oliv actually were better suited to my actual need to my primary purpose....
Iorippi's user avatar
  • 23
2 votes
2 answers
5k views

Best way to search for a string (text) in >10 large CSV files (250mb each)

I am wondering what's the best way or tool to search for a specific text or string in more than 10 large .csv files. Each file is 250mb in size. My idea was to write a powershell script, since I ...
RayofCommand's user avatar
2 votes
2 answers
4k views

Notepad++ Regex Help in cleaning up file

I've got a csv file (the column separator is "<;>" ,the text delimiter is the double quote and the row separator "crlf") of more than 18000 lines. However,many of the data contained within the ...
Raymond's user avatar
  • 123
2 votes
3 answers
2k views

How to set field seperator in Emacs csv-mode?

Can I set the field seperator(s) for the current buffer in Emacs 23?
Arne's user avatar
  • 829
2 votes
3 answers
229 views

Generate an alphabetic index from a spreadsheet

I have a text file of lecture topics from my physics class that looks like this: 1/14,Galilean relativity,Einsteinian relativity,Minkowski space,Henri Poincare,, 1/16,Lorentz transformations,Velocity ...
Nathaniel M. Beaver's user avatar
2 votes
1 answer
1k views

Clean up CSV based on another CSV

I have a csv file named master.csv, which has the following columns link, name And another csv file called details.csv, which has the following columns link, name, price, desc I want to match ...
esafwan's user avatar
  • 156

1 2 3
4
5
20