Questions tagged [csvsimple]

{csvsimple} provides a simple LaTeX interface for the processing of files with comma separated values (CSV).

Filter by
Sorted by
Tagged with
46
votes
3answers
65k views

How to plot data from a CSV file using tikz and csvsimple?

Here is a minimal example : \begin{filecontents*}{data.csv} a,b,c,d 1,4,5,1 2,3,1,5 3,5,6,1 4,1,4,9 5,3,4,7 \end{filecontents*} \documentclass{article} \usepackage[utf8]{inputenc} \usepackage{...
13
votes
3answers
539 views

Populate information from a csv file into a LaTeX document (specifically into the fields/arguments of commands therein)

I have some personal information stored in a plain CSV file personal_info.csv in the following format: personal_info.csv 83 Fancy Avenue,Nowheresville,Gotham City 24061 123 456 7890 someone@xyz.com ...
11
votes
3answers
2k views

How can CSV files be put into LaTeX without having to adjust much?

I would like to have a TeX-Snippet that takes a filename as an argument and outputs a table with toprule and bottomrule: \begin{tabular}{lrr} \toprule Fach & Dauer & Einkommen\\ ...
9
votes
2answers
8k views

Importing CSV file as a table in Latex but file too long

I am trying to import a CSV file but the data in the table is too long it goes down till the end of the page and disappears without continuing on the next page. Here's the file: \begin{filecontents*}...
8
votes
4answers
7k views

Sending Same Letter to multiple addresses

I'm sending the same letter to multiple addresses. The addresses are stored in a csv document. I've so far created a loop to create multiple letters, but I have not been successful in finding a ...
7
votes
1answer
2k views

Skip rows in csvsimple

Similar to this question, I need to skip some rows both from the top and bottom. For example, in this MWE: \documentclass{article} \usepackage{csvsimple,filecontents} \begin{filecontents*}{...
7
votes
1answer
136 views

Is it possible to generate custom exams taken the student's names from a csv archive?

I'd like to generate a single PDF file containing multiple exams (template available below). Each exam must have the field 'name' (see template) filled with the name of a student taken from a ...
7
votes
1answer
2k views

Math mode for csvsimple Import

I am currently struggling when I try to import a CSV file which contains math code using the following code: \documentclass{article} \usepackage{csvsimple} \usepackage{amssymb} % Math symbols \...
6
votes
3answers
4k views

Bold one cell in table using CSV reader

Is it possible to bold a single desired cell (or number of cells) using csvreader (besides the head)? Here is an example of making the table. \documentclass{article} \usepackage{csvsimple} % Make ...
6
votes
1answer
1k views

csvsimple handles underscores wrong

I try to print a .csv file using csvsimple. The column headers of that CSV file contain underscores. Within the csvsimple documentation, I found the option respect underscore=true option that is ...
6
votes
1answer
2k views

How to deal with csv file whoese fields are enclosed by quote?

I have a csv file whose fields contain text. As fields can contains newlines, they are enclosed by double quotes. Editing these file works well with my favourite spreadsheet (libreoffice). I want to ...
6
votes
1answer
3k views

Display top border of table using csvreader

I am using csvreader from the csvsimple package to generate a table in my document. I am struggling to get a top border on the table. Here is the code, including writing the .csv \documentclass{...
6
votes
1answer
2k views

Percentage symbol with csvsimple package

I'm using package csvsimple to read .csv files. The problem is, in some of the cells I have percentages, like: a,b 1,10% 3,16% If I leave the %s, everything after the first % is omitted, that is, it'...
5
votes
2answers
63 views

having problems with greek characters in a table using csvsimple

Hi this is what I wrote: \documentclass{article} \usepackage{amsmath} \usepackage{gensymb} \usepackage[utf8]{inputenc} \usepackage{csvsimple} \usepackage{booktabs} \usepackage{longtable} \usepackage[...
5
votes
2answers
663 views

csvsimple and siunitx

I'm trying to import data from a csv file and using the S column type from siunitx to format the numbers with this code: \documentclass{article} \usepackage{siunitx} \usepackage{csvsimple} \begin{...
5
votes
2answers
194 views

new command is expanding as blank

So I'm trying to import a large list of values that are used throughout my report. However when i do this the results are always blank... \documentclass{scrreprt} \usepackage{csvsimple} % \csvloop{...
5
votes
2answers
1k views

(How) can CSV data be transposed for display in tabular

I can use the csvsimple package to automatically display data from a CSV file in a tabular environment. Can the same be achieved in transposed (rows to columns and vice versa) form , as shown by the ...
5
votes
2answers
2k views

Create a caption for table using the \csvautolongtable command from the csvsimple package

I successfully included a .csv table using the \csvautolongtable command from the csvsimple package (the table is more than one page, this is why I am using this command). Now I want to add a caption ...
5
votes
2answers
2k views

using csvreader to read from csv giving invalid output

I am trying to output a *.csv file to LaTeX, but I keep on getting invalid output. I am using mactex on a yosemite environment. code.csv: code,subcd CITY,LIMA CITY,PUEBLOLIBRE CITY,JESUSMARIA CITY,...
5
votes
1answer
490 views

problematic extra cell when importing CSV to latex

I have a table that spans several pages I will be including in an appendix that I would like to import into my LaTex document from a csv. I found the long table answer post very helpful: Importing CSV ...
5
votes
2answers
974 views

bold or higlight first row and column of tabe created from csv file

I'm using csvreader from csvsimple package to read csv data and create table from it. My goal is to bold or somehow highlight first row and first column. Here is my MWE: \documentclass{article} \...
5
votes
1answer
94 views

Automated truncating and compilation of mean and uncertainty pairs for display in table from csv file

I have to display data from a number of CSV files containing pairs of mean and uncertainty values grouped in columns, the first column containing the mean values, the second the uncertainty values and ...
5
votes
1answer
456 views

csvreader adds extra empty row at the bottom of the table

I want to create a xltabular table by loading the content of a CSV file, which is imported by way of csvreader. At the end of the table, an extra empty undesired row is shown. I can't figure out what ...
4
votes
2answers
967 views

Error while trying to read csv file to create table

I have a csv like the following: CategoryName,Pageviews Restaurants,37951 Shopping,22002 Things to do,20067 Nightlife,10612 Gifts,9194 Food Shopping,8655 Useful Stuff,8536 Parenting ,8353 Home,7654 ...
4
votes
3answers
97 views

Writing over a white table (superimpose writing)

I'm trying to put the number of rows of a csv file into a latex document, without actually putting the table into the last document. I've tried the tag package, and putting the table in another ...
4
votes
2answers
299 views

csvsimple vs. conditional row coloring

I've a CSV file what I want process with csvsimple. My desire is to color some rows based on a conditional (one specified column has bigger value). Here is an MWE: \documentclass[12pt]{article} \...
4
votes
1answer
205 views

Why csvsimple doesn't allow symbols/math in first row?

The package csvsimple is a nice tool to import large tables that were generated externally. However, it fails to interpret files with symbols or math in the header. It does neither work with tabular ...
4
votes
2answers
1k views

Conditional horizontal lines in tables

I am trying to typeset data that is read from CSV files using the csvsimple package. In the input data, there is a column that will tell me where to place a horizontal line between the rows. (In the ...
4
votes
1answer
729 views

Using collcell package with csvsimple, or datatool

I was trying to compose an answer to Bold one cell in table using CSV reader using the collcell package, and can't seem to get it to work either with the csvsimple tabluar, nor datatool. With the ...
4
votes
2answers
737 views

Why “Missing \endcsname inserted.” when importing a csv with csvsimple with babel set to spanish?

After figuring out why my MCVE wasn't working as expected, I think I've found a bug in either babel or csvsimple package. This compiles: \documentclass{article} \usepackage{filecontents} \begin{...
4
votes
2answers
8k views

Csvsimple \csvautotabular and \csvautobooktabular with centered columns' content

I'm using csvsimple for making tables, and csvautotabular and csvautobooktabular are working great. However, I'd like the content of each column to be centered instead of aligned to the left. An ...
4
votes
1answer
843 views

Recreating formatting of an Excel table using simplecsv

I'm trying to recreate a wholesale price list in LaTeX so that the data can be updated automatically from CSV files. I'm able to import data using \csvautolongtable but I'm struggling with the ...
4
votes
1answer
282 views

You can't use a prefix with `\char"FB': error when importing csv into latex

I'm trying to use the package csvsimple to create a table from a csv file. This worked so far, but when I try to add new figures/tables afterwards I get multiple errors. It looks like the \end ...
4
votes
1answer
152 views

Last Column problem with csvsimple and siunitx

I don't understand why it gives me the error Extra }, or forgotten $. <recently read> } in the part ...entoIdraulico & \RendimentoMeccanico } \\ if I change in S the last c of the part \...
3
votes
2answers
192 views

Unable to print without quotes in csvsimple

I am trying to print a table from .csv file which is generated by libreoffice in such a way one of the column has a value comma separated e.g John,Terang i want to print John, Terang without any ...
3
votes
1answer
429 views

Table built with if else statement

I'm trying to build a table that will have a table that will automatically assign a third column depending on the grade. So, the third table is dependant on the second one. I want it to look something ...
3
votes
1answer
904 views

CsvSimple with tabular: set specific number of rows

For a tabular environment with csvsimple I would like to set the number of rows specifically. This example is an attempt to show only the first two rows: \documentclass{article} \usepackage{...
3
votes
2answers
1k views

How to import data from a CSV file in a figure caption using csvsimple?

I have made a pretty report that gets all the data from CSV files data.csv like this : Images,Infos,Bayer,BilineaireA,BilineaireB,TeinteA,TeinteB,ContourA,ContourB,Forme img1(illusion),Temps (en ms),...
3
votes
1answer
86 views

Import csv and multiple eps files into table

How can I import all the elements of a csv file along with corresponding eps files? Basically I have 3 columns, NSC, Name, Structure. I was able to import text using csvsimple package and I think I ...
3
votes
1answer
371 views

Format tabular cell from csv file automatically

I tried to adapt examples from 5.4 Tables with Number Formatting from csvsimple package, but no success. Each line in my csv file has 20 fields, all of them has format like x.xxxxxx. Here is the ...
3
votes
1answer
42 views

csvloop bug with the word “long”?

I'm experimenting some issues with the csvloop using the package csvsimple. I need help determining if it's a bug with the package, or something I can fix myself. The word "long" is showing up in my ...
3
votes
3answers
163 views

How to test values in an \ifnum, that are generated from a csv file via \newcommand and \csvreader?

I would like to conditionally print something in a report, based on whether there was a non-zero data point or not (for this example, \DepthOne and \DepthThree are to be tested). I start by reading ...
3
votes
1answer
1k views

Tabularx or Tabulary populated by csvsimple

I am using csvsimple to import table data. Some cell information is too long and I would like to dynamically manage the column width. I have tried combining the tabularx and tabulary environments ...
3
votes
1answer
554 views

How to make convert csv to fancy tables?

I want convert csv to fancy tables like this : First, I make a basic table with my MWE like this : \documentclass{article} %\usepackage{csvsimple} \usepackage{pgfplotstable,filecontents} \...
3
votes
1answer
900 views

Nested CSV with csvsimple

I have two csv files. I want to use the first (countries.csv) to generate sections, and then filter the second (bottles.csv) by the name of the section. Below is an MWE - you can see that the nested ...
3
votes
2answers
2k views

Use CSV data in table caption?

I want to use some data, imported with csvsimple, in a table caption. \begin{filecontents*}{data.csv} column1,column2,column3 name1,val1a,val1b name2,val2a,val2b \end{filecontents*} \documentclass{...
3
votes
1answer
45 views

Error in longtable with csvreader

I am getting an error while creating a longtable by importing a csv file. The MWE is as given below. \begin{filecontents*}{monodisperse15.csv} 20,2.825,5.967,0.0,0.0,0.0,0.0 22,2.85,15.516,0....
3
votes
1answer
293 views

How to import data from excel and format it as text in LaTeX?

I have a big database spreadsheet on Excel which is a list of products and I want to use its data to write formatted text in LaTeX. The table looks like this: Year / Name product / Details 2000 / ...
3
votes
1answer
110 views

Table: filter not working with decimal values

I have a filter that works with the first filecontents, but not the second. In fact, the filter doesn't work as soon as there is a decimal in the values that are going in the table. Does anybody ...
3
votes
1answer
68 views

Adding code (pagebreak) after value change in csvsimple

Background I want to create a document with the user data of our network at school, which should be handed out to the user. This should be done class by class. Approach The user data are given in a ...